Create SUBTOTAL Formulas with the AutoSum Button or Keyboard Shortcut
Bottom line: Learn how to use the AutoSum feature and keyboard shortcut to create SUBTOTAL formulas.
Skill level: Beginner
The For Next and For Each Loops Explained for VBA & Excel
Bottom line: The For Next Loops are some of the most powerful VBA macro coding techniques for automating common tasks in Excel. This article explains how the loop works to repeat actions on a collection of items, which saves us a ton of time with our jobs.
Skill level: Intermediate
Automatic Default Number Formatting in Excel Pivot Tables
Bottom line: Save tons of time by automatically formatting the numbers in the Values area of your pivot tables with a VBA macro. Number formatting is automatically applied when you drag a field into the Values area in one single step.
Skill level: Intermediate
The Calendar Table (Date Dimension) Explained for Power Pivot & Power BI
Bottom line: In this post we will learn what a Calendar Table or Date Dimension Table is, and how we can use it to create pivot table reports on multiple data sources.
Skill level: Intermediate
Reverse Partial Match Lookup to Filter for a List in Excel
Bottom line: Learn how to filter for a list of items using a reverse partial match lookup.
Skill level: Intermediate
2 Ways to Filter for List of Items in Excel + Video Tutorial
Bottom line: Learn 2 ways to filter for a list of multiple items in Excel in this article and video tutorial.
Skill level: Beginner
3 Tips to Save and Close All Open Excel Workbook Files + Macro
Bottom line: Learn a few shortcuts and tips to save and close all open Excel workbooks.
Skill level: Beginner
New Update to the List Search Add-in
The List Search Add-in has become very popular. This simple add-in allows us to quickly search any data validation list. It has additional features to search lists in cells without validation, and even create lists of unique values.
Create Multiple Pivot Table Reports with Show Report Filter Pages
Bottom line: Learn how to quickly create multiple pivot table reports with the Show Report Filter Pages feature. Video tutorial below.
Skill level: Beginner
How to Create a List of Random Numbers with No Duplicates or Repeats
Bottom line: Learn how to create a list of unique random numbers with no duplicates or repeats.
Skill level: Easy
