AOS 206 : Spreadsheet Applications II

Develop advanced spreadsheet skills in Microsoft Excel and associated technologies. Use advanced functions and formulas; enhance charts, use “what-if ” analysis, analyze data with PivotTables, exchange data with other programs, share files and incorporate web content, and program with XML. Interactive training and skill-based assessments are completed in a virtual environment; projects are based on real-world business situations. Integration with cloud computing.

Prerequisites

AOS 106 or CAT 140

Course Outcomes

  1. Apply critical thinking skills to complete real-world business projects.
  2. Combine technical skills to complete independent core concept reviews.
  3. Create workbooks with advanced formatting and mathematical functions.
  4. Analyze data with PivotTables.
  5. Export data into other file formats.
  6. Customize Excel and advanced worksheet management.
  7. Write VBA code to automate repetitious tasks.
  8. Interact and share information in the Cloud.

Overview

Program

Credits

5