Corrupted Spreadsheets: How to Recover The Data?

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 […]

Read More

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.

Read More

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’s Operators CHEAT SHEET

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 […]

Read More
Recover Unsaved Excel File

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 […]

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