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.
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 UnitTelephone: 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