Doctoral Academy Programme Bookings

In order to register for a session, you must first log in. You will be returned to the workshop session, once logged in.
Excel: Using Graphs and Charts to Present Your Data, Microsoft - Webinar
Domain: A1 Knowledge base

TACE: C - Completion

Format: Webinar
Suitable for: All

Due to Covid-19 Excel: Using Graphs and Charts to Present Your Data, Microsoft will be run as a webinar.

This introductory session will look at how graphs can be created and formatted using Microsoft Excel. Graphical data of this form can easily be incorporated into documents and time will be spent looking at how numerical data can be displayed visually using Charts & Graphs.

The course begins by describing the charting process and looking at different chart types. It continues by showing and practising the separate constituent parts within a chart.

There is an introduction to using Pivot Charts to extract smaller amounts of meaningful data from large spreadsheets.

At the end we look at Chart Object Formatting and we do an exercise that shows how to link Excel worksheets together to pull data from one worksheet into another and also how to plot data that has different units of measurement onto the same graph by using two Y axes concurrently.

This is a practical course and there is an opportunity for those students using a laptop to practise the techniques as we go along.

By the end of this session you will be able to:

• Confidently Create Charts & Graphs in Excel using a variety of methods
• Accurately select data ranges from both consecutive and non-contiguous cells
• Select and configure the separate parts of a chart
• Gain an understanding of charting process
• Use Pivot Charts
• Format Chart data using Excel formatting tools

Places are allocated on a first come first served basis.

Please express your interest in this webinar. Joining instructions will be sent the day before the session.

To make full practical use of the session, attendees will need to have both Microsoft Word and Blackboard open at the same time for the duration of the session.

It is also recommended that attendees use a screen of at 14 inches in size as well as a keyboard and mouse for the practical segments of the session. Attendees using smaller screens or devices without a keyboard and mouse are encouraged to maximise the Blackboard session window and watch the presentation as a demo in order to get the best possible benefit out of the session.

IMPORTANT NOTE - This session runs best using the Google Chrome browser, please use this if possible to ensure the best possible experience.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
For more information on identifying and accessing online learning resources click here

For more information on replacement learning events such as webinars and retreats click here