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.
In this tutorial we’ll take a look at hiding a worksheet in Excel, but more importantly, how to “very hide” a worksheet to keep prying eyes away from your sensitive data.
In this tutorial we will use the AND function along with SUM and MOD in Data Validation to control the distribution of inventory to various locations.
In this tutorial we will look at the tool Excel offers called Selection Pane, that you can use to manage the objects in your worksheet.
In this tutorial we are going to see how we can use an array formula using IFERROR, INDEX, SMALL, IF and ROW functions to create a dynamic, filtered list without using any built-in Excel functions like Filter to accomplish this.
In this tutorial we are going to look at two ways of using VLOOKUP to pull data from a range of multiple columns at one time. One option will utilize an array formula using an array constant.