Microsoft Excel

Create and Define a Simple Worksheet

1. Define worksheet/workbook Access / Navigate / Exit the Program
2. SUM function/AutoSUM button
3. Save/Save as/Name a file
4. Formulas
5. Formatting numbers and text with the toolbar

Develop the Worksheet

1. Plan a worksheet
2. Split worksheet/box/bar
3. Display/move toolbars
4. Row and Column labels
5. Copy data and formulas
6. Enhance worksheet Appearance

Formulas and Macros Formulas

1. Use the Function Wizard
2. Nested functions
3. Relative, Absolute, Mixed cell references
4. Logical functions using IF, AND, OR, NOT
5. Date and time functions
6. Correcting circular references
7. Common functions (AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND,INT)
8. Name cells /ranges /constants
9. >, <, = operators
10. The LOOKUP function
11. Annotating formulas

Macros

1. Definition and use
2. Run a macro
3. Record a macro
4. Store a macro
5. Assign a macro
6. Use the Personal Macro Workbook

Special Operations

1. Use multiple windows
2. Copy/ paste between Worksheets
3. Link worksheets
4. Consolidate worksheets
5. Import and link from other Applications
6. Use AutoFormat
7. Create, use and modify styles and templates
8. Print features
9. Create /edit an outline

Graphics Operations

1. Create charts
2. Enhance charts
3. Drawing features