|
Module 1: Excel Essentials
- Introduction to the Excel interface
- Navigating and selecting cells
- Keyboard Shortcuts
- Entering and editing data
- Deleting and canceling data
- Performing simple calculations
- Saving your workbook
|
Module 2: Introduction to Formulas/Functions
- Spreadsheet structure and design
- Creating basic formulas
- Creating basic functions
- Copying a formula with AutoFill
- Recognizing the differences b/w Relative and Absolute references
|
|
Module 3: Moving/Copying Data, Autofill, & Formatting
- Inserting rows and columns
- Move and copy data
- Using the AutoFill feature to complete a series of values
- Formatting spreadsheet data
- Apply autoformat
|
Module 4: Spreadsheet Design, Page Setup & Printing
- Using and creating templates
- Worksheets - insert, delete, rename, move, copy, & group
- Freezing and splitting panes
- Spell checking your data
- Setting print options through Page Setup
- Printing your worksheets
|