✔ 12 months access
✔ Charts & tables
✔ Pivot tables
✔ Data visualisation

Introduction


The course offers an in-depth understanding of the different types of charts available in Excel.

It has been specifically designed to equip you with the skills you need to create eye-catching and informative tables and charts that will elevate your work to the next level.

Useful to enhance presentations, reports and to improve data interpretation and analysis. Whether you're a beginner or an experienced Excel user, our course will help you master the techniques needed to create clear and concise visual representations of your data.


Learning Outcomes


By the end of this course, participants will be able to:

  • Create and format charts to present data clearly
  • Choose the right chart type for different datasets
  • Edit, label, and customise charts for professional output
  • Build and use pivot tables to analyse data quickly
  • Create pivot charts to visualise key insights
  • Improve presentations using clear visual techniques

Course Curriculum


  Bayfield Training | Executive Education
Available in days
days after you enroll
  Induction and Course Instructions
Available in days
days after you enroll
  Module 1 | Exploring the Insert Tab
Available in days
days after you enroll
  Module 2 | Understanding the basic Excel Chart concepts
Available in days
days after you enroll
  Module 3 | How to Edit a Chart
Available in days
days after you enroll
  Module 4 | PivotTable and PivotChart
Available in days
days after you enroll
  Wrap up
Available in days
days after you enroll

One-Time Payment

On-Demand Course with 12 Months Access

£50 + VAT
Start Learning Today
What you get with this course:
✔ 12 months of on-demand access
✔ Step-by-step guidance on creating charts and tables in Excel
✔ Practical exercises using real estate-style data
✔ Hands-on experience with PivotTables and PivotCharts
✔ Techniques to improve data presentation and clarity
✔ CPD-accredited certificate upon completion
Student Discount Available

Students may be eligible for a discounted rate on this course. For more information, please contact our sales advisor:

Jacob Noble
j.noble@bayfieldtraining.com

Featured Courses


Fundamentals of Cash Flow Calculations

This course goes right back to the very beginning and makes sure you have the tools to grow, discount and value income streams from property

Bayfield Training

Bayfield Training

£200

2026 | Excel Fundamentals

Learn how to set up, navigate and effectively use Excel spreadsheets Key Learning Objectives: · Navigate through the Excel interface · Write simple formulas and perform statistical functions in Excel · Efficiently use keyboard shortcuts to navigate and complete spreadsheets · Formation and modifying worksheet · Save, share and print workbooks Note: Microsoft Windows is the main operating system we are using to explain the features of excel. For more information visit our website: www.bayfieldtraining.com

Bayfield Training

Bayfield Training

£10

NEW !! Introduction to Real Estate Financial Modelling in Excel

An introductory course in which you will learn essential Real Estate financial modelling theory, functions and formulas. The training aims to give delegates a grasp of MS Excel and its usage in real estate cash flow modelling. You will be able to set up a financial modelling cash flow from a blank spreadsheet by using the most common shortcuts, formulas and functions. We will also cover the use of pivot tables to clean and organise your data. This is an excellent starter/refresher course, whether you’re a recent graduate or a mid/senior professional.

Bayfield Training

Bayfield Training

£300

Would you like to speak to one of our friendly learning & course advisors?

We're here to help you choose the right course and answer any questions.

Jacob Noble

Jacob Noble

Chief Executive Officer

j.noble@bayfieldtraining.com

Emma Wilson

Emma Wilson

Marketing Executive

e.wilson@bayfieldtraining.com