Microsoft Excel tips and tricks

• How to LOOKUP the data you want to find in an Excel range

  Many options exist to search for data in Excel, but what do you do if the data is in a range?

• Identify external links in Excel without using VBA

  Take a LINKS function stored as a defined range name and Transpose it via dynamic arrays.

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

• Page 1 of 8
• Next 10 Results