1152 Accountant courses in Cardiff delivered On Demand

A Diploma in Conveyancing is vital in the modern world, offering specialized knowledge in property law and risk management. This course, encompassing modules such as Property Law & Conveyancing Practice, Law of Contract, and Taxation Issues for Conveyancers, equips learners with comprehensive skills crucial for effective risk management in real estate transactions. Mastery in preparing legal documents and understanding accounting procedures is essential for ensuring compliance and mitigating potential risks. The importance of risk management cannot be overstated, especially with frequent updates from the Land Registry and evolving laws that impact standard conveyancing transactions. In the UK, professionals with expertise in conveyancing and risk management are in high demand, with job opportunities ranging from conveyancers to legal advisors. Salaries for conveyancers in the UK average around £25,000 to £45,000 annually, reflecting the value of skilled risk management. The conveyancing sector is on the rise, with an estimated growth of 10-15% over recent years. This upward trend underscores the increasing need for proficiency in risk management, making this diploma a strategic investment for career advancement in the property law sector. Key Features: CPD Certified Diploma in Conveyancing Course Free Certificate Developed by Specialist Lifetime Access Course Curriculum: Module 01: Introduction To Conveyancing Module 02: Key Conveyancing Fundamentals Module 03: Property Law & Conveyancing Practice Module 04: Land Registry Updates And Law Module 05: Law Of Contract Module 06: Landlord And Tenant Module 07: Standard Conveyancing Transactions Module 08: Understanding Accounting Procedures For Conveyancing Transactions Module 09: Preparing Legal Documents Module 10: Taxation Issues For Conveyancers Learning Outcomes: Understand conveyancing procedures and key legal principles in property transactions. Apply property law knowledge to ensure compliance with conveyancing practices. Analyze Land Registry updates and law for accurate conveyancing transactions. Demonstrate proficiency in drafting and preparing legal documents for conveyancing. Identify taxation issues relevant to conveyancing transactions in the UK. Execute standard conveyancing transactions while adhering to accounting procedures. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Diploma on Conveyancing course is accessible to anyone eager to learn more about this topic. Through this Conveyancing course, you'll gain a solid understanding of Diploma on Conveyancing. Moreover, this course is ideal for: Aspiring conveyancers seeking comprehensive legal knowledge in property transactions. Law students aiming to specialize in conveyancing practice and procedures. Real estate professionals looking to expand their expertise into conveyancing. Individuals interested in pursuing a career in property law and transactions. Accountants or financial professionals seeking specialization in conveyancing transactions. Requirements There are no requirements needed to enrol into this Diploma on Conveyancing course. We welcome individuals from all backgrounds and levels of experience to enrol into this Diploma on Conveyancing course. Career path After finishing this Diploma on Conveyancing course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Diploma on Conveyancing are: Conveyancer - £25K to 50K/year. Property Lawyer - £30K to 60K/year. Legal Executive - £20K to 40K/year. Land Registry Officer - £20K to 35K/year. Estate Agent - £18K to 40K/year. Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Whether you're an aspiring finance professional, a small business owner, or just someone who wants to understand the financial health of your investments, our Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting Course is your gateway to mastering the language of business! According to Reed a Financial Analyst can earn from £45,000 to £50,000 in a year depending on qualification, experience, location and other factors. So enrol into our Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting course for learning everything that you need to in order to thrive in this competitive market Key Features: CPD Certified Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting course Developed by Specialist Lifetime Access Course Curriculum of Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting: Module 01: Overview of Financial Analysis Module 02: Challenges in Evaluating Financial Assets and Balancing Sheets Module 03: Comprehensive Insight into the Income Statement Module 04: Unravelling the Cash Flow Statement Module 05: Financial Reporting Fundamentals Module 06: Exploration of Profitability Concepts Module 07: EBITDA - Earnings Before Interest, Taxes, Depreciation, and Amortisation Module 08: In-Depth Analysis of Credit Module 09: Essential Insights into Equity Analysis Module 10: Analysing Financial Ratios Learning Outcomes: Evaluate financial assets using balance sheets for informed decision-making. Analyse income statements for a comprehensive understanding of financial performance. Interpret cash flow statements to assess liquidity and financial stability. Demonstrate proficiency in financial analysis, reporting fundamentals and disclosure requirements. Apply profitability concepts and EBITDA analysis in financial assessment. Utilise financial ratios for in-depth analysis and benchmarking purposes. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting. Moreover, this course is ideal for: Professionals in finance seeking advanced financial analysis skills. Business students aiming to enhance financial statement comprehension. Accountants looking to deepen their understanding of financial analysis and reporting. Investors interested in making informed investment decisions based on financial analysis. Individuals involved in credit analysis or equity evaluation roles. Requirements There are no requirements needed to enrol into this Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reportingcourse. We welcome individuals from all backgrounds and levels of experience to enrol into this Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting course. Career path After finishing this Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting course you will have multiple job opportunities for you. Some of the Job sectors of Financial Analysis, Income Statement, Cash Flow, Balance Sheet & Financial Reporting are: Financial Analyst Credit Analyst Equity Research Analyst Investment Manager Corporate Treasurer Financial Consultant Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Overview of Estate Management Join our Estate Management 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 Estate Management course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Estate Management 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 Estate Management 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 Estate Management. 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 Estate Management 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 Estate Management 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 Estate Management 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 Estate Management 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 Estate Management Property Management Module 1 - Introduction to Property Management 00:12:00 Module 2 - The Role and Responsibilities of a Property Manager 00:11:00 Module 3 - Listing Properties and Marketing 00:25:00 Module 4 - The Letting Process and Tenancy Agreement 00:26:00 Module 5 - The Property Management Process 00:32:00 Module 6 - Keeping Tenants Long Term 00:10:00 Module 7 - Regulations of Property Management 00:11:00 Module 8 - Changes in the UK Property Market: An Opportunity 00:13:00 Property Law and Taxation Module 01: The Property Law and Practice 00:23:00 Module 02: Ownership and Possession of the Property 00:16:00 Module 03: Co-Ownership in Property 00:17:00 Module 04: Property Taxation on Capital Gains 00:16:00 Module 05: VAT on Property Taxation 00:11:00 Module 06: Property Taxation Tips for Accountants and Lawyers 00:16:00 Module 07: Changes in the UK Property Market 00:14:00

Operation Management Diploma is one of our best selling and most popular course. The Operation Management Diploma is organised into 7 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students.  If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why Choose this Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of- Video lessons Online study supplies Mock exams Multiple-choice assessment Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? This Operation Management Diploma Course is perfect for any individual who is just starting to work with company finances in the administration or accounting department of a large firm, or any type of organisation. It may also be used as a refresher course for existing accountants, or those that may need to use a trusted form of financial management.

Unlock the complexities of Property Law and Taxation with our comprehensive training program. Dive into essential legal principles governing real estate while mastering the intricacies of taxation. Equip yourself with the knowledge to navigate property transactions seamlessly and optimize financial outcomes. Join our expert-led training to enhance your expertise in this dynamic field.

Are you looking to enhance your Property Taxation on Capital Gains skills? If yes, then you have come to the right place. Our comprehensive course on Property Taxation on Capital Gains will assist you in producing the best possible outcome by mastering the Property Taxation on Capital Gains skills. The Property Taxation on Capital Gains course is for those who want to be successful. In the Property Taxation on Capital Gains course, you will learn the essential knowledge needed to become well versed in Property Taxation on Capital Gains. Why would you choose the Property Taxation on Capital Gains course from Compliance Central: Lifetime access to Property Taxation on Capital Gains course materials Full tutor support is available from Monday to Friday with the Property Taxation on Capital Gains course Learn Property Taxation on Capital Gains skills at your own pace from the comfort of your home Gain a complete understanding of Property Taxation on Capital Gains course Accessible, informative Property Taxation on Capital Gains learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Property Taxation on Capital Gains Curriculum Breakdown of the Property Taxation on Capital Gains Course Module 01: The Property Law and Practice Module 02: Ownership and Possession of the Property Module 03: Co-Ownership in Property Module 04: Property Taxation on Capital Gains Module 05: VAT on Property Taxation Module 06: Property Taxation Tips for Accountants and Lawyers Module 07: Changes in the UK Property Market CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Property Taxation on Capital Gains course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Property Taxation on Capital Gains. Requirements To enrol in this Property Taxation on Capital Gains course, all you need is a basic understanding of the English Language and an internet connection. Career path Tax Consultant: £30,000 to £60,000 per year Property Tax Advisor: £25,000 to £50,000 per year Tax Analyst: £25,000 to £45,000 per year Tax Manager: £40,000 to £80,000 per year Real Estate Investment Analyst: £35,000 to £60,000 per year Property Portfolio Manager: £30,000 to £70,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

GRAB THIS SUPER MARKDOWN < 4 CPD Courses Ahead > Take an Offer, Get Started with Unlimited Access & Claim a BIGGER Saving Up to 400+ Reviews ... Payroll UK course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in Payroll UK. Our course starts with the basics of Payroll UK and gradually progresses towards advanced topics. Therefore, each lesson of this Payroll UK is intuitive and easy to understand. So, stand out in the job market by completing the Payroll UK course. Get an accredited certificate and add it to your resume to impress your employers. Along with the Payroll UK course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee 4 More Free Courses with Certificates (PDF) Course 01: Sage 50 Accounts Course 02: Xero Accounting and Bookkeeping Online Course 03: Tax Accounting Course 04: Employment Law Course Curriculum: Sage 50 Accounts Sage 50 Bookkeeper - Coursebook Introduction and TASK 1 TASK 2 Setting up the System TASK 3 a Setting up Customers and Suppliers TASK 3 b Creating Projects TASK 3 c Supplier Invoice and Credit Note TASK 3 d Customer Invoice and Credit Note TASK 4 Fixed Assets TASK 5 a and b Bank Payment and Transfer TASK 5 c and d Supplier and Customer Payments and DD STO TASK 6 Petty Cash TASK 7 a Bank Reconnciliation Current Account TASK 7 b Bank Reconciliation Petty Cash TASK 7 c Reconciliation of Credit Card Account TASK 8 Aged Reports TASK 9 a Payroll 9 b Payroll Journal TASK 10 Value Added Tax - Vat Return Task 11 Entering opening balances on Sage 50 TASK 12 a Year-end journals - Depre journal TASK 12 b Prepayment and Deferred Income Journals TASK 13 a Budget TASK 13 b Intro to Cash flow and Sage Report Design TASK 13 c Preparation of Accountants Report & correcting Errors (1) Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Payroll UK course. Requirements To enrol in this Payroll UK course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Payroll UK. Certificates 5 CPD Accredited PDF Certificate Digital certificate - Included Each CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate for £10.79 each. Delivery Charge: Inside the UK: Free Outside of the UK: £9.99

Anti Money Laundering (AML) Every year, billions of dollars are laundered, making compliance more important than ever. Even with advancement of technology, financial infrastructures are not totally safe from fraud and cybercriminals. The huge amount of illegal money floating 'below the surface' and disrupting the economic balance is the main reason for the implementation of anti-money laundering policies. Anti-money laundering (AML) regulations and procedures require financial institutions to monitor and prevent their customers from engaging in money laundering activities. AML seeks to deter criminals from transferring illegal funds into the financial system while also protecting your organisation. With this Anti Money Laundering (AML), you will learn about AML policies and gain a thorough understanding of financial crime. Through this Anti Money Laundering (AML) course you will learn what money laundering is and how AML plays a role in preventing money laundering. This course will teach you how criminals use a variety of methods to launder money and convert black money into white money. This Anti Money Laundering (AML) course covers a wide range of essential topics, including the evolution of AML regulations, a risk-based approach, customer due diligence, suspicious activity/transactions, record keeping, and much more. By the end of this course, you will have a clear understanding of the responsibilities of a money laundering reporting officer as well as the skills required to make your mark in the financial world. Others Benefits of this Anti Money Laundering (AML) Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Anti Money Laundering (AML) course] Anti Money Laundering (AML) course curriculum of Anti Money Laundering (AML) Module 01: A Quick Overview of Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Evolution of Anti Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Employees and Agents Awareness and Training Assessment Method of Anti Money Laundering (AML) After completing each module of the Anti Money Laundering (AML) 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 Anti Money Laundering (AML) After completing the MCQ/Assignment assessment for this Anti Money Laundering (AML) course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Anti Money Laundering (AML) This Anti Money Laundering (AML) course is suitable for anyone interested in learning about AML legislation and how terrorist financing works in order to protect their business and customers. Ethics & Compliance Professionals AML Analysts Accountants & Bookkeepers Bankers Money Laundering Reporting Officer AML Officer Risk & Compliance Analyst Compliance Manager Requirements Anti Money Laundering (AML) There are no specific requirements for this Anti Money Laundering (AML) course because it does not require any advanced knowledge or skills. Career path Anti Money Laundering (AML) This course may lead you to a variety of career opportunities. Certificates Certificate of completion Digital certificate - Included

Are you looking to enhance your Sage Payroll skills? If yes, then you have come to the right place. Our comprehensive course on Sage Payroll will assist you in producing the best possible outcome by mastering the Sage Payroll skills. The Sage Payroll course is for those who want to be successful. In the course, you will learn the essential knowledge needed to become well versed in Sage Payroll. Our course starts with the basics of Sage Payroll and gradually progresses towards advanced topics. Therefore, each lesson of this course is intuitive and easy to understand. Additional Free Course: Xero Accounting and Bookkeeping What you will discover are the following: Learn the fundamentals of Sage Payroll. Obtain more about the legal and business environment. Know the fundamentals of the pension system and its pay components. Get word on how to add both new and existing employees. Learn how to update records and pre-update reports. Acquire the fundamentals of electronic submissions. Obtain a thorough knowledge of editing employee records and reports. Learn how to reset your payments. Why would you choose the Sage Payroll course from Compliance Central: Lifetime access to Sage Payroll course materials Full tutor support is available from Monday to Friday with the Sage Payroll course Learn Sage Payroll skills at your own pace from the comfort of your home Gain a complete understanding of Sage Payroll course Accessible, informative Sage Payroll learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Sage Payroll bundle Study Sage Payroll in your own time through your computer, tablet or mobile device. Curriculum Breakdown of the Sage Payroll Course Sage Payroll: Introduction to Sage Payroll Setting up the System Setting up Customers and Suppliers Creating Projects Supplier Invoice and Credit Note Customer Invoice and Credit Note Fixed Assets Bank Payment and Transfer Supplier and Customer Payments and DD STO Petty Cash Bank Reconciliation Current Account Bank Reconciliation Petty Cash Reconciliation of Credit Card Account Aged Reports Sage Payroll Payroll Journal Value Added Tax - Vat Return Entering opening balances on Sage 50 Year end journals - Depre journal Prepayment and Deferred Income Journals Budget Intro to Cash flow and Sage Report Design Preparation of Accountants Report & correcting Errors (1) Xero Accounting and Bookkeeping: Module 01: Introduction Module 02: Getting Started Module 03: Invoices and Sales Module 04: Bills and Purchases Module 05: Bank Accounts Module 06: Products and Services Module 07: Fixed Assets Module 08: Payroll Module 09: VAT Returns Disclaimer This course will teach you about Xero accounting software and help you improve your skills using it. It's created by an independent company, & not affiliated with Xero Limited. Upon completion, you will earn a CPD accredited certificate, it's not an official Xero certification. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Sage Payroll course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in this sector. It is also great for professionals who are already working in Sage Payroll and want to get promoted at work. Requirements To enrol in this Sage Payroll course, all you need is a basic understanding of the English Language and an internet connection. Career path The Sage Payroll course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Sage Payroll. Bookkeeper Payroll Specialist Payroll Administrator Accounts Payable and Payroll Account Assistant The annual salary for these opportunities is getting the amount of between £55,000 - £60,000 in the UK Certificates Certificate of completion Digital certificate - Included After successfully completing this course, you can get CPD accredited digital PDF certificate for free.

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