GENERAL

   Home
   Faculty
   Courses
   Degrees
   Certificates
 

 TRAINING

   Microsoft Office
       Specialist
   Certification Testing
       Center
 

 OTHER

   Related Programs
   CareerTech Education
  

CSCI C124

Advanced Microsoft Excel
 

CATALOG COURSE DESCRIPTION:

This is a hands-on microcomputer course designed to provide an intermediate to advanced understanding of spreadsheets using Microsoft Excel©. Topics to be covered include importing and exporting data, using templates, using multiple workbooks, formatting numbers, printing workbooks, working with named ranges, working with toolbars, macros and auditing a worksheet design, creation, revision, formatting and printing are covered. This course prepares the student to pass the expert level Microsoft Office Specialist certification exam.

COURSE OBJECTIVES:

By the end of the course the student should be able to:

1. Design spreadsheets with economical formats and self-checking features.
2. Understand use of ranges, formatting, file handling and printing.
3. Understand formulas, arithmetic and logical operators, and data sorting and selection features.
4. Construct and use simple macro instructions to automate spreadsheets.
5. Detect, diagnose, and correct simple errors and problems on spreadsheets.
    

TEXTBOOKS/READINGS:

Mastering and Using Microsoft Excel 2000 Intermediate Course, Napier Course Technology, 1999.

ASSIGNMENTS:

Students will be required to design spreadsheet formats learn all command menu structures, formulate arithmetic and logical expressions, and design and construct graphs to demonstrate proficiency in this application program.

EVALUATION AND GRADING SCALE:

Quizzes 20%
Assignments 40%
Final Examination 40%
 

DETAILED TOPICAL OUTLINE:

1. Importing and Exporting Data
   1. Import data from text files (insert, drag and drop)
   2. Import from other applications
   3. Import a table from an HTML file (insert, drag and drop—including HTML round tripping)
   4. Export to other applications
2. Using Templates
   1. Apply templates
   2. Edit templates
   3. Create templates
3. Using Multiple Workbooks
   1. Using a workspace
   2. Link workbooks
4. Formatting Numbers
   1. Apply number formats (accounting, currency, and number)
   2. Create custom number formats
   3. Use conditional formatting
5. Printing Workbooks
   1. Print and preview multiple worksheets
   2. Use the Report Manager
6. Working with Named Ranges
   1. Add and delete a named range
   2. Use a named range in a formula
   3. Use Lookup Functions (Hlookup or Vlookup)
7. Working with Toolbars
   1. Hide and display toolbars
   2. Customize a toolbar
   3. Assign a macro to a command button
8. Using Macros
   1. Record macros
   2. Run macros
   3. Edit macros
9. Auditing a Worksheet
   1. Work with the Auditing Toolbar
   2. Trace errors (find and fix errors)
   3. Trace precedents (find cells referred to in a specific formula)
   4. Trace dependents (find formulas that refer to a specific cell)
10. Displaying and Formatting Data
    1. Apply conditional formats
    2. Perform single and multi-level sorts
    3. Use grouping and outlines
    4. Use data forms
    5. Use subtotaling
    6. Apply data filters
    7. Extract data
    8. Query databases
    9. Use data validation
11. Using Analysis Tools
    1. Use PivotTable autoformat
    2. Use Goal Seek
    3. Create pivot chart reports
    4. Work with Scenarios
    5. Use Solver
    6. Use data analysis and PivotTables
    7. Create interactive PivotTables for the Web
    8. Add fields to a PivotTable using the Web browser
12. Collaborating with Workgroups
    1. Create, edit and remove a comment
    2. Apply and remove worksheet and workbook protection
    3. Change workbook properties
    4. Apply and remove file passwords
    5. Track changes (highlight, accept, and reject)
    6. Create a shared workbook
    7. Merge workbooks