Excel Tutorials (Blog)

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

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

Table Number Formatting Doesn't Copy Down

Macros & VBA, Tables & Data

Why Table Number Formatting Doesn’t Copy Down and How to Fix It

March 8, 2018

How to turn off GETPIVOTDATA formulas in Excel Pivot Tables

Pivot Tables

How to Turn Off GETPIVOTDATA Formulas for Pivot Tables

February 28, 2018

Pivot Table Grouped Day Field Number Formatting

Macros & VBA, Pivot Tables

How to Change Date Formatting for Grouped Pivot Table Fields

February 15, 2018

Expand Collapse Entire Pivot Field Macro - Rows Area

Macros & VBA, Pivot Tables

Expand and Collapse Entire Pivot Table Fields – VBA Macro

February 6, 2018

2 Critical VBA Assumptions Video Thumb 640

Macros & VBA

VBA Assumes the Active Workbook and Active Worksheet in Excel

January 24, 2018

Create Show Details Sheet Only Displays Used Fields Columns of Pivot Table

Macros & VBA, Pivot Tables

Only Display Used Fields on Pivot Table Show Details Sheet

January 18, 2018