ETP members contact: etp@butte.edu 

Training Details: March 26th, April 2nd, & 9th, 2025 | 9am - 12pm

*Class Held In-Person* Laptops Provided

Managing complex workbooks and optimizing data organization is essential for efficiency and accuracy. This course equips professionals with advanced Excel skills, including formatting techniques, data management strategies, and collaborative features to streamline workflows and enhance productivity.

Learning Objectives:

• Optimize Workbook and Worksheet Management: Freeze panes, split worksheets, manage multiple sheets, and navigate linked workbooks with ease.
• Enhance Data Organization and Formatting: Apply custom number formats, modify themes, merge cells, transpose data, and incorporate backgrounds and watermarks.
• Streamline Data Analysis and Structure: Use outlines, subtotals, sorting, filtering, and structured tables to organize and summarize data efficiently.
• Improve Collaboration and Documentation: Track changes, protect worksheets, add comments, and share workbooks while maintaining data integrity.

Why This Matters to You:

• Boost Efficiency: Automate and streamline data organization for increased productivity.
• Enhance Collaboration: Utilize Excel’s sharing features to improve teamwork and version control.
• Improve Data Accuracy: Implement structured tools and auditing features to maintain consistency and reliability.

Ready to expand your Excel proficiency? Register for “Microsoft Excel Intermediate 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 refine their data management and reporting skills for improved efficiency and collaboration.

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.

ETP members contact: etp@butte.edu

Training Details: 9am - 12pm | May 7th, 14th & 21st, 2025

*Class Held In-Person* Laptops provided

Managing data efficiently is a crucial skill, yet many struggle with navigating Excel’s features and functions. This hands-on course provides practical techniques to streamline your workflow, improve accuracy, and enhance data management. Designed for professionals, administrators, and anyone looking to boost their Excel proficiency, this training equips you with essential spreadsheet skills.

Learning Objectives:

• Navigate and manipulate spreadsheets with ease, including entering, editing, and formatting data effectively.
• Utilize key Excel functions such as SUM, AVERAGE, and COUNT to analyze data efficiently.
• Create and customize charts, apply conditional formatting, and optimize worksheets for professional reporting and printing.

Why This Matters to You:

• Increase efficiency by automating calculations and formatting tasks.
• Enhance data accuracy and organization for better decision-making.
• Improve reporting capabilities with professional charts and structured workbooks.

Ready to enhance your Excel skills and streamline your workflow? Register for “Microsoft Excel Basic Training” today!

Trainer Bio: John Dahlgren has over 25 years of industry experience, specializing in Excel training and workforce development. He teaches at Butte College and leads training programs for various industries.