NOTE: Course login details are normally sent to registrants within one week from date of registration.
EL22230091
This in-depth course will teach you how to build a custom Excel dashboard using professional data visualization techniques. By the end of the course you will have a solid understanding of how to tell a story by combining data, charts, graphs, and other visuals.
WHO WILL BENEFIT
This Excel dashboards course should be taken by any type of financial analyst working in corporate finance. This includes financial planning & analysis (FP&A), corporate development, equity research, and investment banking.
KEY LEARNING OBJECTIVES
This course will teach you all about the most important data visualization techniques, including:
- How to focus attention
- How to use white space effectively
- Storytelling with data
- Narrative techniques
- A variety of visuals
- How to use affordances
- Storyboarding
Additionally, this online course will teach you how to create a dashboard in Excel from scratch. The main dashboard topics covered in this class include:
- Page layout and design
- Linecharts
- Area charts
- Column and bar charts
- Gaugecharts
- Formatting and design
CPD- 4 Hours