Excel: Creating Charts Using Excel
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.
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 email@example.com
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.
Staff who wish to learn more about displaying data graphically and those interested in taking the ECDL Advanced module in Spreadsheets.
Previous attendance at Excel 1: Essentials or a similar level of experience of using Excel.
Currently offered via self study
Course Contact DetailsName: IT Training and Assessment Unit
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