Tutorials (Blog)

Learn how to use Excel more efficiently with our in-depth articles & videos.

Refresh Pivot Table when Source Data is Changed

Macros & VBA, Pivot Tables

Refresh Pivot Tables Automatically When Source Data Changes

August 28, 2018

7 Keyboard Shortcuts Cells Ranges YouTube Thumb 640

Keyboard Shortcuts, Tips, Tips & Shortcuts

7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel

August 20, 2018

Add New Items to Drop-down Lists Automatically Thumb 640

Tables & Data, Tips, Tips & Shortcuts

How to Add New Rows to Drop-down Lists Automatically – Dynamic Data Validation Lists

August 13, 2018

Excel Tutorial Drop Down Lists in Cells

Tables & Data, Tips, Tips & Shortcuts

How to Create Drop-down Lists in Cells – Data Validation Lists

August 8, 2018

How to Enable the Developer Tab in Excel for Windows

July 27, 2018

Keyboard Shortcuts for Intellisense Video Thumb 2

Keyboard Shortcuts for the VBA Intellisense Drop-down Menu

July 24, 2018

Multiple Macro Buttons to Apply Filters

How to Create VBA Macro Buttons for Filters in Excel

July 19, 2018

VBA Code to Clear Filters in Excel

How to Clear Filters with VBA Macros

July 12, 2018

How to Filter for Colors & Icons with VBA Macros in Excel

July 12, 2018