Microsoft Excel tips and tricks

• Excel: How to count unique items in a list

  Using dynamic arrays, PivotTables, and the SUMPRODUCT function are three approaches to this common task.

• Excel: How to reference a row dynamically

  Excel MVP Liam Bastick explains the OFFSET(COUNTA) function combination, used for dynamic lookups.

• Excel: Broken y-axis charting

  Breaking the y-axis on a chart can be a useful way to display data, but the technique should be used with discretion, says Excel MVP Liam Bastick.

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

• Page 1 of 8
• Next 10 Results