Microsoft Excel tips and tricks

Excel: Simple prorating over time

Excel MVP Liam Bastick provides a formulaic solution to the common financial modelling issue of how to correctly prorate amounts over time.

Exploring 14 new Excel functions: Part 2

In this second of a two-part article, Excel MVP Liam Bastick introduces you to new functions that shape and resize arrays.

Exploring 14 new Excel functions: Part 1

In this first of a two-part article, Excel MVP Liam Bastick introduces you to one group of functions that manipulate text and another group that combine arrays.

Calculating weighted averages in Excel

This article shows how to set up Excel spreadsheets to efficiently determine weighted averages and avoid common mistakes.

Excel tips: Top 4 functions to improve efficiency in 2022

Excel MVP Liam Bastick talks about XLOOKUP, SUMPRODUCT, OFFSET, and MOD functions, limitations of the spreadsheet software, and his wish list of changes for Excel.

Excel tips: Power Query, LAMBDA function, and why Excel is still relevant today

Excel trainer Liam Bastick discusses the most common mistake accountants make when using Excel, whether Excel is outdated, and the new LAMBDA function.

Summing a dynamic range in Excel with XLOOKUP

Accountants often want to sum data, such as year-to-date costs and rolling budgets, for a period of time. Excel XLOOKUP makes the process simpler.

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.

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.

Microsoft Excel tips and tricks

Most Read