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. 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
Description
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 the
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.
Prerequisites for attending:
- An intermediate understanding of Microsoft Excel is required.
- A stable internet connection is required.
Having a second display is beneficial but not required