Power Query and Power Pivot in Microsoft Excel: A Quickstart Guide Course Description Copyright Ross Maynard 2022 Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide. Key Learning Points On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points Pre-Course Requirements There are no pre-course requirements Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented. Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type
Overview of Level 3 Diploma in Health & Social Care If you are thinking about a career in Healthcare, you have the right mindset. In the UK, professionals in the health and social care sector enjoy the fulfilment of making a difference in people's lives but also benefit from competitive salaries. Our Level 3 Diploma in Health & Social Care provides a comprehensive understanding of the field and is designed to enhance your career prospects. Care Assistants and Healthcare Assistants can earn between £22,000 to £30,000 annually, while specialised roles like Social Workers may earn between £28,000 and £38,000. This sector offers both financial stability and significant growth potential. In this Level 3 Diploma in Health & Social Care, you'll learn about the fundamentals of health and social care. You will also learn effective communication tailored for care settings, understand the rights and responsibilities of healthcare workers, and explore the roles of caregivers and healthcare professionals. The course also covers promoting equality, diversity, and rights in care, understanding legal and ethical aspects of healthcare, safeguarding vulnerable individuals, risk management in health and social care and much more. By taking this course, you'll improve your job prospects and be equipped to make a real difference in the lives of others. The curriculum ensures that upon completion, you will be an attractive candidate for various roles in this sector and a more effective, empathetic, and informed professional. So what are you waiting for? Enrol today and start your success journey! Fast-Track Your Learning: Watch the Course Trailer Get a Quick Look at The Course Content: This Level 3 Diploma in Health & Social Care Course will help you to learn: Fundamentals of Health and Social Care, including core responsibilities and ethics. Effective Communication skills tailored for health and social care settings. Understanding and upholding the Rights and Responsibilities in care environments. The Role and Skills of a Caregiver and Healthcare Professional. Promoting Equality, Diversity, and Rights in Health and Social Care. Principles and Policies governing Health and Social Care work. Legal and Professional Standards of Practice in Health Care, in two comprehensive parts. Techniques for Safeguarding Vulnerable Individuals. Comprehensive knowledge of Health and Safety Responsibilities. Effective Risk Management strategies in Health and Social Care. Preparation for real-world scenarios through Mock and Final Exams. 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 Certificate of Completion - Digital/PDF Certificate After completing the Level 3 Diploma in Health & Social Care course, you can order your CPD-accredited Digital/PDF Certificate for £5.99. Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Individuals aspiring to enter the health and social care sector. Existing care workers seeking formal qualifications. Nurses and healthcare assistants aiming for career advancement. Support workers in residential or community settings. Anyone interested in understanding the complexities of health and social care. Requirements You don't need any educational qualification or experience to enrol in the Level 3 Diploma in Health & Social Care 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 This Level 3 Diploma in Health & Social Care isn't just an investment in your education; it's a step towards a rewarding and impactful career where you make a difference every day. Some potential career paths are: Care Assistant: £20,000 - £30,000 annually Healthcare Assistant: £22,000 - £32,000 annually Support Worker: £22,000 - £30,000 annually Senior Care Worker: £25,000 - £35,000 annually Nursing Assistant: £24,000 - £35,000 annually Residential Care Home Manager: £28,000 - £40,000 annually Level 3 Diploma in Health & Social Care FAQs Q: What is health care and social care? Healthcare is more easily understood. It is the care that professionals or pharmaceutical companies provide for well-defined illnesses, injuries, or diseases or to prevent such conditions. It also includes care for pregnant women, who may be healthy and may have healthy fetuses but need facilitation to give birth. Social care addresses a wide range of needs beyond healthcare, although the two are interrelated. It helps individuals better adapt to a social and family environment. The term and its boundaries need to be more well-defined. Q. What is level 3 of health and social care? A level 3 Health and social care qualification is equivalent to A-levels. It is usually done as a BTEC (however, if you're 19+, it's usually an NVQ or an Access course). You do one year for a Subsidiary Diploma, and after completing the second year, you get an Extended Diploma worth three A-levels. It's basically the go-to qualification if you want to go to university to study Nursing, midwifery, SALT (speech and Language), OT (occupational therapist), social work, etc. However, because it is so broad in modules you learn, you can work in some areas of schools. Q. Why do you want to study health and social care? Health and social care is an amazing learning field where you will learn how issues like mental health, poverty and the use of recreational drugs impact individuals. You will also learn different aspects of this arena. You will learn- - Fundamentals of Health and Social Care. - Effective Communication skills tailored for health and social care. - Understanding and upholding the Rights and Responsibilities in care environments. - The Role and Skills of a Caregiver and Healthcare Professional. - Promoting Equality, Diversity, and Rights in Health and Social Care. - Principles and Policies governing Health and Social Care work. - Effective Risk Management Strategies in Health and Social Care. Q. What's the best career choice for health and social care? The best career choices in health and social care include: - Nursing: Providing direct patient care and working in diverse healthcare settings. - Medicine: Diagnosing, treating illnesses, and leading healthcare teams. - Allied Health Professions: Specialised assessments and therapeutic interventions in physiotherapy, occupational therapy, and radiography. - Social Work: Supporting individuals and families facing challenging circumstances. - Counselling and Psychotherapy: Helping individuals navigate mental health challenges and providing therapy. - Public Health: Improving population health, developing policies, and promoting disease prevention. - Health Administration and Management: Overseeing healthcare facilities and ensuring efficient delivery of services. - Caregiving and Support Roles: Directly providing care and support to needy individuals. Q. What do you do for health and social care GCSE? To make an outstanding result, you have to cover these topics - - Personal Development and Relationships - Health, Social Care and Early Years Provision - Health and Wellbeing - Health, Social Care and Early Years in Practice Q. What is RQF Health and Social Care? The RQF Health and Social Care or RFQ Level 2 Diploma in Health & Social Care is a suitable qualification for those who are just starting employment in the social care industry or those who are already working as a social care assistant/worker. Q. Why I will study NVQ Health and Social Care? The NVQ Health and Social Care or Level 2/ Level 3/ Level/ Level 5 NVQ Health and social care programme will help you reach your fullest potential and make a more significant impact on the lives of the most vulnerable community members. You will look at equality and diversity, growth, and development, as well as the role of safeguarding and protection in health and social care. Course Curriculum Module 1: Introduction to Health and Social Care Module 1: Introduction to Health and Social Care 00:19:00 Module 2: Communication and its Relevance Module 2: Communication and its Relevance 00:42:00 Module 3: Rights and Responsibilities as a Health and Social Care Worker Module 3: Rights and Responsibilities as a Health and Social Care Worker 00:38:00 Module 4: Role as A Caregiver and Healthcare Professional Module 4: Role as A Caregiver and Healthcare Professional 00:26:00 Module 5: Working in Health and Social Care: Promoting Equality, Diversity and Rights Module 5: Working in Health and Social Care: Promoting Equality, Diversity and Rights 00:49:00 Module 6: Important Principles and Policies in Health and Social Care Work Module 6: Important Principles and Policies in Health and Social Care Work 00:23:00 Module 7: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 Module 7: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care (Part - 1) 00:50:00 Module 8: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care (Part - 2) Module 8: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care (Part - 2) 00:48:00 Module 9: Safeguarding Vulnerable Individuals Module 9: Safeguarding Vulnerable Individuals 00:52:00 Module 10: Health and Safety Responsibilities Module 10: Health and Safety Responsibilities 00:51:00 Module 11: Risk Management in Health and Social Care Module 11: Risk Management in Health and Social Care 00:03:00 Mock Exam Mock Exam - Level 3 Diploma in Health & Social Care 00:20:00 Final Exam Final Exam - Level 3 Diploma in Health & Social Care 00:20:00
Overview of Level 3 Diploma in Health & Social Care If you are thinking about a career in Healthcare, you have the right mindset. In the UK, professionals in the health and social care sector enjoy the fulfilment of making a difference in people's lives but also benefit from competitive salaries. Our Level 3 Diploma in Health & Social Care provides a comprehensive understanding of the field and is designed to enhance your career prospects. Care Assistants and Healthcare Assistants can earn between £22,000 to £30,000 annually, while specialised roles like Social Workers may earn between £28,000 and £38,000. This sector offers both financial stability and significant growth potential. In this Level 3 Diploma in Health & Social Care, you'll learn about the fundamentals of health and social care. You will also learn effective communication tailored for care settings, understand the rights and responsibilities of healthcare workers, and explore the roles of caregivers and healthcare professionals. The course also covers promoting equality, diversity, and rights in care, understanding legal and ethical aspects of healthcare, safeguarding vulnerable individuals, risk management in health and social care and much more. By taking this course, you'll improve your job prospects and be equipped to make a real difference in the lives of others. The curriculum ensures that upon completion, you will be an attractive candidate for various roles in this sector and a more effective, empathetic, and informed professional. So what are you waiting for? Enrol today and start your success journey! Fast-Track Your Learning: Watch the Course Trailer Get a Quick Look at The Course Content: This Level 3 Diploma in Health & Social Care Course will help you to learn: Fundamentals of Health and Social Care, including core responsibilities and ethics. Effective Communication skills tailored for health and social care settings. Understanding and upholding the Rights and Responsibilities in care environments. The Role and Skills of a Caregiver and Healthcare Professional. Promoting Equality, Diversity, and Rights in Health and Social Care. Principles and Policies governing Health and Social Care work. Legal and Professional Standards of Practice in Health Care, in two comprehensive parts. Techniques for Safeguarding Vulnerable Individuals. Comprehensive knowledge of Health and Safety Responsibilities. Effective Risk Management strategies in Health and Social Care. Preparation for real-world scenarios through Mock and Final Exams. 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 Certificate of Completion - Digital/PDF Certificate After completing the Level 3 Diploma in Health & Social Care course, you can order your CPD-accredited Digital/PDF Certificate for £5.99. Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Individuals aspiring to enter the health and social care sector. Existing care workers seeking formal qualifications. Nurses and healthcare assistants aiming for career advancement. Support workers in residential or community settings. Anyone interested in understanding the complexities of health and social care. Requirements You don't need any educational qualification or experience to enrol in the Level 3 Diploma in Health & Social Care 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 This Level 3 Diploma in Health & Social Care isn't just an investment in your education; it's a step towards a rewarding and impactful career where you make a difference every day. Some potential career paths are: Care Assistant: £20,000 - £30,000 annually Healthcare Assistant: £22,000 - £32,000 annually Support Worker: £22,000 - £30,000 annually Senior Care Worker: £25,000 - £35,000 annually Nursing Assistant: £24,000 - £35,000 annually Residential Care Home Manager: £28,000 - £40,000 annually Level 3 Diploma in Health & Social Care FAQs Q: What is health care and social care? Healthcare is more easily understood. It is the care that professionals or pharmaceutical companies provide for well-defined illnesses, injuries, or diseases or to prevent such conditions. It also includes care for pregnant women, who may be healthy and may have healthy fetuses but need facilitation to give birth. Social care addresses a wide range of needs beyond healthcare, although the two are interrelated. It helps individuals better adapt to a social and family environment. The term and its boundaries need to be more well-defined. Q. What is level 3 of health and social care? A level 3 Health and social care qualification is equivalent to A-levels. It is usually done as a BTEC (however, if you're 19+, it's usually an NVQ or an Access course). You do one year for a Subsidiary Diploma, and after completing the second year, you get an Extended Diploma worth three A-levels. It's basically the go-to qualification if you want to go to university to study Nursing, midwifery, SALT (speech and Language), OT (occupational therapist), social work, etc. However, because it is so broad in modules you learn, you can work in some areas of schools. Q. Why do you want to study health and social care? Health and social care is an amazing learning field where you will learn how issues like mental health, poverty and the use of recreational drugs impact individuals. You will also learn different aspects of this arena. You will learn- - Fundamentals of Health and Social Care. - Effective Communication skills tailored for health and social care. - Understanding and upholding the Rights and Responsibilities in care environments. - The Role and Skills of a Caregiver and Healthcare Professional. - Promoting Equality, Diversity, and Rights in Health and Social Care. - Principles and Policies governing Health and Social Care work. - Effective Risk Management Strategies in Health and Social Care. Q. What's the best career choice for health and social care? The best career choices in health and social care include: - Nursing: Providing direct patient care and working in diverse healthcare settings. - Medicine: Diagnosing, treating illnesses, and leading healthcare teams. - Allied Health Professions: Specialised assessments and therapeutic interventions in physiotherapy, occupational therapy, and radiography. - Social Work: Supporting individuals and families facing challenging circumstances. - Counselling and Psychotherapy: Helping individuals navigate mental health challenges and providing therapy. - Public Health: Improving population health, developing policies, and promoting disease prevention. - Health Administration and Management: Overseeing healthcare facilities and ensuring efficient delivery of services. - Caregiving and Support Roles: Directly providing care and support to needy individuals. Q. What do you do for health and social care GCSE? To make an outstanding result, you have to cover these topics - - Personal Development and Relationships - Health, Social Care and Early Years Provision - Health and Wellbeing - Health, Social Care and Early Years in Practice Q. What is RQF Health and Social Care? The RQF Health and Social Care or RFQ Level 2 Diploma in Health & Social Care is a suitable qualification for those who are just starting employment in the social care industry or those who are already working as a social care assistant/worker. Q. Why I will study NVQ Health and Social Care? The NVQ Health and Social Care or Level 2/ Level 3/ Level/ Level 5 NVQ Health and social care programme will help you reach your fullest potential and make a more significant impact on the lives of the most vulnerable community members. You will look at equality and diversity, growth, and development, as well as the role of safeguarding and protection in health and social care. How Do Our Online Courses Work? Q. How do I purchase a course? 1. You need to find the right course on our IOMH website at first. You can search for any course or find the course from the Courses section of our website. 2. Click on Take This Course button, and you will be directed to the Cart page. 3. You can update the course quantity and also remove any unwanted items in the CART and after that click on the Checkout option and enter your billing details. 4. Once the payment is made, you will receive an email with the login credentials, and you can start learning after logging into the portal. Q. I have purchased the course when will I be able to access the materials? After purchasing the course, you should receive an email with the login credentials within 24 hours. Please check your spam or junk folder if you didn't receive it in your inbox. You can access your courses by logging into your account. If you still need any assistance, please get in touch with our Customer Support team by providing the details of your purchase. Q. I haven't received my certificate yet. What should I do? You should receive your Digital Certificate within 24 hours after placing the order, and it will take 3-9 days to deliver the hard copies to your address if you are in the UK. For International Delivery, it will take 20-25 days. If you require any assistance, get in touch with our dedicated Customer Support team, and your queries/issues will be dealt with accordingly. Q. I don't have a credit/debit card, what other methods of payment do you accept? You can make the payment using PayPal or you can Bank Transfer the amount. For Bank transfer you will require an invoice from us and you need to contact our Customer Support team and provide details of your purchase to get the invoice. After that, you will receive an email with the invoice and bank details and you can make the payment accordingly. Q. When I log into the account it says 'Contact Administrator'. To resolve this issue, please log out of your account and then log back in. Course Curriculum Module 1: Introduction to Health and Social Care Module 2: Communication and its Relevance Module 3: Rights and Responsibilities as a Health and Social Care Worker Module 4: Role as A Caregiver and Healthcare Professional Module 5: Working in Health and Social Care: Promoting Equality, Diversity and Rights Module 6: Important Principles and Policies in Health and Social Care Work Module 7: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 Module 8: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care (Part - 2) Module 9: Safeguarding Vulnerable Individuals Module 10: Health and Safety Responsibilities Module 11: Risk Management in Health and Social Care
Overview Join our Electronic & Electrical Devices Maintenance & Troubleshooting 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 Electronic & Electrical Devices Maintenance & Troubleshooting course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Electronic & Electrical Devices Maintenance & Troubleshooting 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 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 everything you must know to stand against the tough competition. The future is truly yours to seize with this Electronic & Electrical Devices Maintenance & Troubleshooting. 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 This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Electronic & Electrical Devices Maintenance & Troubleshooting. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Electronic & Electrical Devices Maintenance & Troubleshooting 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 Electronic & Electrical Devices Maintenance & Troubleshooting 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 Electronic & Electrical Devices Maintenance & Troubleshooting 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 Electronic & Electrical Devices Maintenance & Troubleshooting 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 Electronic & Electrical Devices Maintenance & Troubleshooting Section 1: Introduction & Getting Started Unit 1: Introduction 00:02:00 Unit 2: Instructor's Introduction 00:03:00 Section 2: Electronic and Electrical maintenance Repair Unit 1: Becoming a Troubleshooter 00:02:00 Section 3: Tools Needed Unit 1: Tools Needed 00:01:00 Unit 2: Multimeters 00:07:00 Unit 3: Wire Cutter and Stripper 00:03:00 Unit 4: Wiring Tools Soldering Iron 00:02:00 Unit 5: Screw Drivers 00:03:00 Unit 6: Pliers 00:02:00 Unit 7: Wrench 00:02:00 Unit 8: Oscilloscope and Function Generator 00:03:00 Section 4: Electronic Components Unit 1: Passive Electronic Components 00:03:00 Unit 2: Active Electronic Component Diode 00:03:00 Unit 3: Active Electronic Component Transistor 00:03:00 Unit 4: Common Electronic and Electrical Components 00:05:00 Section 5: Testing Unit 1: Testing a Fuse 00:03:00 Unit 2: Testing a Bulb or Lamp 00:02:00 Unit 3: Testing a Switch 00:01:00 Unit 4: Testing a Transformer 00:04:00 Unit 5: Testing a Resistance 00:08:00 Section 6: Troubleshooting Unit 1: Safety Concerns 00:05:00 Unit 2: Main Concerns - Maintenance 00:02:00 Unit 3: Main Concerns - Servicing 00:02:00 Unit 4: Troubleshooting Part - 1 00:03:00 Unit 5: Troubleshooting Part - 2 00:04:00 Section 7: Introduction to Electronic Components: A Step by Step Guide Unit 1: Introduction 00:05:00 Unit 2: Voltage Current and Resistance 00:06:00 Unit 3: Types of Current 00:03:00 Unit 4: Types of Circuits 00:02:00 Unit 5: Practical: Introduction to Digital Multimeter DMM 00:07:00 Unit 6: Volt Ohm Meter Basics 00:05:00 Unit 7: Measuring Voltage 00:13:00 Unit 8: Practical: How to Measure DC Voltage 00:03:00 Unit 9: Measuring Current 00:05:00 Unit 10: Measuring Currents - Lab Experiment Explained 00:11:00 Unit 11: Practical 1: How to Measure Current 00:04:00 Unit 12: Practical 2: How to Measure Current 00:01:00 Unit 13: Measuring Resistance 00:08:00 Unit 14: Practical: How to Test Resistors 00:05:00 Unit 15: Circuit Diagram Basics and Basic Symbols 00:12:00 Unit 16: Introduction to Resistor and Color Band Coding 00:09:00 Unit 17: Power Dissipation + Parallel and Series Resistors 00:12:00 Unit 18: Ohm's Law 00:14:00 Unit 19: Introduction to Capacitors 00:11:00 Unit 20: Capacitors Behavior + Capacitors in Series and Parallel 00:07:00 Unit 21: Practical 1: How to Test a Capacitor 00:03:00 Unit 22: Practical 2: How to Test A Capacitor 00:02:00 Unit 23: Introduction to Inductors 00:07:00 Unit 24: Practical: How to Test and Measure Coils 00:06:00 Unit 25: Introduction to Diode + Zener Diode and LED 00:08:00 Unit 26: Practical 1: How to Test a Diode 00:02:00 Unit 27: Practical 2: How to Test a Diode 00:02:00 Unit 28: Introduction to Transistors 00:10:00 Unit 29: Practical 1: How to Test a Transistor 00:04:00 Unit 30: Practical 2: How to Test a Transistor 00:04:00 Unit 31: Practical 3: How to Test a Transistor 00:03:00
Level 3 AET (PTLLS) | Training qualification course for teaching in the UK | Awarded by Focus Awards | Ofqual Regulated
Overview of ISO 9001: Quality Management System In an era where excellence is paramount, quality management has surged as a pivotal sector. With its multifaceted industries, the UK thrives on ISO 9001: Quality Management Systems, ensuring business processes meet global standards. Embracing this ISO 9001: Quality Management Systems course unlocks opportunities in a dynamic environment that values quality. The demand for ISO 9001 expertise is robust and ever-growing, from major corporate giants to rising start-ups. Dive into this immersive ISO 9001: Quality Management Systems course and become a beacon of excellence in the realm of quality management. Unlock the potential of businesses and elevate your career trajectory. Get a quick look at the course content: This ISO 9001: Quality Management System Course will help you to learn: Understand ISO 9001's structure and key definitions. Identify roles and responsibilities in quality management. Recognise quality management principles and their applications. Analyse major alterations and updates to the ISO 9001. Evaluate organisational performance through set objectives. Use tools for efficient quality management system application. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this ISO 9001: Quality Management System. 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 Certificate of Completion - Digital / PDF Certificate After completing the ISO 9001: Quality Management System course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This course is designed for individuals aiming to delve into the world of quality management using ISO 9001: Quality Management Systems. Whether you're a budding manager keen to streamline processes, a business owner wanting to understand and implement quality standards, or a consultant looking to advise organisations, this ISO 9001: Quality Management Systems course offers comprehensive insights. Delving into pivotal definitions, major changes, and quality objectives, attendees will leave equipped with the knowledge to assess and bolster organisational performance. Moreover, this ISO 9001: Quality Management Systems course curriculum serves those interested in setting up or refining quality management systems in alignment with ISO standards. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the ISO 9001: Quality Management System 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 Quality Assurance Manager - £35K to £50K/year. ISO 9001 Auditor - £30K to £45K/year. Quality Systems Coordinator - £28K to £42K/year. Quality Improvement Specialist - £32K to £48K/year. Compliance Officer (Quality) - £27K to £40K/year. Frequently Asked Questions (FAQ's) Q. How do I purchase a course? 1. You need to find the right course on our IOMH website at first. You can search for any course or find the course from the Courses section of our website. 2. Click on Take This Course button, and you will be directed to the Cart page. 3. You can update the course quantity and also remove any unwanted items in the CART and after that click on the Checkout option and enter your billing details. 4. Once the payment is made, you will receive an email with the login credentials, and you can start learning after logging into the portal. Q. Will I receive certificate after completing the course? Yes, you will receive a free Digital Certificate after completing the course. If you want, you can order the Digital Transcript, Hardcopy Certificate & Transcript as well, for which you need to pay an additional fee. The fees of Digital Transcript, Hard Copy Certificate & Transcript are given in the certificate ordering page: Ordering page link: https://www.iomh.co.uk/certificate/ Q. Can I gift a course, and if so, how can I do that? Yes, you can gift a course to anyone you wish. After you find the course that you want to gift, please click on the GIFT THIS COURSE option and enter your email and the student's email address. After that, enter the learner's full name. Once you are done with these, click on the Send as Gift option, and you will be directed to the Cart page. You can now make the payment from the Checkout option. The learner will receive the course access details within 24 hours if the payment is successful. Q. Can I do the courses using mobile phone? Our courses are conducted online and you can access them using any internet connected smart device. Q. I have purchased the course when will I be able to access the materials? After purchasing the course, you should receive an email with the login credentials within 24 hours. Please check your spam or junk folder if you didn't receive it in your inbox. You can access your courses by logging into your account. If you still need any assistance, please get in touch with our Customer Support team by providing the details of your purchase. Q. I haven't received my certificate yet. What should I do? You should receive your Digital Certificate within 24 hours after placing the order, and it will take 3-9 days to deliver the hard copies to your address if you are in the UK. For International Delivery, it will take 20-25 days. If you require any assistance, get in touch with our dedicated Customer Support team, and your queries/issues will be dealt with accordingly. Q. I don't have a credit/debit card, what other methods of payment do you accept? You can make the payment using PayPal or you can Bank Transfer the amount. For Bank transfer you will require an invoice from us and you need to contact our Customer Support team and provide details of your purchase to get the invoice. After that, you will receive an email with the invoice and bank details and you can make the payment accordingly. Q. I wanted to ask what is the age limit to do the courses. The age limit to enrol on our courses is 16 years. However, learners below 16 years can enrol in the course with parental consent. Q. What happens if I fail the exam, can I retake? If you fail in the exam then you can retake the exam for a maximum of 3 times. Q. What is the duration of the course please? The course can be accessed for 1 year. The specific course duration varies from course to course. You can find the course duration on the course page. Q. Can I do the courses from outside UK? We are an online course provider, and learners from anywhere in the world can enrol on our courses using an internet-connected device. Q. Can I revisit my course even after completing it? Yes, you can revisit your course even after completing the course as long as you have access to the course. Q. Where can I use the certificate I will receive after completing my course? You can use the certificate in applying for a job in the relevant sector. Q. I have received the course login details but the video does not play. It says the course access details will be sent. Yes, it should have been sent. Please check your Spam/Junk folders. For further inquiries please contact our Customer Support team. Q. When I log into the account it says 'Contact Administrator'. To resolve this issue, please log out of your account and then log back in. Q. I haven't received my course yet? After purchasing the course, you should receive an email with the login credentials within 24 hours. Please check your spam or junk folder if you didn't receive it in your inbox. You can access your courses by logging into your account. If you still need any assistance, please get in touch with our Customer Support team by providing the details of your purchase. Q. Can I make the payment over the phone? Yes, you can make the payment over the phone. Our Customer Support team is always available to assist you. Course Curriculum Course Structure Course Structure 00:07:00 Critical Definitions What is Quality 00:00:00 What is ISO 00:08:00 What is a System - Management System 00:02:00 What is Policy - Quality Policy 00:06:00 What is Vision, Mission & Strategy 00:03:00 QA Vs QC 00:06:00 Effectiveness Vs Efficiency 00:06:00 Verification Vs Validation 00:11:00 Conformity Vs Nonconformity Vs Defect 00:04:00 Correction Vs Corrective Action Vs Preventive Action 00:08:00 Risk & Preventive Action 00:06:00 What is Competence 00:03:00 What is the Context of the Organization 00:05:00 Who are the Interested parties 00:03:00 What are the Needs & expectations 00:05:00 Management System Requirements 00:01:00 Who is a customer 00:02:00 What is Customer Satisfaction 00:06:00 Product Vs Service Vs Process 00:05:00 Document Vs Record 00:06:00 What is Customer Complaint 00:02:00 Measuring Vs Monitoring Vs Performance 00:02:00 Who is Responsible Who is Responsible 00:12:00 Responsibility Vs Accountability 00:02:00 Quality Management Principles Quality Management Principles 00:17:00 Major Changes ISO 9001:2015 Core Concepts 00:08:00 Major terminology Differences 00:04:00 Documented Information 00:07:00 Major changes - Organizational Knowledge 00:05:00 Major changes - Risk Based Thinking 00:06:00 Process Approach Process Approach Concept-1 00:04:00 What is PDCA 00:05:00 Process Approach Concept-2 00:03:00 Process Approach in ISO 9001:2015 00:04:00 Key Benefits 00:07:00 PDCA in ISO 9001 2015 00:10:00 Context of the Organization Understanding the Organization and its Context 00:08:00 Internal & External issues 00:03:00 SWOT Analysis 00:06:00 Interested Parties & their Needs & Expectations 00:03:00 KANO Model 00:10:00 Understanding the context - Summary 00:08:00 Choosing your Strategic Objective 00:05:00 Strategic Map Examples-1 00:03:00 Strategic Planning Process 00:06:00 What is a Vision 00:06:00 How to Create a Vision Statement 00:08:00 What is a Mission 00:06:00 SMART GOAL 00:06:00 SMART Goal Example 00:04:00 Strategic Map Examples-2 00:10:00 Context Chapter Summary 00:07:00 Quality Objectives Quality Objectives & Planning 00:05:00 ISO & SMART 00:02:00 Objectives Origin 00:06:00 Objectives Examples 00:07:00 Goal Vs Objective-1 00:07:00 Goal Vs Objective Example 00:02:00 Goal Vs Objective-2 00:10:00 Performance Evaluation Performance Evaluation in ISO 9001:2015 00:10:00 Customer Satisfaction 00:06:00 Analysis & Evaluation 00:12:00 Key Performance Indicators 00:08:00 Dashboard Examples 00:07:00 Management Review Meetings 00:11:00 Improvement 00:16:00 Nonconformity & Corrective Action 00:06:00 Nonconformity & Corrective Action Example 00:06:00 Nonconformity & Corrective Action Origin 00:06:00 Continual Improvement 00:01:00 Analysis Mindset 00:09:00 Quantitative Vs Qualitative 00:16:00 Now What Now What? 00:11:00 Course Summary 00:10:00 Helpful Tools SIPOC 00:06:00 Flowcharts 00:04:00 Control Charts 00:04:00 Cause and Effect Diagram 00:06:00 Pareto Chart 00:07:00 5 WHYs 00:03:00 Other Tools 00:08:00 Finally! 00:01:00 See you soon Bonus Lecture 00:02:00 Assignment Assignment - ISO 9001: Quality Management System 00:00:00
Overview The Invisible Engine: Mastering the Art of Supply Chain Management Picture this: a seamless flow of goods, from raw materials to your doorstep, a silent symphony ensuring everything you need arrives when you want it. This, my friend, is the magic of Supply Chain Management (SCM), the invisible engine driving the modern world. In the UK alone, the logistics industry contributes a staggering £116 billion to the economy, employing over 4.8 million people. It's a dynamic, ever-evolving field with opportunities for those who master its intricacies. Ready to unlock the hidden potential of your supply chain management skills? Enrol today and embark on a journey that will equip you with the knowledge and skills to thrive in this dynamic and rewarding field. You Will Learn Following Things: Unravel the intricacies of Supply Chain Management (SCM), grasping its core principles and the crucial role of logistics. Discover the art of customer response, crafting systems that exceed expectations and build loyalty. Navigate the complexities of global operations, ensuring smooth flow across borders and continents. Master inventory strategies, minimising waste and maximising efficiency. Become a warehouse maestro, optimising operations and mastering storage techniques. Design and monitor resilient supply chains, prepared for any disruption or challenge. Evaluate and optimise your network, ensuring agility and cost-effectiveness. Embrace the future of Supply Chain Management (SCM), exploring new business concepts and cutting-edge technologies. Align your supply chain with your business goals, driving growth and profitability. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Supply Chain Management Course. 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 Supply Chain Management Course 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? Aspiring Supply Chain Management (SCM) professionals seeking a comprehensive foundation. Business owners looking to streamline their operations and gain a competitive edge. Procurement specialists are eager to hone their sourcing and negotiation skills. Logistics professionals aiming to elevate their careers to leadership positions. Anyone fascinated by the invisible forces shaping our world and eager to become a part of it. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Supply Chain Management Course 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 Procurement Officer: £28,000 to £40,000/year. Logistics Coordinator: £25,000 to £35,000/year. Inventory Controller: £26,000 to £38,000/year. Supply Chain Analyst: £30,000 to £45,000/year. Purchasing Manager: £35,000 to £55,000/year. Course Curriculum Module 01: An overview of Supply Chain Management An Overview of Supply Chain Management 00:17:00 Module 02: Role of logistics of Supply Chain Role of logistics of Supply Chain 00:19:00 Module 03: Customer Response Principles and Systems Customer Response Principles and Systems 00:15:00 Module 04: Supply Chain System and Principles Supply Chain System and Principles 00:15:00 Module 05: Global Supply Chain Operations Global Supply Chain Operations 00:17:00 Module 06:Inventory Strategies for Supply Chain Inventory Strategies for Supply Chain 00:15:00 Module 07: Warehouse Management and Operations Warehouse Management and Operations 00:13:00 Module 08: Supply Chain Design and Monitoring Supply Chain Design and Monitoring 00:15:00 Module 09: Supply Chain Network and Evaluating Supply Chain Network and Evaluating 00:18:00 Module 10: Supply Chain Planning and New Business Concepts Supply Chain Planning and New Business Concepts 00:17:00 Module 11: Aligning your supply chain process with your business Aligning Supply Chain Process with Your Business 00:18:00
Overview This SQL course will unlock your full potential and will show you how to excel in a career in SQL. So upskill now and reach your full potential. Everything you need to get started in SQL is available in this course. Learning and progressing are the hallmarks of personal development. This SQL will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your SQL skills to help you advance your career. Acquire a comprehensive understanding of various SQL topics and tips from industry experts. Learn in-demand SQL skills that are in high demand among UK employers, which will help you to kickstart your career. This SQL course covers everything you must know to stand against the tough competition in the SQL field. The future is truly yours to seize with this SQL. Enrol today and complete the course to achieve a SQL 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 SQL 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 SQL 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 SQL 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 SQL is suitable for anyone aspiring to start a career in SQL; even if you are new to this and have no prior knowledge on SQL, this course is going to be very easy for you to understand. And if you are already working in the SQL 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 SQL 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 SQL course has no prerequisite. You don't need any educational qualification or experience to enrol in the SQL 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 SQL course. Course Curriculum Unit 01: Course and Instructor Introduction Course and Instructor Introduction 00:05:00 Unit 02: Laying out the foundation - Overview & Installation Pre-requisites & Different Editions of SQL Server 00:06:00 Downloading Express Edition & sample database 00:03:00 Installing the downloads & Configuration 00:19:00 The sa Login 00:04:00 Wrap up - what we went over! 00:01:00 Unit 03: Core concepts - Taming the RDBMS beast! What is RDBMS? 00:12:00 Where does SQL Server fit in? 00:02:00 Basic database objects 00:16:00 Different Files that got installed - MDF & LDF 00:03:00 Wrap up - what we went over! 00:01:00 Unit 04: Tool of the trade - SQL Server Management Studio Getting started with SSMS 00:07:00 Getting around Object Explorer 00:05:00 Query Window 00:06:00 Pre-built DB - system database 00:04:00 Wrap up - what we went over! 00:01:00 Unit 05: Simple SELECT Bare Minimum: SELECTING a literal 00:05:00 Retrieving / querying data from a table - using FROM clause 00:06:00 Playing with Column Names 00:03:00 Rearranging columns to your liking 00:01:00 Wrap up - what we went over! 00:01:00 Unit 06: Filtering out unwanted data Narrowing down and ordering result set - WHERE and ORDER clause 00:17:00 Narrowing down result set - BETWEEN / NOT BETWEEN 00:09:00 Narrowing down result set - IN and NOT IN operator 00:05:00 Narrowing down result set - Pattern Matching: LIKE and Wildcards 00:11:00 Wrap up - what we went over! 00:01:00 Unit 07: Expressions and Functions Dealing with nothing: NULL 00:06:00 Working with strings: Concatenation and other string functions 00:15:00 Working with dates: Date Functions 00:07:00 Some System Functions 00:05:00 Wrap up - what we went over! 00:02:00 Unit 08: Getting data out of multiple tables Joining multiple tables - INNER JOIN 00:09:00 Join types - OUTER JOIN - LEFT / RIGHT / FULL 00:08:00 Join types - CROSS JOIN 00:02:00 Holy UNION! 00:03:00 Subqueries 00:04:00 Wrap up - what we went over! 00:02:00 Unit 09: Summarizing and Grouping data DISTINCT and ALL Predicates 00:02:00 Aggregate Functions 00:03:00 GROUP BY clause / HAVING clause 00:04:00 WHERE and ORDER BY in aggregate queries 00:04:00 Wrap up - what we went over! 00:01:00 Unit 10: Bonus Bonus_Section 00:01:00
Overview This SEO course will unlock your full potential and will show you how to excel in a career in SEO. So upskill now and reach your full potential. Everything you need to get started in SEO is available in this course. Learning and progressing are the hallmarks of personal development. This SEO will quickly teach you the must-have skills needed to start in the relevant industry. In This SEO Course, You Will: Learn strategies to boost your workplace efficiency. Hone your SEO skills to help you advance your career. Acquire a comprehensive understanding of various SEO topics and tips from industry experts. Learn in-demand SEO skills that are in high demand among UK employers, which will help you to kickstart your career. This SEO course covers everything you must know to stand against the tough competition in the SEO field. The future is truly yours to seize with this SEO. Enrol today and complete the course to achieve a SEO 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 SEO 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 SEO 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 SEO 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 SEO is suitable for anyone aspiring to start a career in SEO; even if you are new to this and have no prior knowledge on SEO, this course is going to be very easy for you to understand. And if you are already working in the SEO 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 SEO 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 SEO course has no prerequisite. You don't need any educational qualification or experience to enrol in the SEO 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 SEO course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Section 1: Introduction Unit 1: Introduction 00:04:00 Unit 2: Course Overview 00:04:00 Section 2: SEO: Core Concepts Unit 1: What is SEO (Search Engine Optimisation) 00:04:00 Unit 2: Types of SEO: Black Hat, Grey Hat & White Hat SEO 00:05:00 Unit 3: How Search Engines Give Ranks: Crawling, Indexing & Ranking 00:06:00 Unit 4: 2 Ways to Get Ranked on Search Engines 00:03:00 Section 3: On - Page Optimisation Unit 1: On Page SEO Explained 00:01:00 Unit 2: On Page SEO Activities 00:04:00 Unit 3: 4 Key Ranking Factors of On Page SEO 00:04:00 Unit 4: Tools & Tips for Increasing Site Speed 00:13:00 Unit 5: Using SEO Friendly Themes 00:06:00 Unit 6: Increasing the Dwell Time & Decreasing Bounce Rate 00:05:00 Unit 7: How to Make the URL SEO Friendly 00:03:00 Unit 8: Long Form SEO Optimised Content 00:03:00 Unit 9: Internal Linking 00:05:00 Unit 10: Meta Title & Meta Description 00:03:00 Unit 11: Optimising Images for SEO 00:04:00 Unit 12: Outbound Links 00:04:00 Section 4: Keyword Research & Optimisation Unit 1: What Are Keywords & Why They Are Important 00:06:00 Unit 2: Types of Keywords 00:08:00 Unit 3: Which Type of Keywords You Should Choose 00:01:00 Unit 4: Free Tools for Keyword Research & SEO 00:06:00 Unit 5: Paid Tools for Keyword Research & SEO 00:03:00 Unit 6: 2 Metrics to Check Before Choosing Content 00:05:00 Unit 7: Steps for Keyword Research 00:11:00 Unit 8: What is Keyword Stuffing? 00:05:00 Section 5: SEO Content Writing Unit 1: Write SEO Optimised Title 00:04:00 Unit 2: 6 Hacks to Write Attractive Headlines 00:17:00 Unit 3: Keyword Placement For SEO 00:06:00 Unit 4: Steps to Write Content & Optimise It for Search Engines 00:09:00 Section 6: Off Page SEO Unit 1: What Is Off Page Optimisation 00:01:00 Unit 2: Link Building - 1st Factor of Off Page SEO 00:07:00 Unit 3: 3 Methods to Get Backlinks 00:02:00 Unit 4: Method 1: Guest Posting for Link Building 00:07:00 Unit 5: Method 2: Building Relations with Experts 00:04:00 Unit 6: Method 3: Getting Backlinks from Round Up Post 00:04:00 Unit 7: Social Media Marketing - 2nd Factor of Off Page SEO 00:05:00 Section 7: Conclusion Unit 1: Conclusion 00:01:00