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
Tag: learn
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
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
How to add a LINE to your charts in Excel – Super easy trick
Microsoft Excel Tips and Tricks This one is a massively simple yet amazingly useful. Use a calculated column to add[…]
Read more
VBA to Automate Sending Email From Excel Table with Attachment from Folder
Microsoft Excel Tips and Tricks In this video I demonstrate how to automate sending emails (including attachment) from Excel. Credit[…]
Read more