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. |