The Training Place

ETP members contact: etp@butte.edu

Training Details:  April 16th, 23rd, & 30th, 2025 | 9am - 12pm

*Class Held In-Person* Laptops provided

Effectively analyzing and managing large datasets can be a challenge without the right tools. This advanced Excel training equips professionals with powerful data analysis techniques, helping them optimize workflows, improve decision-making, and enhance reporting capabilities. Designed for analysts, managers, and professionals who work with data, this course provides in-depth instruction on Excel’s most powerful features.

Learning Objectives:

• Advanced Functions and Formulas: Utilize logical, conditional, text, date, and array functions to manipulate and analyze data effectively.
• Lookups and Data Tables: Leverage VLOOKUP, HLOOKUP, XLOOKUP, MATCH, and INDEX functions for efficient data retrieval and comparison.
• PivotTables and PivotCharts: Create, customize, and analyze large datasets using PivotTables and visually represent insights with PivotCharts.
• Exporting and Importing Data: Transfer data between Excel and external sources using text files, Microsoft Query, and web query features.
• Power Query and Power Pivot: Connect to multiple data sources, transform data, build relationships, and create interactive dashboards with Power BI.

Why This Matters to You:

• Optimize Data Management: Improve efficiency by automating complex data analysis tasks.
• Enhance Decision-Making: Utilize powerful Excel tools to derive meaningful insights from large datasets.
• Improve Reporting and Visualization: Build comprehensive reports and dashboards that drive strategic decisions.

Ready to enhance your Excel expertise? Register for “Microsoft Excel Advanced Training” today!

Trainer Bio: John Dahlgren John Dahlgren has over 25 years of industry experience and teaches in the Butte College Drafting Technology and Engineering programs. He specializes in Excel training and workforce development, helping professionals master data analysis, reporting, and automation.