53585 Courses delivered Online

Discover who your child is and who they are meant to be

Discover how to raise a Resilient child

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  

Find out what Discipline is, and what it isn't and how to discipline effectively to empower your child

Overview of Health and Safety at Workplace Join our Health and Safety at Workplace 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 Health and Safety at Workplace course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Health and Safety at Workplace 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! This Health and Safety at Workplace Course will help you to learn: 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 Health and Safety at Workplace. 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 Health and Safety at Workplace 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 Health and Safety at Workplace 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 You don't need any educational qualification or experience to enrol in the Health and Safety at Workplace 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 Health and Safety at Workplace 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 Module 01: Health and Safety at Work and the Laws Health and Safety at Work and the Laws 00:24:00 Module 02: Managing for Health and Safety Managing for Health and Safety 00:09:00 Module 03: Risk Assessment and Common Risks Risk Assessment and Common Risks 00:34:00 Module 04: Workplace Health, Safety and Welfare Workplace Health, Safety and Welfare 00:27:00 Module 05: Accidents and Ill Health at Work Accidents and Ill Health at Work 00:21:00 Module 06: Electrical, Fire and Gas Safety Electrical, Fire and Gas Safety 00:25:00 Module 07: Safety in Different Work Settings Safety in Different Work Settings 00:41:00 Module 08: Work Equipment Hazards and Risk Control Work Equipment Hazards and Risk Control 00:24:00 Module 09: Other Health and Safety Hazards at Work Other Health and Safety Hazards at Work 00:22:00 Assignment Assignment - Health and Safety at Workplace 00:00:00

Overview of Eating Psychology Join our Eating Psychology 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 Eating Psychology course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Eating Psychology 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! Get a quick look at the course content: This Eating Psychology Course will help you to learn: 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 Eating Psychology. 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 Eating Psychology 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 Eating Psychology 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 You don't need any educational qualification or experience to enrol in the Eating Psychology 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 Eating Psychology 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 Module 1: Introduction to Eating Psychology Introduction to Eating Psychology 00:17:00 Module 2: Mindful Eating and Nutrition Mindful Eating and Nutrition 00:16:00 Module 3: Eating Disorders and Disordered Eating Eating Disorders and Disordered Eating 00:18:00 Module 4: Food and Mood Food and Mood 00:15:00 Module 5: Emotional Eating and Food Addiction Emotional Eating and Food Addiction 00:22:00 Module 6: Integrative Approaches to Eating Psychology Integrative Approaches to Eating Psychology 00:11:00 Module 7: Body Image and Self-Esteem Body Image and Self-Esteem 00:14:00 Module 8: Coaching and Professional Practice Coaching and Professional Practice 00:15:00

Overview of Medical Transcription Unlock your full potential and excel in a career in the Medical Transcription field. Everything you need to get started is available in this Medical Transcription course. You will get step-by-step lessons from experts. Enrol today and complete the course to achieve a CPD Accredited certificate that can uplift your career. Become proficient in Medical Transcription by grasping all the essential knowledge from our top-quality course step by step. Enrol now to ensure that your Medical Transcription mastery is not limited to only conceptual frameworks! This course will assist you in standing out from the crowd and being more efficient in your chosen area of expertise. Furthermore, if you require assistance with the Medical Transcription course, we will provide experts who will support and guide you. So, add this course to your cart and boost your personal and career development. This Medical Transcription Course will help you to learn: 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 Medical Transcription. 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 Medical Transcription 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 Medical Transcription 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 You don't need any educational qualification or experience to enrol in the Medical Transcription 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 Medical Transcription 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 Module 01: Introduction to Medical Transcription Introduction to Medical Transcription 00:13:00 Module 02: The What, How, Who and Why of Medical Transcription The What, How, Who and Why of Medical Transcription 00:18:00 Module 03: Understanding Medical Reports Understanding Medical Reports 00:26:00 Module 04: Medical Language Boot Camp Medical Language Boot Camp 00:13:00 Module 05: Formatting: The Basics Formatting: The Basics 00:15:00 Module 06: Data Protection Data Protection 00:18:00 Assignment Assignment - Medical Transcription 00:00:00

Overview of Mental Health Awareness Diploma Mental health issues affect 1 in 4 people in the UK each year. With growing awareness, demand for mental health services is rising. There are opportunities for meaningful careers supporting those experiencing mental ill health. This Mental Health Awareness Diploma quips you with knowledge and skills for healthcare, education, social services, and management roles. You’ll gain a comprehensive understanding of mental health while developing practical abilities to enact positive change. Make a difference and join the critical effort to support mental wellbeing. This Mental Health Awareness Diploma will help you to learn: Understand the range of mental health conditions and their symptoms Learn about assessment, diagnosis and treatment of mental health problems Gain knowledge of mental health legislation, services and social attitudes Develop skills to support those experiencing mental ill health Be able to promote positive mental health and wellbeing Understand the impact of mental health in the workplace and the role of employers. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Mental Health Awareness Diploma. 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 Mental Health Awareness Diploma 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? Healthcare professionals, including nurses, social workers, counsellors, Teachers, lecturers, and education professionals Managers and HR professionals Individuals wanting to promote mental health awareness Students studying psychology, healthcare, social care Anyone wanting to understand mental health better? Requirements You don’t need any educational qualification or experience to enrol in the Mental Health Awareness Diploma course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path Mental Health Nurse - £24K to £40K/year Counsellor - £20K to £60K/year Psychologist - £26K to £60K/year Social Worker - £23K to £40K/year Teacher - £25K to £41K/year

Overview of Diploma in End of Life Care The UK has witnessed a rising need for proficient end of life caregivers, creating a realm where empathy meets expertise. This Level 3 End of Life Care Diploma, interwoven with topics from palliative assessments to the intricacies of post-death procedures, is designed to cultivate a holistic understanding.  As the end of life care sector garners increasing significance, individuals trained in this area stand at the intersection of necessity and opportunity. With the UK's ageing population, the demand for end of life care services is set to increase, making it a timely venture for those wishing to engage in this profoundly impactful area.  Secure your place in this ever-evolving field, and become a beacon of support and care with our comprehensive curriculum. This End of Life Care Course covers the following topics: Understand core concepts surrounding end of life care. Gain insight into the availability and structure of services. Develop expertise in advance care planning and setting goals. Learn effective communication techniques during the end of life stages. Enhance awareness of legal aspects and post-death care. Acquire knowledge in palliative, spiritual, and psychosocial care. 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 Diploma in End of Life 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. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Diploma in End of Life Care 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 You don't need any educational qualification or experience to enrol in the Diploma in End of Life 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 The certification and skills you get from this Diploma in End of Life Care 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 End of Life Care Module 1: Introduction to Palliative & End of Life Care 00:45:00 Module 2: Identification of the Stage of Illness 00:15:00 Module 3: Palliative Care Holistic Assessment 00:15:00 Module 4: Advance Care Planning 00:30:00 Module 5: Care at the End of Life 00:15:00 Module 6: Care after Death 00:15:00 Module 7: Further Support, Training and Development 00:10:00 Module 8: Legal Issues 00:30:00 Module 9: Glossary of Terms 00:15:00 Module 10: Appendices 00:10:00

Overview of Care Planning and Record Keeping | Health & Safety Online Join our Care Planning and Record Keeping | Health & Safety Online 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 Care Planning and Record Keeping | Health & Safety Online course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Care Planning and Record Keeping | Health & Safety Online 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! This Care Planning and Record Keeping | Health & Safety Online Course will help you to learn: 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 Care Planning and Record Keeping | Health & Safety Online. 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 Care Planning and Record Keeping | Health & Safety Online 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 Care Planning and Record Keeping | Health & Safety Online 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 You don't need any educational qualification or experience to enrol in the Care Planning and Record Keeping | Health & Safety Online 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 Care Planning and Record Keeping | Health & Safety Online 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 Care Planning and Record Keeping | Health & Safety Online Course Module 01: Introduction to the Care Planning Process 00:17:00 Module 02: Planning Care With the Individual in Need 00:17:00 Module 03: Concept Care Mapping 00:16:00 Module 04: Implementing and Evaluating the Care Plan 00:18:00 Module 05: Maintaining Medical Records 00:20:00 Module 06: Care Planning Policy in the UK 00:16:00 Module 07: Confidentiality and Record-Keeping 00:12:00 Module 08: Safeguarding Children, Young People and Their Families 00:21:00 Assignment Assignment - Care Planning and Record Keeping | Health & Safety Online Course 00:00:00