.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

 

 
 
 
 

Some of our clients include:
    Altamira

    Aja

 



MS Excel for Career Transition and Advancement
   Training Courses, Seminars & Workshops

MS Excel Training Toronto Mississauga Ontario

 

        

 

 

 

 



     you choose
       you learn
         you succeed

 

 

 

 

 

 

 

 

Tag Cloud

action analysis automation brampton canada chart copying courses creating criteria custom data ebiz embedded etc excel features filtering formatting formulas function graphic level list manager microsoft mississauga modifying moving ms multiple objects offer ontario options pivot printing site sorting spreadsheet sum tables topic toronto training view web workbook working worksheet
created at TagCrowd.com

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

MS Excel Training Toronto Mississauga Ontario

 


MS Excel for Career Transition Toronto Ontario


Are you getting ready for a job interview,
a new job or looking for a promotion?
Improve your chances by building your Excel skills. You will jump from basic spreadsheet tools to advanced formatting and calculations in a way that fits your professional schedule.
In one day you will improve your confidence and master what you need to know to be ready for your new position.
.
Contact us or call (905) 271 1119 for more information about Excel training courses, seminars & workshops.

Better Skills...  More Opportunities


Customize your on site training in the Toronto, Mississauga and GTA area.

Listed below are some set topics in MS Excel 2003, 2007 or 2010.
Please select the Microsoft Excel topics that will further your career. We can advise you as the most common functions that are used in your future career and customize the training to reflect this.

Microsoft Excel 2013, Excel 2007 or Excel 2010
   Training Level 1 - Introduction

Training Topic 1: Microsoft Excel basics
The paper spreadsheet
The Excel 2013/2010 program (new features in Excel 2013)
The workbook environment
Best practices & common errors in workbook setup

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 2013 & Excel 2010)
Using Comments in MS Excel
Hiding worksheets

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

Training Topic 4: Formulas & Functions in Microsoft Excel
Creating formulas (SUM, AVERAGE, MAX, MIN, COUNT, etc)
Working with functions (Extra help in 2013)
Absolute references in Excel formulas
Creating & working with named ranges
How to check a workbook for named ranges

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


Microsoft Excel Excel 2003, Excel 2013 or Excel 2010
   Training Level 2  

Training Topic 1: Creating charts
Creating a chart sheet in MS Excel
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
Adding hyperlinks to graphic objects

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 table or list
Custom criteria
Multiple-condition criteria
Managing a filtered list

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

Microsoft Excel 2013 or Excel 2010
   Training Level 3  

Training Topic 1: Customizing the Work Area
Using Custom Toolbars
Creating and using styles or themes
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
Showing percentages in a pivot table
Creating Interactive Pivot Tables for the Web

Training Topic 4: Working with Multiple Worksheets
Working with Workbooks
Linking Cells in Different Workbooks
Workbook Versus 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

Training Topic 8: Working with Interactive Excel
Web Documents
Saving 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 2013,  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)