Formulas, Analysis and Publishing Data - Online Course - Adult Learning

Online Courses, Nottingham

Date	18 - 19 July 2023
Sessions	Tuesday: 9am - 2pm Wednesday: 9am - 2pm
No. sessions	2
Venue	Online Courses, Nottingham View venue details View on Google Maps
For ages	19+
Group size	5 - 50
Cost	Free

About this course

On completion of this course students should be able to select and use a wide range of advanced spreadsheet software tools and techniques to produce, present and check complex and non- routine spreadsheets. They will also be able to use a software application designed to record data in rows and columns, perform calculations with numerical data and present information using charts and graphs.

Skills shown will also help to use a spreadsheet to enter, edit and organise numerical and other data, select and use appropriate formulas and data analysis tools and techniques to meet requirements and use tools and techniques to present, and format and publish spreadsheet information. More specifically topics will include adding data, naming sheets, merging and centring cells, editing, formatting, inserting hyperlinks, linking data/cells, formulas like 52 week high and low and changing data to stock. Formulas and functions like; sum, minus, multiply, divide, named ranges, lookup, average, percentages, IF/AND, frequency, conditional formatting, creating a basic pivot table, charts, forecasting. Merging cells vertically, gridlines and borders, freezing rows/columns, combination charts, print options, spell check, and error checking.

This is a higher-level course that should not be attempted without prior training at level 2. This course can be combined with any other digital skills courses.

PC / Laptop with Working Internet, Teams and Excel. Zoom will be used during this course.

As this course is online, a suitable device such as laptop, smart phone, tablet or computer will be required to access the course. Zoom will be used for the live sessions and the link will be sent to you once your enrolment has been completed.

Booking your place and fee information

To register your interest, please complete this form – we will check your eligibility and contact you to enrol.

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: