.Excel 2010 Training Toronto
MS Excel 2007 Training, Excel Courses Toronto, Mississauga    

Excel Training Courses
Excel Seminars & Workshops
Excel Webinars
One-on-one Excel Training at Your Desktop
Toronto, Mississauga and the GTA

Full Day On-site Training
Customized Group Classes
One-on-one at Your Desktop
Personalized Webinars
Toronto & Greater Toronto

         YOUR RELIABLE EXCEL TRAINING PARTNER                                               

     
 
 
Home
Excel 2003 / 2007Excel 2010New Features in 2010
New Features in 2013Excel for Data AnalysisExcel for LogisticsExcel for Your Career
Excel Training Solutions
Contact Us 

 

 
 
 

 

 



MS Excel 2010 & 2013 Training Courses & Workshops

MS Excel Training Toronto Mississauga Ontario

 

           you choose
       you learn
         you succeed

 

 

 

 

 

 

 

 

Tag Cloud

created at TagCrowd.com

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

MS Excel Training Toronto Mississauga Ontario

 

MS Excel 2010 Training Toronto Mississauga
.

.  
Increase employee productivity through effective Excel training.
These Excel training courses, seminars and workshops focus on learning how to use Excel formulas Excel i
n order to save you time and produce better reports. Training yourself and/or employees enhances the success of your organization, boosts staff morale and improves productivity.

Contact us or call (905) 271 1119 for
more information about courses.
.

Better Skills...  Improved Productivity

Customize your on site training in the Toronto, Mississauga, Oakville, and GTA area.
Listed below are some set topics in MS Excel 2010 but you can choose the one you need.
Please select the Microsoft Excel 2010 topics that will improve your productivity.

Microsoft Excel 2010 - Training Level 1 - Introduction

Training Topic 1: Microsoft Excel 2010 Basics
The workbook environment
Overview of the Excel 2010 screen
Working with the Ribbon, Groups & dialogue boxes
Customizing the Ribbon with a new tab
New features in Excel 2010

Training Topic 2: Formatting a worksheet in Microsoft Excel
Formatting a worksheet
Number formats and text alignment

Merging cells

Copying and pasting formats with the Format Painter
Special and custom formatting
Conditional Formatting (many new options in Excel 2010)
Using Comments in MS Excel

Training Topic 3: Entering data and navigating in a worksheet
Entering and correcting data in MS Excel

Understanding the data types
Editing cell contents
Saving a file
Navigation and movement techniques

Training Topic 4: Formulas & Functions in Microsoft Excel
Creating formulas (SUM, AVERAGE, COUNT, MAX, MIN etc)
Using Autosum tool
Working with functions (Extra help in 2010)
Absolute references in Excel formulas
Creating & working with named ranges

Training Topic 5: Moving and copying data
Inserting rows and ranges in MS Excel
Moving data
Copying data
Using the AutoFill 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: Excel and the Internet
Using Excel on SharePoint and the Internet


Microsoft Excel 2010 - Training Level 2 - Intermediate 

Training Topic 1: Inserting charts
Creating a chart sheet in MS Excel
Creating an embedded chart
Comparing chart sheets with embedded charts

New Sparklines in Excel 2010

Training Topic 2: Inserting charts in Microsoft Excel 2010
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 2010
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
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 New in Excel 2010 sum by multiple criteria
SUBTOTAL function creates the formulas automatically
(and adds outlines as a bonus)

Microsoft Excel 2010 - Training Level 3  - Advanced

Training Topic 1: Customizing the Work Area
Using Themes & Styles
Using Templates

Training Topic 2: Advanced Formula Construction
Using Named Ranges in formulas in MS Excel
Using the IF Function (multiple IFs are possible)
Using the VLOOKUP Function for data automation
Using the HLOOKUP Function
Using IS Functions and the Auditing

Training Topic 3: Using Pivot Tables in Microsoft Excel
Creating pivot tables for data analysis
Modifying pivot tables
Grouping and summarizing data in a pivot table

New Slicer options in Excel 2010

Training Topic 4: Working with Multiple Worksheets
Working with workbooks
Linking cells in different workbooks
Workbook links and workspaces
Sharing and merging Workbooks

Training Topic 5: Consolidating and Analyzing Data
Consolidating data from more than one worksheet
Using the Goal Seek and Solver utilities in MS Excel
Using Scenario Manager to view a worksheet with different input values

Training Topic 6: Using Protection and Display Options
Protecting worksheets from changes
Using custom views

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


Please contact us or call 905 271 1119 for more information.



Action eBiz offers On-site Microsoft Excel 2007,  training and courses in Ontario, Toronto, 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 marketing and sales analysis and creating MS Excel formula. We offer MS Excel training in Toronto, Mississauga, 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 - 2014 by ACTION  eBIZ. All rights reserved. (Toronto, Mississauga, Ontario, Canada)