Microsoft Excel tips and tricks

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.
How to build an Excel model for revising forecasts

With a little algebra and a lot of flexibility, spreadsheet builders can set up a forecasting model that handles simultaneous changes in multiple parameters.
Excel unveils function that improves on VLOOKUP

They aren’t yet generally available, but they look like an X-cellent matched set.