Excel Tutorials (Blog)

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

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

Select Adjacent Ranges Cover 640

Keyboard Shortcuts, Macros & VBA, Tips & Shortcuts

Excel Shortcuts to Move the Selected Range with the Arrow Keys

April 26, 2018

Library, Power Pivot/Query/BI, Power Query

How to Fill Across Blank Cells in Rows with Power Query

April 12, 2018

5 Uses for Macros Thumb

Macros & VBA

5 Uses for VBA Macros in Excel with Your Job

April 10, 2018

3 Tips for Writing Formulas with Macros 640thumb

Formulas, Macros & VBA

3 Tips for Writing Formulas with VBA Macros in Excel

April 2, 2018

Formula Challenge - First Sale Lookup

Formulas, Tips, Tips & Shortcuts

Formula Challenge: Find the First Transaction for Each Month

March 14, 2018