439 University Avenue
Suite 1150
Toronto Ontario
Canada M5G 1Y8

Microsoft Office 2007/2010

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.

Microsoft Office 2007-2010 Training Courses

Microsoft Excel 2007/2010
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: $565 CDN (+HST)

This class is limited to eight people.

Course Overview

This course is a continuation from the Excel Introduction course. This course will increase your productivity, show you many advanced functions and show you how to manage lists of data in Excel.

Course Content

Productivity

  • Get acquainted with the Ribbon and Quick Access Toolbar in Office 2007 and 2010.
  • Get acquainted with the new Backstage View in Office 2010.
  • Learn how to customize the Quick Access Toolbar.
  • Create an absolute cell reference.
  • 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

  • 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.
  • Use the Subtotal command.
  • Create an automatic Outline to display only subtotals and grand totals.

Workbook Management

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

Macros and Templates

  • Create and use a simple Macro which records repetitive tasks in Excel.
  • Create a template for files you use frequently.

Charts

  • Show your data with the new enhanced chart layouts and styles to make charts more lively and informative.
  • Create tiny charts called Sparklines that provide a visual representation of your data in Office 2010.

Introduction to Pivot Tables

  • L earn how to quickly create a pivot table to summarize, organize, analyze and compare large amounts of data
  • Learn how to use the new data slicers in Office 2010.

Calendar Dates:

May 8/9, 2013

May 22/23, 2013

Jun 6/7, 2013

Jun 10/11, 2013

Jun 26/27, 2013

Jul 10/11, 2013

Jul 15/16, 2013

Aug 14/15, 2013

Aug 26/27, 2013

Sep 11/12, 2013

Sep 26/27, 2013

View Training Calendar

Register Now

Are you using an
older version of
Microsoft Office?

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 Training
Course Discounts

Receive a discount off of the regular fee for this course!

Register for two or more courses and you automatically qualify for a discount of 10% off the regular fees for all courses.

Register for five or more courses at one time and the discount increases to 15% per courses

(Note: Only the 10% discount applies to Microsoft Office or FileMaker Pro training)