Excel Graph – Ignore Blank Cells | Hide #N/A Values | Stop Line Graph Dropping to Zero
Microsoft Excel Tips and Tricks In this video I explain how to ignore the following when creating a chart in[…]
Read more
Category: Excel
How to Combine Multiple IF Formulas in Excel
Microsoft Excel Tips and Tricks You wrote some IF functions to assign a score based on numerical ranges. You want[…]
Read more
Conditional Formatting with Icon Sets in Excel
Microsoft Excel Tips and Tricks Conditional formatting in Excel has an Icon Set feature. Icon Sets have a variety of[…]
Read more
Excel Moving Average with Analysis TookPak Add in
Microsoft Excel Tips and Tricks In Excel, you can create a moving average, also called a rolling average or running[…]
Read more
7 Things You’re Doing WRONG in Excel
Microsoft Excel Tips and Tricks These are common mistakes that most people (including me) make in Microsoft Excel every single[…]
Read more