Microsoft Excel tips and tricks

Building Excel models with S-curves

Want to visually depict costs over time? There’s a dynamic array to do that.
Automate tasks in Excel with Office Scripts

Visual Basic for Applications (VBA) doesn’t play well online, but this tool can get you back on script.
Highlighting chart data in Excel

A series approach can produce conditional formatting that changes dynamically.
An Excel way to calculate key depreciation component

Try this approach to determine the optimised economic life of a noncurrent asset held for continuing use in a business.
Working with ME to test Excel's new LAMBDA function

Our Excel MVP Liam Bastick, FCMA, CGMA, plays with triangle numbers to illustrate how to address a recursion problem.
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.