Excel Formula Errors & How To Deal With Them

Error messages can be especially bad if they show up on end-user worksheets like reports and dashboards. Fortunately, Excel has a way to catch errors like #VALUE!, #NUM!, and #REF! before they show up. Learn how to handle error messages in Excel here…

Read More
Excel VBA

Excel VBA Macro Adds IfError() Functions To Every Formula

Today I found some useful code I wanted to share with our readers. A macro to automatically add an IfError() function to every formula on every sheet in a selected workbook, assuming there was not already an IfError function used. Remember that macros have no Undo command. Once you run this VBA macro the only undo is to close […]

Read More
10 Top Excel Keyboard Shortcuts

The 10 most useful Excel keyboard shortcuts

The 10 most useful Excel keyboard shortcuts Why complicate your spreadsheet life with a bunch of tricks you’ll never use? These 10 shortcuts will expedite the Excel tasks you perform every day. It’s great to know the resources are out there. But on a practical level, mastering 10 genuinely useful shortcuts will get you a […]

Read More
Learn to Debug Formulas in Excel

Learn to Debug Formulas in Excel

Learn to Debug Formulas in Excel Have you ever wondered how to Debug a complex Formula and fix the error quickly?? We all know how painful it is when an excel formula returns a mysterious error and we don’t know what is causing it. Assuming we have a simple formula like this =IF(D5>22000,650,IF(D5>18000,450,250)) and we […]

Read More