Logo
Business
Application Portal
Mastering Excel | XSCZ3482 | 2022/23
Business
Application Portal
Mastering Excel | XSCZ3482 | 2022/23
Availability
Please note that we are not taking any more bookings for this course at the moment. However, we may be able to run this course for a group/organisation - please email statistics@herts.ac.uk for more information.
** Applications will ordinarily close 1 day before start date of a course.

Description

This is a two-day course taking delegates from the basics of using a spreadsheet package such as Excel, through organising numerical and other data, using formulae and functions, absolute and relative references to producing tables, graphs and summary statistics.

The topics covered in the first day are using a spreadsheet to enter, edit and organise numerical and other data, worksheet shortcuts (e.g. AutoFill, copying and moving cells, inserting and deleting rows and columns, AutoSum), using formulae and functions, absolute and relative references. These topics will be demonstrated using Excel. This first day of the course can be taken on its own as our "Mastering Excel Basics" course.

The second day takes delegates beyond the basics of using a spreadsheet and is aimed at those who need to produce tables, graphs and summary statistics from data using a spreadsheet package. The topics covered are sorting and filtering, pivot tables, creating charts/graphs, summarising data. Again, these topics will be demonstrated using Excel.

See our full range of courses (and options for bespoke courses) at https://go.herts.ac.uk/sscu or contact the course organiser, Professor Neil Spencer, at statistics@herts.ac.uk.

PreRequisites

No prior knowledge of Excel is required.

Assessment

There is no formal assessment as part of this course.

Venue
Online
Apply Now
Enquire Now
Course Leader
Name: Neil Spencer
Duration
Two days
Price

If you are unable to pay by card and require an invoice, please email statistics@herts.ac.uk.

Learner Hours
14
Mode of Delivery
Online
Apply Now
Enquire Now