Recently we’ve talked about how to hide and very hide worksheets in Excel. In this tutorial we’ll look at how to hide an Excel workbook and why you may want to do that.
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.