The Training Place

ETP members contact: etp@butte.edu

Training Details: 9am - 12pm | May 7th, 14th & 21st, 2025

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

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