Course Length
Three Hours
Course Description
Designed for beginners or those with basic Excel skills, this hands-on course introduces users to worksheet basics. Users acquire a working knowledge of Excel commands needed to create, format, save, and edit worksheets and perform calculations.
Course Topics
- Explore screen elements
- Move from worksheet to worksheet
- Rename, insert, move, copy, and delete a worksheet
- Change the default number of worksheets
- Enter data in a cell
- Use AutoComplete
- Enter information in a selected range
- Replace, and edit cell content
- Use the Undo and Redo commands
- Save, close, open, and create new workbooks
- Navigate using the mouse and keyboard
- Use the Go To command and change worksheet views
- Select data using the mouse and keyboard
- Enter and edit formulas
- Understand the Order of Operations
- Enter a function using the “Insert Function” dialog box, the Function Library, and using Formula AutoComplete
- Use the AutoSum button and the AutoSum button drop-down list
- Use the AutoFill feature
- Use Flash Fill
- Resize columns and rows
- Change a cell reference in a formula to absolute or mixed
- Insert and delete cells, rows, and columns
- Hide and unhide columns, rows, and a worksheet
- Move, copy, and paste data
- Paste with Live Preview
- Use the Paste Options button
- Sort rows by one column
What Participants Receive
Each participant receives a guide containing step-by-step instructions and practice exercises.
