CIT 202B - Excel Certification Preparation

1. Explain common spreadsheet concepts and terms.
2. Enter, copy and move numeric data, text data, and equations in an Excel spreadsheet.
3. Use Excel’s formatting features to change the appearance of an entire worksheet and of cells in a worksheet.
4. Use equations and built-in functions to interrelate numeric data in an Excel worksheet.
5. Perform what-if analysis using Data Tables, Pivot Tables and Scenario Manager.
6. Troubleshoot worksheets using Excel’s auditing features.
7. Share worksheets by importing data from and exporting data to word processors, database managers and Web pages.
8. Create and modify charts to summarize numeric data in an Excel worksheet.
9. Use Excel’s query tools to extract or filter records in a list to meet simple and complex criteria.
10. Set up a list in an Excel worksheet and sort the list using one or more keys, including key based on a custom list.
11. Summarize data in lists using Data Tables and Pivot Tables.
12. Consolidate data in lists.
13. Consolidate worksheets.
14. Print spreadsheets and charts.
15. Create, edit and run macros to automate repetitive tasks.
16. Create user-defined functions using VBA.
17. Explain and demonstrate the best ways to organize spreadsheets.
18. Explain and demonstrate the appropriate use of the following Excel features: Goal Seek, Scenario Manager, Data Tables, Solver, Pivot Tables.
19. Customize Excel environment.