<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Power BI with Excel

Boost your skills with this class, ideal for Power and Microsoft 365 users. Learn Power Query for shaping data, Power Pivot for data modeling, and present data with Excel PivotTable and PivotCharts.

  • Course Info
  • Instructor
  • What to know beforehand
  • System Requirements

Course Description

This class is designed to get you up to speed using tools easily accessible to Power Users and all Microsoft Office users including Microsoft 365. First you will learn how to use Power Query to shape data that can be found in various data sources. Next you will learn the basics of creating data models using Power Pivot. Finally, you will learn the best ways to present your data by building reports using Excel PivotTable and PivotCharts. You will also learn how to make the self-service BI solutions you create scalable across your entire enterprise environment.

Course Outline ( Free Preview)

Power BI with Excel - What you need to get started

Module 01 - Class Introduction

Module 02 - Leveraging Power Query for Data Cleansing

Module 03 - Building Data Models with Power Pivot 44 min.

Module 04 - Building Analytical Calculations with DAX 40 min.

Module 05A - Designing Excel Reports (PivotTables and PivotCharts) 26 min.

Module 05B - Designing Excel Reports (Connecting to Power BI Datasets) 7 min.

Module 06 - Migrating to Power BI 10 min.

This course includes:

  • 3+ hours of training
  • 8 Modules
  • * Access on mobile and browser
  • Certificate of Completion