Microsoft Excel Charts Deep Dive

The goal of this course is to teach participants how to build advanced charts in Microsoft Excel that are easy to read, interactive, and dynamic.

Dates

There are no dates currently scheduled for this course.

Interested in this course? Suggest a date/location

Description

The goal of this course is to teach participants how to build advanced charts in Microsoft Excel that are easy to read, interactive, and dynamic. The focus will be on creating charts that effectively tell a story about the data and provide additional insights to the reader. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk Group bookings are available and can be tailored to your needs. Courses may be delivered onsite, virtually, in person, or on campus. To arrange a private course, you can register your interest Register interest in a private course

Target Audience:

• Individuals with an intermediate understanding of Microsoft Excel who want to enhance the

Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.

Prerequisites

An intermediate understanding of Microsoft Excel is required.

A stable internet connection is required.

Having a second display is beneficial but not required

Content

Attending this course will help you to:

Build column charts with percentage change.
Construct a conditional doughnut progress chart.
Create an interactive histogram with details.
Develop a dynamic histogram or frequency distribution chart.
Build an annual trend with monthly details.
Create an interactive waterfall chart.
Add variance to clustered charts.
Build an actual vs. multiple targets chart.
Create a stacked bar with dynamic data labels.
Build a comparative distribution chart.
Implement a zoom on charts macro.

Certification

College certificate of attendance