Excel 2024: See Intermediate Calculations

January 13, 2025 - by Bill Jelen

My friend Mike Girvin at the ExcelisFun YouTube channel has a great trick when explaining a long formula. Mike will select part of the formula in the formula bar and press F9 to calculate just that part of the formula. It is a cool trick, but you must remember to press Escape or you will hard-code the intermediate results in the formula.

In 2023, the Excel team provided a better alternative. If you select part of the formula in the formula and pause for a few seconds, a tooltip appears with the intermediate results. Here is an example showing the array stored in the Passcodes named range:

More Reading

Excel 2024: Check Performance in Excel »

January 9, 2025 - by Bill Jelen

A new feature debuted in 2023. Go to the Review tab and choose Check Performance. If you have a workbook that you've been using for years, you should check performance. It looks for excess formatting, unused cell styles, unneeded metadata that can slow your workbook down.

Excel 2024: Prevent Default Conversions »

January 3, 2025 - by Bill Jelen

Since the beginning of time, Excel has performed some annoying conversions. The conversions happened automatically when you imported from a CSV or Text file, Pasted from another application, or typed data in Excel.

Excel 2024: Checkboxes »

December 31, 2024 - by Bill Jelen

In late 2023, Microsoft added a checkbox icon to the Insert tab. As I write this in January 2024, the feature is still in beta. Adding a checkbox to a cell seems to be a special number format that displays True/False values as either checked boxes or unchecked boxes.

Master Your Data with Power Query in Excel and Power BI

August 2021

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.

The Transformative Magic of Power Query M Code in Excel and Power BI

August 2024

A beginner’s guide to mastering the art of data metamorphosis to get just the data structure needed to create insightful data analysis solution

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

December 2021

Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions.

MrExcel 2022 Boosting Excel

April 2022

The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.

see more products »

Excel 2024: See Intermediate Calculations

More Reading

Featured Products