For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Microsoft Excel: Business Charts in Excel

Course Overview

Explore the art of modern data visualization in this comprehensive training course, "Business Charts in Excel: Charting Tutorial." Throughout this course, you will learn to transform basic Excel charts into dynamic visualizations that captivate and inform. Gain essential charting best practices to simplify complex data, ensuring you create compelling visual narratives that resonate today and beyond.

Learn techniques to transform your data into impactful visual stories, like multi-series dumbbell charts and dynamic charts using REPT. Discover how to design alternative bar charts, enhance multi-series doughnut charts, and craft smoothed line charts that captivate your audience. By the end of the course, you will be equipped to create charts that stand out, leveraging advanced Excel functionalities and design principles to elevate your data storytelling.

Learning Objectives:

In this course you will learn how to:

  • Create dynamic multi-series dumbbell charts using different charting techniques.
  • Construct alternative bar charts to display categorical data creatively.
  • Utilize the REPT function for dynamic charts that update with changing data.
  • Enhance multi-series doughnut charts with advanced formatting and interactivity.