Excel Training: Data Analysis for Business Users


Course Delivery

Live Instructor-Led Training

Course Description

The course Data Analysis for Business Users (Excel Training) teaches you to organize, analyze, validate and present data using Microsoft Excel. Starting with data layout, the course explores basic and advanced functions. The training includes a detailed discussion of conditional, math & logic functions, PivotTables, Charts and a comprehensive introduction to Macro development.

Course Dates and Pricing


Nov 12 - 13, 2018$1,150.00Dec 10 - 11, 2018$1,150.00Jan 21 - 22, 2019$1,150.00Feb 18 - 19, 2019$1,150.00Mar 18 - 19, 2019$1,150.00Apr 15 - 16, 2019$1,150.00

Course Outline

Review of Essential Concepts

Working with Absolute and Relative References
Working with Multiple Worksheets
Working with Advanced Functions
Working with Dates and Times
Customizing your Environment
Importing Data from External Sources
Excel Security

Working with Data

The Mechanics of AutoFill
Creating a Data Series
Creating a Data List
Creating a Named Range
Implementing Sorting, Filtering and Searching
Creating a Graph for Impact

Working with Formulas

About Complex Function Syntax
Using Functions to Summarize Data
Using Conditional Functions to Implement Advanced Analysis
Working with Functions and Dates
Implementing your Own Functions using VB

Working with Pivot Tables

Working with Pivot Tables
Creating a Pivot Table
Pivot Table Options
Advanced Pivot Table Options
Pivot Tables and Custom Functions
Working with PivotChart

Macros Part I: Creating Basic Macros

Preparing to Record a Macro: Absolute and Relative Mode
Recording a Macro
Testing the Macro
Understanding the Code

Macros Part II: Modifying Macros

Working with Variables
Working with Cells
Working with Conditional Statements
Creating Support Functions
Modifying a Recorded Macro
If Time Permits - Advanced Macro Development

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related Microsoft Excel Training

Excel Training: Analysis & Reporting for Finance

The course Analysis & Reporting for Finance (Excel Training) teaches you how to use MS Excel to present, analyze and format financial data. The training includes data layout, basic math & financial functions and advanced financial analysis with MS Excel. You learn about present value and future value, WACC, IRR, cash flow calculations & interest considerations. Become a financial wizard with MS Excel. Training course titled Excel Training: Analysis & Reporting for Finance that will allow you to hone your professional skills.

Oct 23 - 26, 2018$2,775.00Nov 20 - 23, 2018$2,775.00Dec 18 - 21, 2018$2,775.00Jan 29 - Feb 1, 2019$2,775.00Feb 26 - Mar 1, 2019$2,775.00Mar 26 - 29, 2019$2,775.00Apr 23 - 26, 2019$2,775.00

Excel Training: Cells, Workbooks and Graphs

The course Cells, Workbooks and Graphs (Excel Training) teaches you how to work efficiently with cells, worksheets & workbooks. The training includes working with multiple worksheets, useful keyboard shortcuts & functions, absolute & relative references and custom functions. You learn to set your data so that it can be easily sorted and filtered. The course also covers how to create, edit & format graphs in MS Excel. Maximum productivity is within your grasp with Microsoft Excel. Training course titled Excel Training: Cells, Workbooks and Graphs that will allow you to hone your professional skills.

Nov 5 - 6, 2018$1,150.00Dec 3 - 4, 2018$1,150.00Jan 14 - 15, 2019$1,150.00Feb 11 - 12, 2019$1,150.00Mar 11 - 12, 2019$1,150.00Apr 8 - 9, 2019$1,150.00

Excel Training: Data Analysis & Reporting

The course Data Analysis & Reporting (Excel Training) teaches you to analyze & report on data using Microsoft Excel. The course covers data layout using multiple Excel worksheets and custom & advanced functions. The training includes Excel graphs, PivotTables and the use of custom functions, sorting & filtering to analyze & report on data. Training course titled Excel Training: Data Analysis & Reporting that will allow you to hone your professional skills.

Nov 12 - 13, 2018$1,150.00Dec 10 - 11, 2018$1,150.00Jan 21 - 22, 2019$1,150.00Feb 18 - 19, 2019$1,150.00Mar 18 - 19, 2019$1,150.00Apr 15 - 16, 2019$1,150.00

Excel Training: Mastering Task Automation

The course Mastering Task Automation (Excel Training) provides business participants with the skills they need to automate almost any business task. Starting with a review of essential concepts in data analysis using Microsoft Excel, the course quickly proceeds to a complete and in depth study of macros and VBA development. The course covers every aspect of VBA development including the Excel object model, looping, functions, conditional logic and database access amongst others. If you need to use Microsoft Excel to automate your business tasks, this SETC certified course will teach you the skills you need. SETC Training - Formation SETC provides advanced Microsoft Excel training in Ottawa, Montreal, Toronto, Quebec and Calgary. Training course titled Excel Training: Mastering Task Automation that will allow you to hone your professional skills.

Oct 24 - 26, 2018$1,675.00Nov 21 - 23, 2018$1,675.00Dec 19 - 21, 2018$1,675.00Jan 30 - Feb 1, 2019$1,675.00Feb 27 - Mar 1, 2019$1,675.00Mar 27 - 29, 2019$1,675.00Apr 24 - 26, 2019$1,675.00