Excel Tips
Excel 2024: Replace Nested IFs with a Lookup Table »
July 15, 2024
A long time ago, I worked for the vice president of sales at a company. I was always modeling some new bonus program or commission plan. I became pretty used to commission plans with all sorts of conditions. The one shown in this tip is pretty tame.
Excel 2024: Preview What Remove Duplicates Will Remove »
July 9, 2024
The new Remove Duplicates tool added in Excel 2010 was a nice addition. Remove Duplicates is found on the Data tab. It is to the right of the Text to Columns command and is often collapsed into a single column of 3 icons: Flash Fill, Remove Duplicates, and Data Validation.
Excel 2024: Twelve Benefits of XLOOKUP »
July 8, 2024
The new XLOOKUP function has been rolled out to Office 365 in November 2019. Joe McDaid of the Excel team designed XLOOKUP to unify the people who use VLOOKUP and the people who use INDEX/MATCH. This section will discuss the 12 benefits of XLOOKUP.
Excel 2024: Troubleshoot VLOOKUP »
July 4, 2024
VLOOKUP is my favorite function in Excel. If you can use VLOOKUP, you can solve many problems in Excel. But there are things that can trip up a VLOOKUP.
Excel 2024: Handle Multiple Conditions in IF »
July 1, 2024
When you need to do a conditional calculation, the IF function is the answer. It works like this: If
Excel 2024: Turn Data Sideways with a Formula »
June 28, 2024
Someone built this lookup table sideways, stretching across C1:N2. I realize that I could use HLOOKUP instead of VLOOKUP, but I prefer to turn the data back to a vertical orientation.
Excel 2024: Calculate Nonstandard Work Weeks »
June 25, 2024
It certainly seems that if you work anything other than Monday through Friday or have a year ending any day other than December 31, a lot of things in Excel don’t work very well.
Excel 2024: Use Function Arguments for Nested Functions »
June 24, 2024
The Function Arguments dialog shown above is cool, but in real life, when you have to nest functions, how would you use this dialog?
Excel 2024: Discover New Functions by Using fx »
June 20, 2024
There are 400+ functions in Excel. Instead of taking 450 pages to describe every function, I am going to teach you how to find the function that you need.