Blog & Excel Tips

Stop excel users from inserting or deleting rows with 3 methods covering normal protection, only protecting rows and columns, or VBA and protect free stops.

IF function not working with numbers so for example the test 0<5 ends with a FALSE instead of the correct answer

Improve your Excel presentations and dashboards with free stock images built automatically into MS Excel

XNPV and effective rate. Why you MUST use the EFFECTIVE rate for the discount rate when using XNPV and nominal when using NPV in Excel

Sum all the negative numbers in Excel by adapting a SUMIFS function with tricks that will tell Excel to look for numbers smaller than zero (and similar)

Average excluding outliers in MS Excel to get a more realistic average without being affecting by very big and very small anomalies

Change the name of items directly in the Pivot Table, so that the Pivot Table remembers it and applies your preferred name going forward without touching the database

Add the happy face emoji into Excel and turn it green, as well as adding sad (red) and neutral (yellow) face emojis to your Excel cells.