0

Discover Training

Overview

Overview

Excel PowerQuery and PowerPivot are powerful tools that enable users to manipulate and analyze large datasets efficiently within Microsoft Excel. This course covers the fundamentals of PowerQuery for data transformation and cleansing, as well as PowerPivot for data modeling and analysis. Participants will learn how to import, clean, and transform data using PowerQuery, and how to create advanced data models and calculations using PowerPivot.

Learning Outcomes

  • Understand the basics of PowerQuery and PowerPivot.
  • Import, clean, and transform data using PowerQuery.
  • Create relationships and build data models in PowerPivot.
  • Perform advanced calculations and analysis using DAX formulas.
  • Visualize data using PivotTables and PivotCharts.
  • Combine multiple data sources in PowerQuery.
  • Automate data refresh and updates.
  • Troubleshoot common issues in PowerQuery and PowerPivot.

What Will Make You Stand Out?

On Completion of this Excel PowerQuery and PowerPivot online course, you’ll acquire:

  • CPD QS Accredited Course.
  • Upon Course Completion, Earn a Complimentary PDF and a hard copy Certificate to Showcase Your Enhanced Skills.
  • Lifetime access.
  • 24x7 Tutor Support.
  • Complete the course at your own pace.

Description

This course provides a comprehensive introduction to Excel PowerQuery and PowerPivot, two essential tools for data analysis and manipulation. Participants will learn how to import data from various sources, clean and transform it using PowerQuery, and create advanced data models in PowerPivot. Through hands-on exercises and real-world examples, participants will gain practical skills that can be immediately applied to their work.

Who is this course for?

This course is suitable for anyone who works with data in Excel and wants to enhance their data analysis skills. It is particularly beneficial for business analysts, data analysts, financial analysts, and professionals in roles that require data manipulation and analysis.

Requirements

Participants should have a basic understanding of Microsoft Excel and data manipulation concepts. Access to Microsoft Excel 2010 or later with PowerQuery and PowerPivot add-ins installed is required.

Certification

Upon successful completion of the Excel PowerQuery and PowerPivot course, learners can obtain both a PDF certificate and a Hard copy certificate for completely FREE. The Hard copy certificate is available for a nominal fee of £3.99, which covers the delivery charge within the United Kingdom. Additional delivery charges may apply for orders outside the United Kingdom.

Career Path

  • Business Analyst
  • Data Analyst
  • Financial Analyst
  • Data Scientist
  • Business Intelligence Developer
  • Financial Controller

Course Curriculum

Excel PowerQuery and PowerPivot
pivot table power query power pivot – 1 00:09:00
pivot table power query power pivot – 2 00:01:00
pivot table power query power pivot – 3 00:02:00
pivot table power query power pivot – 4 00:03:00
pivot table power query power pivot – 5 00:01:00
pivot table power query power pivot – 6 00:04:00
pivot table power query power pivot – 7 00:08:00
pivot table power query power pivot – 8 00:05:00
pivot table power query power pivot – 9 00:03:00
pivot table power query power pivot – 10 00:04:00
pivot table power query power pivot – 11 00:04:00
pivot table power query power pivot – 12 00:02:00
pivot table power query power pivot – 13 00:03:00
pivot table power query power pivot – 14 00:05:00
pivot table power query power pivot – 15 00:02:00
pivot table power query power pivot – 16 00:03:00
pivot table power query power pivot – 17 00:03:00
pivot table power query power pivot – 18 00:08:00
pivot table power query power pivot – 19 00:02:00
pivot table power query power pivot – 20 00:04:00
pivot table power query power pivot – 21 00:05:00
pivot table power query power pivot – 22 00:09:00
pivot table power query power pivot – 23 00:04:00
pivot table power query power pivot – 24 00:03:00
pivot table power query power pivot – 25 00:04:00
pivot table power query power pivot – 26 00:09:00

Frequently Asked Questions

In the UK, the social care system is mainly managed by the local councils. People are directly employed by the councils. They often work together with the health commissioners under joint funding arrangements. Some people work for private companies or voluntary organizations hired by local councils. They help the local councils with their personal social services.

In the UK, the social care system is mainly managed by the local councils. People are directly employed by the councils. They often work together with the health commissioners under joint funding arrangements. Some people work for private companies or voluntary organizations hired by local councils. They help the local councils with their personal social services.

In the UK, the social care system is mainly managed by the local councils. People are directly employed by the councils. They often work together with the health commissioners under joint funding arrangements. Some people work for private companies or voluntary organizations hired by local councils. They help the local councils with their personal social services.

In the UK, the social care system is mainly managed by the local councils. People are directly employed by the councils. They often work together with the health commissioners under joint funding arrangements. Some people work for private companies or voluntary organizations hired by local councils. They help the local councils with their personal social services.

In the UK, the social care system is mainly managed by the local councils. People are directly employed by the councils. They often work together with the health commissioners under joint funding arrangements. Some people work for private companies or voluntary organizations hired by local councils. They help the local councils with their personal social services.

Excel PowerQuery and PowerPivot
£21
TAKE THIS COURSE

14-Day Money-Back Guarantee

This course includes:
  • units Number of Units:
    26
  • Lock Access:
    1 Year
  • Duration Duration:
    1 hour, 50 minutes
  • Certificate PDF Certificate
    Included
CPD and SSL Lifetime Access

COPYRIGHT © 2021 One Education

Oops! We could not locate your form.