Excel Training Tutorials in Flash format

Basic ExcelConcepts

- Using “Paste Special”
– Using Text to Columns
– Tips on Filtering with “AutoFilter”
– Using Goal Seek
– Data Validation in Excel
– About Conditional Formatting
– Basics of Protecting a Worksheet
– Basics of Using Subtotals
– Basics of Print Setup Options
- Formatting Tricks
  Grouping Tabs to Save Time
  Conditional Format with Four Conditions
-

All About Pivot Tables

- Create a Basic Pivot Table
- Sorting in a Pivot Table
- Create a Drill Down Effect with a Pivot Table
- Adding a Calculated Field in a Pivot Table
- Grouping in a Pivot Table
- Creating Pivot Charts
- Using Pivot Table Advanced Options
– Convert Pivot Tables Into Hard Data
– Table Structures: Good and Not So Good
- Synchronize 2 Pivot Tables with a Combo Box
– Tie a Chart to a Pivot Table
  All About Multiple Consolidation Ranges
  Pivot Table Based Conditional Chart
  Add Dynamic Icons to Pivot Table Reports
  Pivot Tables and Spreadsheet Bloat  Sample Add-in
 

All About Charts

- Formatting Charts
– Combo Charts and Formatting Data Points
- Create Dynamic Chart Labels
- Create a Histogram Chart
– Create a Basic Water Fall Chart
– Using the Bar to Pie Chart
– Add Average Line to a Chart
– Invert Negatives in a Chart
– Get Graphical without Charts?
– Create a Scrolling Chart (Offset Function)
- Create a Basic Speedometer Chart
- Create a Thermometer Effect in you Column Charts
  Quick and Easy Organizational Chart
  Creating a Delta Chart
  Creating a Benchmark Chart
  Use Excel Charts in PowerPoint Without Bloat
 

Advanced Excel Functions

- Alternate Shading with Conditional Formatting
– VLOOKUP formulas made easy
– Matrix Lookup Formula (Index and Match)
– Cell Information Functions
– Text and String Functions
– Formula to Convert Trailing Minus Signs
- Using IF(AND()) & IF(OR())
- Increase Available Undo Actions
- Using the SumProduct() Function
– Using the COUNTIF() to Find Duplicates
– Set Duplicates Warning with Data Validation
– Basics of Nested Formulas
– Conditional Sums and Array Formulas
- Formula to convert your dates to quarters
  Using the SUBTOTALS Function
  Sort by Color without an Add-in
  Turn a Row Oriented Dataset into a Column Oriented Dataset
  Dynamic Ranges Finally Explained
  Sort by Capitalization

Building Excel Applications

- All About Recording Macros
- Cleaning up your Macro generated VBA
- Using Spreadsheet Form Controls
- Using Macros to create a user interface
- Send Emails with SENDEMAIL method
- Create your First User Form (Create a Splash Screen)
- Calling up Excel Dialog Boxes
  Fun Spreadsheet that does Magic Tricks
  Force Users to Enable Macros
 

Getting Started with VBA

- Quick overview of VBA
- Understanding Reference Libraries
  Declaring Variables
- Using If Statements
- Using Select Case Statements
- The Basics of the Do Loops
- Using For Next Loops
- Looping with For Each Statements