Your browser is not optimized for viewing this website.

More information »

The Training Place



Excel: Advanced - Data Mastery and Automation

in COMPUTER SKILLS

Excel: Advanced - Data Mastery and Automation

$190

with John Dahlgren

Calendar Next available session starts May 12, 2026 at 8 am

*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 





Forgot password?
Staff Log In