Course Length
Three Hours
Prerequisites
Windows Introduction or equivalent experience
Course Description
Perhaps you have worked in Excel a time or two, but you are unsure how to do some of the basics. This hands-on class is designed for the beginner or someone with minimal Excel skills. Upon completion, you will be able to create and edit worksheets, perform calculations, and use a variety of functions.
Course Topics
- Identify screen elements
- Move from sheet to sheet
- Rename a worksheet
- Select worksheets
- Insert new sheet(s)
- Move, copy, and delete sheet(s)
- Change the default number of sheets in a workbook
- Enter text and numbers
- Use AutoComplete
- Enter information in a selected range
- Replace and edit cell contents
- Use undo and redo
- Print preview and print
- Save and close a workbook
- Create a new workbook
- Open an existing workbook
- Navigate in a worksheet
- Use the Go To command
- Change the view
- Select and deselect data
- Enter formulas
- Edit a formula
- Order of operations
- Enter a function using the Insert Function dialog box, the Function Library, and Formula AutoComplete
- Use the AutoSum button
- Use the AutoFill feature
- Resize columns and rows
- Change a cell reference to absolute or mixed
- Insert and delete cells, rows, and columns
- Hide and unhide columns and rows
- Hide and unhide a worksheet
- Move, copy, and paste worksheet data
- Use the paste options button
- Use the paste button list
- Sort rows by one column
What Participants Receive
Each participant receives a guide containing step-by-step instructions and practice exercises.
