Skip to Content

Course Details

Excel: Creating Charts Using Excel

Event Description

This specialised course looks at the charting feature in Excel and discusses some of the different types of charts that can be created, in particular, line, scatter, pie, bar and column charts. It also covers how to edit scientific or statistical charts to include features such as secondary axes and error bars and how to format charts, both manually and by using the new chart styles available in Excel. Participants will be able to practise creating and formatting different types of charts by completing a series of exercises and will also learn how to set the default chart type and how to create a chart template.

Covid-19 restrictions

Due to Covid-19 restrictions face-to-face training will not be offered at this time.  This course will take the following format:

  • Course participants access a workbook and associated files here.
  • Additional topic specific resources (see link below) can be accessed as required
  • An online clinic to address any queries/problems will be running on 18 November, 10.00 - 11.00.  If you wish to attend this clinic please email s.mcmorrow@qub.ac.uk

Additional Resources

This collection of resources can be accessed via LinkedIn Learning, an online learning resource for staff.  New users will need to complete the LinkedIn Learning sign up here.

Excel Charts 


Aims/Aimed at

Staff who wish to learn more about displaying data graphically and those interested in taking the ECDL Advanced module in Spreadsheets.

Pre-requisites

Previous attendance at Excel 1: Essentials or a similar level of experience of using Excel.


Booking Information

Currently offered via self study


Course Contact Details

Name: IT Training and Assessment Unit
Telephone: 6189
Email: itcourses@qub.ac.uk
New Course: No
Course Type(s): Spreadsheets - Continuing Professional Development
Staff Categories: All Staff
Keywords: Excel, Spreadsheets, Charts, Axes, Error bars, Chart Styles, ECDL Advanced