34992 Courses delivered On Demand

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  

Pool Maintenance Career Training Overview The Pool Maintenance Online Course is a step-by-step guide for anyone looking to keep swimming pools clean, safe and in top working condition. You will learn how to use pool maintenance equipment, clean and service pools regularly, and understand the importance of chemical balance. The course also covers how to check water quality and follow key safety practices. With simple explanations and practical tips, this course helps pool owners, staff, and service providers build the skills needed to manage pool care with confidence. Learning Outcomes Identify and use key pool maintenance tools Perform basic cleaning tasks such as skimming, brushing and vacuuming Understand how chemicals affect pool water Maintain the correct chemical balance for safe swimming Test and monitor water quality regularly Recognise signs of water contamination Prevent algae and bacteria growth Follow safety rules around pools Set up a regular pool care schedule Handle common pool problems and solutions Who Is This Course For This course is ideal for homeowners with a private pool, caretakers, lifeguards, or anyone looking to start a career in pool services. It is also useful for hotel and leisure centre staff who want to improve their pool maintenance skills. Eligibility Requirements There are no formal requirements to join this course. Anyone with an interest in pool care or a desire to learn basic maintenance techniques is welcome. Entry Requirements Age Requirement: Applicants must be 16 or older, making the course accessible to both young learners and adults. Academic Background: No prior qualifications required, open to all backgrounds. Language Proficiency: A good understanding of English is essential, as all lessons are in English. Numeracy Skills: Basic writing and numeracy skills are needed to follow the course content. Why Choose Us Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited Access to course content on mobile, tablet or desktop from anywhere, anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path This course supports career opportunities in pool maintenance and water quality services. It can lead to roles such as Pool Technician, Pool Maintenance Assistant, Leisure Centre Staff, or Groundskeeper. It also helps entrepreneurs who want to start their own pool cleaning business.

The Pastoral Safeguarding Course offers a thorough exploration of safeguarding principles tailored specifically for pastoral settings. Designed to enhance awareness and understanding, this course guides learners through recognising and responding to safeguarding concerns with confidence and clarity. It delves into the essential responsibilities involved in creating safe environments where vulnerable individuals feel protected and supported, all within a straightforward and accessible online format. The content is crafted to suit anyone involved in pastoral care, whether in educational institutions, faith communities, or voluntary organisations. This course ensures that learners gain a clear grasp of safeguarding policies, the importance of confidentiality, and effective communication strategies to foster trust and respect. With an emphasis on recognising signs of abuse or neglect, it equips participants with the knowledge to act appropriately and sensitively. Delivered entirely online, this course fits seamlessly into busy schedules, allowing individuals to study at their own pace without the need for physical attendance. Whether you’re new to pastoral safeguarding or seeking a refresher, this course provides the confidence and understanding necessary to make a positive difference in the lives of those you support. Key Features: CPD Accredited Pastoral Safeguarding Course Instant e-certificate Fully online, interactive Pastoral Safeguarding course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Pastoral Safeguarding Course Curriculum Module 01: Introduction to Safeguarding Module 02: Laws and Guidance Module 03: Child Abuse Module 04: Sexual Abuse Module 05: Risks and Risk Assessment Module 06: Responding to Disclosure and Reporting Module 07: Things to Do after Referral Module 08: Record Keeping Module 09: Introduction to School Administration Module 10: Types of Schools in the UK Module 11: Workplace Development Module 12: Safeguarding Students Module 13: Child Development Module 14: Managing School Premises. Module 15: Managing for Health and Safety Module 16: Risk Assessment and Common Risks Module 17: Accidents and Ill Health at Work Module 18: Electrical, Fire, and Gas Safety Learning Outcomes: Understand the fundamental principles of pastoral safeguarding and its importance in pastoral care. Gain knowledge of the relevant laws and guidance governing pastoral safeguarding practices. Identify different forms of child abuse and understand how to respond appropriately. Acquire a comprehensive understanding of sexual abuse and the measures to prevent and address it. Learn how to respond to disclosures, report incidents, and navigate the referral process. Accreditation All of our courses, including this Pastoral Safeguarding course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Pastoral Safeguarding course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Assessment At the end of the Pastoral Safeguarding course, there will be an online assessment, which you will need to pass to complete the course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This comprehensive Pastoral Safeguarding course is suitable for: School administrators, teachers, and pastoral staff. Social workers and child protection professionals. Healthcare and mental health practitioners working with children and young people. Requirements Learners do not require any prior qualifications to enrol on this Pastoral Safeguarding course. Career path School Safeguarding Officer Child Protection Advocate Youth Support Worker Social Worker (Specializing in Child Welfare) Education Policy Analyst Family Support Worker Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Throughout our course, we will provide you with an in-depth understanding of the AWS Certified Solutions Architect Associate course and how to put it into practice.

Master SQL Database Queries with our comprehensive course. Learn SQL fundamentals, advanced techniques, and data analysis skills for efficient database management.

Overview When it comes to food services, delivering delicious food is not enough. Along with tasty food, you are also responsible for providing safe and hygienic food to your clients. Learn how to secure food safety in the catering business with our exclusive Level 2 Certificate in Food Hygiene and Safety for Catering course.  This course is divided into informative and engaging video modules. These modules will educate you on the law and regulations regarding food safety. You will also learn about different types of food hazards, such as chemical hazards, bacterial hazards, allergen hazards etc. The course will also provide detailed lessons on food poisoning, spoilage, and more. Further, in the study, you will learn the HACCP principles. This course is the ideal place to develop your knowledge and skills. So, enrol today and get a step closer to providing quality food to your customers.  Learning Outcomes Enhance your understanding of food safety law Familiarise yourself with different kinds of food hazards Develop the skills to control food poisoning Understand the principles of storing food and avoiding spoilage Learn about the rules of HACCP Develop the skills to maintain hygiene in the kitchen Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos and materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email Who Should Take this Level 2 Certificate in Food Hygiene and Safety for Catering Course? Whether you're an existing practitioner or an aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge. Are There Any Entry Requirements? This Level 2 Certificate in Food Hygiene and Safety for Catering course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Level 2 Certificate in Food Hygiene and Safety for Catering Certification After completing and passing the Level 2 Certificate in Food Hygiene and Safety for Catering successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at £39 or in PDF format at £24. Career Path​ This exclusive Level 2 Certificate in Food Hygiene and Safety for Catering course will equip you with effective skills and abilities and help you explore career paths such as Caterer Chef Restaurant Staff Restaurant Manager Level 2 Food Hygiene and Safety for Catering Introduction to Food Safety and the Law 00:29:00 Bacteria and Microbiological Hazards 00:27:00 Physical, Chemical and Allergenic Hazards 00:25:00 Food Poisoning and Control Measures 00:23:00 Food Spoilage and Food Storage 00:25:00 Personal Hygiene 00:24:00 HACCP and Food Premises 00:27:00 Cleaning 00:21:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

>>24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now!<< With the help of our Massage Therapy - Level 3 course, learners can start a career as a freelance massage therapist, put up a business, or join a company engaged in providing Sports Massage Therapy services to clients (examples of the latter are fitness centres and spas which are continuously growing in number). A Massage Therapy course may be the ideal choice for those individuals who enjoy helping people and who want to use their knowledge of the body to help individuals to relax through different massaging techniques. This online course teaches individuals how to perform a variety of massaging techniques. Massage therapy is the art of relaxation through pressure applied in various ways to the muscles of the body. This can often help with pain management, chronic conditions, stress, and relaxation. Courses Are Included in This Massage Therapy Bundle: Course 01: Massage Therapy Course 02: Lymphatic Drainage Massage Therapy Course 03: Reflexology Course 04: Aromatherapy Course 05: Sports Massage Whatever the choice is, it can lead to a financially rewarding Massage Therapy based career that also helps other people achieve stress-free and healthy lifestyles. As more and more people appreciate the relief rendered by Massage Therapy specialists, employment opportunities in this field increase day by day. Hence, it is the best time to establish yourself in this Massage industry and this is where ICI can be of great help. Our Sports Message Therapy - Level 3 course breaks down in detail basic and excellent advanced massaging techniques. This course covers different types of Message Therapy - such as Indian Head, Facial, Neck, Back, Full Body, Swedish, Sports, LomiLomi, Anti-Cellulite, Hot Stone, Thai Foot, Prenatal, Medical, Baby, Trigger Point Therapy, Thai, Reflexology and much more. There is also a bonus lesson you'll experience with this Sports Massage course, like Aromatherapy & Acupressure. Learning Outcomes of Massage Therapy Understand the history and principles of massage therapy. Identify the different types of massage techniques and their benefits. Perform various massage modalities, including Swedish, sports, and deep tissue. Apply specialized techniques such as trigger point therapy and reflexology. Learn about the business aspects of massage therapy, including marketing and client management. Understand the importance of ethical and professional conduct in the massage therapy field. Taking a Level 3 Sports Massage Therapy Diploma can help the student prepare for any necessary licensing requirements. It can help individuals get the education they need to learn the skills, including practical application skills and the science of the body's muscle systems. Why Choose Our Massage Therapy Course? Get a free student ID card with Massage Therapy Training Get instant access to this Massage Therapy course. Learn Massage Therapy from anywhere in the world The Massage Therapy is affordable and simple to understand The Massage Therapy is an entirely online, interactive lesson with voiceover audio Lifetime access to the Massage Therapy course materials The Massage Therapy comes with 24/7 tutor support Take a step toward a brighter future with our Massage Therapy course! *** Course Curriculum *** Here is the curriculum breakdown of this Sports Massage Therapy course: Sports Massage Therapy Level 3 Introduction History The Role of a Therapist Tissues, Organs, & Neuromuscular systems General Benefits Different Types of Massages Indian Head Facial Neck Back Full Body Swedish Sports LomiLomi Anti-Cellulite Hot Stone Thai Foot Prenatal Medical Baby Trigger Point Therapy Thai Reflexology How A Therapist Can Start A Business Marketing Your Business Complimentary Massages Building Your Clientele Other Ways to Market Your Business Conclusion Lymphatic Drainage Massage Module 1: Introduction to Lymphatic Drainage Massage Module 2: The Lymphatic System Module 3: Lymphatic Dysfunction Module 4: Manual Lymphatic Drainage Massage Module 5: Manual Lymphatic Massage Treatment Additional Module: Aromatherapy Additional Module: Acupressure Assessment Process Your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the Massage Therapy course. After completing this Massage Therapy, Reflexology, Aromatherapy, LomiLomi & Sports Massage course, you can progress towards- Indian head massage Therapy Facial massage Accredited Massage Therapist Level 3 Diploma in Sports Massage Therapy (RQF) Level 3 Diploma in Massage Therapy for Sports (RQF) Accredited massage course Level 4 Certificate in Massage Therapy for Sports (RQF) Hot Stone massage Massage Diploma Body Massage Diploma Lymphatic Drainage Massage Therapy CPD 20 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Massage course is for you if you: Anyone interested in learning more about the topic is advised to take this Sports Massage Therapy course. This course is open to everybody. Hawaiian Lomilomi Massage Requirements You will not need any prior background or expertise to enrol in this Massage Therapy course. Career path Through industry professional support and resources, this Massage Therapy course is designed to prepare you for success as a Sports Massage Therapist. This course would particularly enhance your career in the following role: Sports Massage Therapist Aromatherapist Acupuncture Alternative Therapy The Annual Avg. salary for this position would be £20,000 to £23,000 per year in the UK. Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

This Baking course will teach you what you need for baking & decorating all types of cakes. Enrol now to see if it fits your needs.

Animal Care with Dog First Aid and Dog Grooming Diploma Embark on a rewarding journey into the realm of Animal Care with our specialised diploma. This course equips you with the essential Animal Care skills and knowledge to provide top-notch care for animals, particularly dogs. Setting you on a fulfilling Animal Care career path, this diploma is your gateway to becoming a consummate professional in the field of Animal Care. Learning Outcomes: Master the key principles underpinning effective Animal Care. Gain practical insights into basic animal health, a cornerstone in quality Animal Care. Understand the fundamentals of animal psychology and how they interface with optimal Animal Care. Learn the critical rules governing Dog First Aid, a vital skill set in Animal Care. Discover the health and aesthetic benefits of Dog Grooming, another crucial aspect of Animal Care. Acquire practical skills for basic dog handling and safety, essential for responsible Animal Care. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Animal Care with Dog First Aid and Dog Grooming Diploma: Principles of Animal Care: Develop a strong foundational understanding of the ethics and methodologies involved in responsible Animal Care. Basic Animal Health in Animal Care: Delve into the vital components of animal health, focusing on preventative care and early diagnosis as key elements in Animal Care. Animal Psychology and Its Role in Animal Care: Explore the complexities of animal behavior and psychology, understanding its direct relevance to Animal Care. Rules of Dog First Aid in Animal Care: Equip yourself with life-saving Dog First Aid rules and procedures to handle emergencies effectively within the context of Animal Care. Benefits of Dog Grooming in Animal Care: Learn about the aesthetic and health benefits of Dog Grooming, along with professional techniques, to offer comprehensive Animal Care. Basic Dog Handling and Safety in Animal Care: Grasp essential dog handling techniques to ensure both human and animal safety as part of comprehensive Animal Care.

Description: Fly fishing is a sport of fishing that uses a rod and an artificial fly as bait. This is a game that you and your family could be interested in. If you are searching for a sport or an outdoor activity that your family could bond on, then might want to consider fly fishing. In this course, you will be provided with the basics and techniques you could use in fly fishing. Whether you are considering is just a time passing activity or profession, you will still be provided with all the learning materials you need for fly fishing. Who is the course for? Fly fishing professionals to learn about the current market trend and feedback from the customers themselves. Anyone who wants to experience fly fishing Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Advanced Diploma in Fly Fishing course is a useful qualification to possess, and would be beneficial for the following careers: Coach Family Activity Organizer Fly Anglers Fly Fishing Guide Mentor. Fly Fishing Basics Introduction 00:15:00 Terminology 00:30:00 Getting the Gear 00:30:00 Putting Together Your Rod & Reel 00:30:00 Knots 00:30:00 CASTING BASICS 01:00:00 D-I-Y Flies 00:30:00 Where the Fish Are 00:30:00 Destinations 00:30:00 Fly Fishing Ethics 00:30:00 Conclusion 00:15:00 Fly Fishing Techniques An Introduction to Fly Fishing 00:30:00 Choosing a Rod 00:30:00 Choosing a Reel 00:30:00 Choosing a Fly Line 01:00:00 How To Care for Your Rod, Reel and Fly Line 01:00:00 Leaders and Tippets 00:30:00 Filling a Reel with Line and Backing 00:30:00 Putting it All Together 00:30:00 Casting for Beginners 00:30:00 Learning the Roll Cast 00:30:00 Choosing the Best Waders for You 00:30:00 Read Your Surroundings 00:15:00 About Fishing Knots 01:00:00 About Artificial Flies 00:30:00 The Figure 8 Retrieve 00:15:00 Glossary 00:15:00 Mock Exam Mock Exam- Advanced Diploma in Fly Fishing 00:30:00 Final Exam Final Exam- Advanced Diploma in Fly Fishing 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00