Microsoft Office Specialist - Microsoft Excel 2003 Core

Who Should Attend: This course is designed for people wishing to formalise their knowledge with a recognised qualification. This is the first level exam for
Microsoft Excel 2003.

Pre-Requisits: Have used MS Excel for a minimum of three months prior to attending or have attended a MS Excel introductory course.

Creating Data and Content
Enter and edit cell content
Navigate to specific cell content
Locate, select, and insert supporting information
Insert, position, and size graphics

Analyzing Data
Filter lists using AutoFilter
Sort lists
Insert and modify formulas
Use statistical, date and time, financial, and logical functions
Create, modify, and position diagrams and charts based on worksheet data

Formatting Data and Content
Apply and modify cell formats
Apply and modify cell styles
Modify row and column formats
Format worksheets

Collaborating
Insert, view, and edit comments

Managing Workbooks
Create new workbooks from templates
Insert, delete, and move cells
Create and modify hyperlinks
Organize worksheets
Preview data in other views
Customize Window layout
Setup pages for printing
Print data
Organize workbooks using file folders
Save data in appropriate formats for different uses