Create an Excel Drop-Down List Including an IF STATEMENT
Microsoft Excel Tips and Tricks I demonstrate how to create a drop-down list in Excel that includes an IF Statement.[…]
Read more
Author: Noel
Excel IF Range Contains Value | How to Perform an IF Statement on a Range
Microsoft Excel Tips and Tricks I demonstrate how to create an IF formula that performs a test across a range[…]
Read more
Conditionally Format Based on Adjacent or Previous value
Microsoft Excel Tips and Tricks I demonstrate how to conditionally format cells based on an adjacent or previous value. This[…]
Read more
How to Count / COUNTIF Items Across Multiple Worksheets in Excel
Microsoft Excel Tips and Tricks The method I demonstrate requires you to house all your data in Excel tables and[…]
Read more
Excel Slicers – The Cool Way to Filter Data!
Microsoft Excel Tips and Tricks This is a look at Excel Slicers, including tips, and how you can use them[…]
Read more