Excel for Work: Formulas, Functions and Formatting - Mansfield Central Library - Community Learning

Mansfield Central Library, Mansfield

Date	14 June - 5 July 2022
Sessions	Tuesdays: 1:30pm - 3:30pm
No. sessions	4
Venue	Mansfield Central Library, Mansfield View venue details
For ages	19+
Group size	5 - 12
Cost	FREE - £24

About this course

This short 4-week course will take you through key formulas and functions needed for intermediate level users. The course is designed to help you, not only improve your knowledge of Excel but also improve your employability.

Areas covered:

Formulas

Totals/Add/Average
Min/Max
Average
Absolute cell references
Pivot tables

Formatting

Numerical formatting
Using the ribbon to format a spreadsheet
Formatting within a cell

Functions

Printing with formulas showing
IF function

This course could be FREE if you claim certain benefits or are in employment.

Having a good understanding of Excel will help you gain employment, for example, in the following areas:

Administration
School-based office administration
Data Entry
Accounts
Retail Manager

Learners on this course should already be familiar with Excel and be able to create simple spreadsheets.

Learners will also need an active email account as resources will be emailed throughout the course.

face-to-face

intermediate - users will need to be familiar with Excel

laptops available in the session

Booking your place and fee information

If you are in receipt of certain benefits you will be offered the course for free, however if you have a financial barrier which may prevent you from enrolling on the course please visit our webpage for further information https://www.inspireculture.org.uk/skills-learning/funding-your-courses/

To secure your place on the course BOTH the following must be done:

Complete the EVENTBRITE BOOKING.
Complete our INSPIRE ONLINE ENROLMENT FORM for each person attending the course.

You should be redirected to the Inspire Online Enrolment Form after completing the Eventbrite booking. If you are not redirected, please use the link supplied in the Eventbrite booking confirmation email.

To book and enrol on one of our courses, you must have been living in England and have been resident in the UK for the past 3 years.

Some exceptions may apply if you are living in England with evidence of the right to remain and are from an EEU/EEAU country (completion of a questionnaire will be required).

As we no longer receive funding for our ESFA-funded courses for learners living in the devolved areas listed below, full cost fees would apply to these courses if you live in these areas: