The Training Place

ETP Members Contact: etp@butte.edu

Training Details: 1pm - 5pm | February 26th & March 12th, 2025

Laptops provided

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

Ready to Register? Elevate your Excel skills and streamline your workflow. Register for “Microsoft Excel Advanced Training” today!

Trainer: John Dahlgren has over 25 years of industry experience and teaches in the Butte College Drafting Technology and Engineering programs. He leads the UpSkill Academy for maintenance operators, MiniSkills for entry-level workers, and specializes in Excel training. With a background in manufacturing, construction, and small business management, John is a certified OSHA Outreach Trainer and delivers OSHA 10- and 30-hour, NFPA 70E Arc Flash, and lean tools training like 5S and Kaizen.