Beginning Video (hr 20 min)
Overview of Excel Features (20 min)
- Menu Bar
- Tool Bars
- Formula Bar and the Worksheet
- Navigating in a Worksheet
- Status Bar and the Mouse Pointer
Entering Data Into a Worksheet (12 min)
- Data Entry Techniques
- Data Correction
- Erasing Cell Contents
- AutoFill Entry Techniques
- Data Type Comparison
Formatting - Part 1 (7 min)
- Selection and Basic Formatting from the Tool Bar
- Other Formatting from the Tool Bar
Entering Formulas (6 min)
- Start with = and Three Methods and Operators
- Copying Formulas
Basic Functions (15 min)
- Summation
- Averages
- The On-screen Calculators & Undo/Redo
Saving, Opening and Closing Files (8 min)
- File Save & Save As
- Opening and Closing a File
Formatting - Part 2 (15 min)
- The Format Painter
- Formatting Numbers From the Tool Bar
- The Best Fit Feature and the Format Cells Command
- Automatic Formatting
Expanded Formulas and Functions (15 min)
- Calculating Cumulative Totals & Percent of Growth
- Operator Precedence in formulas, Operator Symbols & Calculating Ratios
- Functions Beyond =Sum & =Average - Minimum and Maximum
Additional Formatting (15 min)
- Column Width
- Row Height
- Font Styles
- Border Colors & Font Colors
- Center Text Across Columns
Changing the Worksheet Layout (9 min)
- Inserting and Deleting Columns/Rows/Cells
- Moving and Copying Cells
Printing (6 min)
- Using Print Preview & Selecting Portrait or Landscape Mode
- Centering Vertical Margins & Controlling Headers and Footers
|
Intermediate Video (2 hr 18 min)
Using Functions (14 min)
- Categories: Statistical, Financial etc.
- Using the Function Wizard
- Using HELP to Explore Functions
- Example - The PMT Function
Date and Time Functions (18 min)
- Using Dates as Values
- Finding Days of the Week
- Displaying Dates Using the Format Cells command
- Quick Entry Using Auto-Fill Techniques
- Date/Time Entry Techniques and the NOW () and TODAY () Functions
- Other Examples of Ways to Enter Dates in a Worksheet
Tools/Options Command (7 min)
- Show/Hide Grids and Move Selection after Enter
- Default Font and Number of Worksheets
Working with Multi-Sheet Workbooks (15 min)
- (Re)Naming Sheets and Rearranging the Order of Sheets
- Inserting & Moving and Copying Sheets
- Grouping Sheets & Placing Information on Multiple Sheets
- Deleting Sheets
Using Relative, Absolute and Mixed Cell References (17 min)
- Relative and Absolute References
- Mixed References
Additional Formatting Techniques (8 min)
- Word Wrap and Changing Cell Orientation
- Placing Text in Different Parts of a Cell and Double Underlining
- Colored Borders and Patterns With Colored Cell Background
Charting (60 min)
- Selecting Data for a Chart
- Method 1 - The F11 Key and the Chart Tool Bar
- Method 2 - The Chart Wizard
- Moving, Re-sizing, and Copying Charts on a Worksheet
- Selecting Elements to be Changed
- Other Chart Types & Tool Bar/Format/Auto-Format
- Printing an Entire Chart or Part of a Chart
- Pie Charts
- Copying Charts Onto a Worksheet or a Separate Sheet
|
Advanced Video (2 hrs 13 min)
Logical Functions (26 min)
- When to Use the IF Function & Relative Operators With the IF Function
- Using Logical Operators (AND & OR) With the IF Function
- Nested IF Functions
- Using the V-Lookup Function to Overcome IF Function Limitations
Adjusting Worksheet Views (10 min)
- Vertical and Horizontal Split Screens
- Multi-directional Split and Freeze/Unfreeze Panes
Creating Series Data (10 min)
- Auto-Fill Techniques
- The Right Mouse Button as a Series Extender
- The Edit Fill Series Command
Auditing Techniques (12 min)
- Displaying Values versus Formulas
- Using the Auditing Tool Bar
- Tracing Dependent and Precedent Cells
Excel Database Features (30 min)
- Sorting Data From the Tool Bar
- Multiple-key Sorting and the Data Command
- Custom Order Sort
- Using the Auto-Filter Feature
- Creating Subtotals
- Sorting Problems
Pivot Tables (16 min)
- The Pivot Table Wizard
- Changing the Order of Results
Range Names (10 min)
- Naming a Cell
- Naming a Range of Cells
- Using Range Names in Formulas & Functions and Applying Range Names from adjacent Data
Macro Information (19 min)
- Defining a Macro
- Recording a Macro
- Running a Macro With a Keystroke Combination or Tools/New Name on Menu Bar
- Running a Macro From the Tool Bar or Tools/Macro/Run
|