The Training Place

ETP Members Contact: etp@butte.edu

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

*Class Held In-Person* Laptops provided

Note: Participants should have a solid understanding of Microsoft Excel, including Pivot Tables, Lookup functions, and logical functions. Completion of the MS Excel Advanced series is recommended.

Data management can be overwhelming without the right tools. This hands-on training introduces MS Power Pivot and Power Query, equipping you with the skills to connect to multiple data sources, clean and transform data, and build insightful reports. Designed for professionals who work with complex datasets, this course enhances efficiency and decision-making through advanced Excel techniques.

Learning Objectives:

• Utilize MS Power Pivot and Power Query to connect, transform, and manage datasets effectively.
• Build data models and relationships to enhance reporting and analysis.
• Apply data slicers, dashboards, and workspaces to streamline workflows and uncover trends.

Why This Matters to You:

• Reduce manual data processing time and improve efficiency.
• Minimize errors by automating data transformation and cleaning.
• Enhance data-driven decision-making with powerful reporting tools.

Ready to take your Excel skills to the next level? Register today and transform the way you manage data!

Trainer Bio: John Dahlgren is an experienced data analyst and Excel expert with a specialization in Power Pivot and Power Query. With years of industry experience, he helps professionals optimize their data processes and make smarter business decisions through advanced Excel techniques.