LESSON 1 – Getting Started
- Understanding Spreadsheet Terminology
- Working in The Excel Environment
- Getting Help
- Navigating a Worksheet
LESSON 2 – Entering and Editing Data
- Entering and Editing Text and Values
- Entering and Editing Formulas
- Working with Pictures
- Saving and Updating Workbooks
LESSON 3 – Modifying a Worksheet
- Moving and Copying Data
- Moving and Copying Formulas
- Using Absolute and Relative References
- Inserting and Deleting Ranges, Rows, and Columns
LESSON 4 – Functions
- Entering Functions
- Using AutoSum
- Employing Common Functions
LESSON 5 – Formatting
- Using Text Formatting
- Using Row and Column Formatting
- Understanding Number Formatting
- Employing Conditional Formatting
- Working with Additional Formatting Options
LESSON 6 – Printing
- Preparing to Print
- Understanding Page Setup Options
- Printing Worksheets
LESSON 7 – Charts
- Understanding Chart Basics
- Formatting Charts
LESSON 8 – Managing Large Workbooks
- Viewing Large Worksheets
- Printing Large Worksheets
- Working with Multiple Worksheets
|