UCL Learning Portfolio

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.

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.

• 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.