49176 Courses delivered On Demand

Overview This comprehensive course on Handyperson will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Handyperson comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Handyperson. It is available to all students, of all academic backgrounds. Requirements Our Handyperson is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 14 sections • 14 lectures • 04:32:00 total length •Introduction to Handyperson: 00:22:00 •Basic Tools and Equipment: 00:22:00 •Electrical Work: 00:23:00 •Plumbing Skills: 00:19:00 •Appliances: 00:18:00 •General Carpentry: 00:26:00 •Basic Maintenance Skills: 00:14:00 •Walls and Floors: 00:19:00 •Painting and Decorating: 00:17:00 •Drilling, Tiling and Welding: 00:22:00 •Construction Projects: 00:16:00 •Health and Safety at Work: 00:27:00 •Starting Own Business for Handyperson: 00:27:00 •Assignment - Handyperson: 00:00:00

Overview This comprehensive course on Medical Coding Inpatient Training: DRG-PCS will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Medical Coding Inpatient Training: DRG-PCS comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Medical Coding Inpatient Training: DRG-PCS. It is available to all students, of all academic backgrounds. Requirements Our Medical Coding Inpatient Training: DRG-PCS is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 58 lectures • 02:47:00 total length •What is PCS?: 00:08:00 •PCS Reasons and Modifications: 00:07:00 •PCS step by step: 00:10:00 •Quick UNLEARNING before learning IP DRG: 00:03:00 •Quick Learning: 00:06:00 •Character 1 Section Relates to Type of Procedure: 00:10:00 •Character 2 Body System Refers to General Body System: 00:10:00 •Root Operations Introduction: 00:06:00 •ALTERATION: 00:03:00 •BYPASS: 00:03:00 •CHANGE: 00:03:00 •CONTROL: 00:02:00 •CREATION: 00:02:00 •DESTRUCTION: 00:02:00 •DETACHMENT: 00:02:00 •DILATION: 00:03:00 •DIVISION: 00:01:00 •DRAINAGE: 00:02:00 •EXCISION: 00:03:00 •EXTIRPATION: 00:01:00 •EXTRACTION: 00:02:00 •FRAGMENTATION: 00:01:00 •FUSION: 00:03:00 •INSERTION: 00:02:00 •INSPECTION: 00:02:00 •MAP: 00:01:00 •OCCLUSION: 00:01:00 •REATTACHMENT: 00:02:00 •RELEASE: 00:02:00 •REMOVAL: 00:01:00 •REPAIR: 00:02:00 •REPLACEMENT: 00:02:00 •REPOSITION: 00:02:00 •RESECTION: 00:02:00 •RESTRICTION: 00:01:00 •REVISION: 00:02:00 •SUPPLEMENT: 00:02:00 •TRANSFER: 00:01:00 •TRANSPLANTATION: 00:03:00 •Character 4 Body Part: 00:04:00 •Open: 00:02:00 •Percutaneous: 00:02:00 •Percutaneous Endoscopic: 00:02:00 •Via Natural or Artificial Opening: 00:01:00 •Via Natural or Artificial Opening Endoscopic: 00:01:00 •Via Natural or Artificial Opening with percutaneous endoscopic assistance: 00:02:00 •External: 00:02:00 •Character 6 Device: 00:04:00 •Character 7 Qualifier: 00:02:00 •Obstetrics: 00:04:00 •Placement: 00:04:00 •Measurements and Monitoring: 00:02:00 •Extracorporeal Assistance and Performance: 00:04:00 •Extracorporeal Therapies: 00:03:00 •Osteopathic, Other Procedures & Chiropractic: 00:04:00 •3T Technique: 00:02:00 •IP DRG PCS: 00:01:00 •Assignment - Medical Coding Inpatient Training: DRG-PCS: 00:00:00

Course Overview: The global automotive industry is booming, and with technological advancements, the demand for skilled car mechanics has never been higher. This Car Mechanic and Repair Training Diploma caters to the needs of professionals and enthusiasts, offering comprehensive knowledge on safety, maintenance, and advanced automotive systems. Our meticulously designed curriculum covers various topics, from the essential introduction to safety and maintenance in Module 01, restoring engines in Module 14, to more advanced topics in Module 21, Maintenance of Work Equipment. The course's structure ensures an in-depth understanding of each segment of car mechanics, essential for mastering the art of automobile repair and maintenance.Enrol in the Car Mechanic and Repair Training Diploma today and drive your career to new heights! Key Features of the Course: CPD certificate upon successful completion. Access to 24/7 learning assistance for continuous support. Who is This Course For? This Car Mechanic and Repair Training Diploma is perfect for individuals who aspire to pursue a career as a car mechanic, automobile enthusiasts looking to gain in-depth knowledge, or existing mechanics aiming to upgrade their skills and stay ahead in the competitive automotive industry. What You Will Learn: In our Car Mechanic and Repair Training Diploma, you will gain a wealth of knowledge and practical expertise through our engaging modules. From safety protocols and general maintenance techniques to understanding vehicle warning lights and mastering brake maintenance, this course covers all the essential aspects of car mechanics.You'll explore the intricacies of the engine, cooling system, fuel system, electrical system, and drivetrain, gaining in-depth insights into their functioning and maintenance. Additionally, you'll learn the step-by-step process of car restoration, including the interior, exterior, and engine.With modules focusing on workplace safety and equipment regulations, you'll also develop a comprehensive understanding of maintaining a safe and efficient working environment. Why Enrol in This Course: Enrolling in our Car Mechanic and Repair Training Diploma gives you access to a top-reviewed course that stays updated with the latest industry trends. With practical expertise and a comprehensive skill set, you'll be ready to take on the challenges of the automotive industry head-on. Additionally, the CPD certificate you receive upon completion will be a valuable credential, showcasing your dedication and expertise to potential employers or clients. Requirements: No prior experience or qualifications are necessary to join this course. All you need is a passion for cars and the desire to learn. Career Path: Completing this Car Mechanic and Repair Training Diploma course is helpful for numerous exciting career opportunities in the automotive industry. Some potential professions and their corresponding average UK salaries include: Automotive Technician - £25,000 per annum Garage Mechanic - £28,000 per annum Service Advisor - £22,000 per annum Parts Advisor - £20,000 per annum Vehicle Diagnostic Technician - £30,000 per annum Workshop Supervisor - £35,000 per annum Automotive Electrician - £27,000 per annum Certification: Upon completing the Car Mechanic and Repair Training Diploma, you will receive a CPD certificate, internationally recognised and highly regarded in the automotive industry. Course Curriculum 1 sections • 21 lectures • 11:21:00 total length •Module 01: Introduction to Safety and Maintenance: 00:12:00 •Module 02: General Maintenance for Car Mechanics: 00:38:00 •Module 03: Vehicle Warning Lights: 00:31:00 •Module 04: Tyres and Wheels: 00:40:00 •Module 05: The Engine: 00:36:00 •Module 06: The Cooling System: 00:29:00 •Module 07: The Fuel System: 00:30:00 •Module 08: The Electrical System: 00:31:00 •Module 09: The Drivetrain: 00:33:00 •Module 10: The Braking System: 00:29:00 •Module 11: Car Restoration Plan: 00:49:00 •Module 12: Restoring the Car's Interior: 00:30:00 •Module 13: Restoring the Car's Exterior: 00:34:00 •Module 14: Restoring the Engine: 00:31:00 •Module 15: Reassemble & Test Drive: 00:30:00 •Module 16: Hearing Conservation at Workplace: 00:47:00 •Module 17: Provision and Use of Work Equipment Regulations: 00:48:00 •Module 18: Selection and Conformity of Work Equipment: 00:25:00 •Module 19: Safe Functionality of Work Equipment: 00:36:00 •Module 20: Monitoring and Evaluation of Work Equipment: 00:28:00 •Module 21: Maintenance of Work Equipment: 00:14:00

Overview This comprehensive course on Excel Pivot Tables will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Pivot Tables. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 18 lectures • 00:47:00 total length •Excel Pivot Tables: 00:03:00 •Overview about Store Dataset: 00:02:00 •Data Insights: 00:02:00 •Sales Profit Summary: 00:03:00 •Highlight the Data: 00:01:00 •Unprofitable Products: 00:02:00 •Create Crosstabs: 00:02:00 •Select Regions for Unprofitable Products: 00:04:00 •Real Time Analytics and Insights: 00:02:00 •Search Data for States with Slicers: 00:06:00 •Finding Trends: 00:02:00 •Find Data for Specific Date: 00:04:00 •Reporting Made Easy: 00:02:00 •Generate Reports with Pivot Tables: 00:04:00 •Marketing Analytics: 00:02:00 •Target Your Advertisements: 00:05:00 •Become Analyst: 00:01:00 •Assignment - Excel Pivot Tables: 00:00:00

Overview Diabetes is becoming one of the most common medical conditions in the UK, and you can learn to understand and treat the condition.This comprehensive and enlightening Diabetes Care Diploma course thoroughly explains the causes and the impact of Type 2 Diabetes and associated medicinal procedures.The Diabetes Care Diploma course has been written in conjunction with industry professionals. It will deliver all the appropriate knowledge needed to tackle the many issues created by hypoglycaemia and hyperglycaemia in an individual. You will be taught everything about the required dieting, medicines, exercise, and lifestyle changes, along with tips for supervision and emotional support that can help fight the condition. Learning Outcomes Differentiate between Type 1 and Type 2 Diabetes and their causes. Understand the societal impact of diabetes in the UK. Identify various diabetes types and treatments. Manage hypoglycaemia and hyperglycaemia symptoms. Master diabetes terminology through a glossary. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Diabetes Care Diploma. It is available to all students, of all academic backgrounds. Requirements To enrol in the Diabetes Care Diploma course, you typically need to meet these requirements: Be 16 years of age or older. Have proficiency in the course's language (usually English). Access to a computer with internet and basic computer skills. Payment of tuition fees, if applicable. Healthcare background, while optional, can be beneficial. Career path Completing the Diabetes Care Diploma can lead to careers like: Diabetes Educator: £35,000-£45,000 per year. Clinical Nurse Specialist: £40,000-£57,000 per year. Registered Dietitian: £30,000-£50,000 per year. Diabetes Researcher: Salary varies by experience and location. These are approximate salary ranges, and actual earnings can vary based on factors such as location, experience, and specific job roles. Course Curriculum 2 sections • 13 lectures • 05:05:00 total length •Module 01: What is Diabetes: 00:20:00 •Module 02: The Diabetes Challenge: 00:30:00 •Module 03: The Cost of Diabetes in Social Care: 00:19:00 •Module 04: Type 1 Diabetes: 00:24:00 •Module 05: Type 2 Diabetes: 00:28:00 •Module 06: Type 2 Diabetes Treatments: 00:26:00 •Module 07: Prediabetes: 00:12:00 •Module 08: Gestational Diabetes: 00:23:00 •Module 09: Other Types of Diabetes: 00:15:00 •Module 10: Hypoglycaemia: 00:18:00 •Module 11: Hyperglycaemia and Hyperosmolar Hyperglycaemic State: 00:32:00 •Module 12: Glossary of Diabetes Terms: 00:58:00 •Assignment - Diabetes Care Diploma: 00:00:00

Overview This comprehensive course on Restaurant Management - Takeaway Business will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector.This Restaurant Management - Takeaway Business comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Restaurant Management - Takeaway Business. It is available to all students, of all academic backgrounds. Requirements Our Restaurant Management - Takeaway Business is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 8 lectures • 02:30:00 total length •Starting a Takeaway Business: 00:21:00 •Going Online: 00:25:00 •Creating an Online Ordering System: 00:32:00 •Restructuring Management: 00:24:00 •Legal Requirements: 00:27:00 •Complying with the COVID-19 Guidance: 00:21:00 •Assignment - Restaurant Management -Takeaway Business: 00:00:00 •Order Your Certificate: 00:00:00

Overview This comprehensive course on Car Mechanic Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Car Mechanic Training comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Car Mechanic Training. It is available to all students, of all academic backgrounds. Requirements Our Car Mechanic Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 11 lectures • 05:03:00 total length •Introduction to Safety and Maintenance: 00:06:00 •General Maintenance for Car Mechanics: 00:38:00 •Vehicle Warning Lights: 00:31:00 •Tyres and Wheels: 00:40:00 •The Engine: 00:36:00 •The Cooling System: 00:29:00 •The Fuel System: 00:30:00 •The Electrical System: 00:31:00 •The Drivetrain: 00:33:00 •The Braking System: 00:29:00 •Additional Reading Materials - Car Mechanic Training: 00:00:00

Overview This comprehensive course on Street Photography will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Street Photography comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Street Photography. It is available to all students, of all academic backgrounds. Requirements Our Street Photography is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 29 lectures • 01:34:00 total length •Introduction: 00:02:00 •What is Street Photography: 00:03:00 •Equipment Recommendations: 00:02:00 •Basic Settings : 00:04:00 •Intro to Strongest I'II Ever Be: 00:15:00 •Where Shoot Photos: 00:04:00 •How to Take Photos of Strangers : 00:14:00 •Composing Better Photos: 00:09:00 •Portrait - Face in the Shadows: 00:02:00 •Portrait - Capturing Raw Emotions : 00:05:00 •Portrait - When Life Gives You Lemons: 00:02:00 •Portrait - Get Up Close and Personal: 00:01:00 •Portrait - Silhouettes and the Power of RAW : 00:02:00 •Portrait - When You Can't Take a Portrait: 00:03:00 •Portrait - Can I Take Your Photograph While We're Talking: 00:02:00 •Portrait - Ease Your Way Into the Shot: 00:01:00 •Portrait - Wait for the Right Moment : 00:02:00 •Lighting - Drama and Lens Flares: 00:02:00 •Architecture - Seeing the Beauty in the Small Things: 00:01:00 •Lighting - Taking Photos at High Noon: 00:02:00 •Lighting - Photographing the Sun: 00:01:00 •Silhouette - Walking Away: 00:01:00 •Lighting - Back Lighting and Shadows: 00:02:00 •Be Ready for Any Moment: 00:01:00 •Find Your Frame and Be Patient: 00:01:00 •When Your Subject Walk on By: 00:01:00 •Where Preparation and Luck Meet: 00:01:00 •Sharing Your Work: 00:06:00 •Thank You: 00:02:00

Overview This comprehensive course on Office Assistant and Secretarial Diploma will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Office Assistant and Secretarial Diploma comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Office Assistant and Secretarial Diploma. It is available to all students, of all academic backgrounds. Requirements Our Office Assistant and Secretarial Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 3 sections • 36 lectures • 08:46:00 total length •Module One - Getting Started: 00:05:00 •Module Two - Working with Your Manager: 00:15:00 •Module Three - Administrative Soft Skills: 00:15:00 •Module Four - Effective Time Management: 00:20:00 •Module Five - Meeting Management: 00:17:00 •Module Six - Tools of the Trade (I): 00:17:00 •Module Seven - Tools of the Trade (II): 00:15:00 •Module Eight - Being an Effective Gatekeeper: 00:15:00 •Module Nine - Organizational Skills: 00:15:00 •Module Ten - Confidentiality Guidelines: 00:15:00 •Module Eleven - Special Tasks: 00:15:00 •Module Twelve - Wrapping Up: 00:05:00 •Module One - Getting Started: 00:05:00 •Module Two - Why Your Office Needs Administrative Procedures: 00:15:00 •Module Three - Gathering the Right Tools: 00:10:00 •Module Four - Identifying Procedures to Include: 00:15:00 •Module Five - Top Five Procedures to Record: 00:15:00 •Module Six - What to Include in Your Binder (I): 00:15:00 •Module Seven - What to Include in Your Binder (II): 00:15:00 •Module Eight - Organizing Your Binder: 00:15:00 •Module Nine - What Not to Include in the Procedure Guide: 00:15:00 •Module Ten - Share Office Procedure Guide: 00:10:00 •Module Eleven - Successfully Executing the Guide: 00:12:00 •Module Twelve - Wrapping Up: 00:05:00 •Module One - Getting Started: 00:10:00 •Module Two - Verbal Communication Skills: 00:20:00 •Module Three - Non-Verbal Communication Skills: 00:20:00 •Module Four - Making Small Talk and Moving Beyond: 00:20:00 •Module Five - Moving the Conversation Along: 00:25:00 •Module Six - Remembering Names: 00:15:00 •Module Seven - Influencing Skills: 00:20:00 •Module Eight - Bringing People to Your Side: 00:15:00 •Module Nine - Sharing Your Opinion: 00:15:00 •Module Ten - Negotiation Basics: 00:30:00 •Module Eleven - Making an Impact: 00:15:00 •Module Twelve - Wrapping Up: 00:05:00

Overview This comprehensive course on Office Admin and Reception will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Office Admin and Reception comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Office Admin and Reception. It is available to all students, of all academic backgrounds. Requirements Our Office Admin and Reception is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 17 sections • 56 lectures • 11:17:00 total length •Module 01: Introduction to Reception and Receptionist: 00:28:00 •Module 02: Business Telephone Skills: 00:21:00 •Module 03: Representing Your Boss and Company: 00:36:00 •Module 04: Mail Services and Shipping: 00:27:00 •Module 05: Travel Arrangements: 00:26:00 •Module 06: Organising Meeting and Conferences: 00:27:00 •Module 07: Time Management: 00:37:00 •Module 08: Record Keeping and Filing Systems: 00:30:00 •Module 09: Business Writing Skills: 00:42:00 •Module 10 :Organisational Skills: 00:27:00 •Module 11: Communication Skills: 00:27:00 •Module 12: Customer Service: 00:18:00 •Module 13: Effective Planning and Scheduling: 00:48:00 •Module 14: Invoicing/Petty Cash: 00:29:00 •Module 15: Business Environment: 00:18:00 •How to Get the most of the course: 00:01:00 •Text formulas in Excel: 00:08:00 •Text Formulas Exercise: 00:01:00 •Text Formulas Exercise (answers): 00:01:00 •Mathematical Formulas In Excel: 00:04:00 •Mathematical Formulas Exercise: 00:01:00 •Mathematical Formulas Exercise (answers): 00:01:00 •Date and Time Formulas In Excel: 00:05:00 •Date and Time Formulas Exercise: 00:01:00 •Date and Time Exercise Formulas (answers): 00:01:00 •Logic Formulas In Excel: 00:12:00 •Logic Formula Exercise: 00:01:00 •Logic Formula Exercise (answers): 00:01:00 •Financial Formula In Excel: 00:06:00 •Financial Formula Exercise: 00:01:00 •Financial Formula Exercise (answers): 00:02:00 •Informational Formula In Excel: 00:04:00 •Informational Formula Exercise: 00:01:00 •Informational Formula Exercise (answers): 00:01:00 •Getting Traffic To Your Site: 01:00:00 •Menu Example with Excel Vlookup: 00:08:00 •Wildcard Search with Excel Vlookup: 00:09:00 •Looking to the Left with Excel Vlookup: 00:17:00 •2-Way Lookup: 00:14:00 •Comparing Lists with Excel Vlookup: 00:03:00 •Microsoft Excel Vlookup Tips and Tricks: 00:14:00 •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Enabling M in Power Query: 00:02:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Simple Expressions: 00:08:00 •Simple Expressions - Nested Expressions: 00:03:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Variables: 00:08:00 •Formatting Excel Keyboard Shortcuts: 00:02:00 •Table Excel Keyboard Shortcuts: 00:02:00 •Editing Excel Keyboard Shortcuts: 00:05:00 •Formula Excel Keyboard Shortcuts: 00:03:00 •Workbook Excel Keyboard Shortcuts: 00:02:00 •Handy Excel Shortcuts Keyboard Shortcuts: 00:05:00