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.
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.
In this second of a two-part article, Excel MVP Liam Bastick introduces you to new functions that shape and resize 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.