Organize your data. A lot of
Description trends. Make your data, charts and graphics – including a small chart of life known as the Mini Figure
Check your data. Summary information found the hidden mode PivotTable slicer
Share your spreadsheet. Excel Web App to collaborate online with colleagues
Rescue lost data. You forgot to save and restore the old version of the data and spreadsheets
Five skills in Microsoft Excel
1. Page Break Preview – Page Break Preview mode (select “View” -> “workbook View -> Page Break Preview), you can see that you print the worksheet will be split across multiple pages. More valuable is the ability of a page break, drag it to a new place. example, if you find the right side of the data does not fit on your page, you can drag the right side of the page breaks, so that it When you do, your entire worksheet Excel scale, in order to adapt to the information you want.
2. Recover unsaved work – Ever since the beginning of a new workbook, and then forget to save it when you close Excel hurry? Now you can get your lost his job. Simply select “File” -> “Information”, click the “version” button, and choose to find unsaved spreadsheet, Excel will automatically restore unsaved workbook.
3. Find a formula – if you know how to use them to find the formula to provide a powerful way for you to copy information from one part of the spreadsheet to another. For example, you can use the Find a formula to create invoices automatically correct product and price information, when you enter a product code. Under normal circumstances, you would expect this solution requires a macro or Visual Basic, but that is not the case.
4. The formula for tracking – Sometimes the formula is a problem, the result is not significant (or error code). Excel formula tracking feature is a great help, if this happens in a complex spreadsheet. When you use it, Excel saves it from the source cell formula, use the arrow cells. Essentially, the formula for tracking your provides a graphical way to “see” your formula is how to connect to the rest of your data, it can often help you find troublemakers cells and cause of the problem.
5. Chart tips – charts tell a story with your data, there are a lot of techniques that you can use, so that they render the story more clearly and decisively. Example: change the size of the chart, increase coverage, change a series of specific filling, insert text and graphics directly on the surface in the chart, and so on, have a huge impact. The chart of the differences between them, convey useful insights, this is just a bit of spreadsheet decoration.
Show more
