Video Tutorials

Free instructions

Michael Alexander has produced a collection of about 60 online video demonstrations of some interesting Excel maneuvers.

Topics include:

Basic Excel Concepts

• Using "Paste Special"
  
• Using Text to Columns
  
• Tips on Filtering with "AutoFilter"

All About Pivot Tables

• Create a Basic Pivot Table
  
• Sorting in a Pivot Table
  
• Create a Drill Down Effect with a Pivot Table

All About Charts

• Create Dynamic Chart Labels
  
• Create a Thermometer Effect in your Column Charts

And More:
DataPig Technologies



See all Topics