Excel 2003 - Level 2

In this course, you will use Microsoft® Excel 2003 to streamline and enhance your spreadsheets with charts, graphics, and formulas.

Course Outline

In Microsoft® Office Excel 2003: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Excel 2003 to streamline and enhance your spreadsheets with charts, graphics, and formulas.

Course Objective
You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Target Student
The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

• create and modify charts
• calculate with advanced formulas
• work with lists

Course Content

Lesson 1: Creating and Working with Charts

• Create a Chart
• Moving and Resizing a Chart
• Format and Edit Chart Objects
• Changing Charts Source Data
• Changing the Chart Type
• Adding Titles, Gridlines, and a Data Table
• Formatting a Data Series and Chart Axis
• Selecting and Saving a Custom Chart
• Using Fill Effects

Lesson 2: More Functions and Formulas

• Formulas with Several Operators and Cell Ranges
• Using the Insert Function Feature
• Creating and Using Range Numbers
• Selecting Nonadjacent Ranges and Using AutoCalculate
• Using IF Function to Create Conditional Formulas
• Using the PMT Function
• Displaying and Printing Formulas
• Fixing Formula Errors

Lesson 3: Working with Lists

• Creating a List
• Working with Lists and Using the Total Row
• Adding Records Using the Data Form Dialog Box
• Sorting a Lists
• Filtering a List Using AutoFilter
• Filtering a List Using Advanced Filters
• Using Data Validation

Lesson 4: Working with Other Programs

• Inserting an Excel Worksheet into a Word Document
• Modifying an Inserted Worksheet
• Inserting a Linked Excel Chart in a Word Document
• Inserting a Graphic into a Worksheet
• Opening and Saving Files in Different Formats

Additional Details

Pre-Requisites

To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheet formulas in Microsoft Excel 2003. Students can obtain this level of skill by taking: Microsoft Excel 2003: Level 1.

Certificates offered

Certificate of Completion

Cancellation Policy

You may cancel or reschedule your registration without penalty up to 5 days before your class date. Presidio reserves the right to change or cancel courses up to 2 days prior to the class start date, due to insufficient enrollment or extenuating circumstances. You will be notified at that time in writing of such change or cancellation.

Materials and Certificates Received with Course:
All students receive a course manual and Certificate of Completion. Included with the courses is the use of our kitchen facility which is stocked with snacks, various teas and coffees.

Vendor Information:
Presidio has over 10 years of experience offering training in the adult education environment. We keep the attendance in our courses small so that every person has a chance to participate. Our average size is 5 people and usually not larger than 8. Course start at 8:30 but our doors are open and coffee is on at 8:00am. All training is hands-on and everyone receives a manual to keep. Post support is available at no charge.

We are centrally located in a modern facility in the historic Exchange District. Access is easy by any method of transportation as we are only blocks away from major routes for Winnipeg Transit as well as offer paid parking right outside our door to motorists. Our training rooms are fully networked systems with high-speed internet access and use video projection overhead systems.

Map & Reviews

Presidio Learning Center
[ View Provider's Profile ]

Presidio Learning Center
8-90 Market Avenue
Winnipeg, Manitoba
Canada    R3B 0P3

Reviews

 

   

Course info was very helpful - instructor provided real work examples and work arounds.

Reviewed by Linda H. 2011

   

Instructor was very knowledgeable and patient. Atmosphere was friendly and welcoming.

Reviewed by Nishadi G. 2011

   

I felt the class was not completely professional. There was a lot of joking between the teacher & students & I did not completely enjoy the atmosphere.

Reviewed by Pam L. 2011