Navigate with ease and Excel's tabs Master. Toolbar newly backstage look Perform various calculations. Write a formula to figure rounding, calculate mortgage payments, and more Organize your data sorting. Search,, and the large number of filters trends Illustrate information. Bring your data to life with charts and graphs - including miniature graph called Sparklines Quick Check Restore your data. information and discover hidden patterns of pivot tables slicers and Sharing with older spreadsheets. Use the Excel Web App to collaborate with colleagues online Rescue version of the missing. data spreadsheet data and discover you forgot to save Microsoft Excel? S Top 5 Tricks 1. Page break preview - In page break preview mode (choose View -> Workbook Views -> Page Break Preview), you can see how the worksheet will be printed is divided in several pages. For example, if you see some data to the right side that does not fit on your page, you can drag the page break to the right so it does not. Just choose File -> Info, click the Manage button versions, and select Recover unsaved Workbooks to find that the Excel spreadsheet is not saved automatically stores. 3. Lookup formula - If you understand how to use it, lookup formula gives you a powerful way to copy information from one part of the spreadsheet to another. Formula Tracing - Sometimes the formula is wrong, and the result is information that does not make sense (or error code). Excel formula for tracing feature is a great help if this occurs in a complex spreadsheet. Basically, the trace formula gives you a way to graphically "see" how the formula you are connected to all your data, and often help you find a problem making cells that cause the problem. 5.