I decided to start the new year off right with a new release.
When I originally wrote 50 Useful Excel Functions I chose those functions from a list of about 125 total functions I thought could be really useful to someone. I didn’t want to write them all up in one book because that’s just too much to handle for the average user in my opinion.
But it wasn’t easy to narrow that list down either, because which functions a user considers most useful will very much depend on why they’re using Excel. I also had to include in that book certain functions just for completeness sake. If I was going to discuss X function then I also really needed to discuss Y and Z functions, too.
Which meant that I was left with about a hundred functions that I didn’t cover in the first book but that I figured a certain number of users might want to know about.
Well, now I’ve covered another batch of them in 50 More Excel Functions.
This one really digs into some of the date and time functions and discusses the quirks of how Excel handles dates, at least one of which threw me a nasty surprise on a work project a few years ago. Hint: Don’t work with really old dates in Excel, it doesn’t turn out well.
Anyway. Happy new year. Enjoy.