#### Archive

Category Archives for "Pivot Tables"
142

## Interactive Dashboards with Pivot Tables & Charts [Video 3 of 3]

Bottom line: Learn how to quickly create an interactive dashboard using pivot tables and pivot charts.  It's easier than you think!

Skill level: Beginner

90

## Introduction to Pivot Tables and Dashboards [Video 2 of 3]

Bottom line: Learn how to use the different calculation types to quickly answer questions about your data.  I also explain how to update your pivot table with more data.

Skill level: Beginner

146

## Introduction to Pivot Tables and Dashboards [Video 1 of 3]

Bottom line: In this video series you will learn how to use Pivot Tables to create meaningful reports and interactive charts and dashboards.

Skill level: Beginner

15

## Interactive Waterfall Chart Dashboard

Bottom line: Learn how to create this interactive dashboard with a waterfall chart that tells the story of what happened over time.

Skill level: Intermediate

Tools used: Charts, Pivot Tables, Slicers

33

## How Do Pivot Tables Work?

Bottom line: This post explains how pivot tables work.  You will learn what actually happens when you drag a field into each area of the pivot table, and why the structure of your source data is so important.

Skill level: Beginner

92

## How to Create Dependent Cascading Drop-down Lists

Bottom line: Learn how to create cascading or dependent drop-down lists (also known as cascading validation) in Excel.  This technique does NOT require named ranges.  If you don't mind using named ranges then there are a few links at the bottom of the page with solutions that will be easier to implement.

Skill level: Intermediate

Functions used: OFFSET, MATCH, COUNTA, COUNTIF, INDIRECT Continue reading

6

## Why Take an Excel Online Course When YouTube is Free?

I received a lot of great questions about the Dashboard and PowerPivot courses from MyOnlineTrainingHub.  I'm guessing that you might have these same questions, and in this post I will try to provide some answers.

27

## Convert Pivot Table to SUMIFS Formulas – Free VBA Macro

This post contains a free VBA Macro that will convert any pivot table into a report containing SUMIFS, COUNTIFS, or AVERAGEIFS formulas.  If you want a very quick way to create a long SUMIFS formula, this is your ticket. 🙂

18

## How To Use Power Pivot Instead of VLOOKUP

In this post I will explain how you can use Power Pivot instead of VLOOKUP to save time and analyze your data in new ways.

20

## How To Compare Multiple Lists of Names with a Pivot Table

In this post I will explain how to compare two or more lists of names using a Pivot Table.