What you will learn
- the types of charts that are available in Excel and when to use them
- how to present data effectively
- how to create bespoke and dynamic charts, using the latest Excel functions
- how to create effective dashboards that tell a story.
About this course
Do you need to know what charts are available in Excel and when to use them to get your message across? Are you able to modify chart elements so that your dashboards are easy to understand immediately? We explain how to create each type of standard chart, from column charts to waterfall charts, and show you how to create complex bespoke charts. We demonstrate how to make charts dynamic and create an effective dashboard design, including some tips on how to use VBA to enhance the user experience. If you want to make your Excel dashboards more exciting with eye-catching visuals, this is the course for you.
Key information
- This course contains a collection of interactive slides and videos for you to follow, and exercises for you to complete within Excel.
- This course requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021 (Excel 2019 for MAC support will end in October 2023).
- The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
- This course requires you to have a basic understanding of Microsoft Excel.
- CPD certificate is available upon successful completion of the course.
