Course Length
Three hours
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
- Recognize screen elements
- Move from sheet to sheet in a workbook
- Rename, insert, move, copy, and delete a sheet
- Change the default number of sheets in a workbook
- Enter text and numbers in a cell
- Use AutoComplete
- Enter information in a selected range
- Replace and edit cell contents
- Use the Undo and Redo commands
- Preview and print data
- Save and close a workbook
- Create a new workbook
- Open an existing workbook
- Navigate using the mouse and keyboard
- Use the Go To command
- Change worksheet views
- Select data using the mouse and keyboard
- Enter a formula using cell references
- Edit a formula
- Understand the Order of Operations
- Enter a function using the “Insert Function” dialog box
- Enter a function using the Function Library
- Enter a function using Formula AutoComplete
- Use the AutoSum button
- Use the AutoSum button drop-down list
- 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 and unhide columns, rows, and a worksheet
- Move, copy, and paste data using the Clipboard
- Paste with Live Preview
- Use the Paste Options button
- Move and copy using Drag and Drop
- Sort rows by one column
What Participants Receive
Each participant receives a guide containing step-by-step instructions and practice exercises.
