16921 Basic courses delivered On Demand

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Assessment Assessment - Microsoft Excel 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Supplementary Resources Supplementary Resources - Microsoft Excel Diploma 00:00:00 Assessment Assessment - Microsoft Excel Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Are you looking forward to Functional Skills packages, the most demanding skills, for the ongoing year and beyond? Then you are in the perfect place. Let's explore! The development of a learner's capacity to resolve issues in practical situations is referred to as a functional skill. The essential English, mathematics, and ICT abilities required for success in both the professional and personal spheres are known as functional skills. You may build these abilities with the aid of our functional skills course. Courses you'll get: Course 01: Functional Skills Maths Course 02: Functional Skills English Course 03: Functional Skills IT We provide beginner-level functional skills training in English, Maths, and ICT. The Functional Skills course contents are divided into modules and subjects, and learning evaluations are placed at regular intervals to test the level of understanding. You are supposed to learn the basics of arithmetic, computers, databases, and other subjects in the Functional Skills. Learning Outcome of Functional Skills course: Understand foundational Functional Skills maths Grasp the fundamentals of Functional Skills English Learn how to use computer hardware and software. Explore sharing and controlling software for data storage IT troubleshooting training Key Highlights for Functional Skills Course: CPD Accredited Functional Skills Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Functional Skills Course Materials 100% Functional Skills Learning Satisfaction Guarantee Lifetime Access & 24/7 Support with the Functional Skills Course Self-paced Functional Skills Course Modules Curriculum Breakdown of the Maths, English & IT Bundle Take a look at the training modules of the Functional Skills English Course: Basics of Grammar The Basics of Sentence Structure of Sentence Punctuation & Capitalisation Spelling Take a look at the training modules of the Functional Skills Maths Level 2 bundle: Numbers and Negative Numbers Multiples Factors Fractions and Power Percentages Expressions Decimals Ratio and Proportion Exponents and Radicals Graphs The Profit and Loss Perimeter and Area Averages Probability Take a look at the training modules of the IT course: Section 01: How People Use Computers Section 02: System Hardware Section 03: Device Ports and Peripherals Section 04: Data Storage and Sharing Section 05: Understanding Operating Systems Section 06: Setting Up and Configuring a PC Section 07: Setting Up and Configuring a Mobile Device Section 08: Managing Files Section 09: Using and Managing Application Software Section 11: IT Security Threat Mitigation Section 12: Computer Maintenance and Management Section 13: IT Troubleshooting Section 14: Understanding Databases CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in Functional Skills course. Besides, this course particularly recommended for- Anyone who is interested in reviewing or studying the fundamentals of IT, English, or mathematics. Whoever wants to be successful in functional skills. Anyone wishing to enhance their maths, English, or IT skills in order to increase their work prospects. Applicants for higher education. Requirements Learners seeking to enrol for Functional skills course should meet the following requirements; Basic knowledge of English Language, which already you have Be age 16 years or above Basic Knowledge of Information & Communication Technologies for studying online or digital platform. Stable Internet or Data connection in your learning devices. Career path After completing Functional Skills course, you can explore trendy and in-demand jobs related to this course, such as- Department Head Teacher Teaching Assistant Maths Teacher English Teacher IT Teacher Deputy Chief Explore each of the roles available and how you can start your career in Functional sectors. Certificates Certificate of completion Digital certificate - Included After successfully completing the course, you can get 3 CPD accredited digital PDF certificate for free. Certificate of completion Hard copy certificate - Included After successfully completing this course, you get 3 CPD accredited hardcopy certificate for free. The delivery charge of the hardcopy certificate inside the UK is £3.99 and international students need to pay £9.99 to get their hardcopy certificate.

Martial Arts First Aid: Martial Arts First Aid Course Online This Martial Arts First Aid: Martial Arts First Aid Course is specially designed to cater to injuries during martial arts training and sessions. The Martial Arts First Aid: Martial Arts First Aid Course includes a variety of subjects that apply to any martial arts sector. The course is appropriate for both instructors and students. Martial Arts First Aid: Martial Arts First Aid Course, by its nature, presents a risk. An injury does not happen when performed correctly, but in the case it happens, the responsible precaution is for everyone to have a basic understanding of what to do. This qualification Martial Arts First Aid: Martial Arts First Aid Course covers injuries such as contact injuries, cardiac arrest, and illnesses such as allergic reactions. First aid is a simple skill to learn, and the training is presented in a simple way to ensure better understanding. In today's competitive world, you must have a specific set of skills to succeed in your profession. In this comprehensive training Martial Arts First Aid: Martial Arts First Aid Course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Special Offers of this Martial Arts First Aid: Martial Arts First Aid Course This Martial Arts First Aid: Martial Arts First Aid Course includes a FREE PDF Certificate. Lifetime access to this Martial Arts First Aid: Martial Arts First Aid Course Instant access to this Martial Arts First Aid: Martial Arts First Aid Course Get FREE Tutor Support from Monday to Friday in this Martial Arts First Aid: Martial Arts First Aid Course Main Course: Martial Arts First Aid Course Courses with Martial Arts First Aid: Martial Arts First Aid Course Course 01: Paediatric First Aid Course 02: Sports First Aid [ Note: Free PDF certificate as soon as completing the Martial Arts First Aid: Martial Arts First Aid Course] Martial Arts First Aid: Martial Arts First Aid Course Online Industry Experts Designed this Martial Arts First Aid: Martial Arts First Aid Course into 08 detailed modules. Detailed course curriculum of the Martial Arts First Aid Course Module 01: An Overview of Martial Airs First Aid Module 02: Primary Assessment Module 03: CPR & Recovery Position Module 04: Dealing with Frequent Injuries Module 05: Dealing with Serious Injuries Module 06: Dealing with Medical Emergencies Module 07: The Way of Preventing Injuries Module 08: Things to Remember Assessment Method of Martial Arts First Aid Course After completing each module of the Martial Arts First Aid: Martial Arts First Aid Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification of Martial Arts First Aid Course After completing the MCQ/Assignment assessment for this Martial Arts First Aid: Martial Arts First Aid Course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Martial Arts First Aid: Martial Arts First Aid Course Online This Martial Arts First Aid: Martial Arts First Aid Course is suitable for - Students Recent graduates Job Seekers Anyone interested in this topic. People already working in this field want to polish their knowledge and skill. Requirements Martial Arts First Aid: Martial Arts First Aid Course Online Students who intend to enrol in this Martial Arts First Aid: Martial Arts First Aid Course must meet the following requirements: Martial Arts First Aid: Good command of the English language. Martial Arts First Aid: Must be vivacious and self-driven Martial Arts First Aid: Basic computer knowledge. Martial Arts First Aid: A minimum of 16 years of age is required Career path Martial Arts First Aid: Martial Arts First Aid Course Online Successfully complete your Martial Arts First Aid: Martial Arts First Aid Course and grow as a person to increase your chances of success in the Martial Arts First Aid: Martial Arts First Aid Course industry and other pertinent industries.

Drug and Alcohol: Drug and Alcohol Awareness Course Online When it comes to the risk of drugs and alcohol in the workplace, our Drug and Alcohol: Drug and Alcohol Awareness Course offers your staff the knowledge of all people's principles and obligations at the workplace. The Drug and Alcohol: Drug and Alcohol Awareness Course takes the learner through the safety responsibilities, testing requirements, and processes for drugs and alcohol in the workplace, as well as the implications of any positive tests. By the end of this Drug and Alcohol: Drug and Alcohol Awareness Course, learners will understand the effects of drugs and alcohol on work fitness and how they can contribute to a safe workplace. Learning Outcomes of Drug and Alcohol: Drug and Alcohol Awareness Course After completing this Drug and Alcohol: Drug and Alcohol Awareness Course, the learner will be able to: Understand the basic concepts of substance misuse. Demonstrate a thorough understanding of the different types of illegal drugs. Understand the legal, health, and social implications of drug and alcohol abuse. Understand how organizations and individuals are expected to handle substance misuse issues. Demonstrate an understanding of the statistics on drug and alcohol abuse in the UK. Describe the various types of drug treatment services available in the UK. Plan a drug intervention and understand when someone requires assistance. Special Offers of this Drug and Alcohol: Drug and Alcohol Awareness Course This Drug and Alcohol: Drug and Alcohol Awareness Course includes a FREE PDF Certificate. Lifetime access to this Drug and Alcohol: Drug and Alcohol Awareness Course Instant access to this Drug and Alcohol Awareness: Drug and Alcohol Awareness Course Get FREE Tutor Support from Monday to Friday in this Drug and Alcohol: Drug and Alcohol Awareness Course Drug and Alcohol: Drug and Alcohol Awareness Course Bundle: Course 01: Drug and Alcohol Awareness Course 02: Suicide Awareness Training Course 03: Level 5 Mental Health Care - MCA and DOLS Course 04: Diploma in Counselling and Psychology [ Note: Free PDF certificate as soon as completing the Drug and Alcohol: Drug and Alcohol Awareness Course] Drug and Alcohol: Drug and Alcohol Awareness Course Online Industry Experts Designed this Drug and Alcohol: Drug and Alcohol Awareness Course into 06 detailed modules. Course Curriculum of Drug and Alcohol: Drug and Alcohol Awareness Course Module 01: Introduction Module 02: Historical Overview Module 03: Nature of Addiction Module 04: Policy Initiatives and Strategy in Alcohol and Drug Use Module 05: Understanding Alcohol Abuse Module 06: Drug Addiction & Abuse Assessment Method of Drug and Alcohol Awareness After completing each module of the Drug and Alcohol Awareness: Drug and Alcohol Awareness Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Drug and Alcohol Awareness After completing the MCQ/Assignment assessment for this Drug and Alcohol Awareness: Drug and Alcohol Awareness course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Drug and Alcohol: Drug and Alcohol Awareness Course Online This Drug and Alcohol Awareness: Drug and Alcohol course is designed for those working in high-risk industries like hospitality and construction and anyone who manages or works with vulnerable people like adolescents. Requirements Drug and Alcohol: Drug and Alcohol Awareness Course Online Students who intend to enrol in this Drug and Alcohol Awareness: Drug and Alcohol Awareness course must meet the following requirements: Drug and Alcohol Awareness: Good command of the English language. Drug and Alcohol Awareness: Must be vivacious and self-driven Drug and Alcohol Awareness: Basic computer knowledge. Drug and Alcohol Awareness: A minimum of 16 years of age is required Career path Drug and Alcohol: Drug and Alcohol Awareness Course Online This Drug and Alcohol Awareness: Drug and Alcohol Awareness course opens a new door for you to enter the relevant job market. It also gives you the opportunity to gain in-depth knowledge along with the necessary skills to grow in no time. Certificates Certificate of completion Digital certificate - Included

Unlock abundant opportunities in the UK's Carpentry and Joinery sector. Experience a thriving field with competitive salaries averaging £30,000+. Expect 10% industry growth by 2025, ensuring a stable and prosperous career path. Embrace the craftsmanship and reap the rewards in this lucrative job market. What are we offering? This course begins with the fundamentals of carpentry and joinery and continues to more advanced subjects. This pattern of lesson plans in this Carpentry and Joinery course makes each lesson simple to learn and logical. This training programme will help you develop your carpentry abilities and turn you into a competent, responsible carpenter. Upon successful completion of this Carpentry course, you: Can provide services related to Carpentry with complete knowledge and confidence Be able to classify the various building materials used in Carpentry Learn how to build an interior and exterior wall Be able to classify the various building materials they use Can train up others and grow an efficient peer community in your locality and serve people Will be competent and proficient enough to start a Carpentry related business on your own Enrol in this Carpentry and Joinery course today to learn everything there is to know about this Carpentry and Joinery industry. The goal of this brief, online carpentry course is to teach formwork and joinery in a straightforward manner. Check out the course right away; by the conclusion of it, your career will have improved. The curriculum breakdown for this course will be as follows: Module 01: Introduction to Carpentry - In this module, you will study the brief introduction to carpentry and joinery. You will learn about the basic term used in the carpentry and joinery field. Module 02: Tool Checklist and Use - Here, you will explore the tools and their functionalities used in carpentry. Module 03: Building Materials - This module discusses the restoration materials used in carpentry. Module 04: Adhesives and Fasteners - This module will teach you about the techniques and functionalities of adhesives and fasteners of carpentry equipment. Module 05: Floor Systems - This module will explain the sequence involved in constructing a platform floor assembly Module 06: Wall Framing - In this module, you will study the different types of wall and framing procedures as well as learn their different components. You will also learn how to build and renovate interior walls and measure the details of building walls. Module 07: Roof Framing and Siding - This module will teach you the various terms associated with floor systems, wall, ceiling and roof framing Module 08: Windows and Exterior Doors - This module will educate you about the various types of windows and exterior doors used in residential construction and the kinds of glass used in window glazing. Module 09: Stair Construction - This module will cover stair construction and various stair designs, such as straight-run, platform, and spiral staircases. Next, you'll learn about the three different types of staircases, as well as the elements of a flight of stairs and interior stairways. Additionally, the course will cover the specifications, layout, and design of stairways, stairwells, and stair framing. Module 10: Concrete Construction - This module discusses the terms associated with concrete, concrete reinforcing materials and how to build a complete concrete structure from scratch. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anybody with a passion for carpentry can benefit from this useful training. No prerequisites are needed to take it. You can enrol on the course if you are a, Student, Enthusiast Employee/Employer Entrepreneur Business Professional Requirements To enrol in this Carpentry and Joinery course, all you need is a basic understanding of the English Language and an internet connection. Career path The course will add a valuable skill to your resume and enable you to get hired in Carpentry and Joinery related Trendy and Demanding jobs, such as, Carpenter (Salary: £20,000 to £38,000 per annum) Bench Joiner (Salary: £25,000 - £35,000 per annum) Furniture designer (Salary: £20,000 to £38,000 per annum) Furniture restorer (Salary: £19,000 to £28,000 per annum) Certificates Certificate of completion Digital certificate - Included Free CPD Accredited PDF Certificate.

You can get an easy introduction to Italian or just consolidate your basic knowledge with the Learn Italian Language: Complete Italian Course - Beginners. Following the course step-by-step, you can quickly gain an understanding of the most important ideas, and you can learn up to an advanced beginner's level of learning. The course covers the following topics: Italian speaking, Italian pronunciation, Italian writing, Italian grammar rules and patterns, Italian vocabulary, Italian conversation and communication skills. Through the course you will be able to hold a conversation in Italian. You will learn the basics and some intermediate of Italian grammar. You will acquire basic and some intermediate Italian skills. You will understand and use familiar everyday expressions. Learn all the expressions you need, as well as grammar and pronunciation for a beginner's level of learning, and you will learn how to put your Italian into practice in everyday situations. What you'll learn The #1 Italian Course. Start speaking real, grammatically correct Italian fluently, effortlessly and confidently today. Improve your listening and Italian comprehension skills through ear training and visual learning thanks to the Italian speaking teacher, interactive board, subtitles and included .pdf materials. Be confident regarding your Italian skills (A1, A2, A2+ levels) by lots of practice after every lesson. Understand and use familiar everyday expressions. By the end of the course, you will build and develop your practical communication skills in Italian speaking, writing, reading and, of course, your fluency and grammatical accuracy. Requirements No previous Italian language knowledge is required. The course is recommended to anyone who wants to learn Italian language fast and easy and is designed for beginners. We start with the absolute basics. Videos are in Italian with captions/subtitles. Italian Immersion is widely considered to be the best method of learning Italian. If you're a visual learner you'll love the interactive board, the subtitles and the included .pdf materials. Free demo lessons and quizzes. Who is the target audience? Anyone who wants to learn Italian fast and easy. This course is designed for beginners. We start with the absolute basics. If you are nearly intermediate you can improve your Italian with this course. Learn ltalian : ltalian Course for Beginners (A1 A2 A2+) Learn Italian- Find out all about this course in less than two minutes FREE 00:02:00 Learn Italian - The Alphabet. The Definite Article Learn Italian - The Alphabet. The Definite Article - Part 1 FREE 00:14:00 Dictation- Italian Language- Exercise 00:18:00 Learn Italian - The Indefinite Article. The numbers from 0 to 100 Learn Italian - The Indefinite Article. The numbers from 0 to 100 00:19:00 Learn Italian - Present Simple for regular verbs Learn Italian - Present Simple for regular verbs 00:17:00 Learn Italian - Present Simple for irregular verbs. Learn Italian - Present Simple for irregular verbs. 00:17:00 Learn Italian - Present Simple for irregular verbs(II) 00:14:00 Exercises - Dictation 2 00:09:00 Learn Italian - The verb ''to be''-reflexive Learn Italian - The verb 'to be'-reflexive 00:11:00 Learn Italian - Reflexive verbs. Adverbs of frequency Learn Italian - Reflexive verbs. Adverbs of frequency 00:16:00 Learn Italian - At the supermarket. The food Learn Italian - At the supermarket. The food 00:10:00 Learn Italian - Modal verbs Learn Italian - Modal verbs 00:09:00 Learn Italian - Prepositions. Learn Italian - Prepositions. Part 1 00:11:00 Learn Italian - Prepositions. Part 2 00:09:00 Learn Italian - The Adjectives. The numbers Learn Italian - The Adjectives. The numbers 00:14:00 Learn Italian - Clothes Learn Italian - Clothes 00:10:00 Learn Italian - After and before. Masculine nouns which end in '-ma' Learn Italian - After and before. Masculine nouns which end in '-ma' 00:08:00 Learn Italian - Place adverbs Learn Italian - Possessive pronouns and adjectives. The family 00:10:00 Learn Italian - Dialogue: On the phone Learn Italian - Dialogue- On the phone 00:08:00 Learn Italian - Present Perfect. The animals Learn Italian - Present Perfect. The animals 00:13:00 Exercises - Dictation 3 00:12:00 VideoLearn Italian - Present Perfect(II) 00:19:00 Learn Italian - Past Participle. Irregular Verbs. Learn Italian - Past Participle. Irregular Verbs(II) 00:08:00 Learn Italian - Greetings 00:05:00 Learn Italian - Past Participle. Irregular Verbs(II) 00:08:00 Learn Italian - Past participle. Irregular Verbs(III). Prepositions and 00:11:00 Learn Italian - The weather Learn Italian - The weather 00:09:00 Learn Italian - Parts of the body. At the pharmacy Learn Italian - Parts of the body. At the pharmacy 00:11:00 The adverbs with Present Perfect. The auxiliary verbs ''to be'' and ''to have'' The adverbs with Present Perfect. The auxiliary verbs 'to be' and ' 00:11:00 Learn Italian - Conjunctions Learn Italian - Conjunctions 00:09:00 Learn Italian - Vocabulary: New verbs Learn Italian - Vocabulary- New verbs 00:10:00 Learn Italian - Vocabulary- New verbs(II). The expression 'ce l'ho' 00:10:00 Learn Italian - Dialogue: How did you spend your weekend? Learn Italian - Dialogue- How did you spend your weekend- 00:09:00 Learn Italian - Future Simple Learn Italian - Future Simple 00:12:00 Learn Italian - Future Simple. Irregular Verbs 00:11:00 Learn Italian - The use of Future Simple 00:08:00 Exercises - Dictation 4 00:10:00 Learn Italian - Metterci and volerci Learn Italian - Metterci and volerci 00:11:00 Learn Italian - Recap Learn Italian - Recap 00:17:00 Exercises - Dictation 5 00:08:00 Course Certification

Overview This comprehensive course on 'Human Rights' will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This 'Human Rights' comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this 'Human Rights'. It is available to all students, of all academic backgrounds. Requirements Our 'Human Rights' is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 5 sections • 5 lectures • 02:00:00 total length •Basic Concept of Freedom and Human Rights: 00:14:00 •Classification of Human Rights: 00:26:00 •Women's and Children's Right: 00:41:00 •Various Aspects of Freedom: 00:18:00 •Various International Human Rights Organisations: 00:21:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this