Microsoft Excel tips and tricks

Extracting images from Excel

How to get a large number of graphs, charts, and other pictures quickly out of a worksheet.
Test your skill at cell referencing in Excel

Even experienced spreadsheet modellers can misplace the dollar signs.
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.