::Computeach:: Technology training for the real world
navbar
This text is replaced by the Flash movie.




Course: Excel XP 2003/2007 I/II

Overview
These courses are designed to teach those with little or no experience with how to effectively use Microsoft’s Excel spreadsheet application. Individuals receiving this training will become experts at working with the various aspects of workbooks including cells, formulas, formatting and printing. The training will also prepare someone for the Microsoft Office Specialist (Office Specialist or MOS) certification, which is the globally recognized standard for validating expertise with the Microsoft Office suite of business productivity programs.

Topics Included in Training

Course I:
Excel Basics
• Terminology
• Workbook Overview
Enter/Edit Data
• Labels and values
• Formulas
Modify Worksheet
• Move/Copy Data
• Move/Copy Formulas
• Insert/Delete Ranges
Functions
• Overview
• AutoSum
• Average, Min and Max
Formatting
• Text
• Rows and Columns
• Numbers
Printing
• Page Setup
Charts
• Create/Update
• Modify/Print
Web Features
• Save as Web Page
• Hyperlinks

Course II:
Managing Large Worksheets
• View Options
• Hide Data
• Printing
Multiple Worksheets
• Link Worksheets with Formulas
• Consolidate Data
• Link/Manage Workbooks
Customizing Excel
• Options Dialog Box
• Toolbars/Menus
Advanced Formatting
• Borders and Shading
• Dates
• Styles
Advanced Charting
• Options
List Management
• Creating
• Sort/Filter
Auditing and Protection
• Tracking Changes
• Comments
Templates
Documenting/Auditing

Prerequisite: Excel 2003 I or equivalent knowledge (for Course II only)
Certification Tests: Offered in our Certiport Testing Center
Excel 2003 Core (MOS)
Format: 8 Hours Instructor Led Training (Each Course)
Daytime and Evening/Saturday Classes Available

Course Content Subject to Change without Notice
Version 027/028-403A

::Computeach:: Technology training for the real world