*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.

ETP members contact: etp@butte.edu

*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 

*Class Held In-Person* Computers Provided if needed

Mastering Microsoft Office is essential for everyday productivity, yet many users lack the foundational skills to confidently use Excel, Word, and PowerPoint. This interactive training session equips participants with practical tools and real-world applications to create polished documents, analyze data, and deliver effective presentations. Designed for students, office staff, and professionals, this course is perfect for anyone looking to build or refresh their core Office skills.

Learning Objectives:

• Create and format documents, spreadsheets, and presentations using Microsoft.
• Apply time-saving tips, formatting techniques, and basic functions to enhance productivity across all Office applications.
• Organize, manage, print, and share files efficiently across the Microsoft Office suite.
  

Why This Matters to You:

• Improves team efficiency by standardizing digital document workflows.
• Reduces training time by boosting baseline Office proficiency.
• Empowers staff to produce professional documents, data reports, and presentations with confidence.

Unlock the full potential of your team with essential Office skills—sign up today and start making Microsoft Office work for you!

Trainer Bio: John Dahlgren has over 25 years of industry experience in technology, manufacturing, and workforce training. He teaches in the Butte College Drafting Technology and Engineering programs and specializes in Excel training, digital literacy, and workplace productivity tools.

ETP members contact: etp@butte.edu

*Class Held In-Person* Laptops provided

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.

*Class Held In-Person* Computers provided if needed

Many individuals struggle to navigate and organize their digital workspace efficiently, especially when using the Microsoft Windows operating system. This hands-on training session provides practical demonstrations and guided exercises to help users master essential Windows functions for both work and personal use. Ideal for beginners or anyone looking to refresh their foundational Windows skills.

Learning Objectives:

• Navigate the Windows desktop, Start Menu, and taskbar with confidence.
• Organize and manage files and folders using File Explorer.
• Customize settings and troubleshoot basic issues to improve user efficiency.

Why This Matters for Your Organization:

• Enhances digital literacy across your workforce.
• Reduces IT support requests by empowering self-sufficiency.
• Increases productivity through smarter desktop and file management.

Equip your team with essential tech skills—register today and empower users to take full control of their Windows experience!

Trainer Bio: John Dahlgren has over 25 years of industry experience in technology, manufacturing, and workforce training. He teaches in the Butte College Drafting Technology and Engineering programs and specializes in Excel training, digital literacy, and workplace productivity tools.

ETP members contact: etp@butte.edu

*Class Held In-Person* Laptops provided

Many workplaces still rely on manual data entry and disconnected processes that slow productivity and increase the risk of errors. This training provides practical, hands-on tools to automate workflows by integrating Excel with Microsoft Forms, Power Automate, and AI features. Designed for professionals who want to streamline tasks and enhance data accuracy, this course helps participants build intelligent systems that work for them—not the other way around.

Learning Objectives:

• Create automated workflows by connecting Excel with Forms, Power Automate, and real-time data sources.
• Use AI-driven tools to categorize, summarize, and analyze information for better decision-making.
• Build end-to-end workflow solutions that reduce manual entry and improve data accuracy and efficiency.

Why This Matters to You:

• Boosts productivity by automating routine tasks and minimizing human error.
• Enhances data reliability with standardized, automated processes.
• Improves decision-making through real-time insights and efficient data management.

Ready to transform your workflows with powerful automation? Register today and unlock the full potential of Excel and Microsoft’s automation tools.

*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 

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.