$525 – $600

The Marquee Group - Data Analysis and Communications with Excel

Event Information

Share this event

Date and Time

Location

Location

The Marquee Group

56 Temperance Street

Suite 200

Toronto, ON M5H 3V5

Canada

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

The Data Analysis and Communication Course provides practical tips and hands-on application to a variety of data management, charting and formatting skills in an Excel environment.

Participants will build a series of charts that complete a sample dashboard that provides summary analysis and detailed displays of the underlying data. A variety of chart types will be explored. Automating titles, creating informative labels and text boxes and learning best practices for dashboard design and construction will also be covered.

Topics Include:

Communicate with the optimal chart types and formatting

  • Determine the optimal chart for presenting types of data
  • Learn design ideas for simple and elegant charts
    • Colour, position, size and shape
  • Learn complex chart structures such as bubble charts and multiple chart styles in a single chart
  • Use slicers and other tools to rapidly create interactive and flexible analysis

Data organization and manipulation best practices

  • Organize and manage data effectively for chart and table creation
  • Employ sophisticated automation techniques to manage data
  • Use pivot tables to build powerful data analysis capabilities and link them to charts

Powerful formatting and automation techniques

  • Use formulas to automate titles and labels
  • Use conditional formatting for unique data display and highlighting techniques
  • Use text functions to create powerful descriptions in your charts
  • Chart formatting tips to simplify chart creation and to build elegant and easily maintained visual reports

Who Will Benefit:

This seminar is designed for anyone who wants to use Excel to manipulate data and communicate the results using charts that are robust, dynamic and effective.

Eligible for CFA & CPA professional development hours.


Date & Time
Friday, February 8, 2019
8:30 am to 5:00 pm

Special Instructions

  • Attendees must bring their own laptop with access to Excel.
  • This course assumes the participant is comfortable with the skills that are taught in Data Manipulation with Excel - Part 1 and Data Manipulation with Excel - Part 2.


Registration Deadlines

Early Payment Pricing: $525 + tax (if registration paid by January 25, 2019)

Regular Pricing: $600 + tax (registration closes on February 5, 2019)


*Please note that student pricing is available. To obtain a 40% discount, please email a scanned copy or photo of your student ID that clearly shows your name and expiration date to info@marqueegroup.ca. Once we confirm your status as a current full-time student, we will provide you with a student discount code.

Share with friends

Date and Time

Location

The Marquee Group

56 Temperance Street

Suite 200

Toronto, ON M5H 3V5

Canada

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved