.Excel 2007 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
   Seminars & Workshops

MS Excel Training Toronto, Mississauga, Oakville, Ontario

 

           you choose
       you learn
         you succeed

 

 

 

 

 

 

 

 

Tag Cloud

created at TagCrowd.com

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

MS Excel Training Toronto Mississauga Ontario

 


.
Increase employee productivity through effective Excel training.
These Excel training courses, seminars and workshops focus on learning how to use certain features of Excel i
n order to utilize the full potential of the Excel application. Training your employees enhances the success of your organization, boosts staff morale and improves productivity.

Contact us
or call (905) 271 1119 for more information about Excel training courses, seminars & workshops.

Better Skills...  Improved Productivity

Customize your on site training in the Toronto, Mississauga and GTA area.
Listed below are some set topics in MS Excel 2010 or 2007.
Please select the MS Excel topics that will improve your productivity. Excel Level 1 & 2 can often be combined if the participants are already using Excel.

Microsoft Excel 2010, 2013 - Training Level 1 - Fundamentals

Training Topic 1: Microsoft Excel Basic Concepts
Electronic spreadsheet versus the paper spreadsheet
Microsoft Excel 2010 & 2013)

Training Topic 2: Formatting worksheets in Microsoft Excel

Worksheet Formatting
Number formats and text alignment
Copying and pasting formats
Conditional Formatting (New Features in Excel 2010 & 2013)
Special and custom formatting
Inserting Comments in MS Excel

Training Topic 3: Entering number & text data and navigating in a worksheet
Inputting and correcting data in MS Excel
Editing cell contents
Navigation and movement techniques (Ribbon in 2010)

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

Training Topic 5: Moving, copying & filling data series
Inserting extra rows and columns in MS Excel 2010
Moving & copying data between workbooks
Using the AutoFill Series feature

Training Topic 6: Printing a worksheets from a workbook
Using the Spell Checker in MS Excel
Using the Print Preview command
Printing a large worksheet
Additional print options

Training Topic 7: Multiple worksheets
Creating a multiple-sheet workbook
Design concepts for a multi-sheet workbook

Training Topic 8: Creating Excel Web pages
Using Excel on the Internet


MS Excel 2010, 2013 - Training Level 2  

Training Topic 1: Creating Excel charts
Creating & inserting a chart in MS Excel
Creating an embedded chart
Chart sheets versus embedded charts

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

Training Topic 3: Formatting a chart & components
Formatting chart text in MS Excel
Formatting labels & legends
Formatting the axes, plot area etc.
Printing a chart sheet in MS Excel

Training Topic 4: Inserting graphical objects in Microsoft Excel
Adding graphic objects (Excel 2007 has SmartArt also)
Formatting & recolouring graphic objects
Using graphic objects to enhance worksheets and charts

Training Topic 5: Sorting tables of data
Single-level sorting in MS Excel
Multi-level sorting
Sorting options for Custom Sort (a non alphabetic sort)
Sorting by colour in Excel 2010 & 2013
Design considerations

Training Topic 6: Filtering tables of data in Microsoft Excel
Filtering a table or list
Custom filter criteria
Multiple-condition criteria
Managing and moving a filtered list

Training Topic 7: Timesaving Functions
SUMIF to sum all values under each label
SUMIFS Excel 2010 & 2013 feature which can sum by multiple criteria
SUBTOTAL outlines and inserts formulas automatically (a very useful timesaver)

MS Excel 2010, 2013 - Training Level 3  

Training Topic 1: Customizing Excel
Creating and using Styles
Using Templates & creating new templates

Training Topic 2: Advanced Formulas (IF, Lookups & Audit)
Using Named Ranges in various formulas in MS Excel
The IF Function - IF "Yes" or "No" (multiple IFs are possible)
Using the VLOOKUP Function to make data update automatically
The HLOOKUP Function - similar to the VLOOKUP
Using IS & Audit Functions to check formulas

Training Topic 3: Pivot Tables for data analysis in Microsoft Excel
Inserting pivot tables for data or text analysis
Modifying the elements of pivot tables
Summarizing & grouping in a pivot table

Training Topic 4: Multiple Worksheets

Multiple workbooks setups are possible
Linking cells to update data in other Workbooks
Saving a workspace in Excel

Training Topic 5: Consolidating and Analyzing Data

Consolidating data from more than one worksheet
Getting Excel to remove duplicates
Using the CONSOLIDATE feature
Data Validation to restrict entry
Using the Goal Seek and Solver utilities in MS Excel
Using Scenario Manager to view a worksheet with different input values

Training Topic 6: Protection and Display Options
Protecting worksheets
Locking only certain cells
Using custom Excel views

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

Training Topic 8: Excel & the Internet
Publishing an Excel Worksheet as  a Web Document
Spreadsheet Web Components

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)