Advanced
ECDL:
Spreadsheets 2016 SCQF Level 6

This advanced course will strengthen your skills and understanding when it comes to Spreadsheets 2016.

Overview

Why take this course?

Advanced ECDL Spreadsheets (Module AM4) is a high-level certification programme which presents candidates with the opportunity to bring their spreadsheet skills to an expert level. Completion of this module will enable candidates to master the more advanced functions of spreadsheet applications, enabling them to produce more sophisticated reports, and to perform complex mathematical and statistical calculations, thus saving time and improving productivity in the completion of tasks. It has been specifically designed to:

  • Allow users to become more confident, efficient and effective in using a spreadsheet application 
  • Proves mastery of the application 
  • Enable users to produce better reports with deeper data analysis 
  • Improves user's productivity 

This Advanced ECDL course is a Level 3 qualification (QCF) - roughly equivalent to SCQF Level 6 in Scotland - and is accredited by the British Computer Society (BCS). Please note that although there are four Advanced ECDL Modules and these can enrolled on, completed and certified independently of each other, you only need to complete all four modules if you choose to.

What you will experience

This course is highly comprehensive, and has been developed with input from computer users, subject matter experts and practising computer professionals from all over the world - this ensures relevance and accuracy of module content. You will explore a range of key aspects relating to spreadsheets, including:

  • Applying advanced formatting options such as conditional formatting and customised number formatting, and how to handle worksheets 
  • Using functions such as those associated with logical, statistical, financial and mathematical operations 
  • Creating charts and applying advanced chart formatting features 
  • Working with tables and lists to analyse, filter and sort data. Create and use scenarios
  • Validating and auditing spreadsheet data 
  • Enhancing productivity by working with named cell ranges, macros and templates 
  • Using linking, embedding and importing features to integrate data 
  • Collaborating on and reviewing spreadsheets
  • Applying spreadsheet security features

Upon completion of this course you should be able to maximise the Microsoft Excel package using skills and knowledge that will set you apart in today's competitive job market.

Student at a computer

Key facts

Mode of study
Distance Learning
Method of study

This course requires you to manage your workload independently, and will involve attendance at a campus or centre - often for assessment purposes only.

Subject area

Entry requirements

Prospective students should ideally have the ECDL certification and/or previous experience using computers and common software applications.  It is essential that you have previous experience in using a computer, the Windows interface and Windows terminology.

What you will need

All students are assigned a login to Microsoft Office 365 which includes online access to Microsoft Excel 2016 at no extra cost.

What you need to know

Additional costs

An assessment will be carried out at the College when you have completed the course work. The cost of the Advanced Test is £60 payable at the time of booking. Payment can be made in cash at the Assessment Centre, by cheque made payable to North East Scotland College or by Credit or Debit Card by telephoning 01224 612237.

Anything else?

This is a Distance Learning course which means you can study at home, in the workplace or wherever you choose at times that are convenient for you. You do not have any classes to attend. The materials for this course are provided as webpages for you to work through online. As you progress through the course materials you will find explanations of each feature, followed by practical exercises. You will be supported throughout the course by a specialist Distance Learning Tutor.

As you progress they will continue to make regular contact to offer support and guidance, usually by email but sometimes by phone, to ensure you are making good progress and to support your learning throughout. You must be able to study independently through the course materials.

Whilst studying with Business & Community Development, you will have access to the Library+ sites and the Digital Skills Space. You will also have technical and administrative support from Business & Community Development team.

Fee Waivers

Please note that fee waivers or funding may apply. Find out more about funding for part-time courses

Next steps

Education

Employment

For more information about job opportunities, salaries and employment rates in this industry, visit the Career Coach website.

Availability

This course requires some attendance at College, often for assessment purposes only. Please enquire about expectations for your specific course when booking.

Attendance is usually at the Aberdeen City Campus or Fraserburgh Campus.

Duration Fees Code
60 Hours over 10 Months £143.00
YBNAX
-O171A
Paper applications only

Paper applications

You must submit a paper application form for this course and return it to us completed and signed.

Completed forms should be returned to the following freepost address:

The Student Information & Admissions Manager
North East Scotland College
FREEPOST RTJJ-TXBA-AEZS
Aberdeen City Campus
Gallowgate
Aberdeen
Scotland
UK AB25 1BN

Should you have any problems with your application, please contact the Student Advice Centre:

Telephone: 01224 612330
Email: enquiry@nescol.ac.uk

If you take up a place on a College course, at the start of the course you will be asked to sign an enrolment form. In signing the form and/or taking up a place on a College course, you will enter into a contract with the College and be bound by the North East Scotland College Standard Terms and Conditions of Study. Copies of the Terms and Conditions are available for inspection on notice boards and at various locations throughout the College, at the College Reception, on the College website: www.nescol.ac.uk, or can be obtained on request from the Student Funding and Admissions Manager, North East Scotland College, Aberdeen City Campus, Gallowgate, Aberdeen AB25 1BN. Please note that courses are offered subject to (a) there being sufficient numbers of enrolments and (b) the availability of resources. The College reserves its right (i) not to run courses where the number of students is considered insufficient or where resources are unavailable and (ii) in certain circumstances, to refuse admission to an individual applicant.