• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

4646 Courses delivered On Demand

Sports Coaching: Sports Coaching

By Training Tale

Sports Coaching: Sports Coaching Online Training This Sports Coaching: Sports Coaching course is designed for anyone who wants to start a sports coaching business or work in sports as a mentor or coach. This Sports Coaching course covers a wide range of sports and coaching models, as well as important information on coaching philosophy and skills. This Sports Coaching: Sports Coaching course will teach you how to motivate and empower your clients, set individual goals for them, and train them to reach their full physical potential and overcome injury. By the end of this Sports Coaching course, you will be able to help players in reaching their goals and establishing a promising career as a sports coach. So enrol Sports Coaching course today and advance your career. Why Choose This Sports Coaching: Sports Coaching Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Sports Coaching Course developed by industry experts. Free PDF certificate as soon as completing the Sports Coaching course. Main Course : Sports Coaching Free Courses : Course 01: Sports Psychology for Coaches Course 02: Diploma in Sports Nutrition Others Included in this Sports Coaching: Sports Coaching Course Free 03 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Sports Coaching: Sports Coaching course] Sports Coaching: Sports Coaching Training This Sports Coaching course will walk you through the entire coaching process. The Sports Coaching course will provide you with theoretical knowledge that you can apply in the real world, from assessing your clients' abilities to analysing their nutritional needs. Industry Experts Designed this Sports Coaching: Sports Coaching course into 11 detailed modules. Assessment Method of Sports Coaching: Sports Coaching After completing each module of the Sports Coaching course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Sports Coaching: Sports Coaching After completing the MCQ/Assignment assessment for this Sports Coaching course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Sports Coaching: Sports Coaching Online Training This Sports Coaching: Sports Coaching course is ideal for anyone who wants to establish a business or kickstart a career as a sport coach. Requirements Sports Coaching: Sports Coaching Students who intend to enrol in this Sports Coaching: Sports Coaching course must meet the following requirements: Sports Coaching: Good command of the English language Sports Coaching: Must be vivacious and self-driven Sports Coaching: Basic computer knowledge Sports Coaching: A minimum of 16 years of age is required Career path Sports Coaching: Sports Coaching Certificates Certificate of completion Digital certificate - Included

Sports Coaching: Sports Coaching
Delivered Online On Demand22 hours
£12

British Sign Language (BSL) with Interpreter Level 3

By Training Tale

British Sign Language (BSL) Do you want to master an interpreter course to achieve a handsome job for a better career? Come enrol our interpreter course for a broad interpreter introduction. This interpreter course helps to develop language skills. You will gain mastery over interpreting modes and methods through the interpreter course. Our interpreter course covers cultural competency and sensitivity. Specific interpreting abilities are taught in the interpreter course. The interpreter course will teach you how to apply ethnology in interpretation. Professional growth and ethics are aided by this interpreter course. If you want to meet your requirements you must take the interpreter course assistance! Industry Experts Designed this British Sign Language course into 15 detailed modules. Course Curriculum of (BSL) British Sign Language Course Module 1: Introduction to BSL Module 2: Fingerspelling Module 3: Basic Vocabulary and Phrases Module 4: Numbers Module 5: Family and Relationships Module 6: Colours, Animals, and Food Module 7: Advanced Vocabulary Module 8: Grammar and Syntax Module 9: Conversational Skills Module 10: Deaf Culture Module 11: Storytelling and Narration Module 12: Poetry and Literature Module 13: Regional Variations Module 14: Interpreting Module 15: Legal and Medical Sign Language Course Curriculum of Interpreter: Interpreter Course Module 01: Introduction to Interpreting Module 02: Language Skills Mastery Module 03: Interpreting Techniques and Modes Module 04: Cultural Competence and Sensitivity Module 05: Specialized Interpreting Skills Module 06: Technology in Interpreting Module 07: Professional Development and Ethics Who is this course for? Interpreter Online Training Professionals, students, career changers, and beginners in interpreting can all benefit from this interpreter course. Career path Interpreter Online Training Following your completion of the interpreter course, you might choose to work as an educator, researcher, or interpreter specialist.

British Sign Language (BSL) with Interpreter Level 3
Delivered Online On Demand8 hours
£12

Environmental Engineering Level 7

By Training Tale

Environmental Engineering: Environmental Engineering Online Training Can you think of our planet being powered by all-natural elements? Enrol in our Level 7 Environmental Engineering Diploma course right away if you're curious to learn more! The Level 7 Environmental Engineering Diploma offers a high-level education in advanced environmental engineering concepts. This Level 7 Environmental Engineering Diploma covers water quality management and air quality management. Moreover, the Level 7 Environmental Engineering Diploma describes waste treatment and sustainable solutions. This Level 7 Environmental Engineering Diploma equips students with practical skills and knowledge of complex environmental challenges. Enrol our Environmental Engineering: Environmental Engineering Diploma to contribute to sustainable engineering practices and environmental preservation! Course Included Main Course: Level 7 Environmental Engineering GIFT Courses included with Level 7 Environmental Engineering course Course 01: Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course 02: Asbestos Awareness Special Offers of this Environmental Engineering Course This Environmental Engineering Course includes a FREE PDF Certificate. Lifetime access to this Environmental Engineering Course Instant access to this Environmental Engineering Course Get FREE Tutor Support from Monday to Friday in this Environmental Engineering Course Other Benefits Include this Environmental Engineering Course Bundle. Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Environmental Engineering: Environmental Engineering course] Environmental Engineering: Environmental Engineering Online Training Industry Specialists developed this Environmental Engineering Course into 20 user-friendly modules. Module 1: Introduction to Environmental Engineering Module 2: Design Tools for Environmental Engineers Module 3: Environmental Science Module 4: Environmental Hydrology Module 5: Engineering Mechanics Module 6: Fluid Mechanics Module 7: Heat Transfer Module 8: Mass Transfer Module 9: Environmental Chemistry Module 10: Environmental Microbiology Module 11: Environmental Impact Assessment Module 12: Water Treatment Module 13: Wastewater Treatment Module 14: Air Pollution Control Module 15: Soil and Groundwater Remediation Module 16: Environmental Law in the UK Module 17: Environmental Policy Module 18: Environmental Economics Module 19: Environmental Modeling and Simulation Module 20: Emerging Technologies in Environmental Engineering Assessment Method of Environmental Engineering After completing each module of the Environmental Engineering: Environmental Engineering Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Environmental Engineering After completing the MCQ/Assignment assessment for this Environmental Engineering: Environmental Engineering course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Environmental Engineering: Environmental Engineering Online This Environmental Engineering: Environmental Engineering Diploma course is open to interested parties who wish to work in environmental engineering or renewable energy. Requirements Environmental Engineering: Environmental Engineering Online There are no specific requirements for this Environmental Engineering: Environmental Engineering course because it does not require any advanced knowledge or skills. Career path Environmental Engineering: Environmental Engineering Online This Environmental Engineering: Environmental Engineering Diploma course will open job doors in the sectors of: Renewable Energy Engineer Environmental Consultant Energy Analyst And many more! Certificates Digital Certificate Digital certificate - Included

Environmental Engineering Level 7
Delivered Online On Demand18 hours
£12

Leadership Management & Supervision for Team Leader - Level 7

By Training Tale

Leadership Management: Leadership Management & Supervision for Team Leader Online Training This Leadership Management: Leadership Management will help you advance your career by providing you with the most up-to-date leadership and management information. The Leadership Management: Leadership Management course requires no prior knowledge or experience, as candidates are introduced to the characteristics and qualities of an effective leader. Unlock your leadership potential with our transformative Leadership & Management course. Gain essential skills for effective Leadership Management: leadership management in today's dynamic business world. Elevate your career with our comprehensive program. Enroll now and master the art of Leadership Management: leadership management for unparalleled success. Leadership Management: Leadership Management: Empower your future! Special Offers of this Leadership Management Course This Leadership Management Course includes a FREE PDF Certificate. Lifetime access to this Leadership Management Course Instant access to this Leadership Management: Leadership Management Course Get FREE Tutor Support from Monday to Friday in this Leadership Management: Leadership Management Course Courses are included in Leadership Management: Leadership Management Course Course 01: Level 7 Leadership and Management Course 02: Level 7 Project Management Course 03: Level 7 Business Management Course 04: Level 7 Operations Management Course 05: Level 7 Life Coaching [ Note: Free PDF certificate as soon as completing the Leadership Management: Leadership Management & Supervision for Team Leader Course] Leadership Management: Leadership Management & Supervision for Team Leader Online Training Training Industry Experts Designed this Leadership Management: Leadership Management course into 10 detailed modules. Course Curriculum of Leadership & Management level 7 Course: Module 1: Understanding Management and Leadership Module 2: Leadership over Yourself Module 3: Creativity and Innovation Module 4: Leadership and Teambuilding Module 5: Motivation and People Management Module 6: Communication and Leadership Module 7: Presentation, One-to-one Interview and Meeting Management Module 8: Talent Management Module 9: Strategic Leadership Module 10: Stress Management Assessment Method of Leadership Management After completing each module of the Leadership Management: Leadership Management you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification Method of Leadership Management After completing the MCQ/Assignment assessment for this Leadership Management: Leadership Management course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Leadership Management: Leadership Management This Leadership Management Course is for anyone serious about their professional development. This Leadership Management course is designed primarily for group leaders, managers at all levels, and business professionals. Students and recent graduates who want to improve their resumes and gain experience are also welcome to enrol in this Leadership Management: Leadership Management Course. Requirements Leadership Management: Leadership Management Students who intend to enrol in this Leadership Management: Leadership Management Course must meet the following requirements: Leadership Management: Good command of the English language Leadership Management: Must be vivacious and self-driven Leadership Management: Minimum Basic computer knowledge Leadership Management: A minimum of 16 years of age is required Career path Leadership Management: Leadership Management & Supervision for Team Leader Training Level 7 Leadership & Management: Leadership Management Operations Manager Project Manager Team Leader Business Development Manager Certificates Certificate of completion Digital certificate - Included

Leadership Management & Supervision for Team Leader - Level 7
Delivered Online On Demand42 hours
£12

Food Safety and Hygiene for Catering

By Training Tale

Food Safety and Hygiene for Catering Online Training Anyone who works in catering or hospitality must be aware of the latest food hygiene standards. All food handlers are required by law to understand food hygiene principles and know how to work safely to protect the food they serve from contamination. Our Food Safety and Hygiene for Catering course covers the most important aspects of food hygiene and safety at all stages of food handling, so you can minimize safety hazards and ensure that the food you work with remains safe. You will also learn about the legal responsibilities of working with food and how to stay on the right side of the law. >> Courses you will GET Course 01: Food Safety and Hygiene for Catering Course 02: Level 2 HACCP Training for Catering and Retail Course 03: Level 2 Food Hygiene and Safety Course 04: Level 3 Supervising Food Safety in Catering [ Note: Free PDF certificate as soon as completing the Food Safety in Catering course ] Food Safety and Hygiene for Catering Training Course Curriculum of Food Safety and Hygiene for Catering Module 01: An Overview of Food Hygiene and Safety Module 02: Legislation Related to Food Safety Module 03: Microbiological Hazards Module 04: Other Types of Hazards Module 05: Food Storage Process Module 06: Preparing Food Module 07: Personal Hygiene Module 08: Food Premises Design, Layout, Size and Suitability Module 09: Food Premises Cleaning and Disinfection Assessment Method of Food Safety and Hygiene for Catering After completing each module of the Food Safety and Hygiene for Catering, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Food Safety and Hygiene for Catering After completing the MCQ/Assignment assessment for this Food Safety and Hygiene for Catering course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Food Safety and Hygiene for Catering This Food Hygiene and Safety for Catering course is designed for anyone within the hospitality or catering sectors, whether self-employed or employed and at any stage of their career. Special Note: Our Course is not a regulated course. If You want to get qualified, you can consider following options: Level 1 Award in Food Safety in Catering (RQF) Level 2 Award in Food Safety for Catering (RQF) Level 2 Award in Food Safety for Retail (RQF) Level 2 Award in Food Safety in Manufacturing (RQF) Level 3 Award in Food Safety for Catering (RQF) Level 3 Award in Food Safety for Retail (RQF) Level 3 Award in HACCP for Catering (RQF) Level 3 Award in Food Safety for Manufacturing (RQF) Level 4 Award in Food Safety Management for Catering(RQF) Level 4 Award in Food Safety Management for Catering(RQF) Requirements Food Safety and Hygiene for Catering Online Training There are no specific requirements for this Food Safety and Hygiene for Catering course because it does not require any advanced knowledge or skills. Career path This Food Safety and Hygiene for Catering Course will prepare you for a variety of career opportunities; here are a few examples: Restaurant Manager Salary: £28,000 - £32,000 per year Hunstanton Head Chef: £31,800 per year £8.98 per hour plus benefits as a kitchen assistant £12.00 - £15.00 per hour for a cook £10.00 - £12.00 per hour for a chef £9.75 per hour for an assistant nursery cook Certificates Certificate of completion Digital certificate - Included

Food Safety and Hygiene for Catering
Delivered Online On Demand28 hours
£12

Childcare and Education Course - Online

By Training Tale

Childcare and Education Course - Online The Childcare and Education Course teaches learners a wide range of essential knowledge required when working with children. This childcare course covers many aspects of a child's health and development during the Early Years and the role of an Early Years Educator during this crucial stage in life. You will also study young children's physical, emotional, and nutritional needs and their exercise requirements. In the Childcare and Education Course, you will learn important information that will help you whether you already work in a child care setting or hope to. Learning Outcomes After completing the Childcare and Education Course - Online, the learner will be able to: Understand Child Development from Conception to Seven Years. Understand Children's Health and Wellbeing. Main Course: Childcare and Education Course - Online Free Courses Course 01: Speech Therapy Course 02: Paediatric First Aid [ Note: Free PDF certificate as soon as completing the Childcare and Education Course - Online] Childcare and Education Course - Online Industry Experts Designed this Childcare and Education Course - Online course into 2 detailed modules. Course Curriculum of Childcare and Education Course Module 1: Child Development from Conception to Seven Years Understand Development from Conception to Birth and Routine Screening Programmes in the First Year of Life Understand Stages and Sequences of Development from Birth to Seven Years. Understand Theory and Educational Frameworks Which Inform Knowledge and Understanding of Early Years Practice Understand the Role of the Early Years Practitioner When Promoting Child Development from Birth to Seven Years Understand How to Plan Opportunities for Children's Learning and Development from Birth to Five years Module 2: Children's Health and Wellbeing Understand Children's Needs in Relation to Emotional Wellbeing Understand the Needs of Children During Transition and Significant Events Understand the Physical Care Needs of Children Understand the Impact of the Early Years Environment on the Health and Well-being of Children Understand the Nutritional Needs of Children Understand the Impact of Poor Diet on Children's Health and Well-being Understand Children's Need for Exercise Assessment Method of Childcare and Education Course - Online After completing each module of the Childcare and Education Course - Online Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Childcare and Education Course - Online After completing the MCQ/Assignment assessment for this Childcare and Education Course - Online Training course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Childcare and Education Course - Online This Childcare and Education Course - Online Training Course is suitable for Learners who can progress into a variety of unsupervised job roles in the public, voluntary, or private sectors, such as Early Years Educator Practitioner in day nurseries Practitioner in nursery schools Practitioner in reception classes in primary schools Pre-school worker Home-based Childcarer Nanny Requirements Childcare and Education Course - Online Students who intend to enrol in Childcare and Education Course course must meet the following requirements: Childcare: Good command of the English language Childcare: Must be vivacious and self-driven Childcare: Basic computer knowledge Childcare: A minimum of 16 years of age is required Career path Childcare and Education Course - Online Certificates Certificate of completion Digital certificate - Included

Childcare and Education Course - Online
Delivered Online On Demand32 hours
£12

Store Assistant Training Course

By One Education

Step into the fast-paced world of retail with confidence through our expertly designed Store Assistant Training Course. This online programme is tailored to sharpen your skills in customer service, stock control, sales processes, and day-to-day store operations. Whether you’re new to retail or looking to improve your understanding of the shop floor, this course delivers clear and structured knowledge you can apply in a wide range of retail settings. From managing product displays to supporting store targets, every module has been created to reflect what’s expected from a reliable store assistant. You’ll gain insight into customer expectations, retail etiquette, and the finer details that help keep a store running smoothly. Learn how to work efficiently as part of a team, handle common retail challenges, and keep customers smiling. If you’re aiming for a career in retail or simply want to know what it takes to be the backbone of a successful store, this course is your ideal guide. Enrol right now. Learning Outcomes An introduction to shop management basics. Be familiar with the duties and obligations that a retail assistant has. Understand shop psychology and retail management. Learn how to interact with suppliers and consumers. Research the retail-related laws. Study consumer behaviour and visual merchandising. Dedicated tutor support and 24/7 customer support are available to all students with this premium quality Store Assistant training. This premium online training ensures your professional development with CPD QS accreditation. You'll have the privilege of learning in your own time, at your own pace and earning an accredited certificate. Key Benefits Eligibility for CPD QS -accredited certificates on successful completion Learning materials contain engaging audio-visual elements for your comfort Freedom to study at your own pace 24/7 access to the materials for 12 months Full Tutor support on weekdays (Monday - Friday) Key Features CPD Accredited Quality License Endorsed Certificate Available Upon Course Completion This online training has been designed by industry experts and will give you an in-depth understanding of this topic. The certificate you'll achieve after completing the Store Assistant bundle will help you land the job you want in a related field. Exam and Assessment MCQ based test 60% Marks to pass Instant Assessment and Feedback Certification CPD Certified PDF and Hardcopy Certificate Level 3 QLS Endorsed Hardcopy Certificate for Certificate in Store Manager at QLS Level 3 CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Store Assistant bundle is ideal for highly motivated individuals who want to enhance their professional skills and train for the job they want! Requirements There are no formal entry requirements for the Store Assistant bundle, with enrollment open to anyone! Anyone and everyone with a knack for learning can enrol on this course without hesitation. Career path People can pursue the following professions in this sector Assistant Store Keeper Store Assistant Sales Assistant Store Keeper Assistant Manager Executive The average store assistant salary in the United Kingdom is £25,019 per year or £11.29 per hour. Entry-level positions start at £20,703 per year. Certificates Certificate of completion Digital certificate - £9 Certificate of completion Hard copy certificate - £79 QLS Endorsed Certificate Hardcopy of this certificate of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying - Within the UK: £79 International: £79 + £10 (postal charge) = £89 CPD Accredited Certification Hardcopy Certificate (within the UK): £15 Hardcopy Certificate (international): £15 + £10 (postal charge) = £25

Store Assistant Training Course
Delivered Online On Demand7 days
£12

Accident Reporting - CPD Approved

5.0(172)

By Comply Sense

This CPD Approved course will teach the learner how to fill in accident reports and cover RIDDOR Reporting. Take this HSE compliant course to help you get through Standards Audits and help identify the needs for reporting with our online training course for accident reporting.

Accident Reporting - CPD Approved
Delivered Online On Demand15 minutes
£10

Nursing Training Course

By Training Tale

Nursing Online Training If you want to learn about Nursing and become an expert in the field, you have arrived at the right place. Industry experts designed this Nursing course to enable you to learn quickly and efficiently and at your own pace and convenience. Enrol Nursing course today and take the next step towards your personal and professional goals. Courses : Nursing Assistant Diploma Forensic Nursing Nursing & Prescribing Nursing Online In this Nursing course, you will learn about nursing, the legal standards and professional aspects of nursing, working in various healthcare settings. By completing this Nursing course, You will also learn the legal and ethical aspects of prescribing, public health principles, medication management, and fundamental principles of pharmacology. The course also covers the duties and responsibilities of a midwife, maternity care assistant, paramedic practitioner, birth doula, and physiotherapist. Assessment Method of Nursing After completing each module of the Nursing Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Nursing After completing the MCQ/Assignment assessment for this Nursing UK course, you will be entitled to a Certificate of Completion from Training Tale which is completely free to download. Who is this course for? Nursing Online This Nursing UK course is ideal for anyone who enjoys learning new skills. Requirements Nursing Training There are no specific requirements for this Nursing course. Career path Nursing Online Training

Nursing Training Course
Delivered Online On Demand15 hours
£12

Power Query and Power Pivot in Microsoft Excel: A Quickstart Guide

By Ideas Into Action

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  

Power Query and Power Pivot in Microsoft Excel: 
A Quickstart Guide
Delivered Online On Demand
£9.99