Excel Tutorials (Blog)

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

the-table-of-contents-image-gallery-for-excel

Macros & VBA

How to Add a Table of Contents Image Gallery Sheet to Your Excel Files

October 5, 2016

pivot-table-group-field-button-disabled-not-working-for-dates

Pivot Tables

Why the Pivot Table Group Field Button is Disabled for Dates

September 28, 2016

how-slicers-and-pivot-tables-are-connected

Pivot Tables

How Slicers and Pivot Tables are Connected + Filter Controls Error

September 21, 2016

The Filter Columns Macro Thumbnail 640x360

Macros & VBA

Hide & Unhide (Filter) Columns with a Slicer or Filter Drop-down Menu

September 1, 2016

Excel Add-in Ribbon Disappeared - Windows Security Update Unblock

Macros & VBA

Excel Add-in Ribbon Disappears After Installation

August 6, 2016

Calculate Percentage Change with Negative Numbers

Formulas

Calculate Percentage Change for Negative Numbers in Excel

August 1, 2016

Percentage Change Formula Creator Macro for Excel

Formulas, Macros & VBA

How to Quickly Create Percentage Change Formulas with a Macro

July 12, 2016

Library, Macros & VBA

Excel VBA Code to Reference Column Numbers Instead of Letters

June 29, 2016

Keyboard Shortcut to Jump To Any Row or Column in Excel

Keyboard Shortcuts, Macros & VBA, Tips & Shortcuts

Keyboard Shortcut to Jump to Any Row or Column

June 21, 2016