30627 TEC courses

Full Excel Course Beginner to Advanced 6hrs

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

Learn the techniques and best practices of anger management and conflict resolution within your personal life or the workplace. Enrol in this course and explore the secrets behind anger to deal with it effectively.  Anger and conflict are two common companions in our day to day lives, not only in personal life but also in professional life. Anger demolishes self-control and gives rise to conflict which eventually impacts our efficiency and productivity, worsening our rapport with others. That's why anger management and conflict resolution are two vital skills for both personal life and professional growth. This Anger Management and Conflict Resolution Program is designed to teach you the core theories and best practices to manage anger and resolve conflict. In this course, the expert instructor will walk you through the basics of anger management and effective strategies to resolve issues. You'll learn the psychological reasons behind anger and how to deal with those. Also, you'll learn the common forms of anger and their solutions in effective ways. Besides, you'll have a comprehensive understanding of different types of conflict and practical guidance to resolve them.  No matter whether you're a professional or just a personal development enthusiast, this comprehensive course will help you build the skills to manage anger and conflict, and create harmony in your personal or professional life.  Upon completion of this CPD accredited course, you will be awarded a certificate of completion, as proof of your expertise in this field, and you can showcase your certificate on your Linkedin profile and your resume to impress employers and boost your career. If you are a job seeker or are looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. Our Anger Management and Conflict Resolution Program Course is packed with 20 modules and takes 4 hours, 12 minutes to study.  You will be able to study this course at your own pace, from anywhere and at any time. Enrol today and learn to manage anger and conflict to achieve mental peace and professional growth.

Course Overview Do you want to earn money passively from home? DO you want to drive more traffic to your website? Google AdWords is a great way for that. Learn how you can use Google ad services to get ahead of your competitors and drive traffic towards your business from this Learn Google AdWords and Earn Passive income with PPC course and boost your sales in no time. This course will teach you to how you can make a profit out of per click of your visitors. In this Learn Google AdWords and Earn Passive income with PPC course, you will learn how to set up an AdWords account, theories, keyword research, conversation tracking, sales and revenue tracking. You'll also understand the importance of quality scores, data analysis and understanding customer psychological level from this course. This course will help you understand the steps of monetizing your website from scratch. Learning Outcomes Be able to drive traffic to your website or landing page Create and optimize your own profitable Google AdWords campaigns Learn how to advertise your products and services online Increase sales to your website using AdSense Use conversion tracking to determine the value of your ad campaign Monetize more than 6 billion daily searches on Google Be able to remarket to your website visitors Who is this course for? This course is for those who want to learn the functions of Adword and earn money from Google ad services. This course will help you to learn how you can earn money passively using AdWord step by step. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Learn Google AdWords and Earn Passive income with PPC is a useful qualification to possess and would be beneficial for any related profession or industry such as: Digital Marketers Influencers Content Creators YouTubers Module 01: Introduction to Google Ads Welcome to Google Ads Masterclass! 00:13:00 Link to Isaac Rudansky's Digital Advertising Superstars Facebook Group 00:05:00 How to Make the Most of This Course, Plus a Sneak Peek of What's to Come! 00:20:00 Google Ads Formula Calculator 00:14:00 AdWords Formula Calculator I Built For You 00:05:00 What is Google Ads? 00:12:00 Where do Google Ads Show Up? 00:13:00 Complimentary Adventure Media Account Audit (exclusions apply) 00:06:00 Module 02: Creating and Setting Up Our First Google Ads Account Download Course Slides! 00:05:00 Creating Your First Google Ads Account 00:09:00 Understanding the Google Ads Account Hierarchy 00:08:00 Using Your Website Navigational Structure to Structure Your Google Ads Campaigns 00:20:00 Understanding Network Settings 00:14:00 Understanding Location Targeting 00:12:00 Configuring Location Targeting in Google Ads 00:10:00 Viewing Location Reports in Google Ads 00:15:00 Understanding Advanced Location Options 00:16:00 Setting and Configuring Languages 00:04:00 Setting Your Daily Budget and Understanding How Daily Budgets Work in Google Ads 00:13:00 Finding Your Hourly Reports in the Google Ads Interface 00:06:00 Using Google's Default Bid Strategy (Clicks) And Optional Max CPC Bid Limit 00:06:00 Bidding Strategies: Target Search Page Location 00:06:00 Bidding Strategies: Target ROAS 00:10:00 Bidding Strategies: Target CPA 00:05:00 Bidding Strategies: Target Outranking Share 00:08:00 Bidding Strategies: Maximize Clicks 00:05:00 Bidding Strategies: Enhanced CPC Bidding 00:05:00 Bidding Strategies: Manual CPC Bidding 00:05:00 Campaign Start and End Dates 00:02:00 Introduction to Dynamic Search Ads! 00:08:00 Understanding Sitelink Extensions 00:14:00 Callout Extensions 00:05:00 Call Extensions 00:08:00 Structured Snippet Extensions 00:06:00 App Extensions 00:02:00 Message Extensions 00:09:00 Location Extensions 00:10:00 Location Setting Exercise 00:05:00 Promotion Extensions 00:10:00 Price Extensions 00:12:00 Understanding Ad Rotation Settings 00:05:00 The Basics of Ad Scheduling 00:11:00 Understanding the Basics of Device Targeting 00:15:00 Understanding Campaign URL Options 00:07:00 Module 03: Structuring Your Ad Groups Like A Professional Ad Group Structure Basics and Organization 00:14:00 Ad Group Structure Ideas 00:07:00 Creating Our First Ad Group in Google Ads 00:09:00 Module 04: How To Write Killer Ads in Google Ads! The Anatomy of Google Text Ads 00:07:00 Compliance in Google Text Ads 00:06:00 Requesting a Manual Review of Your Ads and Expediting the Process 00:03:00 Best Practices for Successful Text Ads 00:14:00 Real-Life Case Ad Copy Case Study: Medical Equipment Company 00:15:00 The BJ Fogg Behavioral Model 00:39:00 Creating Our First Ad in Google Ads 00:13:00 Module 05: Setting Up Your AdWords Billing Configuring Your Billing Details in Google Ads 00:05:00 Module 06: Keywords in Depth - The Heartbeat of Your Account Keyword Basics: Keywords vs Queries 00:09:00 The Basics of Keyword Research 00:11:00 The Basics of Keyword Planning 00:13:00 The Basics of Keyword Organization 00:07:00 Understanding Keyword Match Types 00:12:00 Keyword Match Types: Broad Match 00:09:00 Keyword Match Types: Broad Match Modified 00:06:00 Keyword Match Types: Phrase Match 00:07:00 Keyword Match Types: Exact Match 00:12:00 Keyword Match Types: Negative Match 00:12:00 Using the Search Term Report to Find Negative Keywords Part 1 00:15:00 Using the Search Term Report to Find Negative Keywords Part 2 00:17:00 Understanding Negative Keyword Lists 00:12:00 Traffic Sculpting: Negative Keywords at the Ad Group Level 00:18:00 Adding Negative Keywords at The Ad Group Level 00:09:00 Traffic Sculpting Using OPTMYZR 00:07:00 Keyword Research: Google Suggestions, Google Related Searches and Autocomplete 00:14:00 Using Additional Research Tools to Get Negative Keyword Ideas 00:12:00 Keyword Research: Using the Google Keyword Planner 1 00:20:00 Keyword Research: Using the Google Keyword Planner 2 00:16:00 Keyword Research: Downloading Keyword Ideas from the Google Keyword Planner 00:16:00 Keyword Planning: The 6 Main Ways People Communicate With Search Engines 00:17:00 Keyword Planning: Understanding the Buyer Funnel 00:12:00 Keyword Planning: What Keywords Can Teach Us About Buying Intent 00:12:00 Keyword Planning: Using SEM Rush to Get Volume and Cost Estimates 00:18:00 Keyword Planning: Using SEM Rush to Get Keyword Ideas from Your Competitors 00:19:00 Keyword Planning: Using Google Keyword Planner to Get Volume & Cost Estimates 00:17:00 Keyword Organization: Getting Keywords Into Excel & Understanding Keyword Themes 00:17:00 Keyword Organization: Formatting Keywords in Excel 00:12:00 Keyword Organization: Using Pivot Tables to Visualize Your Campaign Structure 00:12:00 Keyword Organization: Using Mergewords to Generate Keyword Lists 00:14:00 Keyword Bidding Basics: Setting Your Initial Max CPC Bids 00:20:00 Module 07: Account Structure - How To Structure Ad Groups Like A pro Account Structure: How To Create A New Ad Group Within Your Campaign 00:07:00 Importing Your Keyword Lists From Excel Into Your New Ad Group 00:11:00 Creating Multiple, Relevant Ads For Your New Ad Groups 00:13:00 How To Navigate Between Ad Groups, Keywords and Ads Within A Campaign 00:08:00 Module 08: The Incredible Dynamics Of The AdWords Auction Introduction To The AdWords Auction 00:20:00 Understanding Quality Score: Click Through Rate And Ad Relevancy 00:15:00 Understanding Quality Score: Landing Page Quality 00:07:00 Understanding Ad Rank and How It Is Calculated 00:12:00 When You Could Ignore Low-Quality Scores (and when you can't!) 00:09:00 Advanced Techniques: Diagnosing Low-Quality Score With Excel Pivot Tables (1/3) 00:08:00 Advanced Techniques: Diagnosing Low-Quality Score With Excel Pivot Tables (2/3) 00:11:00 Advanced Techniques: Diagnosing Low-Quality Score With Excel Pivot Tables (3/3) 00:07:00 Module 09: Expanding And Refining Your Campaigns Navigating The AdWords Dashboard 00:16:00 How To Edit, Pause And Enable Keywords, Ad Groups and Campaigns 00:15:00 Editing The Essential Campaign Settings 00:06:00 How To Create New Campaigns That Will Improve Your Results 00:15:00 How To Use Your Website To Make The Best Campaigns Possible 00:16:00 How To Set Up Powerful Custom Schedules For Your Campaigns 00:12:00 Understanding Bid Adjustments And Using Them To Enhance Your Custom Schedules 00:12:00 Module 10: Negative Keywords - Your Greatest Ally Understanding Negative Keywords In-Depth 00:14:00 Using Broad, Phrase and Exact Match With Your Negative Keywords 00:07:00 Adding and Removing Negative Keywords and Negative Keyword Lists 00:20:00 Module 11: Making Your Ads Unstoppable With Multiple Ad Extnesions Introduction To Ad Extensions 00:06:00 The Benefits Of Using Ad Extensions 00:08:00 Different Types Of Ad Extensions and Best Practices 00:06:00 Adding Sitelink Extensions 00:08:00 Configuring Your Sitelink Extensions For The Best Results 00:11:00 Adding Callout Extensions And Phone Extensions 00:08:00 Module 12: Remarketing - Your Secret Weapon To Converting Like A Boss The 5 Primary Forms Of Remarketing 00:16:00 Realizing The Benefits And Importance Of Remarketing 00:13:00 How To Create And Add Your Remarketing Tag 00:09:00 Creating Your First Remarketing Audience 00:13:00 Configuring Your Remarketing Campaign Settings 00:14:00 Module 13: Keeping Track Of Profits With Conversion Tracking Understanding The Basics Of Conversion Tracking 00:14:00 Exploring The Different Conversion Actions Visitors Take On Your Site 00:14:00 Setting Up Conversion Tracking For Form Submissions 00:18:00 Generating And Installing Your Conversion Tracking Tag 00:09:00 Understanding The Basics Of Phone Call Tracking 00:09:00 Setting Up Phone Call Tracking And Understanding How To Analyze Conversion Data 00:10:00 Module 14: Profitable Bidding Strategies Return On Investment (ROI) vs Return On Ad Spend (ROAS)_ Important Distinction 00:15:00 How To Mathematically Calculate ROI and ROAS 00:09:00 Calculating Max CPC Bids From Your Conversion Rate And Conversion Value 00:12:00 Calculating Profitable Keyword Bids Based On Revenue Per Click 00:09:00 Module 15: Using AdWords Scripts To Enhance Performance and Increase Optimization Speed Introduction To AdWords Scripts - What Are Scripts 00:05:00 Bidding To Average Position AdWords Script (Part 1) 00:12:00 Bidding To Average Position AdWords Script (Part 2) 00:14:00 Module 16: Conclusion ... Goodbye For Now! Conclusion 00:03:00 Module 17: Bonus Material! Part 1 Understanding Search Queries and What We Learn From Searcher Languagage 00:18:00 Part 2 Accessing The Search Query Report and Understanding Long Tail Keywords 00:18:00 Part 3 Qualifying Your Ad Text And How To A_B Split Test Your Ads 00:23:00 Calculating Profitable Keyword Bids Based On Revenue Per Click 00:09:00

This e-learning / online course looks at: Why services need awareness The law Types of discrimination and hate crime Terminology Forms of anti-LGBT+ prejudice Impact on individuals Barriers to accessing services and reporting issues Meeting the needs of LGBT+ individuals

Welcome to this short Online Programme on equality and diversity. Its purpose is to explain what equality and diversity mean and how they affect you. We will also look at some of the barriers that can prevent equality from being realised and cover the key legislation surrounding it. Finally, we will take a look at both employers' and employees' responsibilities in relation to the legislation.

This short online programme is designed for anyone who comes into contact with children through their work or leisure activities. Information sharing is key to delivering better, more efficient services that are coordinated around the needs of children, young people and families. It is essential to enable early intervention and preventative work, for safeguarding and promoting welfare and for wider public protection. Information sharing is a vital element in improving outcomes for all.

The Foundations of Marketing Mix course is an in-depth exploration of essential marketing concepts within the context of tourism and hospitality industries. It offers a comprehensive understanding of the Marketing Mix and the Nine P Model, encompassing People, Planning, Product, Place, Price, Promotion, Partners, Presentation, and Passion. This course delves into the critical analysis of these elements to facilitate strategic decision-making. This course merges theoretical foundations with practical applications, fostering a holistic grasp of marketing strategies essential for success in the dynamic tourism and hospitality industries. After completing this course, you will be able to: Evaluate the Marketing Mix and the comprehensive Nine P Model, delving into its nuanced components and implications. Gain insights into the pivotal role of Tourism and Hospitality within a country's economy. Explore marketing as an integrated and cross-functional activity within the Tourism and Hospitality sectors. Comprehend and apply Integrated Marketing strategies tailored to the Tourism and Hospitality Business landscape. "Foundations of Marketing mix" delves into core principles and methodologies shaping successful marketing strategies. This course covers market analysis, consumer behavior, and strategic planning techniques to build effective marketing campaigns. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. The Components of the Marketing Mix Self-paced pre-recorded learning content on this topic. Foundations of Marketing Mix Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be an added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. · Guest Service Management· Hospitality Marketing Strategies· Tourism Industry Professionalism· Hospitality Branding and Standards· Customer Experience Enhancement· Hospitality and Tourism Management Strategies· Digital Marketing Specialization· Brand Management Specialization· Strategic Marketing Management Specialization· Marketing Analytics Specialization· International Marketing Specialization Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Hello future dance stars! Get ready to leap into action with our exciting Junior Jazz Dance Class. This course is exclusively curated for our spirited dancers aged between 8 and 11, who are ready to jazz up their dance skills and truly come alive on the dance floor. Welcome to the world of jazz dance - a world filled with high energy, fun and freedom! Jazz dance is more than just dancing; it's expressing yourself, making new friends, and gaining invaluable skills for life. And we can't wait to embark on this exciting journey with you! Our Junior Jazz Dance Class will take you deeper into the vibrant world of jazz dance. You'll master intricate jazz steps and techniques that form the backbone of this versatile dance style. From the rhythmic "jazz walk" to the mesmerising "pas de bourrée", every week brings a new move to conquer, and our team of dedicated instructors are here to guide you every step of the way. Now, who's ready for some dramatic leaps and spins? We've designed specific segments of the class to focus on these exciting elements of jazz dance. By mastering these leaps and turns, you'll not only be enhancing your dance repertoire, but also boosting your flexibility, coordination and plasticity. And we promise, there's nothing quite as thrilling as nailing that perfect pirouette or executing a flawless leap across the dance floor! But our Junior Jazz Dance Class offers so much more than just dance skills. At the heart of every class, we focus on developing the person as much as the dancer. We believe that dance is a powerful tool for building self-esteem and fostering life skills. Through dance, our juniors learn how to express themselves confidently, collaborate with others, and even overcome challenges with grace. Finding new friends is a delightful side effect of joining our dance family. In our class, every child gets the opportunity to make connections that go beyond the dance floor. We are more than just a class, we are a community of young, enthusiastic dancers supporting each other every leap and turn of the way. And yes, we are committed to making each class an unforgettable experience! We encourage individual creativity and improvisation. This gives our Junior Jazz Dancers the chance to dance their heart out in their unique style and truly shine! So, put on your jazz shoes, young stars! Let's embark on a journey of rhythm, movement, and self-expression in the Junior Jazz Dance Class. We can't wait to see how you'll shine, grow, and, most importantly, enjoy the world of jazz dance. See you on the dance floor! Remember, dance is about self-expression and joy. So, bring your energy, enthusiasm, and let's jazz it up in the Junior Jazz Dance Class!