On one hand MS Excel offers some advanced features. On the other hand, it may create some serious problems like file corruption. This problem becomes big if we do not take a corrective measures to handle the file corruption. There are several factors which are likely to be responsible for spreadsheet corruption: Virus infection and […]
Articles Tagged: Debugging Tips
How to Reduce Size of Excel Files? – Top 10 Tips
Did you ever wonder why your Excel File is so huge while it actually has very little information?
When you receive an excel file it was in KBs but when you make changes and save, file size surprisingly increased to MBs!! Fortunately there are several ways to overcome this problem, this article will help you learn the Top Ten Awesome Tips & Tricks to Reduce Excel File Size to a great extent without losing the actual content.
Excel Circular References – How to deal with them?
In Excel, a circular reference is created when you refer to same cell either directly or indirectly. Learn more about Excel Circular References here.
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…
Excel’s Operators CHEAT SHEET
Excel’s Operators CHEAT SHEET Believe it or not, Excel has 16 infix operators, 5 match fix operators, 3 prefix operators and a postfix operator. Infix Operators + Addition – Subtraction * Multiplication / Division ^ Exponentiation > is Greater than < is Less than = is Equal to >= is Greater Than or Equal to […]
How to recover unsaved excel file?
Recover Unsaved Excel File At times you get into a scenario when you have worked on a file and it is closed, for some reason, without being saved. It results into data lose to the extent it is not saved. If you are interested in learning as how to recover unsaved excel file, then keep […]
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 […]