Advanced ECDL: Spreadsheets 2016

Vocational
North East Scotland College

Course details

Course description

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.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.

Provided by

North East Scotland College

01224 612000

Provider website

Aberdeen City Campus

Gallowgate

Aberdeen

AB25 1BN

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. This course requires you to manage your workload independently with tutor support which would be available via email and telephone. You would be assigned contact details and guidelines for your tutor once enrolled on course.

Course options

Course details

Distance learning

4th Jul 2023 to 3rd Jul 2024

Cost: £219.00 (ex. VAT)

Venue details

ONLINE

ONLINE

ONLINE

ONLINE

ONLINE

Who to contact

ANN SMITH

ADMIN ASSISTANT

annsmith@nescol.ac.uk

01224612789