20943 Certificate of Completion of Training (CCT) courses delivered Online

Overview This British Sign Language Level 1 course will unlock your full potential and will show you how to excel in a career in British Sign Language Level 1. So upskill now and reach your full potential. Everything you need to get started in British Sign Language Level 1 is available in this course. Learning and progressing are the hallmarks of personal development. This British Sign Language Level 1 will quickly teach you the must-have skills needed to start in the relevant industry. In This British Sign Language Level 1 Course, You Will: Learn strategies to boost your workplace efficiency. Hone your British Sign Language Level 1 skills to help you advance your career. Acquire a comprehensive understanding of various British Sign Language Level 1 topics and tips from industry experts. Learn in-demand British Sign Language Level 1 skills that are in high demand among UK employers, which will help you to kickstart your career. This British Sign Language Level 1 course covers everything you must know to stand against the tough competition in the British Sign Language Level 1 field.  The future is truly yours to seize with this British Sign Language Level 1. Enrol today and complete the course to achieve a British Sign Language Level 1 certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the British Sign Language Level 1 course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the British Sign Language Level 1 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 British Sign Language Level 1 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 British Sign Language Level 1 is suitable for anyone aspiring to start a career in British Sign Language Level 1; even if you are new to this and have no prior knowledge on British Sign Language Level 1, this course is going to be very easy for you to understand.  And if you are already working in the British Sign Language Level 1 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 British Sign Language Level 1 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 British Sign Language Level 1 course has no prerequisite.  You don't need any educational qualification or experience to enrol in the British Sign Language Level 1 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 British Sign Language Level 1 course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum British Sign language (BSL) Level 1 Online Course Introduction to BSL FREE 00:04:00 Alphabet Finger spelling and Names Practice Alphabet with 00:01:00 Alphabet 00:01:00 Fingerspelling test 00:01:00 Fingerspelling replay 00:01:00 Names test 00:04:00 Names replay 00:04:00 Greetings Greetings 00:05:00 Greetings without voice try these yourself 00:04:00 Family, question forms and family story Family Vocabulary 00:02:00 Family vocabulary test your memory 00:03:00 Question forms 00:01:00 Question forms test your memory 00:01:00 Family story test 00:03:00 Family Story Recap How did you do 00:03:00 Rooms in the house vocabulary Rooms in the house Vocabulary 00:02:00 Kitchen Vocabulary 00:02:00 Bathroom Vocabulary 00:01:00 Bedroom Vocabulary 00:01:00 Living room and Dining room Vocabulary 00:02:00 Study Vocabulary 00:01:00 Utility room Vocabulary 00:01:00 Garden Vocabulary 00:01:00 Colours Colours 00:01:00 Colours test yourself 00:01:00 Questions and statements about the home Questions and statements about home test 00:01:00 Questions and statements about the home replay were you right 00:01:00 Animals Animal Vocabulary 00:03:00 Animal vocab replay test your knowledge 00:03:00 Short animal story 00:01:00 Short animal story replay were you right 00:01:00 Animal and pet questions 00:01:00 Numbers and Money Numbers 1-30 00:02:00 Numbers 1-30 replay without voice test yourself 00:02:00 Numbers 10's, 100's 00:02:00 Numbers 10's, 100's replay without voice test yourself 00:01:00 Mixed number test 00:01:00 Mixed number test replay 00:01:00 Money £1 - £20 00:01:00 Money £1 - £20 replay test your knowledge 00:01:00 Mixed money test 00:01:00 Mixed money test replay 00:01:00 Time and Months of the Year Time 1 o'clock to 12 o'clock 00:01:00 Days of the week 00:01:00 Months of the year 00:01:00 Time periods 00:02:00 Time periods replay test your knowledge 00:02:00 Describing Ages Describing ages 00:01:00 Describing ages replay without voice test your knowledge 00:01:00 Number and ages phrase test 00:02:00 Number & Ages phrase test replay 00:02:00 Mixed time, ages and money test 00:03:00 Mixed time, ages, and money test replay 00:03:00 Weather Weather Vocabulary 00:02:00 Weather vocab without voice test your understanding 00:02:00 Weather phrase test 00:04:00 Weather phrase test replay 00:02:00 Transport Transport Vocabulary 00:04:00 Transport vocabulary without subtitles - test yourself 00:04:00 Transport phrases without subtitles 00:03:00 Transport phrases replay with subtitles 00:03:00 Directions Directions Vocabulary 00:02:00 Directions vocabulary without subtitles test yourself 00:02:00 Direction phrases test without subtitles 00:03:00 Direction phrases replay with subtitles 00:03:00 Hobbies Hobbies Vocabulary 00:03:00 Hobbies vocabulary without subtitles test yourself 00:03:00 Hobbies phrases test 00:04:00 Hobbies phrases replay with subtitles 00:04:00 Work Work Vocabulary 00:05:00 Work vocabulary without subtitles test yourself 00:05:00 Work phrases test 00:04:00 Work phrases replay with subtitles 00:04:00 Food and Drink Food and Drink Vocabulary 00:08:00 Food and drink without subtitles 00:08:00 Food and drink phrases without subtitles 00:04:00 Food and Drink phrases replay with subtitles 00:04:00 Dialogues No Voice No Subtitles The broken car 00:02:00 Tom's 18th Birthday Party 00:03:00 New House 00:05:00 At the bank without 00:01:00 On a train 00:02:00 Going to a restaurant without 00:02:00 Going on a picnic without 00:02:00 Job interview day 00:01:00 Horse riding without 00:09:00 I'm lost and need directions 00:01:00 Valentine's Day 00:04:00 A day in hospital without 00:01:00 Learning to drive 00:02:00 Meeting up with the family 00:01:00 Dialogues with voice and subtitles The broken car 00:02:00 Tom's 18th birthday party 00:02:00 New house 00:02:00 At the bank 00:01:00 On a train 00:02:00 Going to a restaurant 00:02:00 Going on a picnic 00:02:00 Job interview day 00:02:00 Horse riding 00:01:00 I'm lost and need directions 00:01:00 Valentines Day 00:01:00 A day in hospital 00:02:00 Learning to drive 00:03:00 School reunion 00:02:00 Meeting up with the family 00:02:00 Bonus 5 Stories with voice and subtitles Tom's 18th Birthday Party 00:03:00 New house 00:05:00 On a Train 00:05:00 Valentines day 00:04:00 Learning to drive 00:03:00 Bonus 5 stories with no voice over Tom's 18th Birthday Party 00:03:00 New House 00:05:00 On a train 00:04:00 Valentine's Day 00:04:00 Learning to drive 00:03:00 Refer a Friend Refer a Friend and Claim One Course for FREE 00:00:00

Overview This Power Electronics for Electrical Engineering course will unlock your full potential and will show you how to excel in a career in Power Electronics for Electrical Engineering. So upskill now and reach your full potential. Everything you need to get started in Power Electronics for Electrical Engineering is available in this course. Learning and progressing are the hallmarks of personal development. This Power Electronics for Electrical Engineering will quickly teach you the must-have skills needed to start in the relevant industry. In This Power Electronics for Electrical Engineering Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Power Electronics for Electrical Engineering skills to help you advance your career. Acquire a comprehensive understanding of various Power Electronics for Electrical Engineering topics and tips from industry experts. Learn in-demand Power Electronics for Electrical Engineering skills that are in high demand among UK employers, which will help you to kickstart your career. This Power Electronics for Electrical Engineering course covers everything you must know to stand against the tough competition in the Power Electronics for Electrical Engineering field.  The future is truly yours to seize with this Power Electronics for Electrical Engineering. Enrol today and complete the course to achieve a Power Electronics for Electrical Engineering certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Power Electronics for Electrical Engineering course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Power Electronics for Electrical Engineering 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 Power Electronics for Electrical Engineering 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 Power Electronics for Electrical Engineering is suitable for anyone aspiring to start a career in Power Electronics for Electrical Engineering; even if you are new to this and have no prior knowledge on Power Electronics for Electrical Engineering, this course is going to be very easy for you to understand.  And if you are already working in the Power Electronics for Electrical Engineering 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 Power Electronics for Electrical Engineering 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 Power Electronics for Electrical Engineering course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Power Electronics for Electrical Engineering 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 Power Electronics for Electrical Engineering course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Unit 1- Introduction to Power Electronics Components Module 1- Introduction to Power Electronics 00:13:00 Module 2- Uncontrolled Switches 00:17:00 Module 3- What is the Benefit of Diode 00:06:00 Module 4- Semi-Controlled Switches Part 1 00:09:00 Module 5- Semi-Controlled Switches Part 2 00:14:00 Module 6- Semi-Controlled Switches Part 3 00:05:00 Module 7- What is the Benefit of Thyristor 00:05:00 Module 8- Fully Controlled Switches Part 1 00:17:00 Module 9- Fully Controlled Switches Part 2 00:10:00 Module 10- Fully Controlled Switches Part 3 00:12:00 Unit 2- Fundamentals of Rectifier Circuits Module 1- Overview on Rectifiers 00:02:00 Module 2- Rectifier Definition 00:01:00 Module 3- Half Wave Uncontrolled Rectifier with R Load 00:21:00 Module 4- Example on Half Wave Uncontrolled Rectifier with R Load Part 1 00:06:00 Module 5- Example on Half Wave Uncontrolled Rectifier with R Load Part 2 00:07:00 Module 6- Half Wave Uncontrolled Rectifier with RL Load 00:10:00 Module 7- Derivation of the Discontinuous Current in R-L Load 00:08:00 Module 8- Freewheeling Diode (Commutation Diode) 00:03:00 Module 9- Half Wave R-L Load with FWD 00:09:00 Module 10- Difference Between Continuous and Discontinuous Mode in RL Load 00:07:00 Module 11- Half Wave RL Load with FWD Continuous Mode 00:06:00 Module 12- Example on Half Wave Rectifier with FWD 00:07:00 Module 13- Bridge Full Wave Uncontrolled Rectifier Part 1 00:07:00 Module 14- Bridge Full Wave Uncontrolled Rectifier Part 2 00:05:00 Module 15- Quick Revision on Bridge Full Wave Uncontrolled Rectifier 00:06:00 Module 16- Firing Angle 00:02:00 Module 17- Half Wave Controlled Rectifier R Load 00:05:00 Module 18- Half Wave Controlled Rectifier R-L Load 00:04:00 Module 19- Half Controlled R-L Load with FWD 00:06:00 Module 20- Example 1 00:07:00 Module 21- Example 2 00:08:00 Module 22- Example 3 00:13:00 Module 23- Example 4 00:09:00 Module 24- Example 5 00:05:00 Module 25- Fully Controlled Bridge Rectifier Part 1 00:06:00 Module 26- Fully Controlled Bridge Rectifier Part 2 00:06:00 Module 27- Quick Revision on Bridge Full Wave Controlled Rectifier 00:02:00 Module 28- Example 6 00:08:00 Module 29- Half Controlled Bridge Rectifier 00:08:00 Module 30- Half Controlled Bridge Rectifier with FWD 00:05:00 Module 31- Example 7 00:06:00 Module 32- Example 8 00:07:00 Module 33- Performance Parameters 00:04:00 Module 34- Power Factor 00:04:00 Unit 3- Fundamentals of AC Choppers Module 1- Introduction to AC Choppers 00:02:00 Module 2- Definition of AC Choppers 00:05:00 Module 3- Switching Techniques in AC Choppers 00:06:00 Module 4- Applications on AC Choppers 00:03:00 Module 5- Types of AC Choppers 00:02:00 Module 6- AC Chopper with R Load 00:14:00 Module 7- Example 1 on AC Chopper with R Load 00:06:00 Module 8- Example 2 on AC Chopper with R Load 00:04:00 Module 9- AC Chopper with L Load Part 1 00:13:00 Module 10- AC Chopper with L Load Part 2 00:06:00 Module 11- Example on AC Chopper with L Load 00:08:00 Module 12- AC Chopper with RL Series Load 00:20:00 Module 13- Example on AC Chopper with RL Series Load 00:07:00 Module 14- AC Chopper with RL Parallel Load 00:25:00 Module 15- Example on AC Chopper with RL Parallel Load 00:06:00 Module 16- AC Chopper with Pure Capacitive Load 00:14:00 Module 17- Example on AC Chopper with Pure Capacitive Load 00:04:00 Module 18- AC Chopper Loaded by Heavy Rectifier 00:06:00 Module 19- AC Chopper Loaded by an AC Motor with Sinusoidal Back Emf 00:12:00 Module 20- Example on AC Chopper Loaded by an AC Motor with Sinusoidal Back Emf 00:08:00 Module 21- Integral Cycle Control 00:11:00 Module 22- Example on Integral Cycle Control 00:04:00 Unit 4- Fundamentals of DC Choppers Module 1- Introduction to DC Choppers 00:02:00 Module 2- Definition and Application of DC Choppers 00:05:00 Module 3- Step down DC Chopper with R Load 00:12:00 Module 4- Example on Step Dwon DC Chopper with R Load 00:08:00 Module 5- Generation of Duty Cycle 00:09:00 Module 6- Switching Techniques 00:03:00 Module 7- Step Down DC Chopper with RLE Load Part 1 00:19:00 Module 8- Step Down DC Chopper with RLE Load Part 2 00:15:00 Module 9- Example 1 on Step Down DC Chopper with RLE Load 00:13:00 Module 10- Example 2 on Step Down DC Chopper with RLE Load 00:02:00 Module 11- Step Up DC Chopper with R or RL Load 00:09:00 Module 12- Step Up DC Chopper with RE Load 00:15:00 Module 13- Example on Step Up DC Chopper with RE Load 00:20:00 Module 14- Buck Regulator Part 1 00:16:00 Module 15- Buck Regulator Part 2 00:17:00 Module 16- Example on Buck Regulator 00:03:00 Module 17- Boost Regulator 00:23:00 Module 18- Example on Boost Regulator 00:06:00 Module 19- Buck Boost Converter 00:17:00 Module 20- Example on Buck-Boost Converter 00:05:00 Unit 5- Fundamentals of Inverters Module 1- Introduction to Inverters 00:02:00 Module 2- Definition of Inverters 00:04:00 Module 3- Importance and Applications of Inverters 00:08:00 Module 4- Single Phase Half Bridge R-Load 00:15:00 Module 5- Single Phase Half Bridge RL- Load 00:08:00 Module 6- Performance Parameters of an Inverter 00:05:00 Module 7- Example on Single Phase Half Bridge 00:10:00 Module 8- Single Phase Bridge Inverter R- Load 00:06:00 Module 9- Single Phase Bridge Inverter RL- Load 00:07:00 Module 10- Example on Single Phase Bridge Inverter 00:06:00 Module 11- Three Phase Inverters and Obtaining the Line Voltages 00:15:00 Module 12- Threee Phase Inverters and Obtaining The Phase Voltages 00:17:00 Module 13- Example on Three Phase Inverters 00:16:00 Module 14- Single Pulse Width Modulation 00:13:00 Module 15- Multiple Pulse Width Modulation 00:13:00 Module 16- Example on Multiple Pulse Width Modulation 00:04:00 Module 17- Sinusoidal Pulse Width Modulation 00:16:00 Module 18- Industrial Inverter 00:03:00

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  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 There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel 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 course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00

Overview This Life Coach Masterclass course will unlock your full potential and will show you how to excel in a career in Life Coach Masterclass. So upskill now and reach your full potential. Everything you need to get started in Life Coach Masterclass is available in this course. Learning and progressing are the hallmarks of personal development. This Life Coach Masterclass will quickly teach you the must-have skills needed to start in the relevant industry. In This Life Coach Masterclass Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Life Coach Masterclass skills to help you advance your career. Acquire a comprehensive understanding of various Life Coach Masterclass topics and tips from industry experts. Learn in-demand Life Coach Masterclass skills that are in high demand among UK employers, which will help you to kickstart your career. This Life Coach Masterclass course covers everything you must know to stand against the tough competition in the Life Coach Masterclass field.  The future is truly yours to seize with this Life Coach Masterclass. Enrol today and complete the course to achieve a Life Coach Masterclass certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Life Coach Masterclass course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Life Coach Masterclass 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 Life Coach Masterclass 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 Life Coach Masterclass is suitable for anyone aspiring to start a career in Life Coach Masterclass; even if you are new to this and have no prior knowledge on Life Coach Masterclass, this course is going to be very easy for you to understand.  And if you are already working in the Life Coach Masterclass 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 Life Coach Masterclass 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 Life Coach Masterclass course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Life Coach Masterclass 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 Life Coach Masterclass course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Introduction What You Will Learn 00:06:00 Get To Know Your Instructor 00:02:00 PART 1: LIFE COACHING CERTIFICATION What Is Life Coaching 00:05:00 The Benefits Of Becoming A Life Coach 00:04:00 The Difference Between Coaching, Therapy, Mentoring & Training 00:03:00 The Responsibilities Of A Life Coach 00:03:00 Coaching Fundamentals Coaching Fundamentals Overview 00:02:00 Listening Introduction 00:02:00 The 3 Kinds Of Listening As A Coach 00:05:00 Your Listening Template 00:11:00 Questioning Introduction 00:01:00 Questioning & Coaching 00:03:00 How Coaching Questions Are Different From Normal Questions 00:02:00 The Different Types Of Coaching Questions 00:12:00 Questions Summary 00:03:00 Building Trust Introduction 00:01:00 The Trust Checklist Exercise 00:03:00 How To Build Trust As A Coach 00:08:00 More Trust Building Strategies 00:05:00 Understanding Personalities Understanding Personalities Overview 00:03:00 Big Five Personality Model 00:02:00 Myers Briggs Personality Model 00:04:00 Your Personality Model 00:09:00 How To Bring Out Your Strengths With This Model 00:10:00 Coaching Models Explained Coaching Models Introduction 00:02:00 GROW Model Explained 00:05:00 STEPPPA Model Explained 00:08:00 FUEL Model Explained 00:03:00 CLEAR Model Explained 00:04:00 Why We Will Use The GROW Model 00:01:00 Coaching Step 1: Goal Setting Step 1 Introduction 00:03:00 Why Defining Your Values Is Important 00:03:00 How To Define Your Personal Values 00:06:00 What Does Your Ideal Life Look Like? 00:04:00 The 4 Biggest Goal Setting Mistakes To Avoid 00:06:00 Stretch Goals Explained 00:03:00 Why You Should Start With Long Term Goals 00:05:00 Setting Your First Long Term Goal 00:06:00 Turning Long Term Goals Into Short Term Goals 00:05:00 Next Steps 00:01:00 Coaching Step 2: Reality Step 2 Introduction 00:01:00 Status Quo Explained 00:06:00 Wheel Of Life Excercise Explained 00:06:00 Big Rocks Exercise Explained 00:05:00 Coaching Example Step 2 00:05:00 Coaching Step 3: Options & Obstacles Step 3 Introduction 00:01:00 How To Brainstorm With Your Client(s) 00:05:00 How To Evaluate Your Brainstorming Ideas 00:05:00 'Spheres Of Influence' Excerise Explained 00:03:00 'Not To Do List' Exercise Explained 00:04:00 Coaching Example Step 3 00:07:00 Coaching Step 4: Will & Action Planning Step 4 Introduction 00:01:00 The 80/20 Rule Applied To Coaching 00:04:00 How To Design An Action Plan 00:03:00 Coaching Example Step 4 00:05:00 GROW Model Recap 00:03:00 How To Structure Your Coaching Sessions Structuring Your Sessions Introduction 00:01:00 How To Define Your Coaching Ground Rules 00:03:00 How Much Should You Charge 00:05:00 The Pre Coaching Call 00:03:00 Your First Coaching Session 00:03:00 Progress Evaluation Sessions 00:05:00 My Recommended Coaching Timeline 00:03:00 Client Coach Relationship Client Coach Relationship Intro 00:01:00 What Clients Expect From Their Coaches 00:04:00 Why Clients Choose One Coach Over Another 00:02:00 Client Coach Boundaries 00:03:00 How To Retain Clients Long Term 00:05:00 Advanced Coaching Strategies Advanced Coaching Strategies Introduction 00:01:00 Reframing Explained 00:07:00 Managing Emotional States 00:07:00 Understanding Representational Systems 00:08:00 Personal SWOT Analysis 00:06:00 Johari Window - Developing Self Awareness 00:05:00 Giving Good Feedback As A Coach 00:05:00 PART 2: HOLISTIC HEALTH COACHING CERTIFICATION Part 2 Introduction 00:03:00 What It Means To Be Healthy 00:04:00 What Does A Health Coach Do? 00:03:00 How Can You Combine Life Coaching & Health Coaching 00:02:00 Diet & Nutrition Fundamentals Diet Introduction 00:01:00 Your Health & Diet: How They Are Linked 00:04:00 The Consequences Of Following A Bad Diet 00:04:00 How To Eat For Longevity 00:02:00 What Are Calories? Explained 00:04:00 The Relationship Between Bodyweight And Health 00:05:00 Calories & Bodyweight In A Healthy Diet 00:02:00 The Surprising Results Of The Twinkie Diet 00:02:00 The Relationship Between Weight Loss And Health 00:03:00 Figuring Out How Many Daily Calories You Need 00:02:00 Calculating Your Total Daily Calories 00:03:00 Healthy Weight Ranges 00:02:00 The Best Foods For A Healthier Life 00:02:00 Best Protein Foods 00:01:00 Best Carbohydrate Foods 00:01:00 Best Dietary Fat Foods 00:01:00 How Much Of Each (Protein, Carbs, Fat)? 00:04:00 What About The Remaining Calories 00:01:00 Diet & Nutrition Coaching Client Assessment Introduction 00:01:00 Client Interview 00:04:00 How To Create A Diet Plan For Clients 00:09:00 Calculating BMI 00:03:00 Exercise Coaching: Cardio Cardio Introduction 00:01:00 The Different Types Of Cardio 00:02:00 Creating A Cardio Workout For A Client 00:04:00 How To Monitor Your Heart Rate During A Workout 00:02:00 Cardio vs Weigh Training - Which Is Better For Weight Loss 00:07:00 Exercise Coaching: Resistance Training Weight Training Introduction 00:01:00 Muscle Building Formula 00:07:00 The Science Behind Muscle Growth 00:04:00 Weight Training vs Bodyweight Training 00:02:00 How To Create A Beginner Workout Plan 00:09:00 5 Most Important Aspects Of Lifting Form 00:03:00 Progressive Overload 00:03:00 Hormone Health Explained Hormones Introduction 00:02:00 The 3 Types Of Hormones 00:03:00 The Endocrine System Explained 00:04:00 Hormones & Heart Disease 00:04:00 Anabolic Steroids: Why They Are So Dangerous 00:04:00 Most Important Hormones Overview 00:01:00 Insulin 00:04:00 Glucagon 00:02:00 Adrenaline 00:03:00 Cortisol 00:04:00 Ghrelin 00:02:00 Leptin 00:03:00 Thyroid Hormones 00:02:00 Estrogen 00:03:00 Growth Hormone 00:01:00 Testosterone 00:03:00 Supplements How To Build Your Own Supplement Stack 00:09:00 Top 3 Beginner Supplements For Muscle Growth 00:04:00 The Best Supplements To Boost Immunity 00:04:00 The Best Supplements For Vegans & Vegetarians 00:02:00 The Best Supplements For Joint & Bone Health 00:02:00 The Best Supplements For Fat Loss 00:04:00 Health & Fitness Motivation Health & Fitness Motivation Introduction 00:02:00 How To Get Out Of A Workout Rut 00:09:00 Health & Fitness FAQ Answered What Is Nutrient Density 00:04:00 Is Brown Sugar Better Than White Sugar 00:03:00 What Should You Train On Your First Day At The Gym? 00:07:00 Are Microwaves Harmful? 00:05:00 Fresh vs Frozen Food: Which Is Healthier 00:04:00 PART 3: WELLNESS COACHING CERTIFICATION Part 3 Introdudction 00:02:00 Stress Management The Difference Between Stress & Anxiety 00:03:00 Short vs Long Term Stress 00:02:00 The Effects Of Stress & Anxiety On Your Body 00:05:00 Proven Stress Management Strategies & Techniques 00:03:00 The Benefits Of Calm Breathing 00:03:00 Breathing Exercise #1 - Three Part Breath 00:02:00 Breathing Exercise #2 - Bellows Breath 00:02:00 Progressive Muscle Relaxation 00:03:00 Complete PMR Routine 00:07:00 Sleep Sleeping For A Longer Life 00:04:00 Tips To Fall Asleep Faster 00:03:00 Supplements For Improved Sleep 00:02:00 Emotional Self Care What Is Emotional Self Care 00:05:00 How To Accept Yourself 00:03:00 Taming Your Inner Critic 00:06:00 Getting A Different Perspecitive 00:04:00 Acknowledging Your Qualities 00:03:00 Getting Rid Of Time Consuming Commitments 00:06:00 How To Say 'No' To Others 00:05:00 Resources Resources - Life Coach Training - Guideline For The Startup 00:00:00

★★ FREE PDF Certificate| PDF Transcript| Student ID| Assessment| Lifetime Access| Enrolment Letter ★★ Explore our comprehensive Health and Social Care course designed to equip you with the knowledge and skills needed for a rewarding career in the healthcare sector. Learn about patient care, community health, medical ethics, and social support systems through interactive modules and hands-on training. Ideal for aspiring healthcare professionals and those looking to enhance their expertise, this course provides a solid foundation for roles in nursing, social work, and healthcare administration. Enroll now to make a meaningful impact on individuals and communities. Ready to make a difference in healthcare? Our Health and Social Care course offers in-depth training on patient care, medical ethics, and community health. Perfect for aspiring nurses, social workers, and healthcare professionals. Start your journey today and help create healthier communities! #Healthcare #SocialCare #CareerInHealthcare #Nursing #SocialWork #CommunityHealth

This online Rigging and Slinging Safety course is designed to provide participants with a basic level of knowledge of rigging gear, proper rigging procedures & load control includes covering practices and techniques to safely sling and rig loads according to the OSHAD CoP 34, BS 7121 p1 & best practices . It also adheres to ANSI (American National Standards Institute) and ASME (American Society of Mechanical Engineers) standards. Certificate Validity: 1 Year Upon successful completion of this online course, a certificate of completion will be available for download and printing. COURSE ASSESSMENT: Online quiz A mark of 70% must be achieved in order to receive a certificate of completion. Language of Training: English

The aims and objectives of this Initial Training Programme are to provide personnel, who have little experience of the Banksman and Slinger role, with the basic knowledge of activities associated with the combined roles, and the safety and regulatory requirements of those activities.The Banksman role is primarily to replay instructions to the crane operator during lifting activities, and the Slinger role is to prepare and sling loads for lifting, and release the loads at their destination. Certificate Validity: 1 Year Upon successful completion of this online course, a certificate of completion will be available for download and printing. COURSE ASSESSMENT: Online quiz A mark of 70% must be achieved in order to receive a certificate of completion. Language of Training: English

Controlling traffic through work areas is one of the most important — and dangerous — operations in construction maintenance. Flagmen play an important part in warning motorists of construction hazards and in controlling traffic flow. This training course will equip flag persons to perform their duties safely and professionally. The primary objective of the program is to train flaggers to provide safe passage of traffic through and around work areas and to minimize confusion by bringing standard flagging procedures to our nation’s highways. Certificate Validity: 1 Year Upon successful completion of this online course, a certificate of completion will be available for download and printing. COURSE ASSESSMENT: Online quiz A mark of 70% must be achieved in order to receive a certificate of completion. Language of Training: English

Course Overview Learn the qualities needed to inspire others and drive a team to excellence by taking this comprehensive Guide to Great Leadership. A person can be given the privilege of seniority in a company due to their achievements and experience, but their personality traits may not be best-suited to the role. You can become the total package as a leader by embodying the elements needed to excel in the position, which you can gain from this learning experience. This Leadership coaching details all the personal attributes and characteristics essential to great people management and their development. All techniques and ideologies are covered for your convenience, from the necessity of honesty to the gift of empowerment and the utilisation of EI (Emotional Intelligence). Take this training and learn to lead from the experts. This best selling Guide to Great Leadership has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Guide to Great Leadership is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Guide to Great Leadership is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Guide to Great Leadership is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Guide to Great Leadership, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Guide to Great Leadership will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Guide to Great Leadership to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Communication is a crucial life skill that can open doors to many opportunities in our personal and professional lives. It is essential for conducting business, forming personal relationships and expressing ourselves.  In this Winning Communication Skills for Telephone, Conference Calls course, you will explore the secrets to effective communication. It will teach you techniques, tips and strategies that will help you to become an excellent communicator, as well as teach you best practices for talking with clients, and on the phone. You will learn the art of listening, body language etiquette in the workplace, and much more. It will equip you with the communication skills to get your message across clearly, negotiate deals, resolve conflict, and form strong personal and professional relationships. Learn the art of effective communication and enrol in this best-selling course today. This best selling Winning Communication Skills for Telephone, Conference Calls has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Winning Communication Skills for Telephone, Conference Calls is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Winning Communication Skills for Telephone, Conference Calls is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Winning Communication Skills for Telephone, Conference Calls is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Winning Communication Skills for Telephone, Conference Calls, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Winning Communication Skills for Telephone, Conference Calls will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Winning Communication Skills for Telephone, Conference Calls to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.