IC1190

Power Pivot, Power Query & DAX in Excel

In this Excel course, we look at three crucial advanced Excel features - Power Pivot, Power Query, and DAX. These functions allow you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. Learn how to bring your data together, merge, and clean it using Power Query before moving onto creating relationships between data tables and building out a data model. We then look at performing calculations on a data model using DAX, and finally, displaying an analysis using PivotTables and PivotCharts.


Course Goal

  • How to use Power Query to manipulate and organize your data
  • How to use Power Pivot to perform detailed analysis on millions of rows of data
  • All about creating Pivot Charts and PivotTables and using your data model
  • How to set up and manage relationships in a data model
  • How to merge and append queries using Power Query

Who This Training Is For

  • All

Exam/Certificate

  • Certificate of Completion (more certification info)
  • Upon successful completion of this course, receive your Power Pivot, Power Query & DAX in Excel certificate

This Course is In the Following Learning Paths:

Microsoft Data Analytics and Business Intelligence
Microsoft Data Analytics and Business Intelligence

Learn the skills to manipulate, merge, analyze, and evaluate millions of rows of data from Excel or other databases whil...

Microsoft Excel
Microsoft Excel

Take this learning path to increase your skills from a spreadsheet novice to an Excel Master. After you complete this pa...

Show All Learning Paths

Instructor

Simon Calder

4.7 Average Rating

88 Reviews

651 Students

20 Courses

Simon Calder

Teaching Business Software

Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles's most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.

Students Also Bought:

SAP S/4 HANA - Basic Navigation
SAP S/4 HANA - Basic Navigation

Your path to specializing in SAP S/4 HANA starts here. Perform hands-on simulations to learn the basics of SAP S/4 HA...

4.5

Average Rating

SAP S/4 HANA Intermediate SAP Skills
SAP S/4 HANA Intermediate SAP Skills

Specialize in SAP S/4 HANA. Open the door to new job opportunities and a command higher wages. Designed for intermedi...

4.5

Average Rating

Basic SAP Skills for Beginners
Basic SAP Skills for Beginners

This introductory course teaches you the basics of SAP and puts you on a path to developing highly sought-after, high...

4.5

Average Rating

View All Courses

Student Feedback

4.8

Average Rating

Reviews

Language: English
Level: Expert
Duration: 3.5 hours
Type:  Instructor-led
Releases: Enterprise Software
Category: Microsoft

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Businesses