MCCCD Program Description

Advanced Excel Spreadsheet: Level II

Course: CIS214DE

First Term: 2011 Fall

Lec + Lab 3 Credit(s) 5 Period(s) 4.4 Load
Subject Type: Occupational
Load Formula: S

Description: Advanced Excel spreadsheet features including formatting techniques, macros and Visual Basic for applications. Templates, built-in functions and lists as well as analysis tools including Pivot Tables and Goal Seek covered. Import and export data, workgroup collaboration and Internet features of Excel emphasized

MCCCD Official Course Competencies
1. Format Excel worksheets using advanced formatting techniques. (I) 2. Create and edit templates and workbooks. (II) 3. Use advanced built-in functions. (III) 4. Create and edit lists. (IV) 5. Use Excel`s analysis tools. (V) 6. Hide, display and customize toolbars. (VI) 7. Use Excel`s macros and Visual Basic for applications. (VII) 8. Demonstrate how to share and change properties of workgroups. (VIII) 9. Import data from Web pages into Excel. (IX) 10. Export data from Excel into Web pages. (IX)
MCCCD Official Course Competencies must be coordinated with the content outline so that each major point in the outline serves one or more competencies. MCCCD faculty retains authority in determining the pedagogical approach, methodology, content sequencing, and assessment metrics for student work. Please see individual course syllabi for additional information, including specific course requirements.

MCCCD Official Course Outline
I. Formatting Techniques A. Apply different formats to numbers B. Custom formats C. Format cells D. Worksheet layout E. Hide zeros F. Conditional formatting G. Change page orders and rename sheets II. Templates A. Built-in templates B. New templates C. Multiple workbooks 1. Merge multiple 2. Link and share workbooks III. Functions A. Built-in functions 1. Financial 2. Statistical 3. Date and time 4. Math and trig 5. Logical B. Input IV. Lists A. Create B. Sort C. Modify D. Filter V. Analysis Tools A. Pivot Table 1. Create 2. Manage B. Pivot table reports 1. Create 2. Interactive tables for the Web C. Goal Seek VI. Toolbars A. Floating B. Decked C. Hide D. Display E. Customize VII. Macros A. Record and play B. Edit VIII. Workgroups A. Share B. Change properties C. Protect D. Apply passwords E. Track changes IX. Text Files A. Import B. Export C. Link D. Embed objects

MCCCD Governing Board Approval Date: 12/14/1999

All information published is subject to change without notice. Every effort has been made to ensure the accuracy of information presented, but based on the dynamic nature of the curricular process, course and program information is subject to change in order to reflect the most current information available.