.
MS Excel 2010, Excel 2007
  Training Course Outline

Training topics MS Excel 2010, Excel 2007 & Excel 2003. Save time: Cover only the Excel courses & topics you need in Toronto, Mississauga, Oakville, Hamilton, GTA and SW Ontario.

Please select the Microsoft Excel 2010/2007/2003. topics that interest you.
Contact us or call (905) 271 1119 for more information about onsite courses in Toronto, Mississauga etc.

   never stop
      thinking

Microsoft Excel 2010, 2007, 2003
  Training Level 1 - Introduction

Training Topic 1: Microsoft Excel basics
The paper spreadsheet versus Excel
The Excel 2010 & 2007 program (new features in Excel 2010 and 2007)
The workbook & Worksheet environment

Training Topic 2: Formatting a worksheet in Microsoft Excel
Formatting a worksheet
Number formats and text alignment
Copying and pasting formats
Special and custom formatting
Conditional Formatting (New Features in Excel 2007 and 2010)
Using Comments in MS Excel

Training Topic 3: Entering data and navigating in a worksheet
Entering and correcting data in MS Excel 2010
Editing cell contents
Saving a file
Navigation and movement techniques (Ribbon in 2007/2010)

Training Topic 4: Formulas & Functions in Microsoft Excel
Creating Excel formulas (SUM, AVERAGE, MAX, MIN etc)
Working with functions (Extra help in 2007/2010)
Absolute references in Excel formulas
Creating & working with named ranges (Defined Names)

Training Topic 5: Moving and copying data
Inserting rows and ranges in MS Excel 2010
Moving data
Copying data
Using the Fill Series feature

Training Topic 6: Printing a worksheet
Checking spelling in MS Excel
Using the Print Preview command
Printing a large worksheet
Additional print options

Training Topic 7: Multiple worksheets
Using a multiple-sheet workbook
Outlining Spreadsheet Solutions

Training Topic 8: Creating Excel Web pages
Using Excel as a Web tool

Click to go to MS Excel Level 1

Microsoft Excel 2010/2007/2003
  Training Level 2  

Training Topic 1: Creating charts
Creating a chart sheet in MS Excel 2003/2007/2010.
Creating an embedded chart
Comparing chart sheets with embedded charts

Training Topic 2: Modifying charts in Microsoft Excel
Chart types (Column, Bar, Line Charts etc.)
Modifying embedded charts
Adding and deleting chart items
Moving and sizing chart items

Training Topic 3: Formatting a chart
Formatting chart text in MS Excel
Formatting labels
Formatting the chart
Printing a chart sheet

Training Topic 4: Using graphic objects in Microsoft Excel
Adding graphic objects
Formatting graphic objects
Using graphic objects to enhance worksheets and charts

Training Topic 5: Sorting data
Single-level sorting in MS Excel 2010
Multiple-level sorting
Sorting options for Custom Sort (a non alphabetic sort)
Design considerations

Training Topic 6: Filtering data in Microsoft Excel
Filtering a list
Custom criteria
Multiple-condition criteria
Managing a filtered list

Training Topic 7: Useful Functions
SUMIF to sum by label type
SUMIFS Excel 2007/2010 sum by multiple criteria
SUBTOTAL function creates the formulas automatically

Click to go to MS Excel Training One

Microsoft Excel 2010/2007/2003  
  Training Level 3  

Training Topic 1: Customizing the Work Area
Using Custom Views
Creating and Using Styles
Using Templates
Protecting Worksheets from changes

Training Topic 2: Advanced Formula Construction
Using Names (named ranges) in formulas in MS Excel
Best practices with named ranges
Saving time with named ranges

Training Topic 3: Using Pivot Tables in Microsoft Excel
Creating Pivot Tables for data analysis
Modifying Pivot Tables
Grouping and Summarizing Data in an Excel Pivot Table
Creating Interactive Pivot Charts

Training Topic 4: Using the IF function in Microsoft Excel
Using the IF Function
Multiple IFs are possible when there are a range of answers
Nesting IFs with AND & OR functions

Training Topic 5: Using the VLOOKUP & HLOOKUP in MS Excel
Using the VLOOKUP Function for data automation
How the VLOOKUP can work across files
Using the HLOOKUP Function

Training Topic 6: IS function and Auditing Excel
Using the IS Functions to check formulas
Use the Auditing functions ISERROR to reduce clutter

Training Topic 7: Working with Multiple Worksheets
Working with Workbooks
Linking Cells in Different Workbooks
Workbook Versus Links and Workspaces
Sharing and Merging Workbooks
Workbook Versus Links and Workspaces

Training Topic 8: Consolidating and Analyzing Data
Consolidating Data from More Than One Worksheet
Using links to summarize
Using CONSOLIDATE functions
Use a 3D formula in Excel 2003/2007/2010

Training Topic 9: Using Goal Seek & Solver
Using the Goal Seek to give a solution
Using Solver Utilities in MS Excel
Using Scenario Manager to View a Worksheet with Different Input Values

Training Topic 10: Scenario Manager 
Using Scenario Manager to View a Worksheet with Different Input Values
Creating a summary report from Scenario manager

Training Topic 11: Introduction to Macros in Microsoft Excel
Running Excel Macros
Recording a Macro
Viewing the VBA Code

Click to go to MS Excel Training 1
Click to go to MS Excel Training 2

Please contact us or call 905 271 1119 for more information

Cover only the Excel topics that interest you
 

Microsoft Certified Technology Specialist (MCTS)

MS Office Training
► MS Excel
► MS Access
► MS Project
► SharePoint
► MS Word
► MS PowerPoint
► MS Outlook
► Microsoft Office

Action eBiz offers On-site Microsoft Excel 2010/2007,  training and courses in Ontario, Toronto Excel, Mississauga. In MS Excel courses trainer covers MS Excel data analysis, Microsoft Excel Charts, MS Excel pivot tables, Microsoft Excel Graphs, MS Excel sorting and filtering, MS Excel database. Microsoft Excel training also includes MS Excel formulas, Microsoft Excel VLOOKUP Function for data automation, Microsoft Excel HLOOKUP Function for data automation, Microsoft Excel functions marketing and sales analysis and creating MS Excel IF functions formula. We offer MS Excel training in Toronto, Mississauga, Oakville, Burlington, Hamilton, Brampton, Ontario, Kitchener, Waterloo, Cambridge, Canada We offer customized MS Excel training for Employees, Managers, Executives involved in Financial, Accounting, Marketing, Sales etc.. in Toronto, Mississauga, Brampton, Ontario, Kitchener, Waterloo, Hamilton, Cambridge, Canada On-site Training Microsoft MS Excel Courses Trainer Toronto Mississauga Brampton Ontario
We also offer on site training in other Microsoft Office software: MS Project, MS PowerPoint, MS Word, MS Outlook, MS Access and MS FrontPage.

Site Map                                                                                                                ACTION eBIZ inc.      email   (905) 271-1119
                      Copyright © 1999 - 2013 by ACTION  eBIZ. All rights reserved. (Toronto, Mississauga, Ontario, Canada)