Microsoft Excel Charts/Graphs Deep Dive
Course Overview
Course Overview:
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.
Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.
Target Audience:
- Individuals with an intermediate understanding of Microsoft Excel who want to enhance their chart building skills and create more advanced and interactive charts.
Course Content:
- 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
Pre-requisites for attending:
- basic understanding of Microsoft Excel
- Stable internet connection
- No previous understanding of macros is required
- Having a second display is beneficial but not required
Programme Information
Study Mode: Virtual (via Teams)
Duration: 6 hours
Times: 9.30 - 4.00pm
Price : £90
For further information on this course contact corporate@wcs.ac.uk or call 0141 581 2121 .