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

Microsoft Excel 2007
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 (+HST)

This class is limited to eight people.

Course Overview

This course is a continuation from the Excel 2007 Introduction course. At the end of this course, you will feel confident to use the following Excel features.

Course Content

Productivity

  • Learn how you can take advantage of the new increased limits that Excel now provides you when creating a worksheet and workbook.
  • Get acquainted with the new Microsoft Office Button, Ribbon and Menus and also learn how to customize the Quick Access Toolbar.
  • Create an absolute cell reference for sales commission or exchange rates.
  • Use range names to quickly go to a range or use the range name in a formula.
  • Identify trends in your data using the improved conditional formatting features.
  • Insert cell comments to make your work easier to review.

Advanced Functions

  • Discover the improvements that have been made to formula writing.
  • Use the IF, COUNTIF, SUMIF, ROUND, TODAY and VLOOKUP functions.
  • Nest functions such as the SUM function with the IF function.

List Management

  • Apply the new themes and styles to help you create a unified design within your workbook.
  • Add records directly on the worksheet or use the Data Form.
  • Analyze your data more efficiently using the improved sorting command.
  • Create a custom sort order list and use it.
  • Analyze your data more efficiently using the new filtering by colour capabilities.
  • Use the Subtotal command.
  • Create an automatic Outline to see only subtotal and grand totals.

Workbook Management

  • Work with multiple worksheets and consolidate data.
  • Protect parts of or the entire worksheet and also protect the workbook.

Eliminating Repetitive Tasks

  • Get an introduction on how to create and use Macros.
  • Create a template for files you use frequently.

Graphics and Charts

  • Explain your Excel data more effectively using the new SmartArt Graphics.
  • Show your data with the new enhanced chart layouts and styles to make charts more lively and informative.

Introduction to Pivot Tables

  • Learn how to quickly create a pivot table to summarize, organize, analyze and compare large amounts of data.

Optional: Track Changes

  • Learn how you can keep track of any revisions made to a workbook whether you or another person make the revision.

Calendar Dates:

Aug 16/17, 2010

Aug 30/31, 2010

Sep 16/17, 2010

Oct 18/19, 2010

Nov 15/16, 2010

Dec 15/16, 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 >>