Tutorials (Blog)

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

Copy VBA Code to Other Workbooks Video Thumb 640

How to Copy or Import VBA Code to Another Workbook

October 11, 2018

New Excel Features: Dynamic Array Formulas & Spill Ranges

October 3, 2018

Table of Contents Automatic Updates Video Thumb 640

Excel Table of Contents that Automatically Updates

September 26, 2018

Macro Buttons to Add Remove Fields to Pivot Tables

Macros & VBA, Pivot Tables

Macro Buttons to Add Fields to Pivot Tables

September 20, 2018

2 Ways to Assign Keyboar Shortcuts to Macros - Video Thumb 640

Keyboard Shortcuts, Macros & VBA, Tips & Shortcuts

2 Ways to Assign Keyboard Shortcuts to Macros

September 13, 2018

Excel Hash Episode 1 Contenders

Charts & Dashboards, Tips, Tips & Shortcuts

Excel Hash: Episode 1 – Dynamic Histogram

September 5, 2018

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