Excel – Data Visualisation Workshop

Duration: 2 hours

Our Excel Data Visualisation workshop looks at creative ways to present data in Excel. It looks at creating data to give a more visual appearance and shows tips and tricks for effective working.

By the end of the course, you will be able to visually present data using specific Excel tools. You will learn how to set up and customise different charts/graphs, how to use conditional formatting, sparklines and data types to present data.

By the end of the course you will be able to be:

  • Present data using Sparklines
  • Setup Conditional Formatting
  • Create Graphs/Charts
  • Use Data Types
  • Tips and tricks for building worksheets
  • Adding functions
  • Creating sparklines and showing trends
  • Changing the cell format depending on set criteria
  • Databars, Top/Bottom Rules and Colour Scales
  • Creating simple charts
  • Changing the type of graph
  • Adding data labels
  • Customising the graph
  • Using Combo charts
  • Creating Geographical data types
  • Extracting and Inserting data
  • Creating a map chart

The section on using the geography tool was brilliant, I like to think I’m well versed in Excel but this blew my mind! I showed my 13 year old son as it may come in handy with his schoolwork.

Megan, St Catherine's Hospice

Great session, well run, so much better than many I have seen and great idea for HR functions development – should be compulsory!

Lynda, Interim

The section on using the geography tool was brilliant, I like to think I’m well versed in Excel but this blew my mind! I showed my 13 year old son as it may come in handy with his schoolwork.

Tim, South Western Railway

Back to all courses