Microsoft Excel Training Courses | Excel Dashboards & Data Visualization – Toronto

$300

 

Next classes

Monday,TBA

Excel Dashboards – Excel Advanced Topic Class | Designed for Excel 365, 2019, 2016, 2013

 

Training Type:  Classroom Training – Toronto

Other options : Online Training- On-site at your company office ” Anywhere”

Course Level: Excel Advanced Topics Series.

Related Excel Courses :  Excel introduction course + Excel Intermediate

Number of students per session:  Our class sizes are typically 4-6 students per session. Our classes are intentionally kept small in order to foster more interaction between the instructor and students. We limit classes to a maximum of six (6) students unless we are teaching a private group or organization. Each student is provided with a laptop with Microsoft Excel 2019 (Windows) already installed.

Locations: Toronto ” 1 Yonge Street”, Mississauga, Scarborough, Hamilton and Barrie. Mississauga ( 55 Village Centre Pl, Mississauga, ON L4Z 1V9).  Barrie”  92 Caplan Ave. Barrie, ON, L4N 9J2″.  For Advanced Excel Course, go to Toronto GTA Excel Advanced Training

 Duration:   1 day  ( 10 AM- 5 PM) – Weekend and weekdays courses

Special Offers:   Sign up with a friend and save 5% each  – Sign up with 2 friends and save 10%

Bring your laptop: Save $25 ($275 only)  (Your laptop with Microsoft Excel 2013, 2016 or Excel 2019 installed). You can get Microsoft office including MS.Excel 2019 for less than $15/Month from Microsoft Office Official site. Select Office 365 Business

Corporate Training:  Contact us for special offers

 

This Excel Dashboards training course is designed for students wanting to take their Excel Reporting skills to the next level by learning how to build Professional, easily update-able reports and Dashboards.

By the completion of this Excel Dashboards (Excel 2019) training course, you will be comfortable with preparing your data for building interactive reports and dashboards, and making your charts and visualizations Dynamic

With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.

Prerequisites

Our Microsoft Excel Dashboards training course is suitable for those with a sound working knowledge of Excel who wish to learn how to prepare Excel Dashboards . Also the training is suitable for those who took our Excel Intermediate Level Course and Excel Advanced Course

  • Students should know common Lookup functions like VLOOKUP & HLOOKUP, INDEX& MATCH.
  • Students should know summing and counting functions such as COUNTIF,COUNTIFS,SUMIF,SUMIFS and also the IF function.
  • Students should have good understanding of working with pivot tables.
  • Students should have basic understanding of how to create charts in Excel.

Target Audience:

Students who have Intermediate Excel skills and wanting to take their Excel Reporting skills to the next level by learning how to build Professional, easily updateable reports and Dashboards

Course Objectives:

At the end of the course you should be able to:

  • Know how to prepare your data for building interactive reports and dashboards.
  • Know how to choose the color theme for your dashboards.
  • Learn more tricks for using lookup functions like VLOOKUP, HLOOKUP, INDEX & MATCH more efficiently.
  • employ different tricks to make your charts and visualizations Dynamic.
  • Learn special kinds of charts such as the bullet charts, waterfall charts, Pareto Chart, Gantt Chart, Speedometer Chart, Map Chart.
  • Know how to professionally use the form controls in Excel to create professional Interactive reports and Dashboards.
  • Learn how to effectively use slicers to control your reports and dashboards.
  • Learn different dashboarding techniques that can make you update your reports and dashboards with just a few clicks
  • We will also demonstrate step by step how to build a full dashboard in the class.

 

Course Outline

  • Introduction to Dashboards

 

Included Course Materials

  • Course workbook “PDF” including step-by-step course exercises complete with many actual screen captures and advanced project tips, exercises and answers
  • Data files with all applicable Microsoft Excel files used in the course
  • Certificate of completion (PDF)

 

 

For more details about Microsoft Excel , please visit the product  official page EXCEL 2016

 

Contact us

 

Learn What’s New in Microsoft Excel 2019

 

 

Related Classes

Take Microsoft Excel 2019 Fundamentals Training Courses in Toronto, Mississauga, Scarborough , Montreal & Ottawa

Take Microsoft Excel 2019 Intermediate Level Training Classes in Toronto, Mississauga, Scarborough , Montreal & Ottawa

Take Microsoft Excel 2019 Advanced Level Classes in Toronto, Mississauga, Scarborough , Montreal & Ottawa

Microsoft Excel 2019 Tables, Pivot Tables and Conditional Formatting

Microsoft Excel 2019 | Using Formulas for Financial Analysis.

Microsoft Excel 2019 | Using Formulas For Statistical Analysis

Microsoft Excel 2019 | Data Analysis with Pivot Tables

Delivery Methods:

  1.  Classroom Training: Downtown Toronto – Mississauga , Scarborough, Ottawa & Montreal.
  2.  Virtual Classroom
  3.  On-Site Training: At your location, anytime , anywhere
  4.  Corporate Training: Special rates for Corporate Training

Group Discount:

We provide special rate for groups :

  • 5% Discount for Group of 2
  • 10% Discount for Group of 3
  • 15% Discount for Group of 4

PMVISION reserves the right to postpone/cancel an event, or change the location of an event because of insufficient enrollments, instructor illness or force-majeure events.

 

Cancellation & Refund Policy

  • Reserve your seat fee:  Non Refundable. To be refunded if the class is cancelled by PMVISION
  • In case PMVISION  cancels an event, 100% refund will be paid to the delegate.
  • If the cancellation is done by the delegate within 48 hours of subscribing, 10%  will be deducted as administration fee.
  • If a cancellation is done by a delegate 7 days or more, prior to the event, 20% will be deducted as administration fee.
  • If a cancellation is done by a delegate 7 days or less, prior to the event, no refunds will be made
  • Bookings made at discounted prices ( Including Early Bird Booking) cannot be cancelled.
  • If you will have to travel to attend the course, please don’t make any travel arrangements until we confirm the class. We usually usually confirm the class by emails at least one week prior to the start date.

 

IMPORTANT: We recommend waiting to book any non-refundable travel until 1 week  before the start of class. PMVISION is not responsible for any loss incurred as a result of a canceled class. Please email: contact@pmvision.ca for any additional questions.

A certificate of completion(PDF Format) is available upon completing the training.

At our location: (1 Yonge Street)

2 Attendees : $500 ($250 each)

3 Attendees:  $700 ($235 each)

4 – 6  Attendees:  $900

At your location: ( GTA- Daily Rate) 

$800 : Up to 6 attendees

$1000: Up to 12 Attendees

Assuming each attendee will have access to a computer with the software installed. If PMVISION to provide laptops during the training, a $25 fee per laptop to be added

If location is outside Greater Toronto Area “GTA”, travel expenses to be added

Tax to be added