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

When you should merge cells in Excel – 3 scenarios
Cross filter visuals in Excel How to make cross filter visuals in Excel (amazing interactive visuals)
Power Query - Rename Columns - without errors Power Query: Rename columns in nested tables from list (without errors)
How to create Multiple PDFs from Excel (Office Scripts + Power Automate)

Power Query - Fiscal Year, Month, Quarter How to add fiscal Month, Quarter or Year Column in Power Query
Power Query Replace Values Based On List Power Query: How to multiple replace values based on a list
Transform Nested Tables in Power Query How to transform nested tables in Power Query (without coding)
Find & Replace Multiple Words How to Find & Replace multiple words in Excel: REDUCE & SUBSTITUTE

Interactive View Only Dashboard How to make an interactive view-only dashboard from Excel
Power Query: How to Combine files based on a list
Dynamic Text - TEXT + Number Format How to create dynamic text in Excel (TEXT + Number Formats)
Waffle Charts in Excel Online How to make Waffle Charts in Excel that work EVERYWHERE!