Microsoft Excel tips and tricks

• 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.

• 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.

• 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.

• Page 1 of 8
• Next 10 Results