Beginning Video (2 hrs 20 min)
Overview of Excel Features (20 min)
- Menu Bar
- Tool Bars
- Formula Bar & the Worksheet
- Navigating in a Worksheet
- Status Bar & 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 & Basic Formatting from the Tool Bar
- Other Formatting from the Tool Bar
Entering Formulas (6 min)
- Start with = & Three Methods & Operators
- Copying Formulas
Basic Functions (15 min)
- Summation
- Averages
- The On-screen Calculators & Undo/Redo
Saving, Opening & Closing Files (8 min)
- File Save & Save As
- Opening & Closing a File
Formatting - Part 2 (15 min)
- The Format Painter
- Formatting Numbers from the Tool Bar
- The Best Fit Feature & the Format Cells Command
- Automatic Formatting
Expanded Formulas & Functions (15 min)
- Calculating Cumulative Totals & Percent of Growth
- Operator Precedence in Formulas, Operator Symbols & Calculating Ratios
- Functions Beyond =Sum & =Average - Minimum & 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 & Deleting Columns/Rows/Cells
- Moving & Copying Cells
Printing (6 min)
- Using Print Preview & Selecting Portrait or Landscape Mode
- Centering Vertical Margins & Controlling Headers & Footers
|
Intermediate Video (2 hrs 18 min)
Using Functions (14 min)
- Categories: Statistical, Financial, etc.
- Using the Function Wizard
- Using HELP to Explore Functions
- Example - The PMT Function
Date & 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 & the NOW () & TODAY () Functions
- Other Examples of Ways to Enter Dates in a Worksheet
Tools/Options Command (7 min)
- Show/Hide Grids & Move Selection after Enter
- Default Font & Number of Worksheets
Working with Multi-Sheet Workbooks (15 min)
- Re)Naming Sheets & Rearranging the Order of Sheets
- Inserting & Moving & Copying Sheets
- Grouping Sheets & Placing Information on Multiple Sheets
- Deleting Sheets
Using Relative, Absolute & Mixed Cell References (17 min)
- Relative & Absolute References
- Mixed References
Additional Formatting Techniques (8 min)
- Word Wrap & Changing Cell Orientation
- Placing Text in Different Parts of a Cell & Double Underlining
- Colored Borders & Patterns with Colored Cell Background
Charting (60 min)
- Selecting Data for a Chart
- Method 1 - The F11 Key & the Chart Tool Bar
- Method 2 - The Chart Wizard
- Moving, Resizing & 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 (&/ OR) with the IF Function
- Nested IF Functions
- Using the V-Lookup Function to Overcome IF Function Limitations
Adjusting Worksheet Views (10 min)
- Vertical & Horizontal Split Screens
- Multi-directional Split & 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 vs. Formulas
- Using the Auditing Tool Bar
- Tracing Dependent & Precedent Cells
Excel Database Features (30 min)
- Sorting Data from the Tool Bar
- Multiple-key Sorting & 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 & 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
- Running a Macro from a Button or an Object on the Worksheet
|