Beginning (2 Hrs. 16 Min.)
The Excel Screen (32 Min.)
- The Excel Workbook and Worksheets
- Title Bar & Menu Bar
- Toolbars
- Formula Bar
- Columns & Rows
- Navigation
- Sheet Names & the Status Bar
- Mouse Pointers & Shortcut Menus
Entering Data into a Worksheet (27 Min.)
- Data Entry Techniques
- Auto-Fill Entry Techniques
- Erasing Data
- Auto Complete
Entering Formulas (26 Min.)
- Three Methods of Entering Formulas
- Repeating a Formula
- Formulas Beyond Addition and Subtraction
Basic Functions (21 Min.)
- Summation
- Recalculating Effects (Change one cell and five others change)
- Averages
Formatting (13 Min.)
- The Formatting Toolbar
- Adjusting Column-width and Row-height
- Numeric Formatting
Saving, Opening & Closing Files (16 Min.)
- File Save or File Save as
- Opening a File
- Closing a File
- Creating a new Workbook
|
Intermediate (2 Hrs. 5 Min.)
Changing Worksheet Layout (26 Min.)
- Inserting Columns, Rows and Cells
- Deleting Columns, Rows and Cells
- Moving Cells
- Copying Cells
Additional Formatting (6 Min.)
- Formatting Cell Attributes and Alignment
- Borders
- Numeric Formatting
- Center Text across Columns
- Hiding & Unhiding Columns & Rows
Printing (25 Min.)
- Using Print Preview and Page Setup
- Printing Controls
- Using Page Break Preview
Using Cell References (29 Min.)
- Absolute References
- Mixed References
Tools Options Command (18 Min.)
- Show/Hide Gridlines
- Show/Hide Formulas
- Recently used Files List
- Sheets in New Workbook
- Default Settings
|
Advanced (2 Hrs. 2 Min.)
Adjusting Worksheet Views (13 Min.)
- Freeze/Unfreeze Panes
- Horizontal & Vertical Split screen
Auditing Techniques (12 Min.)
- Using the Auditing Toolbar
- Tracing Dependant Cells
- Tracing Precedent Cells
Using Functions (18 Min.)
- Paste Function
- The PMT Function
- Expanding the use of standard functions
Logical Functions (30 Min.)
- IF Functions and Relational Operators (> < >= <= = <> )
- Using Words in IF Functions
- Using IF Functions with Arithmetic Operators (* / + -)
- Using Logical Operators (AND & OR) with the IF Function
- Nested IF Functions
- Using the VLOOKUP Function to overcome Limitations of the IF Functions
Date & Time Functions (21 Min.)
- Using Dates as Values
- Entering a Series of Dates
- Date/Time entry Techniques
Multi-Sheet Workbooks (22 Min.)
- Re-Naming & Re-Ordering Sheets
- Inserting and Deleting Sheets
- Moving, Copying and Grouping Sheets
|