Home
Basic Excel Concepts
- 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 NEW!! Adding Tool Tips to Cells
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 Get this video Convert Pivot Tables Into Hard Data Get this video Table Structures: Good and Not So Good Get this video Synchronize 2 Pivot Tables with a ComboBox Get this video Tie a Chart to a Pivot Table Get this video All About Multiple Consolidation Ranges Get this video Pivot Table Based Conditional Chart Get this video Add Dynamic Icons to Pivot Table Reports Get this video Pivot Tables and Spreadsheet Bloat
All About Charts
- Formatting Charts - Combo Charts and Formatting Data Points - Create Dynamic Chart Labels - Create a Histogram Chart - Using the Bar to Pie Chart - Add Average Line to a Chart - Invert Negatives in a Chart - Get Graphical without Charts? - Use Excel Charts in PowerPoint Without Bloat - Quick and Easy Organizational Chart - NEW!! Creating Bullet Graphs in Excel Get this video Create a Basic Speedometer Chart Get this video Create a Thermometer Effect in you Column Charts Get this video Creating a Delta Chart Get this video Creating a Benchmark Chart Get this video Create a Scrolling Chart (Offset Function)
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 - Using IF(AND()) & IF(OR()) - 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 Get this video Increase Available Undo Actions Get this video Formula to Convert Trailing Minus Signs Get this video Sort by Color without an Add-in Get this video Turn a Row Oriented Dataset into a Column Oriented Dataset Get this video Dynamic Ranges Finally Explained Get this video Sort by Capitalization
Building Excel Applications
- All About Recording Macros - Fun Spreadsheet that does Magic Tricks Get this video Cleaning up your Macro generated VBA code Get this video Using Macros to create a user interfaceup your Macro generated VBA Get this video Using Spreadsheet Form Controls Get this video Send Emails with SENDEMAIL method Get this video Create your First User Form (Create a Splash Screen) Get this video Calling up Excel Dialog Boxes Get this video 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