Excel Training Courses Toronto, Mississauga, Oakville, Hamilton, Ontario
Trainingexcel's Blog
Onsite customized training in Toronto, Mississauga, Oakville, Hamilton, GTA Excel Training to suit your specific needs
Versions MS Excel 2016/2013/2010/2007 by Exceltraining
Also Office 365 Excel (which has new functions)
Go to Excel Training at Action eBiz to suit your specific needs -work on your own files.
We customize the Excel topics to your specific needs in your office or home - Why waste your time to sit through MS Excel formulas that you already know?
Get learning Excel the way you need! MS Excel Training Toronto Mississauga Hamilton
Our hands-on personal training approach with Microsoft certified, expert instructors.
Use the latest functions to save time - in Excel 2016 new functions added are MINIFS and MAXIFS (so you can can get the Max based on certain criteria) Also now with an Office 365 subscription you can install MS Excel on 5 computers (or other device)
New time saving IFS function helps you input multiple IFs with a simple dialogue box
Note that Excel 2016 is included with an Office 365 sub so you get the latest updates and new functions and new chart types straight away - this can save you valuable time.
Call 905-271-1119 for more info
You can work on your existing Excel formulas in the training, create formulas such as VLOOKUP & HLOOKUP to automate work and save you time and errors. Pivot tables can analyze thousands of rows of data in minutes. With PowerPivot you can analyze millions of rows
MS Excel Training Toronto Mississauga, Hamilton, Ontario & Course Outlines
Listed below are some set topics in MS Excel 2016, 2013, 2010, 2007. We also customize onsite programs in the Toronto, Mississauga, Oakville, Hamilton, GTA Ontario areas. If people are already using Microsoft Excel we can make very rapid progress through many topics. Learn new features in Excel re formulas & data analysis and save time (for example Excel CORREL functions shows you coefficient of correlation between 2 data sets)
Please select the Microsoft Excel 2016, 2013, 2010, 2007 topics that interest you (the Excel topics can be from different levels)
Contact us or call (905) 271 1119 for more information about courses. If there is an Excel topic not listed please let us know and we can add it to the agenda (note there are thousands of formulas in Excel and they can be combined if needed)
Also check MS Excel 2010 training course Toronto, Mississauga, Hamilton Ontario
New in Excel 2013 and Excel 2016 is Flash Fill this fills in columns once you give it a few examples - so if you wanted to separate First and Last name type in a few and Flash Fill does the rest - it can learn as it works.
MS Excel Training Toronto Mississauga
Microsoft Excel – Training Level 1 – Fundamentals
Training Topic A: Microsoft Excel basics
The specifications of the electronic spreadsheet (sheets and how to copy them)
New Excel functions such as SUMIFS & COUNTIFS
Excel 2016, 2013, 2010, 2003/2007 comparison of the programs
Training Topic B: Formatting a worksheet in Microsoft Excel
Formatting the worksheets
Various number and date formats and text alignment options
Copying and pasting formats (Format Painter)
Special and custom formatting
Insert & Modify Comments in MS Excel
Training Topic C: Entering data and navigating in a worksheet
Entering and correcting data in MS Excel worksheets
Editing cell contents
Saving a file
Navigation and movement techniques – shortcut keys (a time saver)
Training Topic D: Formulas & Functions in Microsoft Excel
Creating formulas (SUM, COUNT, MAX, AVERAGE, MIN etc)
Working with built-in functions
Absolute references in Excel formulas
Creating & working with Named Ranges (instead of A1:B45 it can be called PriceList)
Training Topic E: Moving and copying data
Inserting rows and columns in MS Excel 2016, 2013, 2010 and 2007
Moving data from cell to cell
Copying data (values and/or formulas)
Using the Fill Series feature (to create a list Like Toronto, Mississauga, Oakville, Burlington, Hamilton etc.)
Training Topic F: Printing a worksheet
Checking spelling in MS Excel
Using the Print Preview command and & page breaks
Printing a large worksheet
Training Topic G: Multiple worksheets
Setting up and using a multiple-sheet workbook
Inserting new worksheets
Outlining Spreadsheet Solutions
Microsoft Excel – Training Level 2 Intermediate
Training Topic A: Creating charts
Creating charts in MS Excel (new chart types are available)
Creating an embedded chart
Comparing chart worksheets with embedded charts
Training Topic B: Modifying charts in Microsoft Excel
Chart types – Column, Bar, Line, Pie etc.
Modifying embedded charts
Adding and deleting chart items such as values & labels
Moving and sizing chart items
Training Topic C: Formatting a chart
Formatting chart text in MS Excel
Formatting labels
Changing the format of a chart
Printing a chart sheet
Training Topic D: Using graphic objects in Microsoft Excel
Drawing graphic objects
Formatting graphic objects – Fill colour & line colour
Using graphic objects to enhance worksheets and charts
Training Topic E: Sorting data
Setting up Single-level sorting in MS Excel
Multiple-level sorting
Sorting options
Design considerations re the data table
Training Topic F: Filtering data in Microsoft Excel
Setting up and Filtering a list
Custom criteria options (AND versus OR)
Multiple-condition criteria (Advanced Filter)
Managing a filtered list
Training Topic G: Useful Functions
SUMIF to sum by specified criteria or label
SUMIFS to sum by many criteria or label
Note the SUMIFS Excel function is a new function that can have up to 127 criteria
Excel training for formulas in Toronto & Mississauga Ontario
SUBTOTAL function creates the formulas automatically
Microsoft Excel – Training Level 3 Advanced
Training Topic A: Customizing the Work Area
Working with Built-in Toolbars in MS Excel
Using Custom Toolbars
Creating and Using Styles
Using Templates to save time
Training Topic B: Advanced Formula Construction
Using Named Ranges in formulas in MS Excel
Using the IF Function (multiple IFs are possible)
VLOOKUP Function to retrieve data
HLOOKUP Function to retrieve data
Using IS Functions to spot errors
Auditing the worksheet
Add the Forecast Sheet function which can deal with a monthly pattern and give a forecast
Training Topic C: Using Pivot Tables in Microsoft Excel
Creating Pivot Tables for analysis
Modifying Pivot Tables
Summarizing Data in a Pivot Table
Training Topic D: Working with Multiple Worksheets
Working with Workbooks
Dynamic Linking Cells in Different Worksheets or Workbooks
Excel Workspaces
Training Topic E: Consolidating and Analyzing Data
Consolidating Data from More Than One Worksheet
3D formulas for identical worksheets - very easy to change once set up
Goal Seek and Solver Utilities in MS Excel
Scenario Manager to View a Worksheet with Different Input Values (these can be used to compare various options in Excel - Toronto, Mississauga training)
Training Topic F: Using Protection and View Options
Protecting cells from changes
Using Custom Views: see data a needed
Training Topic G: Introduction to Macros in Microsoft Excel
Running Macros
Recording a basic Macro
View the Macro Code and modify some parts of it
Training Topic H: The Data Analysis Tools
Use File >Options> Add-ins to add the Data Analysis Tools
This tool can create:
Histograms and Pareto Charts
A new function in Excel 2013 is PDURATION gives you the number of periods that it will take for an investment to reach a value
Toronto Onsite MS Excel training to save time
Please contact us re Excel 2013, 2010, or 2007 or call 905 271 1119 for more information
Training for Excel Toronto Mississauga onsite
Action eBiz offers On-site Microsoft Excel 2016, 2013, 2010, 2007, training and courses in Ontario, Toronto, Mississauga. In MS Excel courses the 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 training for marketing and sales analysis Toronto Mississauga Hamilton and creating MS Excel formula. We offer Microsoft 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
Excel 2013, 2016 2010, Training Toronto Mississauga Onsite
We also offer onsite training in other Microsoft Office software: MS Project, MS PowerPoint, MS Access, MS Outlook, Office 365, SharePoint
Onsite customized training in Toronto, Mississauga, Oakville, Hamilton, GTA Excel Training to suit your specific needs
Versions MS Excel 2016/2013/2010/2007 by Exceltraining
Also Office 365 Excel (which has new functions)
Go to Excel Training at Action eBiz to suit your specific needs -work on your own files.
We customize the Excel topics to your specific needs in your office or home - Why waste your time to sit through MS Excel formulas that you already know?
Get learning Excel the way you need! MS Excel Training Toronto Mississauga Hamilton
Our hands-on personal training approach with Microsoft certified, expert instructors.
Use the latest functions to save time - in Excel 2016 new functions added are MINIFS and MAXIFS (so you can can get the Max based on certain criteria) Also now with an Office 365 subscription you can install MS Excel on 5 computers (or other device)
New time saving IFS function helps you input multiple IFs with a simple dialogue box
Note that Excel 2016 is included with an Office 365 sub so you get the latest updates and new functions and new chart types straight away - this can save you valuable time.
Call 905-271-1119 for more info
You can work on your existing Excel formulas in the training, create formulas such as VLOOKUP & HLOOKUP to automate work and save you time and errors. Pivot tables can analyze thousands of rows of data in minutes. With PowerPivot you can analyze millions of rows
MS Excel Training Toronto Mississauga, Hamilton, Ontario & Course Outlines
Listed below are some set topics in MS Excel 2016, 2013, 2010, 2007. We also customize onsite programs in the Toronto, Mississauga, Oakville, Hamilton, GTA Ontario areas. If people are already using Microsoft Excel we can make very rapid progress through many topics. Learn new features in Excel re formulas & data analysis and save time (for example Excel CORREL functions shows you coefficient of correlation between 2 data sets)
Please select the Microsoft Excel 2016, 2013, 2010, 2007 topics that interest you (the Excel topics can be from different levels)
Contact us or call (905) 271 1119 for more information about courses. If there is an Excel topic not listed please let us know and we can add it to the agenda (note there are thousands of formulas in Excel and they can be combined if needed)
Also check MS Excel 2010 training course Toronto, Mississauga, Hamilton Ontario
New in Excel 2013 and Excel 2016 is Flash Fill this fills in columns once you give it a few examples - so if you wanted to separate First and Last name type in a few and Flash Fill does the rest - it can learn as it works.
MS Excel Training Toronto Mississauga
Microsoft Excel – Training Level 1 – Fundamentals
Training Topic A: Microsoft Excel basics
The specifications of the electronic spreadsheet (sheets and how to copy them)
New Excel functions such as SUMIFS & COUNTIFS
Excel 2016, 2013, 2010, 2003/2007 comparison of the programs
Training Topic B: Formatting a worksheet in Microsoft Excel
Formatting the worksheets
Various number and date formats and text alignment options
Copying and pasting formats (Format Painter)
Special and custom formatting
Insert & Modify Comments in MS Excel
Training Topic C: Entering data and navigating in a worksheet
Entering and correcting data in MS Excel worksheets
Editing cell contents
Saving a file
Navigation and movement techniques – shortcut keys (a time saver)
Training Topic D: Formulas & Functions in Microsoft Excel
Creating formulas (SUM, COUNT, MAX, AVERAGE, MIN etc)
Working with built-in functions
Absolute references in Excel formulas
Creating & working with Named Ranges (instead of A1:B45 it can be called PriceList)
Training Topic E: Moving and copying data
Inserting rows and columns in MS Excel 2016, 2013, 2010 and 2007
Moving data from cell to cell
Copying data (values and/or formulas)
Using the Fill Series feature (to create a list Like Toronto, Mississauga, Oakville, Burlington, Hamilton etc.)
Training Topic F: Printing a worksheet
Checking spelling in MS Excel
Using the Print Preview command and & page breaks
Printing a large worksheet
Training Topic G: Multiple worksheets
Setting up and using a multiple-sheet workbook
Inserting new worksheets
Outlining Spreadsheet Solutions
Microsoft Excel – Training Level 2 Intermediate
Training Topic A: Creating charts
Creating charts in MS Excel (new chart types are available)
Creating an embedded chart
Comparing chart worksheets with embedded charts
Training Topic B: Modifying charts in Microsoft Excel
Chart types – Column, Bar, Line, Pie etc.
Modifying embedded charts
Adding and deleting chart items such as values & labels
Moving and sizing chart items
Training Topic C: Formatting a chart
Formatting chart text in MS Excel
Formatting labels
Changing the format of a chart
Printing a chart sheet
Training Topic D: Using graphic objects in Microsoft Excel
Drawing graphic objects
Formatting graphic objects – Fill colour & line colour
Using graphic objects to enhance worksheets and charts
Training Topic E: Sorting data
Setting up Single-level sorting in MS Excel
Multiple-level sorting
Sorting options
Design considerations re the data table
Training Topic F: Filtering data in Microsoft Excel
Setting up and Filtering a list
Custom criteria options (AND versus OR)
Multiple-condition criteria (Advanced Filter)
Managing a filtered list
Training Topic G: Useful Functions
SUMIF to sum by specified criteria or label
SUMIFS to sum by many criteria or label
Note the SUMIFS Excel function is a new function that can have up to 127 criteria
Excel training for formulas in Toronto & Mississauga Ontario
SUBTOTAL function creates the formulas automatically
Microsoft Excel – Training Level 3 Advanced
Training Topic A: Customizing the Work Area
Working with Built-in Toolbars in MS Excel
Using Custom Toolbars
Creating and Using Styles
Using Templates to save time
Training Topic B: Advanced Formula Construction
Using Named Ranges in formulas in MS Excel
Using the IF Function (multiple IFs are possible)
VLOOKUP Function to retrieve data
HLOOKUP Function to retrieve data
Using IS Functions to spot errors
Auditing the worksheet
Add the Forecast Sheet function which can deal with a monthly pattern and give a forecast
Training Topic C: Using Pivot Tables in Microsoft Excel
Creating Pivot Tables for analysis
Modifying Pivot Tables
Summarizing Data in a Pivot Table
Training Topic D: Working with Multiple Worksheets
Working with Workbooks
Dynamic Linking Cells in Different Worksheets or Workbooks
Excel Workspaces
Training Topic E: Consolidating and Analyzing Data
Consolidating Data from More Than One Worksheet
3D formulas for identical worksheets - very easy to change once set up
Goal Seek and Solver Utilities in MS Excel
Scenario Manager to View a Worksheet with Different Input Values (these can be used to compare various options in Excel - Toronto, Mississauga training)
Training Topic F: Using Protection and View Options
Protecting cells from changes
Using Custom Views: see data a needed
Training Topic G: Introduction to Macros in Microsoft Excel
Running Macros
Recording a basic Macro
View the Macro Code and modify some parts of it
Training Topic H: The Data Analysis Tools
Use File >Options> Add-ins to add the Data Analysis Tools
This tool can create:
Histograms and Pareto Charts
A new function in Excel 2013 is PDURATION gives you the number of periods that it will take for an investment to reach a value
Toronto Onsite MS Excel training to save time
Please contact us re Excel 2013, 2010, or 2007 or call 905 271 1119 for more information
Training for Excel Toronto Mississauga onsite
Action eBiz offers On-site Microsoft Excel 2016, 2013, 2010, 2007, training and courses in Ontario, Toronto, Mississauga. In MS Excel courses the 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 training for marketing and sales analysis Toronto Mississauga Hamilton and creating MS Excel formula. We offer Microsoft 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
Excel 2013, 2016 2010, Training Toronto Mississauga Onsite
We also offer onsite training in other Microsoft Office software: MS Project, MS PowerPoint, MS Access, MS Outlook, Office 365, SharePoint