VBA vs Power Query vs Office Scripts: Which Should You Use to Automate Excel Reports?
Excel VBA vs Power Query vs Office Scripts (and Python): what each is good at, a decision table by task, and the setup I use to automate reports.
Practical guides on automating reports, building dashboards and cleaning data in Excel.
Excel VBA vs Power Query vs Office Scripts (and Python): what each is good at, a decision table by task, and the setup I use to automate reports.
Learn the Excel GROUPBY function and PIVOTBY with worked examples: monthly totals, filters, sorting, multiple columns, and how they compare to PivotTables.
Excel stuck on "Calculating (12 threads)"? Find out what slows your workbook down and fix it: bloat, volatile formulas, heavy lookups, links and queries.
Copilot in Excel can now edit your workbook directly. Here's what it does well in business reporting, where it falls short, licensing and data privacy.
Combine multiple Excel files into one with Power Query: load a whole folder, handle different columns and sheet names, add checks and refresh in one click.
Learn how to put multiple values in one cell in Excel, then combine, split, look up and count them with TEXTJOIN, TEXTSPLIT, FILTER and simple formulas.
Manual reporting wastes time and money. Discover the hidden costs it creates—and how automation in Excel can fix it for good.
Manual spreadsheets slowing your team down? Discover five key signs your business is ready for Excel automation and how it can boost productivity.
Learn how to clean messy, inconsistent data in Excel using built-in features, Power Query, and smart validation techniques.
Learn what Power Query is, how it works in Excel, and why it can save your business hours by automating data import and transformation.
Tired of repetitive Excel work? Learn how to use macros to automate your monthly reports and save hours of manual effort every month.
Learn how to create a dynamic, interactive dashboard in Excel to visualize KPIs, track performance, and impress your stakeholders.
Unsure whether to use Excel or Power BI for your reports? We break down the differences and help you choose the right tool for your needs.
Learn how to track and visualize procurement KPIs using Excel. Includes step-by-step setup and a downloadable template to get started.