Confirmed

You have been removed from the notification list on the dashboard course and free webinars.  Please contact me if you clicked this link in error and would like to continue receiving these notifications.

 

Checkout the latest blog posts

Macro Buttons to Add Fields to Pivot Tables

Bottom Line: Learn how to create simple macro buttons that users can click to instantly add or remove fields to Excel pivot tables.Skill Level: Intermediate.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container embed { position: absolute; top: 0; l [...]

Continue reading»

2 Ways to Assign Keyboard Shortcuts to Macros

Bottom Line: Learn two different ways to create keyboard shortcuts to run macros, and discover the pros and cons for both methods.Skill Level: Intermediate.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container embed { position: absolute; top: 0; lef [...]

Continue reading»

Excel Hash: Episode 1 – Dynamic Histogram

Have you heard about Excel Hash yet?  This is a contest between a few Excel YouTube channels to create a solution based on four main ingredients (Excel features).The concept is similar to popular cooking TV shows like Chopped, where the chefs must prepare a dish using a few main ingredients.[...]

Continue reading»

Refresh Pivot Tables Automatically When Source Data Changes

Bottom Line: Learn how to use a simple macro to refresh pivot tables automatically whenever changes are made to the source data.  I also share a non-macro solution to update the pivot tables when the file is opened.  Includes video tutorial and Excel file download.Skill Level: Intermediate.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overf [...]

Continue reading»