Your browser is not optimized for viewing this website.

More information »

The Training Place

Excel: Advanced - Data Mastery and Automation

with John Dahlgren

$190

*Class Held In-Person* Laptops provided

As data workloads grow, many professionals struggle with manual processes, inconsistent formulas, and spreadsheets that are difficult to manage or scale. This course provides practical tools to automate calculations, analyze complex datasets, and structure spreadsheets for accuracy and efficiency. Designed for employees who work with data daily, the training helps participants build advanced, dependable spreadsheets that reduce errors and improve reporting quality.

Learning Objectives:

  • Automate calculations and data manipulation using logical, conditional, text, date, and array functions.
  • Build dynamic pivot tables, charts, 3-D formulas, and macros to streamline analysis and repetitive tasks.
  • Strengthen data accuracy and security through auditing, workbook protection, and professional formatting techniques.

Why This Matters to You:

  • Increases productivity by reducing manual data processing and repetitive tasks.
  • Improves data quality and consistency through structured functions and automated workflows.
  • Enhances reporting accuracy with well-designed, secure, and auditable spreadsheets.

Ready to master advanced Excel techniques and automate your data workflows? Register today and elevate your team’s analytical capabilities.

*In-Person* Computers available if needed.

ETP members contact: etp@butte.edu 

  • Spring 2026: 5/12 & 5/19: May 12 - 19th, 2026
    Tue from 8:00 - 11:00 am

The Training Place - Butte College

2480 Notre Dame Blvd.
Chico, CA 95928 Get directions

Room: SC133

Location map for The Training Place - Butte College




Forgot password?
Staff Log In