CIS 102: Advanced Excel
Issued by
Year Up
Objective is to apply Excel functions to accounting scenarios and manipulate datasets to solve problems; conduct what-if analysis and make projections for a market by evaluating its portfolio value; analyze a client's budget and goals and present the client with an informed recommendation on capabilities and limitations; produce effective pivot tables to report financial data to decision makers; and organize and manage a database by creating macros to provide conceptual context and meaning.
- Type Validation
- Level Intermediate
- Time Months
Skills
Earning Criteria
-
The methods of assessment include quizzes, examinations, written papers, case studies, presentations, performance rubrics (checklists), and group projects with a minimum passing score of 70 percent.
-
The methods of instruction include audio visual materials, case studies, laboratory, practical exercises, lecture, discussion, classroom exercises, and computer-based training.