Course

Course Summary
Credit Type:
Course
ACE ID:
USDA-0617
Organization's ID:
SPRD9952T
Organization:
Location:
Classroom-based
Length:
18 hours (3 days)
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 1 Information Systems or Computer Applications Upon Completion Of This Course and Microsoft Excel Intermediate: Sprd8968T
Description

Objective:

To understand advanced MS Excel concepts including the use of Macros and Visual Basic, formula auditing and data validation.

Learning Outcomes:

  • Work with databases, templates, lists, macros and audit tools
  • Understand advanced management features of Microsoft Excel 2003 including the analysis components within the application to budget and manage financial expenses
  • Summarize large amounts of data rapidly, performing 'what-if' analyses and working problems backwards to find variables when a desired outcome or scenario is known
Instruction & Assessment

Instructional Strategies:

  • Computer Based Training
  • Lectures
  • Project-based Instruction
Supplemental Materials