• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

9328 Courses in Cardiff delivered Online

Microsoft Excel Online Training

By Study Plex

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

Microsoft Excel Online Training
Delivered Online On Demand
£19

Microsoft Excel Diploma

By Study Plex

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

Microsoft Excel Diploma
Delivered Online On Demand
£19

Negotiation Skills Certificate

5.0(1)

By Course Gate

Whether you want to close a business deal or sell a house effective negotiation skills can help you seal the deal. This craft can take you a long way in both your personal and professional life. Learn this useful skill set from the comfort of your home with the Negotiation Skills Certificate course. This course will take your skills to the next level in no time. This course will provide quality training on negotiation. Through the informative and engaging modules, you will get a clear understanding of collaborative negotiation. Then it will provide elaborate lessons on the seven steps of successful negotiation. Next, you will learn how to apply these steps in your home. The course will also teach you tips and tricks to negotiate with different personalities. In addition to this valuable skill set you will also receive a certificate of achievement which will add significant value to your resume. Join now! Learning Outcomes  Get introduced to the essentials of collaborative negotiation Learn about the 7 steps of successful negotiation in detail Know how to use these 7 steps in your home Develop the skills to negotiate with different personality types Identify the practices you should avoid while negotiating Who is this Course for? Anyone who wants to improve their negotiation skills can join the course. The Negotiation Skills Certificate course will equip the learners with excellent negotiation techniques and help them close lucrative deals. Entry Requirements Individuals from any background can take the course A good understanding of the English language, numeracy and ICT Any smart device such as a laptop, pc, or smartphone with an internet connection CPD Certificate from Course Gate  After completing the final assignment, you will receive a CPD-accredited certificate. The PDF copy of the certificate will cost you £9. You can order the hard copy for £15, or you can get both the hard copy and PDF certificate for £22. Career Path This course will provide the learners with an in-depth understanding of the subject. After completing the course, the learners will develop the skills and knowledge to explore career opportunities in the following fields  Sales Executives Customer Service Executives Project Managers Estate Agent Contract Specialist Course Curriculum Introduction and The Principles of Collaborative Negotiation Welcome and Course Overview 00:06:00 Why Good Negotiation Practice Leads to Better Relationships 01:03:00 Shameless Book Plug 00:01:00 Millie's Cookie Story 00:07:00 Exercise 1: Intentions / Objectives for This Programme 00:01:00 Giving Structure to Your Negotiation Strategy Negotiation is not 00:02:00 Distinguishing Negotiation from -Haggling 00:07:00 The 7 Steps to Negotiation Success 00:06:00 Exercise 2: Giving Structure to your Negotiations 00:01:00 Step One - Preparing Yourself for Collaborative Negotiation Preparing Yourself and Your WIN Outcomes 00:06:00 Exercise 3: Securing Commitment to Negotiate 00:01:00 The 4 P's 00:01:00 The Importance of Personality 00:02:00 We, Then Me 00:02:00 Exercise 4: The 4 P's 00:01:00 Step Two - Preparation - Understanding the Power of Variables Introduction to Variables 00:04:00 Video Examples of Excellent Creativity in Variables 00:03:00 Exercise 5: Understanding the Power of Variables 00:01:00 Using the WIN Matrix 00:03:00 Exercise 6: Write Your Win Matrix 00:02:00 Step Three - Understanding Your Partner's Point of View Introduction 00:01:00 Example Story- Maps of the World - Dyl's Den 00:03:00 Exercise 7: Stepping Into Your Partner's Shoes 00:01:00 Step Four - Discussing Introduction- Stating Intentions 00:04:00 Co-Active Listening- Are You Really Listening 00:02:00 The Power of Pause 00:01:00 Exercise 8: Using Open Questions 00:01:00 Exercise 9: Going Above and Beyond Their Wildest Dreams 00:01:00 Exercise 10: Socratic Questioning 00:04:00 Exercise 11: Creating a Discussion Agreement Statement= 00:01:00 Step Five - Proposing Introduction to the Propose Stage 00:05:00 Exercise 12: Putting Your Proposal into Writing 00:01:00 Step Six - Bargaining Introduction 00:02:00 Exercise 13: Creating a Bargaining Agreement Statement 00:02:00 The Power of Silence 00:04:00 Exercise 14: Developing Your Time-Out Strategy 00:01:00 Step Seven - Agreeing Introduction to Bargaining 00:04:00 The Written Columbo 00:02:00 Exercise 15: Drafting an 'Agreement In Principle' 00:01:00 Getting Yourself Out of the Way - The Human Operating System Introduction - The Missing Link 00:04:00 Exercise 16: Noticing Your Thinking 00:02:00 What Does this Mean in Your Negotiations? 00:03:00 Understanding Personality Why Personality? 00:05:00 Introducing the 4 Colours 00:04:00 Introducing the 8 Aspects 00:04:00 Inspiration v Discipline Driven 00:04:00 Exercise 17: Teddy Bear 00:01:00 Big Picture vs Down to Earth 00:03:00 Exercise 18: Football Club Trip 00:01:00 People Focused vs Outcome Focused 00:02:00 Splash App 00:02:00 Exercise 19: Completing Your Own Assessment 00:01:00 Negotiation with Different 'Personality Types' 00:04:00 Using the Seven Steps at Home Introduction 00:04:00 Avoiding Common Gambits Some Negotiators Use Nibbling - The Columbo 00:02:00 The Flinch 00:02:00 The Red Herring 00:01:00 Higher Authority 00:02:00 The Reluctant Buyer - Seller 00:01:00 The Best of a Bad Choice 00:01:00 Conclusion - Can You Really Get More by Giving More? Conclusion & Thank You 00:02:00 Bonus Lecture 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Negotiation Skills Certificate
Delivered Online On Demand3 hours 37 minutes
£11.99

Level 3 Health and Safety in the Workplace - CPD Certified Diploma

By Compete High

🚀 Unlock Your Potential with Level 3 Health and Safety in the Workplace Course! 🚀 Are you ready to elevate your career and become a safety champion in your workplace? Look no further! Our Level 3 Health and Safety in the Workplace course is designed to equip you with the essential knowledge and skills to ensure a safe and healthy working environment for yourself and your colleagues.   🌟 Benefits of Taking Our Course 🌟 Enhanced Safety Awareness: Gain a comprehensive understanding of occupational health and safety principles, regulations, and best practices. You'll learn how to identify and mitigate workplace hazards effectively. Reduced Risks: By mastering risk assessment techniques and emergency procedures, you'll be empowered to minimize workplace accidents and injuries, creating a safer environment for everyone. Legal Compliance: Stay ahead of the curve by staying updated on the latest health and safety legislation. Our course will ensure you understand your legal obligations as an employer or employee, helping you avoid costly penalties and legal issues. Improved Confidence: Armed with knowledge and expertise, you'll approach your work with confidence, knowing that you have the skills to handle any safety-related challenges that may arise. Career Advancement: Stand out in the job market and open doors to new opportunities. Employers highly value candidates with strong health and safety credentials, making you a desirable asset to any organization. Peace of Mind: Whether you're a seasoned professional or new to the field, our course provides you with the peace of mind that comes from knowing you're equipped to protect yourself and others in the workplace.   Who is this for? 👨‍💼👩‍💼 Our Level 3 Health and Safety in the Workplace course is suitable for individuals across various industries and job roles, including: Managers and supervisors Human resources professionals Safety officers and representatives Health and safety consultants Workers in high-risk environments No matter your background or experience level, if you're committed to ensuring a safe and healthy workplace, this course is for you!   Career Path 🛤️ Completing our Level 3 Health and Safety in the Workplace course opens up a world of opportunities in the field of occupational health and safety. Here are just a few potential career paths you can pursue: Health and Safety Manager: Lead safety initiatives within organizations, develop policies and procedures, and oversee compliance efforts to ensure a safe working environment. Safety Consultant: Provide expert guidance to businesses on health and safety matters, conducting assessments, offering recommendations, and assisting with regulatory compliance. Risk Manager: Identify and assess potential risks within organizations, develop strategies to mitigate those risks, and ensure compliance with relevant safety standards and regulations. Occupational Health Specialist: Focus on preventing and managing workplace injuries and illnesses, promoting employee wellness, and advocating for safe working conditions. Safety Trainer: Educate workers on safety protocols, procedures, and best practices, empowering them to play an active role in maintaining a safe workplace culture.   Don't miss out on the opportunity to take your career to new heights with our Level 3 Health and Safety in the Workplace course! Enroll today and embark on your journey towards becoming a safety leader in your industry. 🌟   FAQ (Frequently Asked Questions) for Level 3 Health and Safety in the Workplace Q1: What is the significance of Level 3 Health and Safety in the Workplace? Level 3 Health and Safety in the Workplace course is designed to provide participants with advanced knowledge and skills necessary to ensure a safe and healthy work environment. It covers a wide range of topics including risk assessment, hazard identification, emergency procedures, and legal responsibilities. Achieving this level of certification demonstrates competence in managing workplace health and safety effectively, which is crucial for protecting employees, complying with regulations, and minimizing risks of accidents or injuries. Q2: Who should consider taking the Level 3 Health and Safety in the Workplace course? This course is suitable for individuals in various industries and roles, including managers, supervisors, health and safety representatives, and anyone responsible for overseeing health and safety practices within the workplace. It is beneficial for those seeking to enhance their understanding of health and safety regulations, improve risk management skills, and contribute to creating a safer work environment for themselves and their colleagues. Q3: What topics are covered in the Level 3 Health and Safety in the Workplace course? The course curriculum typically includes modules on risk assessment, hazard control measures, health and safety legislation, accident investigation, emergency procedures, and promoting a positive safety culture. Participants will also learn about the importance of communication, consultation, and training in maintaining effective health and safety practices within the workplace. Q4: How is the Level 3 Health and Safety in the Workplace course assessed? Assessment methods may vary depending on the training provider, but they often include a combination of written examinations, practical assessments, and/or project work. Participants are evaluated on their understanding of key concepts, ability to apply health and safety principles to real-world scenarios, and compliance with relevant regulations and best practices. Q5: What are the potential benefits of completing the Level 3 Health and Safety in the Workplace course? Earning a Level 3 Health and Safety in the Workplace certification can lead to various benefits, including improved job prospects, enhanced credibility in the field of health and safety, better risk management skills, increased awareness of legal responsibilities, and ultimately, a safer and healthier work environment for all employees. Additionally, organizations may benefit from reduced accident rates, improved compliance with regulations, and enhanced reputation for prioritizing health and safety. Course Curriculum Module 01 Health and Safety Management Health and Safety Management 00:00 Module 02 Engineering Safety Engineering Safety 00:00 Module 03 Fire and Electrical Safety Fire and Electrical Safety 00:00 Module 04 Occupational Health and Personal Protective Equipment Occupational Health and Personal Protective Equipment 00:00 Module 05 Mental Healthcare Mental Healthcare 00:00 Module 06 Public Health Public Health 00:00 Module 07 Working at Height - Hazards and Control Working at Height - Hazards and Control 00:00 Module 08 Work Equipment Hazards and Control Work Equipment Hazards and Control 00:00 Module 09 Electrical Hazards and Control Electrical Hazards and Control 00:00 Module 10 Chemical and Biological Health Hazards and Control Chemical and Biological Health Hazards and Control 00:00 Module 11 Reporting Accidents and Incidents at Work Reporting Accidents and Incidents at Work 00:00 Module 12 Legal Framework (UK) for Workplace First Aid Legal Framework (UK) for Workplace First Aid 00:00 Module 13 Practice of self-hygiene Practice of self-hygiene 00:00 Module 14 HACCP Food Safety HACCP Food Safety 00:00 Module 15 A Guide to Safe Manual Handling A Guide to Safe Manual Handling 00:00 Module 16 Work Equipment Maintenance Work Equipment Maintenance 00:00 Module 17 Occupational Diseases Occupational Diseases 00:00 Module 18 Exposure to Mutagens Biological Agents and Carcinogens Exposure to Mutagens Biological Agents and Carcinogens 00:00 Module 19 Dangerous Occurrences Dangerous Occurrences 00:00 Module 20 RIDDOR Report RIDDOR Report 00:00

Level 3 Health and Safety in the Workplace - CPD Certified Diploma
Delivered Online On Demand20 hours
£4.99

Medical Transcription Training - CPD Certified

By Wise Campus

Medical Transcription: Medical Transcription Training Course Online Do you want a course on Medical Transcription to keep you better prepared for your Medical Transcription profession? our course will help you on that case. On the very first module of the Medical Transcription course, you can get ideas of medical transcription from this introduction to Medical Transcription. Then the Medical Transcription course will teach all the WH questions of the Medical Transcription subject. This Medical Transcription also explains medical languages boot camp with other documentation preparation. Moreover, the Medical Transcription course will explain the communicate style and data protection tecniques as a medical transcription expert. Take the initial steps toward a successful long-term career by studying the Medical Transcription course. Special Offers of this Medical Transcription: Medical Transcription Training Course This Medical Transcription: Medical Transcription Training Course includes a FREE PDF Certificate. Lifetime access to this Medical Transcription: Medical Transcription Training Course Instant access to this Medical Transcription: Medical Transcription Training Course Get FREE Tutor Support to this Medical Transcription: Medical Transcription Training Course Medical Transcription: Medical Transcription Training Course Online An engaging introduction to medical transcription can be found in the Medical Transcription: Medical Transcription Course. You can learn how to create medical reports and the purpose of medical transcription from the Medical Transcription course. Along with other documentation preparation skills, this medical transcription program teaches medical languages. In addition, the Medical Transcription course will cover data protection and communication protocols for medical clients. Who is this course for? Medical Transcription: Medical Transcription Training Course Online Anyone may benefit from this Medical Transcription: Medical Transcription Training Course, including new grads, job seekers, and students. Requirements Medical Transcription: Medical Transcription Training Course Online To enrol in this Medical Transcription: Medical Transcription Training Course, students must fulfil the following requirements. To join in our Medical Transcription Training Course, you must have a strong command of the English language. To successfully complete our Medical Transcription Training Course, you must be vivacious and self driven. To complete our Medical Transcription: Medical Transcription Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Medical Transcription Course. Career path Medical Transcription: Medical Transcription Training Course Online You may work as a medical transcriptionist, audio typist, medical office manager, and many other positions after finishing this course on Medical Transcription: Medical Transcription Training Course!

Medical Transcription Training - CPD Certified
Delivered Online On Demand1 hour 18 minutes
£12

Facial Massage Therapy Certificate with Luxury Spa Facial Course - CPD Certified

5.0(3)

By School Of Health Care

Facial Massage: Facial Massage Course Online Do you want to work as a Facial Massage: Facial Massage Course expert or expand your knowledge in this field? So, this Facial Massage course is for you. This Facial Massage: Facial Massage Course will help you to solidify your commitment to advancing your pro career while also broadening your understanding of this industry. This Facial Massage: Facial Massage Course will give you a solid foundation for becoming a confident Facial Massage expert, as well as more advanced your capability in this sector. With this Facial Massage: Facial Massage Course, all learners have access to dedicated learning assistance and 24/7 support. Throughout the course, you will receive assistance and answers to all of your questions. So, enroll in this Facial Massage: Facial Massage Course right now. Main Course: Level 2 Certificate In Facial Services Course Free courses included with Facial Massage: Facial Massage Course: Along with Facial Massage course you will get free Luxury Spa Facial Course Along with Facial Massage course you will get free Body Massage Therapy Along with Facial Massage course you will get free Indian Head Massage Training Special Offers of this Facial Massage: Facial Massage Course: This Facial Massage: Facial Massage Course includes a FREE PDF Certificate. Lifetime access to this Facial Massage: Facial Massage Course Instant access to this Facial Massage: Facial Massage Course 24/7 Support Available to this Facial Massage: Facial Massage Course Facial Massage: Facial Massage Course Online This Facial Massage: Facial Massage Course main objective is to equip students with the theoretical and practical knowledge of facial skin care procedures. Through the Facial Massage: Facial Massage Course learners will gain knowledge of facial consultation and skin analysis. This Facial Massage: Facial Massage Course also covers washing, massaging, applying, and removing masks. In addition, the Facial Massage: Facial Massage Course will teach you about how to modify therapy to meet the needs of the client and provide aftercare instructions. Additionally, client care, communication, and health and safety are covered in this Facial Massage: Facial Massage Course. Who is this course for? Facial Massage: Facial Massage Course Online This advanced Facial Massage Course is appropriate for anyone who wants to gain experience in this fascinating field. Requirements Facial Massage: Facial Massage Course Online To enrol in this Facial Massage: Facial Massage Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Facial Massage: Facial Massage Course. Be energetic and self-motivated to complete our Facial Massage: Facial Massage Course. Basic computer Skill is required to complete our Facial Massage: Facial Massage Course. If you want to enrol in our Facial Massage: Facial Massage Course, you must be at least 15 years old. Career path Facial Massage: Facial Massage Course Online This Facial Massage: Facial Massage Course opens a new door for you to enter the relevant job market and also gives you the opportunity to gain in-depth knowledge along with the necessary skills to flourish in no time. You will also be able to add your new skills to your CV.

Facial Massage Therapy Certificate with Luxury Spa Facial Course - CPD Certified
Delivered Online On Demand54 minutes
£12

Mindfulness Diploma

By IOMH - Institute of Mental Health

Overview In a world filled with constant noise and stress, finding calm can be a challenge. The "Meditation & Mindfulness Training for Teachers" course offers a way to bring peace and focus into your life and your classroom. This course is designed to help teachers like you learn and teach mindfulness and meditation techniques. You will start by understanding how meditation affects the nervous system and how to use breathing exercises to centre yourself. As you progress, you’ll gain practical skills for guiding meditation sessions and supporting your students. By the end of the course, you will feel confident in using mindfulness techniques to improve your teaching and well-being. Join us to make a positive impact on your classroom and your life with simple, effective mindfulness practices. Become proficient in Meditation & Mindfulness Training for Teachers by grasping all the essential knowledge from our top-quality course step by step. Enrol now to ensure that your Meditation & Mindfulness Training for Teachers mastery is not limited to only conceptual frameworks! This Meditation & Mindfulness Training for Teachers will assist you in standing out from the crowd and being more efficient in your chosen area of expertise. Furthermore, if you require assistance with the Meditation & Mindfulness Training for Teachers, we will provide experts who will support and guide you. So, add this Meditation & Mindfulness Training for Teachers to your cart and boost your personal and career development. In this Meditation & Mindfulness Training for Teachers, you will: Sharpen your skills to help you advance your career. Acquire a comprehensive understanding of various related topics and tips from industry experts. Learn in-demand knowledge and skills in high demand among UK employers, which will help to kickstart your Meditation & Mindfulness Training for Teachers career. Enrolling in the Meditation & Mindfulness Training for Teachers can assist you in getting into your desired career faster than you ever imagined. So, without further ado, start now! Process of Evaluation After studying the Mindfulness Diploma course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Mindfulness Diploma course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Mindfulness Diploma is suitable for anyone aspiring to start a career in Mindfulness Diploma; even if you are new to this and have no prior knowledge on Mindfulness Diploma, this course is going to be very easy for you to understand.  And if you are already working in the Mindfulness Diploma field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Mindfulness Diploma course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Mindfulness Diploma course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Mindfulness Diploma course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Mindfulness Diploma course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Mindfulness Diploma The Why of No - why No matters and why it's hard to say Why is No Important? 00:07:00 Why is No Difficult? Your Inner Gopher 00:09:00 Why is No Difficult? Six things that Drive you to Say Yes 00:09:00 The What of No - What to say No to, and when to say it What to do to Challenge your Instincts on No 00:05:00 What to Say No to 00:05:00 Specific things to Say No to 00:05:00 When to Say No 00:08:00 What are your Choices? 00:09:00 When to Say No to Relationships 00:04:00 What does No Mean? 00:04:00 What is Special Time? 00:05:00 The How of No - Here's the meat: how to say NO in lot's of situations How to be Happy with No 00:07:00 How to Decide Yes or No: Six Tools to Help Make Your Decision 00:10:00 How to Decide Yes or No: Six Ways of Thinking about Any Problem 00:05:00 How to Make No Feel Easier 00:09:00 How to Say No 00:04:00 How to say No to Friends and Loved Ones 00:02:00 How to say No to your Customers 00:03:00 How to say No to False Assumptions 00:06:00 How to say No to Temptation 00:04:00 How to Say No to your Colleagues at Work 00:03:00 How to Get on with it: How to say No to Procrastination 00:08:00 How to say No in Negotiations 00:11:00 More Tips on How to Say No 00:05:00 The What if of No - Oh wait! What if? ...Don't worry; I've got you covered What if they Resist your No? 00:12:00 What if you want to Say Yes? 00:04:00 Four 'What if?' Questions 00:04:00 What if you don't Follow my Advice? 00:02:00 Mindfulness Meditation for Daily Life Introduction : Let's begin the journey to true love! 00:09:00 Mindfulness Practice 01 : Breath- a doorway to freedom! 00:13:00 Meditation 02 : Are you ready to fall in love with your body as a sacred temple? 00:13:00 Practice 03 : Discover the mystery of the present through sensation tracking 00:13:00 Practice 04- If you like freedom this practice is for you! 00:10:00 Practice 05 : Opening to the Secret of the Magical Pause 00:11:00 Practice 06 : Lining Up Your Speech with Integrity 00:09:00 Practice 07 : Dropping Down Into the Mystery of the Golden Realms 00:09:00 Practice 08- A Return to the Bliss of Self-Love 00:07:00 Now You're Ready to Dive Into Practice - A Review of it All 00:04:00 Mindfulness in the Workplace Introduction 00:01:00 The Practice of Standing Tall 00:02:00 Move and Relate with Confidence 00:03:00 Knowing What You Know 00:06:00 Send the Inner Critic Packing 00:06:00 Taking Input 00:06:00 Build Bridges, Not Walls 00:04:00 Appreciation Makes Your Team Flow 00:04:00 The Quality of Your Attention Matters 00:04:00 Acknowledgement Pumps Us Up! 00:04:00 Grounding Meditation 00:03:00 Conclusion 00:02:00

Mindfulness Diploma
Delivered Online On Demand5 hours 12 minutes
£15

Complete Health: The Perfect Diet Exercise And Motivation

By NextGen Learning

Complete Health: The Perfect Diet Exercise And Motivation Course Overview "Complete Health: The Perfect Diet Exercise And Motivation" is an all-encompassing course designed to provide a comprehensive understanding of health, fitness, and wellness. The course covers essential areas including diet, exercise, and motivation, offering learners the knowledge and tools to enhance their overall wellbeing. Through a well-structured curriculum, learners will explore the significance of a balanced diet, effective exercise routines, and how to maintain motivation for long-term success. By the end of the course, learners will be equipped to make informed decisions about their health, improve their fitness levels, and adopt a sustainable lifestyle. Course Description This course delves deeply into the key components of health and fitness, covering a broad spectrum of topics such as healthy dieting, weight loss strategies, building muscle, and stress reduction techniques. Learners will gain insight into nutrition essentials and the importance of physical exercise for overall health. The course also addresses mental health by offering guidance on managing stress and enhancing motivation. As learners progress, they will develop a solid foundation in health principles, acquiring the skills to implement and maintain a healthy lifestyle. The structured learning experience ensures that students not only grasp theoretical knowledge but also understand its application in daily life. Complete Health: The Perfect Diet Exercise And Motivation Curriculum: Module 01: Introduction Module 02: Healthy Dieting & Weight Loss Module 03: Exercise & Building Muscle Module 04: Mental Health & Stress Reduction Module 05: Common Health & Fitness Questions Answered (See full curriculum) Who is this course for? Individuals seeking to improve their overall health and fitness. Professionals aiming to broaden their knowledge of health and wellness for career development. Beginners with an interest in health, fitness, and wellness. Those looking to gain a deeper understanding of diet and exercise principles. Career Path Health Coach Fitness Trainer Wellness Consultant Nutritionist Mental Health Advisor Corporate Wellness Coordinator

Complete Health: The Perfect Diet Exercise And Motivation
Delivered OnlineFlexible Dates
£7.99

Children's Social Behaviour Training & Management

5.0(1)

By Course Gate

Guide children’s behaviour with positive techniques in our Children's Social Behaviour Training course.

Children's Social Behaviour Training & Management
Delivered Online On Demand14 hours
£11.99

Photoshop CC Masterclass - Beginner to Advanced

4.3(43)

By John Academy

Description Do you want to master the world's best photo editing software? Or are you new to Adobe Photoshop CC? Then enrol the Adobe Photoshop CC Foundation course and begin your acquaintance with the course. The course is for the learners who have little or no knowledge about the photo editor. You will start your journey from the beginning. You will be familiar with the user interface and know how to open and create an image in Adobe Photoshop. The course introduces you to the essential tools, brushes and other features so that you can able to decide which tools to select while editing. Additionally, the course illustrates the concepts of colour schemes and guides you on how to use the colors efficiently. The procedures of adding text and text styles, working with Layers, adjusting Layers, customizing the workspace, moving and transforming Pixels, cropping images, etc. will be covered in the course. Finally, the course shows you how to print, convert and export files from Photoshop. Shortly, the course gives you a general understanding of the application so that you can proceed with the advanced skills. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Photoshop CC Masterclass - Beginner to Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Photoshop CC Masterclass - Beginner to Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Adobe Photoshop CC Beginner Introduction Introduction FREE 00:03:00 Introduction to Photoshop Introduction to Photoshop 00:05:00 Understanding Types of Documents 00:04:00 Understanding Resolution 00:04:00 Creating New Documents 00:06:00 Using Artboards 00:05:00 Using CC Templates 00:03:00 Utilizing the Search Feature 00:02:00 Customizing the Workspace Using Workspace Presets 00:02:00 Moving, Closing, and Opening Panels 00:06:00 Understanding Document Views 00:06:00 Using the History Panel 00:06:00 Working with Layers Why Layers 00:02:00 Using Layers 00:07:00 Creating Fill Layers 00:05:00 Applying Blending Modes 00:04:00 Using Layer Styles 00:09:00 Discovering the Properties Panel 00:08:00 Understanding Selections Creating Basic Selections 00:09:00 Using the Lasso Tools 00:08:00 Understanding the Quick Select Tools 00:07:00 Editing the Quick Mask 00:04:00 Saving Selectionsv 00:04:00 Moving Selections to Layers.mp 00:03:00 Understanding and Using Color Understanding Color Modes 00:10:00 Creating Swatches 00:06:00 Using Masks and Advanced Layers Applying Layer Masks 00:00:00 Deleting Layer Masks 00:01:00 Organizing Layers 00:03:00 Merging Layers 00:02:00 Flattening Layers 00:02:00 Working with Layer Comps 00:06:00 Using Adjustment Layers Using Image Adjustments 00:07:00 Understanding Adjustment Layers 00:10:00 Using Layer Masks with Adjustment Layers 00:03:00 Cropping Images Using the Crop Tool 00:05:00 Using the Crop Tool to Add Canvas 00:02:00 Moving and Transforming Pixels Using Free Transform 00:04:00 Working with Other Transform Options 00:03:00 Flipping Pixels 00:01:00 Adding Text and Text Styles Using the Type Tool 00:10:00 Discovering Typesetting 00:08:00 Formatting Text 00:09:00 Creating Type on a Path 00:03:00 Warping Type 00:03:00 Using Styles on Type 00:08:00 Applying Special Effects Using Layer Styles 00:05:00 Working with Patterns 00:03:00 Applying Filters 00:04:00 Creating Pixels with Filters 00:06:00 Exporting from Photoshop Printing in Photoshop 00:03:00 Converting to CMYK 00:04:00 Converting to Other File Types 00:13:00 Using File Info 00:09:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Intermediate Start Here Introduction FREE 00:03:00 Painting and Using Brushes Painting with Brushes 00:09:00 Using the Brushes Panel 00:06:00 Defining Custom Brushes 00:04:00 Saving Tool Presets 00:02:00 Using the History Brush 00:03:00 Using Vector Tools Working with Vector Shapes 00:10:00 Creating Custom Shapes 00:02:00 Using the Pen Tool 00:07:00 Discovering Paths 00:04:00 Understanding Vector Masks 00:03:00 Using Vector Objects and Spot Colors 00:06:00 Using Libraries What is the CC Library 00:02:00 Adding and Deleting Assets in the Library 00:03:00 Sharing Assets 00:02:00 Creating New Libraries 00:03:00 Sharing a Library 00:02:00 Advanced Special Effects Using the Blur Filters 00:06:00 Applying the Distort Filters 00:03:00 Creating a Pixelated Look 00:02:00 Stylizing Effects 00:02:00 Using Liquify 00:05:00 Using Smart Filters 00:04:00 Working with Smart Objects 00:03:00 Loading a Texture into Type 00:04:00 Working with RAW Images What is a Raw Image 00:05:00 Processing Raw Images 00:12:00 Opening a JPEG File in Raw 00:06:00 Retouching Basics Developing a Strategy for Retouching 00:04:00 Using Retouching Tools 00:10:00 Using the Dust and Scratches Filter 00:04:00 Applying Sharpening 00:08:00 Working with Face Aware Liquify 00:06:00 Automating Tasks Using Actions 00:03:00 Creating Actions 00:07:00 Using Droplets 00:05:00 Using the Image Processor 00:05:00 Creating an HDR Image 00:07:00 Creating a Panoramic Image 00:07:00 Integration with other Adobe Software Using PSD Files in InDesign 00:04:00 Using PSD Files in Illustrator 00:03:00 Using PSD Files in Dreamweaver 00:04:00 Understanding Color Management Why Color Management 00:03:00 Calibrating a Monitor 00:04:00 Calibrating a Printer 00:03:00 Loading Profiles into PSDs 00:02:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Advanced Introduction Introduction FREE 00:03:00 Processing Raw Images What is the RAW Format 00:04:00 Understanding White Balance 00:05:00 Setting Exposure 00:07:00 Working with Color and Clarity 00:03:00 Working with Adobe Camera Raw Updating Adobe Camera Raw 00:01:00 Using the Before and After Views 00:05:00 Resetting the Sliders 00:01:00 Understanding the Workflow Options 00:04:00 Setting the Camera Raw Preferences 00:03:00 Working with the Tools Understanding the White Board Tool 00:03:00 Using the Color Sampler 00:01:00 Working with the Targeted Adjustment Tool 00:02:00 Cropping Images 00:03:00 Applying Straightening 00:01:00 Using the Spot Removal Tool 00:05:00 Applying the Red Eye Tool 00:03:00 Understanding the Adjustment Brush 00:04:00 Using the Graduated Filter 00:02:00 Applying the Radial Filter 00:02:00 Rotating Images 00:01:00 Using Advanced Exposure Settings and Sharpening Using Curves 00:03:00 Understanding Sharpening and Noise 00:03:00 Creating Grayscale Images 00:03:00 Using Split Toning 00:03:00 Managing Corrections and Effects Enabling Lens Profiles 00:03:00 Using Effects 00:02:00 Adding Grain 00:02:00 Applying Post Crop Vignette 00:02:00 Using Camera Calibration 00:03:00 Saving Presets 00:02:00 Applying Snapshots 00:02:00 Creating Image Adjustments Using Adjustment Layers 00:02:00 Painting Layer Masks 00:05:00 Discovering Plugins for Photoshop What are Plugins 00:04:00 Using the Nik Collection 00:08:00 Using HDR Pro Effex 00:06:00 Using On1 Effects 00:04:00 Exploring Workflows Introudcing the Workshop Videos 00:04:00 Processing a Landscape Image 00:13:00 Processing a Macro Image 00:09:00 Processing a City 00:11:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Photoshop CC Masterclass - Beginner to Advanced
Delivered Online On Demand10 hours 52 minutes
£12