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
Category: Microsoft
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
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