Category Archives: Excel






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 […]


Volume 4 Available!

Alright…Excel University Volume 4 is available! Well, this volume has taken two years to create, but, I believe the time spent was well worth it. It is, without a doubt, my favorite volume in the Excel University series. We mainly focus on internal-use workpapers, and how to get them done the fast way! I think […]


Add and Subtract Hours

Excel time zones by Jeff Lenning

I was recently working on a workbook, and had to convert an event time from one time zone to another. Basically, I wanted to enter the time of day into a cell, and then I needed a formula to compute the event time in a different time zone. This post walks through the formula to […]