The Training Place

ETP members contact: etp@butte.edu

Training Detail: 9am - 12pm | April 16th, 23rd, & 30th, 2025

Laptops provided

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

Ready to Register? Elevate your Excel skills and streamline your workflow. Register for “Microsoft Excel Advanced 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.