For information on course costs and booking onto a course, please click here. For any queries please contact us on Training@ttslonline.com or call: 01582 550019Welcome, Guest

Microsoft Excel 365: Charts and Graphs

Course Overview

Charts and Graphs: Learn Excel 365 teaches you how to turn raw data into clear, engaging visuals that capture attention and communicate insights effectively. You will explore how to choose the right chart type, select relevant data, and remove unnecessary elements to create visuals that tell a compelling story. This learning experience is designed for anyone who wants to enhance their ability to present data professionally and persuasively.

You will work with Excel’s recommended charts and discover how to customize them using the Chart Design and Format tabs. Techniques include adjusting chart layouts, modifying colors and labels, and linking chart titles to worksheet data for automatic updates. You’ll also learn about specialized charts such as area, bubble, radar, and candlestick stock charts, giving you flexibility for different types of analysis.

The course emphasizes practical applications, from adjusting rows and columns to refining chart aesthetics for maximum impact. Applying these techniques simplifies complex data, highlights key information, and engages your audience more effectively.

By the end, you will have the skills to design professional charts that support data-driven decisions, improve audience understanding, and make your presentations more impactful.

Learning Objectives:

In this course, you will learn how to:

  • Create various charts from Excel data.
  • Customize charts using the design and format tabs.
  • Link chart titles to worksheet data dynamically.
  • Construct and interpret area charts effectively.
  • Build and format surface charts in Excel.
  • Generate and customize radar charts for comparisons.
  • Create and interpret bubble plot charts.
  • Build candlestick charts for stock data analysis.