The Training Place

ETP Members Contact:  etp@butte.edu

1 pm - 5 pm

2/26, 3/12

In this training, you will be introduced to MS Power Pivot and Power Query tools within MS Excel. Working with data through data source connection, creating reports and data modeling will be covered. The MS Power Pivot and Power Query collection of tools and services helps analyze your organization’s data and uncover insights and trends, improve workflows and mistake proof data processes.

NOTE: A working knowledge of Microsoft Excel including the use of Pivot Tables, Lookup tools and logical functions is required. Completion of MS Excel Advanced series is preferred.

Upon completion, you will be able to:

• Open, access and use MS Power Pivot and Power Query on datasets
• Connect to multiple data sources using MS Power Pivot and Power Query
• Transform and sanitize data using the query editor
• Understand basic data modeling
• Manage query relationships
• Apply data slicers
• Use workspaces, dashboards, and reports