439 University Avenue
Suite 1150
Toronto Ontario
Canada M5G 1Y8

Microsoft Office 2000-2003

Application Overview:
Microsoft Excel

Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, and calculate data. You can use advanced features to manage, track, and chart critical business data to create rich data visualization, PivotTable views, and professional-looking charts. You can compile your company’s data into Microsoft Office Excel by retyping or by copying and pasting. But importing is most effective when you're working with large amounts of data that would be time-consuming to enter manually or too large to copy and paste. In addition, if you import your data, Excel can automatically update your reports and summaries whenever the original source database is updated. Your data is always current.

Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create and edit spreedsheets that can be searched, sorted, analysed, reported, updated and shared with other users.

Upgrade to Microsoft Office 2007 Training Courses

Microsoft Office 2000-2003 Training Courses

Microsoft Excel
Intermediate/Advanced

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player

Course Information

Duration: Two-Day Course
Platform: Windows and Macintosh
Fee: $545 CDN (+GST)

This class is limited to eight people.

Course Overview

Increase your competence with Excel by discovering the more advanced features of the program. You will see a demonstration of the feature and will be given hands-on exercises to reinforce your learning.

Course Content

  • Add, delete and move buttons on an existing toolbar or create a custom toolbar
  • Name a single cell or a range of cells to easily select that area or to make formulas easier to create and read
  • Apply conditional formatting to highlight formula results
  • Insert cell comments to effectively annotate a worksheet with information
  • Use the IF function to create a formula for decision making and calculation
  • Use the SUMIF function to sum a range only if it meets a certain criteria
  • Use the COUNTIF function to count the number of cells within a range that meet your criteria
  • Create and use an Excel database using the Form command
  • Use the Sort command to rearrange the information of a list
  • Use the AutoFilter and Advanced Filter to extract information from a listUse the Subtotal command to produce automatic subtotals and grand totals
  • Manage a large worksheet using the Auto Outline command
  • Link worksheets and workbooks cells
  • Track and highlight changes made in a worksheet
  • Protect cells containing formulas with the Protection command
  • Avoid entering incorrect or inconsistent data by using the Data Validation feature
  • Graphically display relationships between the cells in your worksheet by using the Formula Auditing Toolbar buttons
  • Learn to nest or combine a number of operations in one cell
  • Locate a value within a table by using the VLOOKUP function
  • Reduce time and effort by creating and using a simple macro
  • Apply repetitive formatting by creating styles
  • Establish a consistent look by creating a template of a frequently used worksheet
  • Share Excel data with other Office applications
  • Present data more effectively by creating charts
  • Get an introduction to pivot tables which will help you summarize, organize, analyze and compare large amounts of data

Calendar Dates:

Feb 4/5, 2010

Feb 18/19, 2010

Feb 25/26, 2010

Mar 11/12, 2010

Mar 22/23, 2010

Mar 31/Apr 1, 2010

Apr 7/8, 2010

Apr 22/23, 2010

May 12/13, 2010

May 25/26, 2010

Jun 7/8, 2010

Jun 14/15, 2010

View Training Calendar

Register Now

Download PDF of Course Outline

If you have Adobe Reader installed you can view it now:

(PDF 55 kb)

Need help with PDFs?
PDF help >>

Related Training

DPA Certificate Programs

Our certification programs give you the opportunity to build your proficiency in electronic imaging, page layout, Internet, and office productivity while saving you a considerable amount.
more >>