If you often work with large spreadsheet files, you know how frustrating it can be to lose data because of a stupid mistake or because your computer crashed while you were working with your data.

Go here to read the rest:
Recover Lost Data Using Excel’s Automatic Backup Feature

Excel is one of the most popular applications for both the home and office in Microsoft’s suite of productivity software.

Read more:
Freeze Panes to Make Excel Spreadsheets Easier to Use

Every once in a while, an application’s feature is so simple and obvious that it goes overlooked even by those who use the program regularly. Excel’s zoom capabilities is a good example of an overlooked feature that can increase your efficiency when working with both large and small spreadsheets. Since we can’t change the size of our monitors and it is inconvenient to quickly adjust a monitor’s resolution, you are stuck with what is displayed on the screen with every application you use.

View original post here:
Use Excel’s Zoom Features for Greater Efficiency

Sometimes a powerful feature in an application gets lost among the others so much so that it never gets the recognition it deserves to help us get our work done more efficiently. Excel’s Watch Window is a great example of such as feature. If you use Excel to keep track of important information for a small or home-based business, you know that your client lists, contact databases, and invoicing documents can becomes so large that you are constantly scrolling to see the information you need to see

Link:
Use Excel’s Watch Window to Monitor Important Cells in a Workbook

Tracing Excel formula errors is tedious, if not guided by the built-in formula auditing tools.  The formula bar itself is a good starting place to debug formula errors but when the formula gets longer and more complicated, a visual guide to trace the dependents is a great help. You can use the Trace Precedents button on the Formula Auditing toolbar to trace all the generations of cells that contribute to the formula in the selected cell (something like tracing all the ancestors in your family tree). Many times, finding the original source of the formula leads you right to the source of all the error values in your spreadsheet

See the original post:
How to trace formula dependents in Excel