1. |
Applying number, date, and time formats
|
|
|
|
2. |
Freezing and unfreezing panes
|
|
|
|
3. |
Hiding and unhiding data, and creating outlines
|
|
|
|
4. |
Setting print titles and page breaks, and using Page Break Preview
|
|
|
|
5. |
Navigating, managing, and printing multiple worksheets
|
|
|
|
6. |
Creating 3-D formulas to link worksheets and workbooks
|
|
|
|
7. |
Adding a Watch window
|
|
|
|
8. |
Using the Consolidate command to summarize data
|
|
|
|
9. |
Linking workbooks, creating external links, and redirecting links
|
|
|
|
10. |
Changing View, General, and Calculation settings
|
|
|
|
11. |
Zooming in and out on a large worksheet
|
|
|
|
12. |
Adding borders and shading to cells
|
|
|
|
13. |
Using built-in templates, and creating and managing templates
|
|
|
|
14. |
Creating, modifying, and applying styles
|
|
|
|
15. |
Merging and splitting cells, and changing cell orientation
|
|
|
|
16. |
Sorting and filtering lists
|
|
|
|
17. |
Using advanced filtering options
|
|
|
|
18. |
Using advanced chart formatting options
|
|
|
|
19. |
Creating combination charts and trendlines
|
|
|
|
20. |
Inserting and formatting graphic elements`Using auditing features
|
|
|
|
21. |
Adding comments and text boxes
|
|
|
|
22. |
Protecting a worksheet
|
|
|
|
23. |
Customizing toolbars and menus
|
|
|
|