Level 2 Unit Spreadsheet Software
This course will enhance the participants ability 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.
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.
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.
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.
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.
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.
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.
Sorry you cannot currently apply online for this course.
For more information or help with this course please complete an enquiry form.
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 EnquiryTerms & 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.
Courses are continually reviewed to take advantage of new teaching approaches and developments in research, industry and the professions. Please be aware that modules may change for your year of entry. The exact modules available and their order may vary depending on course updates, staff availability, timetabling and student demand. Please contact the course team for the most up to date module list.
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 EducationLatest Events
Stay connected to SERC: Your guide to upcoming college events!
