Level 3 Spreadsheet Software

Learning Microsoft Excel is one of the most valuable and indispensable skills you can have for work and personal life. Excel can streamline many aspects of everyday tasks. This Includes creating budgets, expense tracking, project planning and goal setting.


Academic Year: 2024/25
Course Code: 10945
Study Type: Part-Time
Education Level Further Education
Department: Computing/Software Engineering/Networking

Available Sessions

The following sessions are open for application on this course:

Campus & Course Type Start
Part-Time
Online
26/08/2024
Time: 18:00-20:30
Part-Time
Online
26/08/2024
Time: 10:00-13:00
Part-Time
Online
26/08/2024
Time: 10:00-13:00
Course Overview

In this accredited course we will expand on skills covered in Level 2 and explore the more advanced features of Excel. This will show you the skills you need for creating and collaborating on a shared workbook including how to protect a workbook and its structures. This course will cover the more advanced formulas and functions that can be applied to give you full control over the data that you are working with -  including VLOOKUP, Pivot tables, Forecasting tools and Data validation to name a few.   

During the course you will be assessed via an assignment that will allow you to put your new skills into practice and gain your qualification. There will be class time provided for the completion of this, however independent study time may be required to ensure you meet the set deadlines.

Class time

  • 2.5 hours per week for 10 weeks for online classes that will include step by step guides, live demonstrations, challenges, video tutorials and time to work on your portfolio.  

Independent Study

  • You will be given ample time in class to work on your portfolio of evidence. However, you are also expected to dedicate adequate time for independent study for your portfolio outside of class if required to ensure you meet any set 

How will I be assessed?

  • During your course you will complete: A Portfolio of Evidence. A 10–15-minute 1-1 Recorded Evidence Session with your tutor.

This course covers the Level 2 Unit in Using Spreadsheet Software.

You need to record or keep track of large amounts of data, or you use Excel in your job role daily. Having advanced skills in Excel can help simplify everyday tasks and assist you with identifying trends in your data more effectively through advanced formulas and functions and understanding how the advanced tools work within Excel and how you can apply these.

If you are a manager or a team leader and want to create a shared workbook for your employees to collaborate on, work with large data and want to learn more techniques to manage this, or if you would just like to become more efficient in your everyday use of Excel, this course is perfect for you.  

On completion of this unit, a candidate 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.

  • Range of data entry, manipulation, and outputting techniques. For example, Data Entry Forms, importing data and linking and embedding objects;
  • Tools, formulas, and functions needed to analyse and interpret the required information (for example, data validation, pivot tables, VLOOKUP, What-If Scenarios); 
  • User will take full responsibility for setting up and developing the functionality of the spreadsheet. Typical examples may include - developing summary reports from a large data set, protecting workbooks and their structures, controlling the input of data using advanced features and functions. 

Learning advanced Spreadsheet Software tools and techniques will improve your efficiency and everyday working when using Spreadsheets and collaborating with others.

Should you wish to progress to higher level qualifications, SERC can support this.

  • To be eligible for enrolment you will require a Level 2 C&G Spreadsheet Software qualification, or equivalent.
  • You will need access to a laptop or computer capable of running Microsoft Office. (Microsoft Office can be made available to download when you enrol)
  • You will need a working microphone and speakers to participate in the classes.
  • Due to the classes being run online, you will need a reliable internet connection.

Available Sessions

The following sessions are open for application on this course:

Campus & Course Type Start
Part-Time
Online
26/08/2024
Time: 18:00-20:30
Part-Time
Online
26/08/2024
Time: 10:00-13:00
Part-Time
Online
26/08/2024
Time: 10:00-13:00

Enquiries Information

For more information or help with this course send us an enquiry and a member of our team will get back in touch.

Available Sessions

Business Services Course

Funding may be available for this course, please contact us on BusinessServices@serc.ac.uk to discuss if you are eligible. Additional sessions may be available for this course throughout the year. Please contact us to discuss a start date that would be suitable for you.

Course Type Title Campus Start Spaces Fee Apply or get more information
PT
FE
Level 3 Spreadsheet Software
Y10945OE1A

Online

26/08/2024

Time: 18:00-20:30

20+ £381.00
PT
FE
Level 3 Spreadsheet Software
Y10945OD1B

Online

26/08/2024

Time: 10:00-13:00

20+ £92.00
PT
FE
Level 3 Spreadsheet Software
Y10945OD1A

Online

26/08/2024

Time: 10:00-13:00

20+ £144.00

Please select a campus from the list above to view the available sessions.

Customer Enquiries

Need more information or have a question about this course? Send us a message below and we will get in touch.

Start New Enquiry

Terms & Conditions

Students will be required to comply with SERC's Terms & Conditions of study.

We strive to ensure the description of courses on SERC's website and in publications is accurate. However, for various reasons there may be occasions when the College may need to change arrangements or be unable to deliver classes due to circumstances such as reduced funding. If there are insufficient numbers applying for a course it may not be viable to deliver the class.

Further Education

Further Education

If you have just completed your GCSEs, Further Education is most likely the option for you. FE covers qualifications from entry to higher level qualifications such as Awards, Certificates, Diplomas, NVQ, BTEC and Apprenticeships.

Explore Further Education