Unit Standard:
116943
1. Defining and applying names
2. Using the IF, SUMIF and ROUND functions
3. Using the PMT function
4. Using the VLOOKUP, MATCH and INDEX functions
5. Using data tables to project values
6. Creating automatic subtotals
7. Validating data
8. Using database functions
9. Using data forms
10. Creating, rearranging and formatting PivotTables
11. Creating Pivot Charts
12. Importing data from and exporting data to text files
13. Importing and exporting XML data
14. Using Microsoft Query and Web Query
15. Using Goal Seek and Solver
16. Installing and using the Analysis ToolPak
17. Creating scenarios and views
18. Running and recording a macro
19. Editing VBA modules
20. Creating custom functions
21. Publishing a PivotTable as an interactive Web Page
22. Creating Document Workspaces
23. Viewing and synchronizing lists with data on a SharePoint server