*Class Held In-Person* Laptops Provided

Sign up for this 3 Part Series!

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 

FREE:  etp@butte.edu

In MS Power BI, topic areas including getting started with terms and navigating the Power BI interface (web and desktop), working with data through data source connection, creating reports and data modeling will be covered. The Microsoft Power BI collection of software, apps, and services helps analyze your organization’s data and uncover insights and trends. There is no prerequisite for this session a working knowledge of Microsoft Excel is helpful at an intermediate level. NOTE: A working Microsoft Office 365 account is required and will be used in this training.

*Class Held In-Person* Laptops provided

Sign up for 3 Part Series!

Many teams struggle to manage data spread across multiple systems, leading to inconsistent reporting and time-consuming manual analysis. This course provides practical tools to transform Excel into a powerful business intelligence platform using Power Query and Power Pivot. Designed for professionals who work with large or complex datasets, the training helps participants build integrated data models that streamline reporting and elevate decision-making.

Learning Objectives:

• Connect, import, and transform data from multiple sources using Power Query and relational modeling.
• Build dynamic reports with slicers, filters, and optimized data models for speed and accuracy.
• Develop a complete analytical workspace that supports interactive, business-ready insights.

Why This Matters to You:

• Reduces time spent on manual data cleanup and report preparation.
• Improves data consistency and accuracy across teams and systems.
• Enhances business intelligence capabilities to support faster, more informed decisions.

Ready to elevate your reporting and unlock Excel’s full analytical power? Register today and transform the way your organization uses data.