UCL Learning Portfolio


DSD: Charting with Excel 2016
Course Description:

This session is for those familiar with Excel who would like to start creating or learn more about using charts. It begins with the basics and moves onto some intermediate topics.


We recommend that you attend our Software for Success: Winning with Charts demonstration session before attending this course (or watch a recording of a previous session in Moodle) and check that you have the following prerequisite skills:

  • Selecting non-adjacent data.
  • Familiarity with the Excel interface.
  • Some understanding of basic statistics or data analysis


Please ensure you are using Desktop@UCL or the UCL VPN when booking because you need to be on the UCL network to use the system.

Once you have enrolled, you will need to click on the play button under 'My current enrolments' in My Learning to join at the time of the live session. You will also receive an email from ISD containing the direct joining link a day before the session. Please check your junk folder as these emails are occasionally tagged as spam.

We would encourage those who are new to Microsoft Teams to join within the first 15 minutes of the advertised start time in order to test out their connection/audio. The actual session will start on the hour.
At the end of this course you will be able to:
  • Use multiple methods for creating differing types of charts.
  • Identify the key features of charts.
  • Format a chart and the chart area to aide readability and accuracy.
  • Plot non-adjacent data in a spreadsheet.
  • Choose between embedded and non-embedded charts in documents.
  • Add detail to charts to show variability in measures plotted in a chart, e.g. error bars.
  • Include features to charts to show the slope of data points and present data changing over time in order to help users understand the data and to predict trends, e.g. trendlines.
  • Understand how chart formatting can be misleading.
  • Select and use appropriate chart print options for a specified purpose.
Intended Audience:
This course is aimed at those familiar with Excel who would like to start creating or learn more about using charts.
Target Audience: All
Register Interest in future dates Register Interest

Back to MyLearning Catalogue