LIVE Data Visualization in Excel (Boston)

Author: Jon Peltier

This product includes registration for the LIVE, in person, 1-day Data Visualization in Excel Boot Camp with Jon Peltier in Boston, MA.

Duration:
8h
Tools:
  • Excel
Skills:
  • Data Visualization

What you'll learn?

  • Understanding chart data and different chart types available in Excel
  • Creating and formatting various types of Excel charts
  • Building dynamic and interactive charts in Excel
  • Using non-chart visualizations such as heat maps, sparklines, and icons
  • Working with small multiples, Pivot Charts, and other data visualization techniques
Course

LIVE Data Visualization in Excel (Boston)

$495(All prices in USD)
  • 8h of training content
  • Support and Discussion
  • Certificate of Completion

Out of stock

LIVE Data Visualization in Excel (Boston)

This is a LIVE, in person training package, delivered over 1 day in a small group format (20 people maximum).

Course Description

In the Data Visualization in Excel Boot Camp, Microsoft MP and charting expert Jon Peltier will cover both the theory and practice of charting in Microsoft Excel through hands-on learning. It will

start off by diving into charting theory, including such topics as data, chart types, and formatting. The practice portion of the course will cover combination charts, conditional formatting of charts, custom chart types, dynamic charts, and interactive charts, with numerous tricks sprinkled in.

This is an intermediate level course with topics ranging from basic to advanced. Attendees should have good Excel skills including formulas and data management techniques, and at least a passing familiarity with creating charts in Excel and general formatting in Office programs.

Attendees will learn to craft effective charts. They will gain an understanding of what makes efficient chart data, and how to manipulate data and formatting to achieve desired chart styles. Chart types and formatting will be covered – not only the how, but the what and why.

Participants will also learn how to work with the different elements of charts. They’ll be able to leverage worksheet formulas and controls to make dynamic charts that reflect changing data and interactive charts that reflect user selections.

While not focused on dashboard reports, the course will include dashboard-related topics such as small multiples and non-chart visuals.

You can view a full listing  of the topics covered in this course by downloading the Course at a Glance document (PDF download).

Who this course is for?

  • Anyone who needs to create charts and other data visualizations in Excel.
  • Attendees who are looking for guided, hands-on training in a small group setting as they learn a new topic.
  • Attendees should be experienced working in Excel, including formulas and data management techniques. Familiarity with charting an asset but not required. 

Course Schedule

This course is 1 day of in person, hands-on training with Jon Peltier in a small group setting (20 people maximum*). There will be time set aside refreshment and a lunch break.

Location: Boston, MA

DatesTime
No future dates scheduled9:00AM – 4:30pm

*If you are registering for more than 1 person, please see the information on group registrations in the FAQ section at the bottom of this page.

Included with Registration

  • Exclusive access to practical hands-on training in a small group setting (20 people maximum) from Microsoft MVPs Ken Puls and Jon Pelteir
  • A USB with all files for use during the course
  • Catered lunch and 2 refreshment breaks
  • Additional learning resources and tools, as noted below

Bonus Gifts

Recording of the live Data Visualization in Excel event

1 license to Peltier Tech Charts for Excel 4.0

Software Requirements

You must bring a laptop with the following installed:

  • Excel 2016 or higher (Office 365 recommended)

Notes on Software Requirements

  1. Don’t have Excel 2016 or higher? You can sign up for a free one-month trial of Office 365 Business Premium. (Click here to learn more.)
  2. If you are running Excel 2016, please go to Windows Update -> Advanced and make sure you’ve checked the box to receive updates for other products when you update Windows!
  3. This course is taught on the Windows platform. (Running a Windows instance in a Fusion or Parallels is fine, but we cannot provide support to set this up, as we are not Mac users.)

Refund & Transfer Policy

Please note that if you must cancel your registration, it is refundable for online credit only; no cash refunds are available on this course.

If you cancel your registration on or before [date] you will receive a credit of the original purchase value that may used towards any of the courses or other digital products offered on the Skillwave Training site. Because of the site rental and catering arrangements, no refunds (credit or otherwise) are available for cancellations on or after [date].

If you are not able to attend, you may transfer your registration to another individual. Please contact us through our online contact form for more information if you need to transfer your registration.

Please note that Skillwave is not responsible for any travel or accommodation costs that registrants may incur, including any that may be due to changes or cancellations.

Course Formats

Coached
This LIVE, on-site, in person training is conducted over 1 day. You will receive hands-on training directly with Jon Peltier in a small group setting (20 people maximum).

How does the subscription work?

This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.

About the author

Jon Peltier

Microsoft MVP
Jon Peltier is a master of leveraging the power of Excel to produce and simplify complex solutions in engineering, finance, and marketing. His background includes Statistics, Total Quality, and Six Sigma, and he knows more about Excel charts than practically anyone. Jon has been a full time Excel developer since 2004, and has received Microsoft’s Most Valuable Professional award for Excel every year since 2001.

FAQs

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.

  • Power BI
  • Power Query
  • PowerBI.com
10h 30m
6 Modules
  • Power BI
  • DAX Studio
  • Power Pivot for Excel
10h 30m
5 Modules
$350