Training Details: 8:30am - 1:00pm | December 11th & 18th, 2024. 

Introduction: Take your Excel skills further with our three-part “Microsoft Excel Intermediate Training.” Learn advanced workbook management, data organization, and collaboration tools to maximize efficiency and streamline your work.

Part I: Advanced Workbook Management

• Navigate Efficiently: Freeze panes, split sheets, and manage multiple worksheets.
• Link Data: Use 3-D formulas and create automatic subtotals.
• Customize Views: Apply formats, themes, and add watermarks.

Part II: Data Structuring & Sharing

• Simplify Formulas: Use names and 3-D references across sheets.
• Organize with Tables: Sort, filter, and create structured data.
• Share & Collaborate: Save workbooks as web pages and send via email.

Part III: Documentation & Security

• Audit Data: Trace formula errors and dependencies.
• Protect Workbooks: Secure content and track changes.
• Build Templates: Create reusable, custom templates for consistency.

Why This Matters to Your Organization: Investing in this training empowers your team to work smarter and faster, enhancing data accuracy, improving collaboration, and securing sensitive information. Mastering these Excel skills enables better decision-making and saves time, allowing your organization to focus on what matters most—driving results.

Ready to Register? Elevate your Excel skills and streamline your workflow. Register for “Microsoft Excel Intermediate Training” today!

Trainer: John Dahlgren has over 25 years of industry experience and teaches in the Butte College Drafting Technology and Engineering programs. He leads the UpSkill Academy for maintenance operators, MiniSkills for entry-level workers, and specializes in Excel training. With a background in manufacturing, construction, and small business management, John is a certified OSHA Outreach Trainer and delivers OSHA 10- and 30-hour, NFPA 70E Arc Flash, and lean tools training like 5S and Kaizen.

 ETP members contact: etp@butte.edu 

ETP members contact: etp@butte.edu

9 am - 12 pm

1/29, 2/5, 2/12 

Part I - Data Analysis 

Advanced functions and formulas 

• Use logical functions to calculate values based on specified criteria 
• Use conditional functions to summarize, count and average data 
• Use text functions to extract specific text strings from cells 
• Use date functions to calculate duration, expressed in a number of days or weeks
• Use array formulas to perform multiple calculations on multiple sets of values 

Lookups and data tables 

• Use the VLOOKUP and HLOOKUP and XLOOKUP functions to find values in a worksheet list 
• Use the MATCH function to find the relative position of a value in a range, and use the INDEX function to find the value of a cell at a given position within a range 
• Use data tables to see the effects of changing the values in a formula 

Part II - PivotTables and PivotCharts 

• Use the pivot table command to create a pivot table for analyzing and comparing large amounts of data 
• Change pivot table views by grouping data, moving fields, and using calculated fields 
• Improving the appearance of a pivot table by applying a style and changing its field settings 
• Create a pivot chart to graphically display data from a pivot table 

Exporting and importing data 

• Export data from excel to a text file and import data from a text file into an excel workbook 
• Use Microsoft query and the web query feature to import data from external databases 

Part III - Power Query and Power Pivot 

• Use of Power Query to connect to data sources, transform data, build relationships in tables and bring back to Excel
• Use of Power Pivot to build comprehensive reports from transformed data
• Introduce Power BI with transformed data and build a multi-element dashboard

Training Details: 1:00pm - 4:00pm | January 29th, 2025.

Introduction to Windows 11 and Office 365

This 3-hour beginner-level course introduces the essentials of Windows 11 and Office 365, equipping participants with foundational computer skills for personal or professional use. In this interactive session, participants will learn to navigate the Windows 11 interface, manage files, and personalize settings. They will also gain hands-on experience with key Office 365 applications: creating and formatting documents in Word, working with data in Excel, and designing presentations in PowerPoint.

Additionally, the course will cover the basics of cloud storage and collaboration using OneDrive, including how to save, share, and edit files in real-time with others. By the end of the session, students will have a solid understanding of essential tools in Windows 11 and Office 365 and the confidence to continue exploring these programs on their own.

Who Should Attend

This course is ideal for individuals new to Windows 11 and Office 365 or those who wish to strengthen their basic computer skills for work, school, or personal use.

Course Highlights

• Windows 11 basics: Start Menu, Taskbar, settings, and file management
• Introduction to Microsoft Word, Excel, and PowerPoint applications
• Cloud storage with OneDrive: file saving and sharing
• Useful shortcuts and productivity tips

Trainer: John Dahlgren has over 25 years of industry experience and teaches in the Butte College Drafting Technology and Engineering programs. He leads the UpSkill Academy for maintenance operators, MiniSkills for entry-level workers, and specializes in Excel training. With a background in manufacturing, construction, and small business management, John is a certified OSHA Outreach Trainer and delivers OSHA 10- and 30-hour, NFPA 70E Arc Flash, and lean tools training like 5S and Kaizen.

ETP members contact: etp@butte.edu

ETP members contact: etp@butte.edu

9 am - 12 pm

2/19, 2/26, 3/5

Laptops provided

Part I: Getting started with terms and navigating a spreadsheet, entry and editing data a beginning modification to spreadsheets are covered. Upon completion, attendees will be able to: 

• Define a spreadsheet and identify spreadsheet components
• Identify the main components of the excel window
• Open and navigate workbooks
• Create a workbook from a template
• Enter and edit text and values in a worksheet
• Enter and edit formulas in a worksheet
• Save and update a workbook, and save a workbook in a different file format
• Move and copy data in a worksheet
• Move, copy, and view formulas in a worksheet
• Use absolute references in formulas
• Insert and delete ranges, rose, and columns in a worksheet

Part II:

• Apply the SUM function to calculate the sum of values
• Use the AutoSum to enter some functions
• Use the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to find average, minimum, and maximum values, and the count of cells in a range
• Apply text formatting
• Customize column widths, row heights, and alignment, and apply color and border formatting
• Format values as currency, percentages, and ordinary numbers
• Apply conditional formatting based on specific criteria
• Copy formatting, apply cell styles, and use Find and Replace to update the formatting for specific content

Part III:

• Create charts based on worksheet data, and move charts within a workbook
• Customize charts and format chart elements
• Insert a picture into a worksheet
• Use graphics as conditional formatting to represent cell data
• Insert and modify SmartArt graphics
• Preview how a worksheet will look when printed, use the spelling checker, and use find and replace to update data
• Set page orientation, scaling, and margins, and create headers and footers
• Print a worksheet and a selected range

ETP Members Contact:  etp@butte.edu

1 pm - 5 pm

2/26, 3/12

In this training, you will be introduced to MS Power Pivot and Power Query tools within MS Excel. Working with data through data source connection, creating reports and data modeling will be covered. The MS Power Pivot and Power Query collection of tools and services helps analyze your organization’s data and uncover insights and trends, improve workflows and mistake proof data processes.

NOTE: A working knowledge of Microsoft Excel including the use of Pivot Tables, Lookup tools and logical functions is required. Completion of MS Excel Advanced series is preferred.

Upon completion, you will be able to:

• Open, access and use MS Power Pivot and Power Query on datasets
• Connect to multiple data sources using MS Power Pivot and Power Query
• Transform and sanitize data using the query editor
• Understand basic data modeling
• Manage query relationships
• Apply data slicers
• Use workspaces, dashboards, and reports

ETP members contact: etp@butte.edu 

9 am - 12 pm

3/26, 4/2, 4/9

Part I - Topics include: managing workbooks and worksheets, advanced methods of spreadsheet formatting and the use of outlining and subtotals are covered. Upon completion, attendees will be able to: 

• Freeze panes, split a worksheet, and hide and display data in window elements.
• Set print titles and page breaks
• Navigate, manage, and print multiple worksheets
• Create 3-D formulas to link worksheets, and add a watch window
• Switch between workbooks, and copy a sheet from one workbook to another
• Create and manage linked workbooks
• Apply built in and custom number formats to display data in specific formats
• Apply and modify themes
• Merge and change orientation of cells to display text in special ways; Transpose data; and add backgrounds and watermarks
• Create outlines to group and organize data, create custom views, and consolidate data from different worksheets
• Summarize the data in a worksheet by creating automatic subtotals

Part II - Topics include: the application of creating names for cells and cell ranges, understanding data structure and tables and web sharing of workbooks and worksheets will be covered. Upon completion, attendees will be able to: 

• Use names to make your formulas easier to understand
• Use the name manager and define 3-D names, which span multiple worksheets
• Organize data logically, sort it by the contents of its columns, and filter it to show only those rows that meet certain criteria
• Create and format tables, and use structured references to include table column names in formulas
• Save a workbook as a web page, and use the auto republish feature to keep the web version of a workbook updated
• Add and remove hyperlinks in a worksheet
• Send workbooks via email

Part III - Topics include: documenting spreadsheets with notes, tags and comments and the creation of workbook/worksheet templates including an extensive review of settings will be covered. Upon completion, attendees will be able to: 

• Use auditing features to trace precedent and dependent cells, and trace errors
• Add and edit comments for a cell and a worksheet
• Protect a workbook or part of a worksheet from unauthorized access or unintentional changes
• Share workbooks, merge versions of a workbook, track changes made by various users, remove personal data from a workbook, and mark a workbook as final
• Change Excel's default application settings
• Create and modify custom templates

ETP members contact: etp@butte.edu

9 am - 12 pm

4/16, 4/23, 4/30

Part I - Data Analysis 

Advanced functions and formulas 

• Use logical functions to calculate values based on specified criteria 
• Use conditional functions to summarize, count and average data 
• Use text functions to extract specific text strings from cells 
• Use date functions to calculate duration, expressed in a number of days or weeks
• Use array formulas to perform multiple calculations on multiple sets of values 

Lookups and data tables 

• Use the VLOOKUP and HLOOKUP and XLOOKUP functions to find values in a worksheet list 
• Use the MATCH function to find the relative position of a value in a range, and use the INDEX function to find the value of a cell at a given position within a range 
• Use data tables to see the effects of changing the values in a formula 

Part II - PivotTables and PivotCharts 

• Use the pivot table command to create a pivot table for analyzing and comparing large amounts of data 
• Change pivot table views by grouping data, moving fields, and using calculated fields 
• Improving the appearance of a pivot table by applying a style and changing its field settings 
• Create a pivot chart to graphically display data from a pivot table 

Exporting and importing data 

• Export data from excel to a text file and import data from a text file into an excel workbook 
• Use Microsoft query and the web query feature to import data from external databases 

Part III - Power Query and Power Pivot 

• Use of Power Query to connect to data sources, transform data, build relationships in tables and bring back to Excel
• Use of Power Pivot to build comprehensive reports from transformed data
• Introduce Power BI with transformed data and build a multi-element dashboard

ETP members contact: etp@butte.edu

9 am - 12 pm

5/7, 5/14, 5/21

Laptops provided

Part I: Getting started with terms and navigating a spreadsheet, entry and editing data a beginning modification to spreadsheets are covered. Upon completion, attendees will be able to: 

• Define a spreadsheet and identify spreadsheet components
• Identify the main components of the excel window
• Open and navigate workbooks
• Create a workbook from a template
• Enter and edit text and values in a worksheet
• Enter and edit formulas in a worksheet
• Save and update a workbook, and save a workbook in a different file format
• Move and copy data in a worksheet
• Move, copy, and view formulas in a worksheet
• Use absolute references in formulas
• Insert and delete ranges, rose, and columns in a worksheet

Part II:

• Apply the SUM function to calculate the sum of values
• Use the AutoSum to enter some functions
• Use the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to find average, minimum, and maximum values, and the count of cells in a range
• Apply text formatting
• Customize column widths, row heights, and alignment, and apply color and border formatting
• Format values as currency, percentages, and ordinary numbers
• Apply conditional formatting based on specific criteria
• Copy formatting, apply cell styles, and use Find and Replace to update the formatting for specific content

Part III:

• Create charts based on worksheet data, and move charts within a workbook
• Customize charts and format chart elements
• Insert a picture into a worksheet
• Use graphics as conditional formatting to represent cell data
• Insert and modify SmartArt graphics
• Preview how a worksheet will look when printed, use the spelling checker, and use find and replace to update data
• Set page orientation, scaling, and margins, and create headers and footers
• Print a worksheet and a selected range