Central Arizona College Back
CBA 133B Advanced Spreadsheet Applications in Excel
Credit Hours:  3
Effective Term: Fall 2016
SUN#: None
AGEC: None  
Credit Breakdown: 2 Lectures, 3 Labs
Times for Credit: 1
Grading Option: A, B, C, D, F

Description: Use of advanced features of MS Excel to import and export data, use templates, generate reports, use macros, audit a worksheet and use analysis tools. Skills learned will include the Excel 2013 Expert Part One & Part Two Level skills for Microsoft Office Specialist (MOS) certification.

Prerequisites: CBA133A

Corequisites: None

Recommendations: Accounting

Measurable Student Learning Outcomes
1. (Application Level) Apply custom styles, and advanced conditional and logical functions to data in the workbook.
2. (Application Level) Use Text, conditional formatting, Lookup and TRANSPOSE functions to manipulate data.
3. (Application Level) Apply advanced date and time functions like NOW and TODAY to serialize dates and times.
4. (Application Level) Implement data collaboration and security techniques to Share, Distribute and Secure workbooks using Three-dimensional formulas, linking, data entry validation, and track changes to share and manage workbooks.
5. (Application Level) Use Analytical options such as Goal Seek, Solver, and Scenario Manager to perform -What If- Analysis.
6. (Synthesis Level) Create One- and Two- variable Data Tables to perform -What If- Analysis.
7. (Synthesis Level) Create advanced charts with trendlines, dual axis and chart animations.
8. (Synthesis Level) Create PivotTables and PivotCharts - modify field selections and options, create a slicer, group records, utilize calculated fields, format data, utilize PowerPivot, and manage relationships to show supplied data in a different view.
9. (Synthesis Level) Create macros - record, edit, and run macros for a given repetitive task.
10. (Synthesis Level) Create advanced formulas that utilize the IF function in conjunction with other functions, utilize AND/OR functions, utilize nested functions, utilize SUMIFS, AVERAGEIFS, and COUNTIFS functions.

Internal/External Standards Accreditation
Microsoft Office Specialist (MOS) 2013 Excel Expert Exam standards can be found at the following links:
Part 1 - Exam 77-427 -- https://www.microsoft.com/learning/en-us/exam-77-427.aspx
Part 2 - Exam 77-428 -- https://www.microsoft.com/learning/en-us/exam-77-428.aspx