Microsoft Excel tips and tricks

Taking stock of inventory calculations in Excel

Our Excel MVP brings clarity to one of the most confusing aspects of spreadsheet modelling.
An introduction to Microsoft Power BI

Extract, transform, and analyse data with business intelligence software frequently seen as the next step after Excel.
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.