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

FILTER by a list - featured image How to FILTER by a list in Excel (including multiple lists)
Number Formats for accounting and finance Excel number formats for accounting & finance you NEED to know
How to expand columns dynamically in Power Query
How to run Excel macros from Power Automate Desktop

Create WS for each item in PT How To Create Sheets For Each Item In PivotTable Field
PQ Data By Position Power Query: Get data when sheet/Table names change (2 ways)
QR Codes in Excel How to create QR codes in Excel for FREE (3 easy ways)
Move data between workbooks PA and OS Move data between workbooks (Power Automate+Office Scripts)

Power Query - filter by a list How to filter by a list in Power Query (4 methods)
One Button Any Macro How to run any macro from one button (magic macro)
Get data from SharePoint with Power Query - Featured image How to get data from SharePoint List with Power Query
AUTOCOMMENTARY Automatic commentary writing formula in Excel – Amazing LAMBDA