Excel Tips
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.
Excel 2024: Audit a Worksheet With Spreadsheet Inquire »
June 18, 2024
Inquire was developed by a company called Prodiance that offered the slick Spreadsheet Compare tool for $145 per person per year. The Excel team liked it so much that Microsoft bought out Prodiance and gave the tool for free to anyone who is on Pro Plus, Professional Plus, or Enterprise Level E3.
Excel 2024: See All Formulas at Once »
June 17, 2024
You inherit a spreadsheet from a former co-worker and you need to figure out how the calculations work. You could visit each cell, one at a time, and look at the formula in the formula bar. Or you could quickly toggle between pressing F2 and Esc to see the formula right in the cell.
Excel 2024: Quickly Convert Formulas to Values »
June 13, 2024
I always say there are five ways to do anything in Excel. Converting live formulas to values is a task that has far more than five ways. But I will bet that I can teach you two ways that are faster than what you are using now.
Excel 2024: Use F4 for Absolute Reference or Repeating Commands »
June 12, 2024
The mighty F4 key should be in your Excel arsenal for two completely different reasons.