2021-2022 Catalog and Student Handbook 
    
    Mar 28, 2024  
2021-2022 Catalog and Student Handbook [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CIT 202B - Excel Certification Preparation


Credits: 3
Description
Comprehensive coverage of basic and advanced features of Microsoft spreadsheet software including, but not limited to, the set of skills on Microsoft’s certification exams for Excel.

Student Learning Outcomes
  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.

Prerequisite: IS 100B  or IS 101  



Add to Portfolio (opens a new window)