Outcomes
In order to successfully complete this course, the student will:
1. Create, modify, and format worksheets.
2. Apply filters (basic and advanced) to lists.
3. Create workbooks using templates.
4. Save workbooks using different names and file formats.
5. Apply styles.
6. Use automated tools to format worksheets.
7. Modify page setup options for worksheets.
8. Insert/delete/modify worksheets.
9. Use 3-D references.
10. Use statistical, date and time, financial, reference, and logical functions in formulas.
11. Create, modify, position, and print charts and graphics.
12. Convert worksheets into web pages [including interactive web pages}.
13. Create hyperlinks.
14. View and edit comments.
15. Import/export data from/to Excel.
16. Retrieve external data and create queries.
17. Create, edit, and apply templates.
18. Create workspaces.
19. Use data consolidation.
20. Create and apply custom number formats.
21. Apply conditional formats and data validation.
22. Customize toolbars and menus.
23. Create, edit, and run macros.
24. Use auditing tools.
25. Use subtotals and filters with lists.
26. Create Extensible Markup Language (XML) Web queries.
27. Create PivotTables, PivotCharts, and PivotTable/PivotChart reports.
28. Forecast values with what-if analysis.
29. Create and display scenarios.
30. Modify passwords, protections, and properties.
31. Create a shared workbook; merge workbooks.
32. Track, accept and reject changes to workbooks.