UCL Learning Portfolio

 

DSD: Charting with Excel
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.

PREREQUISITES:

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

  • Familiarity with the Excel interface.
  • Some basics skills such as selecting non-adjacent data.

IMPORTANT:

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.

Courses start on the hour but please join during the 5 minutes prior to this to download resources and test out your connection/audio.

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


Objectives:
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
01/12/2022 - 01/12/2022  (Enrol between 31/07/2022 and 29/11/2022) Enrol

15/03/2023 - 15/03/2023  (Enrol between 21/11/2022 and 13/03/2023) Enrol

Register Interest in future dates Register Interest

Back to MyLearning Catalogue