Course Length
Full day
Prerequisites
Windows Introduction or equivalent experience
Course Description
Designed for the beginner, this hands-on course introduces users to worksheet basics. Users acquire a working knowledge of Excel commands needed to create, save, and edit worksheets and perform calculations.
Course Topics
- Work with the Ribbon and ScreenTips
- Use the Quick Access Toolbar
- Move from sheet to sheet in a workbook
- Rename, insert, move, copy, and delete a sheet
- Change the default number of sheets
- Enter text and numbers in cells
- Use AutoComplete and enter information in a selected range
- Replace and edit cell contents
- Use the Undo and Redo commands
- Create, open, save, and close a workbook
- Use the Go To command
- Select data using the mouse and keyboard
- Change worksheet views
- Enter a formula using cell references
- Edit a formula and understand the Order of Operations
- Use the “Insert Function” dialog box
- Use the Function Library
- Use Formula AutoComplete
- Use the AutoSum button and drop-down list
- Use the Trace Error button
- Use the AutoFill feature
- Resize columns and rows
- Change a cell reference in a formula to absolute or mixed
- Insert and delete cells, rows, and columns
- Hide columns, rows, and a worksheet
- Move, copy, and paste data
- Use the Paste Options button and Paste List
- Collect and paste multiple items
- Split a window and freeze panes
- Create, view, show, hide, edit, print, and delete Comments
- Format cells and cell contents
- Draw, apply, and erase borders
- Copy formatting using Format Painter
- Apply cell styles and themes
- Print preview and change page orientation
- Change margins and center data on a page
- Create headers and footers
- Insert and remove a page break
- Use Page Break Preview
- Print row or column titles on every page
- Print data and scale printed output
- Set and clear a print area
- Exit Excel
What Participants Receive
Each participant receives a guide containing step-by-step instructions and practice exercises.
