Bottom line: Learn how to get the pivot table to default to a Sum calculation instead of Count when the source data field contains numbers.
Skill level: Beginner
Watch in full screen HD or on Youtube.
Bottom line: In this video you will learn one technique to quickly filter a column for duplicate values.
Skill level: Beginner
Bottom line: In this 3rd video of the series on Excel Filters you will learn how to filter multiple columns. I explain the rules Excel uses when multiple columns are filtered, and how to use OR logic.
Skill level: Beginner
Bottom line: In this 2nd video of the series on Excel Filters I explain all of my favorite keyboard shortcuts for filtering. These will save you a ton of time!
Skill level: Beginner
Bottom line: In this FREE video series you will learn how to use the Filters in Excel. I share time saving tips, techniques, and shortcuts that will help make you a filtering ninja!
Skill level: Beginner
In the last webinar I mentioned a new add-in that I have been working on with Randy, a student of The VBA Pro Course. The add-in is called Filter Mate.
The goal of Filter Mate is to help make it easier to work with filtered ranges and Tables in Excel. I just recorded a quick video that gives a preview of how Filter Mate works.
Bottom line: Learn a fast and easy way to search any data validation list or in-cell drop-down list with a free tool.
Skill level: Beginner
Bottom line: Make your hard work shine, and learn how to add a beautiful Table of Contents sheet to the front of your Excel workbook that contains clickable image tiles to each sheet in the workbook.
Skill level: Intermediate
Bottom line: Learn why the pivot table date group feature is disabled, grayed out, or does not work, and a few quick tips for finding the problem.
Skill level: Beginner
Bottom line: Learn about the pivot cache that creates an invisible relationship between slicers and pivot tables. I also explain how to fix and prevent the connected filter controls error.
Skill level: Beginner
Grab My Free Cheat Sheet!
VLOOKUP Essentials Guide
