Your browser is not optimized for viewing this website.

More information »

The Training Place

Microsoft Excel: Basic - 3 Part

with John Dahlgren

$290

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
  • Feb 19 - Mar 5th, 2025
    Wed for 3 weeks from 9:00 am - 12:00 pm

The Training Place - Butte College

2480 Notre Dame Blvd.
Chico, CA 95928 Get directions

Room: SC133

Location map for The Training Place - Butte College




Forgot password?
Staff Log In