Skip to content Skip to site navigation Skip to service navigation

Excel Basics: Workbooks, Worksheets, and Manipulating Cell Data

Class Sessions

Date Costsort ascending
  • Wed Sep 26, 9:00 am to 12:00 pm
$275
  • Mon Nov 19, 9:00 am to 12:00 pm
$275

Class Code

ITS-1201

Class Description

This class covers several key skills and concepts no Excel user should be without. Learn the basics of Excel from formatting numbers and text to creating simple formulas and functions. This is a good place to start if you are an Excel beginner.

Class outline/topics:

Opening and saving files
- Using Save, Save as, New and Close commands
- File management keyboard shortcuts

Worksheet basics
- Inserting and deleting worksheets
- Renaming worksheets
- Moving and copying worksheets within and between workbooks
- Hiding and unhiding worksheets

Create formulas to sum, multiply and divide numbers
- Understanding cell references

Use simple functions in formulas
- SUM, COUNT, AVERAGE, MAX, MIN, PMT

Format numbers with styles
- Currency, fixed decimals, dates

Copy, cut and paste cell contents
- Basic techniques plus several shortcuts

Using find & replace
- Find on worksheet
- Find on all worksheets
- Hazards and how to avoid them

Freeze panes
- Lock headings into position while scrolling

Prerequisites:

Participants should already have some exposure to Microsoft Office programs and should be comfortable using a computer. Ideally, participants will already be using Excel as part of their job.