439 University Avenue
Suite 1150
Toronto Ontario
Canada M5G 1Y8

Microsoft Office 2007

Application Overview:
Microsoft Excel

Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, calculate data, create rich data visualization and professional-looking charts. You can compile your company’s data into a Microsoft Office Excel workbook that can contain many worksheets.
Microsoft Excel can be used to manage numbers and calculations. You can create formulas in Excel that automatically update when you change your data.

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 2007 Training Courses

Microsoft Excel 2007
Introduction

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

Get Adobe Flash player

Course Information

Duration: One-Day Course
Platform: Windows and Macintosh
Fee: $275 CDN (+HST)

This class is limited to eight people.

Course Overview

In this course you will learn the fundamentals of working with spreadsheets. You will learn how to produce a professional looking worksheet by entering numbers and creating timesaving Excel formulas and using predefined Excel functions. You will also learn how to quickly and easily change the layout of your worksheet and enhance the appearance of your worksheet using the format commands. You will also learn how to work with multiple sheets within a file and how to setup and print your worksheet.

Course Content

Creating and Editing Worksheets

  • Exploring the new Quick Access Toolbar, Ribbon, Tabs and Groups now available in Excel 2007
  • Moving efficiently through a worksheet
  • Selecting cells and ranges proficiently

Developing Formulas and Functions

  • Entering numbers and creating time-saving Excel formulas to produce professional worksheets
  • Using the SUM, AVERAGE, MIN, MAX and COUNT functions in Excel

Managing a Worksheet

  • Inserting, deleting or hiding cells, rows, and columns quickly and easily
  • Discovering the many techniques to cut, copy and paste in Excel 2007

Formatting a Worksheet

  • Enhance the appearance of your worksheet using the many formatting commands

Managing a Workbook

  • Naming, moving, copying and colouring worksheets tabs

Printing a Worksheet

  • Setting-up and printing a worksheet

Calendar Dates:

Aug 20, 2010

Sep 29, 2010

Oct 25, 2010

Nov 22, 2010

Dec 17, 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 >>