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
Category: Excel
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
How to Uncover the Hidden Power Query Function List!
Microsoft Excel Tips and Tricks Hidden inside both Excel and Power BI is a secret Power Query function list that[…]
Read more