Microsoft Excel tips and tricks

How to use Excel Power Query's best feature

Column From Examples can help alleviate or even eliminate mundane repetitive work tasks.
Automate bank reconciliations with Excel Power Query

Want to reconcile data files in a heartbeat? This article shows how to make it happen.
Transform data with Excel Power Query

This tool allows you to eliminate tedious repetition when inputting CSV files.
Analysing future cash flow in Excel

How businesses can calculate how much cash they really need today to not run out tomorrow.
Modelling working capital adjustments in Excel

Learn how to manage your all-important cash with these Excel spreadsheet skills.
Ideas for data analysis in Excel

The AI-powered tool lives up to its name by generating visualisation options from data.
Top 5 Excel functions you might not know

Our Excel MVP unveils a fistful of functions that pack a real punch.
Converting dates to and from US format in Excel

Working with a spreadsheet from a country where the date format differs from yours can cause real problems. Here’s how to solve them.
Prorating over time in Excel

Avoid building a complicated formula in your model with a ‘step it out’ approach.
Excel adds new argument to XLOOKUP

Though not yet generally available, the new function gets a rare syntax shakeup.