Category Archives: Excel



VLOOKUP vs INDEX-MATCH

There are numerous lookup functions in Excel, and often, their capabilities overlap. And, that is true with many things in Excel…there are often multiple ways to accomplish any given task. Performing lookups is no exception. So, how are we supposed to know which lookup function to use? Often, Excel users try to decide between VLOOKUP […]







23 Excel Tips

My Excel friend John Michaloudis put together an excellent podcast a few weeks ago, where he interviewed 23 Excel experts and asked them to give their favorite Excel tip. The tips include shortcuts, functions, features, and design principles. It is a terrific collection of ideas to help as you head into 2017. If you’d like […]


Excel Dates and Times Article

Have you ever tried to do some type of calculation with a time value in Excel, only to receive a strange result? Two examples are adding up hours on a time sheet and multiplying the number of hours worked by a pay rate. If you’ve tried something like this and encountered an unexpected result, the […]