Excel Basics

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

Adding Tool Tips to Cells


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

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 


Excel Charting Techniques

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

Create a Scrolling Chart (With Dynamic Ranges)

Create a Basic Speedometer Chart

Create a Thermometer Effect in you Column Charts

Creating a Delta Chart

Creating a Benchmark Chart

Use Excel Charts in PowerPoint Without Bloat

Creating Bullet Graphs in Excel


Excel Functions Explained

Matrix Lookup Formula (Index and Match)

Cell Information Functions

Text and String Functions

Formula to Convert Trailing Minus Signs

Using IF(AND()) & IF(OR()

Using the SumProduct() Function

Basics of Nested Formulas

Conditional Sums and Array Formulas

Using the SUBTOTALS Function

Dynamic Ranges Finally Explained


Excel Tips and Tricks

Increase Available Undo Actions

Using the COUNTIF() to Find Duplicates

Set Duplicates Warning with Data Validation

Formula to convert your dates to quarters

Sort by Color without an Add-in

Turn a Row Oriented Dataset into a Column Oriented Dataset

Sort by Capitalization


Using Excel Macros

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

Force Users to Enable Macros


VBA Basics

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


Copyright 2004-2009 DataPig Technologies LLC. All rights reserved.