Microsoft Excel Training
Courses in Toronto, Mississauga, St. Catharines, and Ottawa
| Excel 2016 Level 1 1 day, $275 / participant |
More Info |
| Excel 2016 Level 2 1 day, $275 / participant |
More Info |
| Excel 2016 Level 3 – Data Management 1 day, $275 / participant |
More Info |
| Excel 2016 Level 3 – Spreadsheet Analysis 1 day, $275 / participant |
More Info |
Training is available for Excel 2010, 2013, and 2016. Discounted pricing offered for groups of 6 or more. Minimum enrollment required. Courses are delivered onsite in Toronto, Mississauga, St. Catharines, and Ottawa.
Onsite Excel Training
No travel expenses, no hassle. Just quality Excel training delivered in your company’s meeting room.
Live Instructors
Courses delivered by experienced trainers. Ask questions and get answers. Excel training that’s way better than eLearning!
Focused and Relevant
Courses with an emphasis on the skills you need. “Hands on” exercises with plenty of time to review.
Excel Training for Your Team!
Microsoft Excel has become the de facto spreadsheet application for business. This versatile software package can help you manage virtually any type of data. Track orders, work with budgets, or analyze a database – Excel is the powerful and flexible solution your job requires.
Excel is a registered trademark of Microsoft Corporation. Visit the Office website for more information.
Excel 2016 Level 1
Back to Course List Request a Quote!
Minimum enrollment required. Discounted pricing available for groups of 6 or more. Courses offered for Excel 2010, 2013, and 2016. All training delivered onsite, in your company’s meeting room.
Intended Audience
This course is designed for new Excel users or anyone with a need for basic Excel training.
Prerequisites
General proficiency with Microsoft Windows
Agenda
Lesson 1: Getting Started
- Create new Excel workbooks
- Perform file management tasks
- Navigate in Excel worksheets
Lesson 2: Modifying Worksheets
- Work with columns and rows
- Edit cells
- Organize worksheets information
Lesson 3: Using Formulas and Functions
- Perform calculations using formulas and functions
- Use relative and absolute cell references
Lesson 4: Formatting and Viewing Worksheets
- Apply formatting
- Utilize various settings to manage large worksheets
Lesson 5: Printing Workbooks
- Explore worksheets using various views
- Modify page setup
- Preview / print workbooks
Excel 2016 Level 2
Back to Course List Request a Quote!
Minimum enrollment required. Discounted pricing available for groups of 6 or more. Courses offered for Excel 2010, 2013, and 2016. All training delivered onsite, in your company’s meeting room.
Intended Audience
This course is intended for participants with basic Excel skills and a desire to build on their knowledge.
Prerequisites
Agenda
Lesson 1: Worksheet Organization
- Work with named ranges
- Use various techniques to protect data
- Utilize outlines
Lesson 2: Advanced Formulas
- Use the IF function
- Work with linked formulas
Lesson 3: Using Multiple Workbooks and Worksheets
- Use multiple worksheets
- Consolidate data from multiple workbooks
Lesson 4: Working with Charts
- Create, format, and customize charts to present data visually
Lesson 5: Applying Formatting
- Utilize styles to format workbooks efficiently
- Work with annotations and sparklines
Excel 2016 Level 3 Data Management
Back to Course List Request a Quote!
Minimum enrollment required. Discounted pricing available for groups of 6 or more. Courses offered for Excel 2010, 2013, and 2016. All training delivered onsite, in your company’s meeting room.
Intended Audience
This course is designed for experienced Excel users who need to track and analyze large data sets.
Prerequisites
Agenda
Lesson 1: Maintaining Data
- Work with Excel tables
- Manage records using a data form
- Use VLOOKUP / HLOOKUP functions
Lesson 2: Sorting Lists
- Sort data lists using various techniques
- Apply custom sorts as required
Lesson 3: Filtering Lists
- Extract and work with data using AutoFilter
- Utilize Advanced Filter
Lesson 4: Summarizing Data
- Summarize data using Automatic Subtotals
- Work with database functions
Lesson 5: PivotTables
- Create, format, and manage PivotTables
- Work with PivotCharts
- Use slicers to specify custom data sets
Lesson 6: External Data
- Import external data in various formats into Excel
Excel 2016 Level 3 Spreadsheet Analysis
Back to Course List Request a Quote!
Minimum enrollment required. Discounted pricing available for groups of 6 or more. Courses offered for Excel 2010, 2013, and 2016. All training delivered onsite, in your company’s meeting room.
Intended Audience
This course is designed for experienced Excel users who need to manage and analyze financial models.
Prerequisites
Agenda
Lesson 1: Using Functions
- Use formulas with absolute and mixed cell references
- Utilize financial functions
Lesson 2: Projecting Figures
- Leverage Goal Seek and Data Tables to assist in decision making
Lesson 3: What-If Scenarios
- Examine with scenarios and scenario reports
Lesson 4: Using Solver
- Analyze and solve complex problems using Solver
- Utilize Solver reports
Lesson 5: Auditing Concepts
- Utilize a range of tools to audit and better understand complex workbooks
