This tutorial came from a recent request on how to calculate the number of room reservations needed each night for an event. I came up with two solutions, one using the IF and AND functions, and the other using COUNTIFS.
In this tutorial we’ll take a look at how to use the Watch Window feature in Excel. This tool is a great way to keep an eye on other areas of your workbook or even other workbooks while managing your data.
In this tutorial we will take a look at two rarely used options in Excel – Bing Maps and People Graph. These appeared in Excel 2013, and although I’m not expert in them, I at lease want to show you the basics of these features.