In this video, I demonstrate how to create a histogram chart in Excel. I show three methods: Create a histogram chart in Excel 2016, 2019 and Excel 365, using the in-built histogram chart type. Create a histogram chart in Excel 2013 and earlier using the FREQUENCY function to calculate the frequency value for each… Read More »Make a Histogram Chart in Any Version of Excel | Change Bin Size or Number of Bins
In this video I demonstrate how to exclude values when performing a COUNTIF. Normally when you perform a COUNTIF you want to specify which values to count. What if you want to count everything but… I show you how to exclude a single value or multiple values in your COUNTIF calculation. The functions used… Read More »How to Exclude Values in COUNTIF | COUNTIFS NOT EQUAL to Multiple Text | Exclude Values from List
In this video I demonstrate how to create a drop-down list in Excel that includes an IF Statement. The IF statement allows you to display one of two lists in a single drop-down. In our scenario, we have two wedding lists that we want to display in a single drop-down. By default, the drop-down… Read More »Create an Excel Drop-Down List Including an IF STATEMENT | Conditional Drop-Down List