27966 Development courses in Nottingham delivered Online

Do you know that there are languages that are not spoken but rather it can only see? Have you heard about the concept of body language? If not, then you must know that if you are able to read and respond to body language and other expressions on an advanced level, you can predict almost anything. So if you're interested in this, then this course is for you! Description: One of the very important indicators of our mental state can be accessed through our body language which is the way we use different parts of our bodies when we are in public. There are already experts who have concluded that we can actually read people's minds just by looking at their bodies and this activity is known as body language reading. All of us uses Body language, however, only a few of us know the importance of it We should keep in mind that the skill of body language reading can help us to improve our personalities if we use it effectively and it can also help us in so many other areas of our lives. Through body language, we can communicate better and we can become better speakers. In this course, you will be taught with what you need to learn about body language. Who is the course for? Professionals who work in the communications industry or part of the communications and human resources department. People who are interested in learning more about communication through body language to decipher people who have a hard time in communication and expressing. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be ages 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 a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hard copy 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: This Body Language Course is a useful qualification to possess, and would be beneficial for the following careers: Body Language Trainer Counsellors Teachers Psychologists Psychotherapists And Other Kinds of Therapists and Communication Specialists. Body Language Course What Is Body Language 00:15:00 How to Read Body Language 00:30:00 How to Read People's Minds 00:30:00 How To Understand Eyes Contact 00:15:00 The Role of Head and Face in Body Language 00:30:00 The Role of Neck, Chest and Back in Body Language 00:15:00 The Role of Hands and Arms in Body Language 00:30:00 The Role of Legs in Body Language 00:15:00 The Role of the Lips in Body Language 00:15:00 Tips to Improve Body Language 00:15:00 Wrapping Up 00:15:00 Mock Exam Mock Exam- Body Language Course 00:20:00 Final Exam Final Exam- Body Language Course 00:20:00

Let's face it, without a decent plumbing system in place there's a whole bunch of things that we would never be able to take advantage of. This includes hot showers, water based cleaning, heating systems and most importantly a working sanitation system. Taking these for granted is very common but if you want to learn about plumbing then this Plumbing Skills Training Course course can help you. This course is designed to help you learn about the basics of plumbing and as such starts out by teaching you about things such as plumbing code, licensing and where and how to shut off water. Following this you also learn about hydraulic principles as you look into water pressure, hydraulics, vacuums, Pascal's law and more. Next you further learn about plumbing fittings such as plastic & pipe fittings, solvent cementing and other types of joints and unions. This course will also teach you about plumbing repairs of worn out faucets, ball type faucets, water closets and more, before finally moving onto drains & vents. With the help of this course you can very easily expand your knowledge on plumbing systems and take care of various problems around the house. So the question that remains is why are you still waiting? Who is the course for? People interested in learning about plumbing for general DIY Professionals looking to expand their knowledge on plumbing systems 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 hardcopy 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: Plumbing Skills Training Course course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Plumbers DIY enthusiast Contractors Pipefitters Construction workers Plumbing Skills Training Basic Plumbing 00:30:00 Hydraulic Principles 01:00:00 Plumbing Fittings 01:00:00 Plumbing Repairs 02:00:00 Drains & Vents 01:00:00 Bathroom Plumbing Plumbing Safety Basics 00:15:00 Basic Types of Plumbing Pipes 00:15:00 Parts of a Toilet 00:15:00 Bathroom Plumbing Basics 00:15:00 Rerouting Bathroom Sink Plumbing 00:15:00 Vent Bathroom Plumbing 00:15:00 Combining Toilet & Sink Drains 00:15:00 Installing Offset Drain Pipes for Bathroom Sinks 00:15:00 When the Sink Opening Doesn't Align With the Drain 00:15:00 Plumbing a Bathroom Vanity Sink Drain 00:15:00 Preventing Pipe Freezing by Insulation 00:15:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Plumbing Skills Training Course 00:20:00 Final Exam Final Exam- Plumbing Skills Training Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description: Want to improve your cash flow? or want to forecast your sales? Join the Flow Management and Forecasting course and learn to manage your flow and know how to reduce debt for improving your cash flow. The course is devoted to cashflow management. At first, you will learn the necessary concepts about forecasting. Next, the course explains cash flow, cash flow planning and management, dealing with the debt problem, improvements to the cash flow, cash flow problems, managing personal cash flow, and more. You will learn how to reduce your debt to improve the cash flow situation. The course shows you which cash flows on you. Finally, you will learn to amalgamate the superior knowledge in forecasting sales and to manage your flow. Upon completion, you will be able to manage your finances better. Who is the course for? Business owners, students of accountancy/ finance/bookkeeping, budding finance directors and management accountants Individuals who want to manage their personal cashflows better 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 completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. 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 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: After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction to the course Introduction FREE 00:03:00 Forecasting Forecasting 00:07:00 Cashflow Management What is Cashflow? 00:05:00 Planning and Management 00:08:00 Planning Part 2 00:12:00 Where it can go Wrong 00:09:00 Personal Cashflow Analysis 00:05:00 Personal Cashflow Analysis my Numbers Story 00:06:00 Debt 00:10:00 Concluding lecture Conclusion 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Work life balance is the ability to know how to prioritize and do things effectively to avoid stress. Learning how to avoid stress caused by unbalanced lifestyle will benefit both yourself and the company. If you want to know more about work life balance, then this is your chance to learn. Keep in mind that having the right skills and knowledge on work life balance will help you become happier, healthier, and more productive. Who is the course for? Professionals and Trainers who want to be expert in life balancing. Anyone who wants to know to manage their life and work balance. 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 Diploma in Work Life Balance course is a useful qualification to possess and would be beneficial for the following careers: Businessmen Entrepreneur General Manager Management Director Top Executive. Introduction to Work Life Balance WHAT IS A BALANCED LIFE? 00:30:00 HOW TO BALANCE LIFE AND WORK 00:30:00 HOW WOULD BALANCE WORK FOR YOU 00:30:00 FINDING TIME IN YOUR BUSY SCHEDULE 00:30:00 DOES YOUR LIFE FEEL LIKE RUNNING A MARATHON? 00:15:00 Balancing Work Life Module One - Getting Started 00:30:00 Module Two - Benefits of a Healthy Balance 01:00:00 Module Three - Signs of an Imbalance 01:00:00 Module Four - Employer Resources 00:30:00 Module Five - Tips in Time Management 00:30:00 Module Six - Goal Setting 00:30:00 Module Seven - Optional Ways to Work 01:00:00 Module Eight - At Work 01:00:00 Module Nine - At Home 01:00:00 Module Ten - Stress Management 01:00:00 Module Eleven - Working in a Home Office 01:00:00 Module Twelve - Wrapping Up 01:00:00 Level 2 Certificate in Balancing Work-Life- Activities 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

In this course, we'll learn how to visualize data with real weather data downloaded from the US National Weather Service using the R programming language and RStudio. We recommend that you have some background in HTML, CSS, and JavaScript. You don't need to be an expert by any means, but you should have experience building web pages with HTML and CSS, and you should have basic programming skills with JavaScript.

Overview of HTML and CSS Coding for Beginners Join our HTML and CSS Coding for Beginners 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 HTML and CSS Coding for Beginners course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The HTML and CSS Coding for Beginners 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 HTML and CSS Coding for Beginners 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 HTML and CSS Coding for Beginners. 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 HTML and CSS Coding for Beginners 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 HTML and CSS Coding for Beginners 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 HTML and CSS Coding for Beginners 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 HTML and CSS Coding for Beginners 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 Section 01: Introduction 1.1: Introduction 00:03:00 1.2: Course Curriculum 00:02:00 1.3: How to Get Pre-Requisites 00:03:00 1.4: Getting Started on Windows, Linux or macOS 00:02:00 1.5: Code Editor- Setting Up (SublimeText) 00:02:00 1.6: How to Ask Great Questions 00:02:00 Section 02: Let's learn HTML 2.1: HTML overview 00:04:00 2.2: Basic HTML structure 00:13:00 2.3: H1 to H6 - heading tags 00:06:00 2.4: Paragraph tags 00:05:00 2.5: Creating a line break 00:03:00 2.6: Adding a link 00:05:00 2.7: Adding an image 00:08:00 2.8: Creating an image with a link 00:04:00 2.9: Nav tags 00:05:00 2.10: Using the div tag 00:04:00 2.11: Creating unordered and ordered lists 00:05:00 2.12: Forms 00:09:00 2.13: Tables 00:05:00 2.14: Creating comments in HTML 00:03:00 2.15: Colors 00:07:00 2.16: Review HTML elements 00:04:00 2.17: Assessment Test 00:01:00 2.18: Solution for Assessment Test 00:01:00 Section 03: Let's learn CSS 3.1: CSS overview 00:03:00 3.2: CSS syntax 00:02:00 3.3: Background colour 00:08:00 3.4: Creating an ID 00:10:00 3.5: Creating classes 00:05:00 3.6: Creating a border 00:04:00 3.7: Border radius 00:10:00 3.8: Padding 00:06:00 3.9: Margin 00:02:00 3.10: Font size 00:04:00 3.11: Font weight 00:05:00 3.12: Text transform 00:05:00 3.13: Text colour 00:00:00 3.14: Aligning the text 00:04:00 3.15: Font family 00:06:00 3.16: Font style 00:03:00 3.17: CSS comments 00:02:00 Section 04: Final Project 4.1: Project overview 00:03:00 4.2: Conclusion on Project 00:01:00 Section 05: BONUS 5.1: Linking a CSS style common code to your HTML document 00:06:00 5.2: Applying the CSS hover selection to animate website button effects 00:04:00

Report Writing: Report Writing Are you a prospective candidate seeking to maximise your expertise and abilities in the Report Writing: Report Writing area? This Report Writing: Report Writing course is created for you. So that You can receive the tools you need to produce polished and useful business reports from our Report Writing: Report Writing course. Our report writing: Report Writing course is designed to give students important information on managerial, leadership, and business-related skills. Moreover, team management, organisational techniques, and management are discussed in our Report Writing: Report Writing course. Also, you will learn the importance of grammar, punctuation, and formatting in the Report Writing: Report Writing course. A strategy for developing one's writing style will be provided by Report Writing: Report Writing training. You will know the best methods for editing and proofreading your work as well as how to write clearly and simply via the Report Writing: Report Writing. Enrol right away to develop your confidence in completing the projects that will put your knowledge in Report Writing: Report Writing Methods to the test. Main Course: Level 5 Report Writing Course 2 Free Courses included with this Report Writing: Report Writing Course. Special Offers of this Report Writing: Report Writing Course This Report Writing: Report Writing Course includes a FREE PDF Certificate. Lifetime access to this Report Writing: Report Writing Course Instant access to this Report Writing: Report Writing Course Get FREE Tutor Support to this Report Writing: Report Writing Course Report Writing: Report Writing Throughout this Report Writing: Report Writing Course, you will learn goal settings, interpersonal skills, knowledge management, communication strategies, business writing, collaborative business writing, proposal writing and critical thinking. This Report Writing: Report Writing Course also covers principles for effective report writing, desktop publishing, layout and design, typography, illustrations and much more. Who is this course for? Report Writing: Report Writing This Report Writing: Report Writing course is intended for people who wish to advance their Report Writing abilities in order to succeed professionally. Requirements Report Writing: Report Writing To enrol in this Report Writing: Report Writing Course, students must fulfil the following requirements. To join in our Report Writing: Report Writing Training Course, you must have a strong command of the English language. To successfully complete our Report Writing: Report Writing Training Course, you must be vivacious and self driven. To complete our Report Writing: Report Writing Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Report Writing: Report Writing Training Course. Career path Report Writing: Report Writing After completing this Report Writing: Report Writing Course Online your professional life will be boosted significantly.

Course Overview Leading a team towards a specific goal can be challenging as each individual has different views and abilities. Learn how to synchronise your team members' different skills and ideas and lead them to the goal with our exclusive Online Leadership Skills Training. This course is the ultimate guide for those who aspire to be great leaders. In this comprehensive course, you will get the chance to learn a wide range of skills and knowledge. The step-by-step course will introduce you to the process of goal setting. Here, you will receive detailed lessons on project management, risk management and performance management. In addition, the course will also teach you the techniques of team building and effective communication for successful leadership.  By the end of the course, you will become skilled in inspiring your team and getting the most out of the skills. The course will also provide a CPD-accredited certificate, which will prove your abilities to lead and boost your career.  Join now and complete your Online Leadership Skills Training! Course Preview Learning Outcomes Familiarise yourself with the basic principles of leadership Understand what steps to follow for setting goals and managing time effectively Learn the skills required to establish effective communication with the team members Build the expertise required for project management and risk management Explore the vital areas of managing performance Understand the techniques to motivate the team and inspire them to work together. Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials 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. What Skills will You Learn from This Course? Communication Problem-Solving Delegation Motivation Team Building Conflict Management Who Should Take this Online Leadership Skills Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Online Leadership Skills Training 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. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Online Leadership Skills Training course will equip you with effective skills and abilities and help you explore career paths such as  Manager Supervisor Risk Manager Project Manager Module 01: Introduction To Leadership Introduction to Leadership 00:47:00 Module 02: Inspiration And Leadership Inspiration and Leadership 00:33:00 Module 03: Setting Goals And Time Management Setting Goals and Time Management 01:13:00 Module 04: Body Language And Effective Communication Body Language and Effective Communication 01:05:00 Module 05: Self-Esteem And Assertiveness Skills Self Esteem and Assertiveness Skills 01:03:00 Module 06: Business Management And Corporate Behaviour Business Management Corporate Behaviour 01:01:00 Module 07: Meeting Management Meeting Management 01:20:00 Module 08: Project Management Project Management 01:15:00 Module 09: Risk Management Risk Management 00:28:00 Module 10: Team Work And Team Building Performance Management11 01:04:00 Module 11: Performance Management Team Work Team Building 00:53:00 Module 12: Critical Thinking: Implications For Leadership Critical Thinking Implications for Leadership 00:58:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on LOLER Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This LOLER Training comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this LOLER Training. It is available to all students, of all academic backgrounds. Requirements Our LOLER Training is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 9 lectures • 04:42:00 total length •Introduction to LOLER: 00:20:00 •Part 01 - Selecting Lifting Equipment and Accessories: 01:00:00 •Part 02 - Selecting Lifting Equipment and Accessories: 00:42:00 •Planning the Lifting Operation: 00:41:00 •Factors Affecting Safe Lifting Operation: 00:24:00 •Roles and Responsibilities: 00:16:00 •Risk Assessment: 00:28:00 •Examination and Inspection: 00:34:00 •Reports and Defects: 00:17:00

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