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
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.
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. 🙂
In this post I will explain how to compare two or more lists of names using a Pivot Table.
This post contains a video and interactive guide on how to use slicers (free download).
You can use this if you are distributing a file that contains slicers, and want to provide instructions to your users.
This post will show you the proper way to setup or organize your source data for a pivot table.