1. |
Entering Data in Microsoft Excel Worksheets |
Entering Text |
Using AutoComplete |
Entering Numbers and Dates |
Using the Fill Handle |
Quick Analysis |
2. |
Using Formulas in Microsoft Excel |
Math Operators and the Order of Operations |
Entering Formulas |
AutoSum (and Other Common Auto-Formulas) |
Copying Formulas and Functions |
Relative and Absolute Cell References |
3. |
Working with Rows and Columns |
Inserting Rows and Columns |
Deleting Rows and Columns |
Setting Row Height and Column Width |
Hiding and Un-hiding Rows and Columns |
Freezing Panes |
4. |
Data / Time Functions |
5. |
Text Functions |
6. |
Finalizing Microsoft Excel Worksheets |
Setting Margins |
Setting Page Orientation |
Setting the Print Area |
Print Scaling (Fit Sheet on One Page) |
Headers and Footers |