NewEra Technology Facebook
Microsoft Excel 2003 Level 2 - Course Information
PRINT
SEND TO A FRIEND
Name: Microsoft Excel 2003 Level 2
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 245
Description:
The target students for this course are those who desire to gain the skills necessary to create templates, sort and filter data, analyze data, and work with Excel on the Web. How to streamline repetitive tasks and display spreadsheet data in more visually effective ways will also be shown.

Participants will also continue to build on the skills learned in Level 1 regarding the creation of formulas.
Prerequisites:
Excel 2003 Level 1 or equivalent knowledge

Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.
Outline:
Creating and Applying Templates
• Create a Workbook from a Template
• Create a Custom Template
• Working with Comments
• Create a Hyperlink
• Use Web-based Research Tools

Creating and Modifying Charts
• Create a Chart
• Format Chart Items
• Change the Chart Type
• Create a Diagram

Calculating with Advanced Formulas
• Create and Apply a Name for a Range of Cells
• Calculate Across Worksheets
• Calculate with Date and Time Functions
• Calculate with Financial Functions
• Calculate with Statistical Functions
• Calculate with Lookup and Reference Functions
• Calculate with Logical Functions

Sorting and Filtering Data
• Sort Data Lists
• Filter Data Lists
• Create and Apply Advanced Filters
• Calculate with Database Functions
• Add Subtotals to a Worksheet
Guaranteed to run courses