Excel Tutorials (Blog)

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

Automate Filters with VBA Macros - AutoFilter Guide

Macros & VBA, Tables & Data

The Ultimate Guide to Excel Filters with VBA Macros – AutoFilter Method

July 12, 2018

VBA AutoFilter Automate Date Filters

Macros & VBA

How to Filter for Dates with VBA Macros in Excel

July 12, 2018

VBA AutoFilter Automate Text Filters

Macros & VBA

How to Filter for Text with VBA Macros in Excel

July 12, 2018

5 Ways to Select Multiple Shapes Video Thumb 640

Charts & Dashboards, Tips, Tips & Shortcuts

5 Ways to Select Multiple Shapes

July 5, 2018

How To Calculate Daily Averages with Pivot Tables Video Thumb 640

Pivot Tables, Power Pivot, Power Pivot/Query/BI

How to Calculate Daily Averages with a Pivot Table

June 26, 2018

Shape Grid Macro Video Thumb 640

Charts & Dashboards, Macros & VBA

How to Arrange Panel Charts or Shape Grids in Excel with a VBA Macro

June 12, 2018

2 Ways to Align & Space Shapes in Excel Video Thumb 640

Macros & VBA

2 Ways to Align & Space Shapes, Charts, or Slicers + VBA Macro

June 6, 2018

Automatic Dynamic Pivot Chart Titles Video Thumb 640

Charts & Dashboards, Macros & VBA

Create Dynamic Pivot Chart Titles with a VBA Macro

May 23, 2018

Chart Templates Video Thumb 640

Charts & Dashboards

How to use Chart Templates for Default Chart Formatting

May 9, 2018