Microsoft Excel tips and tricks

New Excel function redefines formula building

LAMBDA lets you to define your own custom functions without having to know VBA or JavaScript.
Modelling inventory in Excel: Fee FIFO fumbles

It’s not pretty but a formulaic solution is possible when using first-in, first-out basis.
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.