Skip to content
Microsoft Excel tips and tricks
Excel MVP Liam Bastick provides a formulaic solution to the common financial modelling issue of how to correctly prorate amounts over time.
In this second of a two-part article, Excel MVP Liam Bastick introduces you to new functions that shape and resize arrays.
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.
This article shows how to set up Excel spreadsheets to efficiently determine weighted averages and avoid common mistakes.
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 trainer Liam Bastick discusses the most common mistake accountants make when using Excel, whether Excel is outdated, and the new LAMBDA function.
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.
How to get a large number of graphs, charts, and other pictures quickly out of a worksheet.
Even experienced spreadsheet modellers can misplace the dollar signs.
Want to visually depict costs over time? There’s a dynamic array to do that.
Visual Basic for Applications (VBA) doesn’t play well online, but this tool can get you back on script.
A series approach can produce conditional formatting that changes dynamically.
Try this approach to determine the optimised economic life of a noncurrent asset held for continuing use in a business.
Our Excel MVP Liam Bastick, FCMA, CGMA, plays with triangle numbers to illustrate how to address a recursion problem.
LAMBDA lets you to define your own custom functions without having to know VBA or JavaScript.
It’s not pretty but a formulaic solution is possible when using first-in, first-out basis.
Our Excel MVP brings clarity to one of the most confusing aspects of spreadsheet modelling.
Extract, transform, and analyse data with business intelligence software frequently seen as the next step after Excel.
Column From Examples can help alleviate or even eliminate mundane repetitive work tasks.
Want to reconcile data files in a heartbeat? This article shows how to make it happen.
