In this tutorial I’ll show you how to have images appear and disappear by using a checkbox from the Format Controls of the Developer tab in Excel.
Tag Archives | Microsoft Excel
In this tutorial we’ll see how we can use Conditional Formatting, using the ISBLANK, COUNTIF, and INDIRECT functions, to verify the accuracy of selections from a Data Validation drop down list in Excel.
You’ve created a spectacular looking chart in Excel, and now need to create another that looks the same, but don’t want to spend all the time and effort remembering how you did it for the second one. In this short tutorial, you’ll see how easy it is to copy the format of a chart from […]
Often in formulas in Excel, we use double quotes to indicate a blank. But in Excel, double quotes do not generate true blank cells. How can we get true blank cells without formulas in Excel? This tutorial will take you through the steps to accomplish this, plus show you a few other valuable tricks like […]
In this tutorial we are going to look at how we can do a lookup in an array by looking up the values in the far right column and returning the result from a column to the left. We are going to use the OFFSET and MATCH functions to accomplish this.
In this tutorial we’ll take a look at the OFFSET function, specifically the difference between using a single cell vs a range of cells for the reference argument, and using it in conjunction with the SUM function.