Spreadsheet Development

Further Details
Course Code
LA99298
Location
Yale
Duration
Part Time, Yale – Tue – 18:00-21:00 – 17/01/2023 to 28/03/2023
Department
Digital Technologies, Computing & IT
Start Date
17 Jan 2023
End Date
28 Mar 2023

Shortlist

Course Overview
Spreadsheets are used to store, manipulate and analyse data and to present it in easy-to-understand ways. They are invaluable for collecting and manipulating data of all types. Spreadsheets can be formatted to create clear, concise reports and can be sorted, filtered and updated with the touch of a button.

Spreadsheets are used extensively in many organisations to help people carry out their job roles. For instance, accountants use spreadsheets to keep track of the money going into and out from a business, and scientists use them to analyse the results of their experiments and record the data for use in the future.

In this course you will understand the many uses for spreadsheets and the tools and techniques that are available and become skilled at using them. You will be able to apply some of your findings to your own spreadsheet solutions.

In this course, you will understand the many uses for spreadsheets. You will discover the many tools and techniques that are available in spreadsheet software and will become skilled at using them. You will investigate some of the ways spreadsheets are used in real-life. You will design a spreadsheet solution for a brief. You will then develop and test your spreadsheet solution to store, manipulate and analyse a large amount of data and present the output data in an easy-to-understand way. Once completed, you will review the finished spreadsheet solution having obtained feedback from others, and evaluate possible improvements.

Learning Aims

Know why organisations use spreadsheets
Tools and techniques
Purpose of tools and techniques
Designing a spreadsheet
Use spreadsheet software tools and techniques, e.g.:
● cell manipulation (e.g. entering and editing data, autofilling, replication,
conditional formatting (to highlight outcomes))
● cell formatting (e.g. colours, shading, merging cells, alignment)
● data manipulation (e.g. filters, sorts, pivot tables)
● formulae (e.g. add, subtract, divide, multiply)
● functions (e.g. sum, average, count and countIF, lookup, index)
● logical functions (e.g. IF, AND, OR, NOT)
● data validation
● relative and absolute cell referencing
● boxes (e.g. lists, drop-down)
● data entry forms
● lookup tables
● nested IF functions
● cell protection
● types of charts and graphs (e.g. bar, pie)
● chart and graph formatting (e.g. titles, resizing, labels)
● worksheets (e.g. headers, page breaks, links)
● conditional formatting
● named ranges, relative and absolute cell referencing
● goal seek – what if function
● macros
Test and refine a spreadsheet
Reviewing the spreadsheet solution
Ongoing assessment via tasks and tutor monitoring. Main assessment for this unit is portfolio-based.
There are no formal entry requirements, although a familiarity with computers and websites in general is required
Achieving this qualification will give you an advantage when applying for employment in almost any role, as spreadsheets are widely used in almost every sector.
£99 or free if eligible for PLA funding. To be eligible, you must be over 19, employed and earning under £29,534 per year or a furloughed worker (any salary) or self-employed
Useful downloads

Ready to begin your journey? Apply now

Our open days

Our Open Days is your chance to explore the College and find out the range of courses we offer.

Cambria Christmas Markets – Yale
06/12/2022

Cambria Christmas Markets – Deeside
13/12/2022

Accessible Open Event – Deeside & Deeside Sixth
14/12/2022

17:30

Our Open Events are the perfect opportunity for you to have a look around & get all the info you need to help you make a decision on your next step.
Accessible Open Event – Northop
01/12/2022

17:30

Our Open Events are the perfect opportunity for you to have a look around & get all the info you need to help you make a decision on your next step.

Got a question?

Here’s how you can get in touch

A blue phone icon

Contact us

Email Us

Email

Follow Us

Follow us

Got a question?

Here’s how you can get in touch

A blue phone icon

Contact us

Email Us

Email