UCL Learning Portfolio


DSD: Charting with Excel
Course Description:

Show your data in graphical formats using Excel for further analysis, presentation and dissemination.

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.

This is a 90-minute workshop delivered remotely.


Familiarity with the Excel interface is required, e.g. use of menus, copying and pasting in cells, and formatting text.

Once you have booked on the course you will be able to access all the online materials in our Digital Skills Development Moodle course.


Once you have enrolled, please check that you have received a confirmation email from MyLearning. You will also receive an email with a joining link at least one day before the session.

Please arrive 5 minutes prior to the start of the course to allow time for logging in and downloading resources.

For more details on how to book, cancel and join sessions please visit our practical course information page.

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 aid 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
Course Contact: Digital Skills Development isd-digiskills@ucl.ac.uk
Further Information: https://www.ucl.ac.uk/isd/services/learning-teaching/learning-teaching-services/digital-skills-development/digital-skills
Register Interest in future dates Register Interest

Back to MyLearning Catalogue