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.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

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.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

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.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Power BI with Excel - What you need to get started

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Devin Knight

President

Devin Knight is a Microsoft Data Platform MVP, Microsoft Certified Trainer, and President of Pragmatic Works. He focuses on driving adoption of technology through learning. He is an author of nine Power Platform, Business Intelligence, and SQL Server books. He has been selected as a speaker for conferences like Power Platform Summit, PASS Summit, SQLSaturdays, and Code Camps for many years. Making his home in Jacksonville, FL Devin is a contributing member to several local user groups.

Learn More

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

Please download the following file, which includes all material covered during class and labs that you can work on after class. These labs backup the concepts discussed during the workshop. Unzip these files to your root directory in a Power BI folder. (Ex: C:\Power BI for Excel) [Click to download](https://pragmaticworksonline.sharepoint.com/:u:/s/FileShare/Ed6ws7ZzpMhHqUvoIFkSWq8BiOLqGgFdkKRn-SgbFWKEPw?e=raMHuA&download=1)

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion