Get our FREE VBA eBook of the 30 most useful Excel VBA macros.

Automate Excel so that you can save time and stop doing the jobs a trained monkey could do.

Claim your free eBook

Recent Blog Posts

Calculate days in Excel How to subtract dates in Excel to get days
Powre Query - Combine All Files in Folder Get data from folder in Power Query: combine files quickly
Advanced Excel Formulas (Alan Murray): Book Give Away
8 quick ways to open a new instance of Excel (+1 hard way)

Power Query - Files in a FolderPower Query - Files in a Folder List files in a folder & subfolders with Power Query
Combine or Append Queries Power Query Append: Quickly combine many queries into 1
VBA Code Snippets VBA Tables and ListObjects
Power Query - Using Parameters Power Query Parameters: 3 methods + 1 simple example

Hiding named ranges in Excel Hide named ranges in Excel: 4 simple ways
Power Query - Basic Transformations Common Power Query transformations (50+ powerful transformations explained)
Excel Rounding vs PQ Rounding Excel rounding vs Power Query rounding: WARNING They are different
Excel calculates the wrong result - Featured Image Excel can calculate the wrong results: WARNING