|
Official Course
Description: MCCCD Approval: 12-14-1999 |
|||||
|
BPC214DE
2000 Spring – 2011 Summer
II |
L+L
3.0 Credit(s) 5.0 Period(s) 4.4 Load Occ |
||||
|
Advanced
Excel Spreadsheet: Level II |
|||||
|
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. Prerequisites: BPC/CIS114DE or permission
of Instructor. |
|||||
|
Cross-References:
CIS214DE
|
|||||
Go to Competencies Go to Outline
|
MCCCD
Official Course Competencies: |
|
|
|
|
|
BPC214DE 2000
Spring – 2011 Summer II |
Advanced Excel Spreadsheet: Level II |
|
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) |
Go to Description Go to top of
Competencies
|
MCCCD
Official Course Outline: |
|
|
|
|
|
BPC214DE 2000
Spring – 2011 Summer II |
Advanced Excel Spreadsheet: Level II |
|
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 |