Level 3 certificate in IT user skills (ECDL Advanced)

Course Dates: 06/03/21 - 17/07/21
Time: 10:00 - 17:00
Location: Online
Do you want to know that you can work to an outstanding level in any work environment requiring an expertise in Word, Excel, Powerpoint and Access? Do you want a qualification to prove these skills? The Level 3 Certificate in IT User Skills (ECDL Advanced) will give you exceptional proficiency in word processing, spreadsheet, presentation and database software, and will improve your productivity in using IT. You will gain all the skills you need to work at the highest level in an office environment.
You must have initial assessment before enrolling onto this course. Contact Universal Skills to book an appointment with our coordinator: universal.skills@citylit.ac.uk / Tel: 0207 492 2511.
The course fee is £1200. If you are unable to pay this upfront, you can choose to apply for an Advanced Learner Loan from Student Finance England (SFE) to help cover the course fee, repayable after the course ends. A deposit of £200 is also payable to secure your place (refundable after you complete the course). You can find more information about the Advanced Learner Loan www.citylit.ac.uk/advanced-learner-loans
For more information, please call English, Maths and Essential Computing on 0207 492 2511.
This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
Download
Book your place
Out of stock
Only 5 left
SKU
163802
Full fee £1,200.00 Senior fee £1,200.00 Concession £1,200.00

This course has now finished

Course Code: CEA04

Please choose another course date

Finished Sat, day, 06 Mar - 17 Jul '21

Duration: 18 sessions (over 20 weeks)

Call us to check your level, see if you can still join the course or to discuss other suitable courses

Please note: We offer a wide variety of financial support to make courses affordable. Just visit our online Help Center for more information on a range of topics including fees, online learning and FAQs.

What is the course about?

The ECDL level 3 certificate will provide you with all you the skills you need to work in any office or administrative environment at a high level. You will develop advanced word processing skills to format text and tables, work with referencing features and create tables of contents. You will improve your productivity by using fields, forms and templates. You will learn how to use advanced mail merge and macros, work with master documents and subdocuments, and work with watermarks, sections, headers and footers.
You will develop your skills with Excel to an advanced level so you can use sophisticated functions, create charts and apply advanced chart formatting features, work with tables and lists to analyse, filter and sort data. You will learn how to create and use scenarios and pivot tables, validate and audit spreadsheet data. You will enhance your productivity by working with named cell ranges, macros and templates. And you will learn about applying spreadsheet security.
You will develop your skills in using Microsoft Access including: understanding key concepts in database development and usage, creating a relational database, designing and refining queries using wildcards, parameters and calculations, using controls and sub forms to enhance forms and improve functionality. You will also learn how to create report controls to perform calculations and work with macros.
You will learn how to make advanced PowerPoint presentations including: how to understand your target audience, creating and modifying templates and formatting slide backgrounds. You will learn how to use built-in drawing and image tools, apply advanced chart formatting features and create and edit diagrams, insert movies and sound and apply built-in animation features. You will focus on how to work with custom slide shows, apply slide show setting, and control a slide show.
Finally, you will focus on how to improve your productivity in general through IT use.

This is a live online course. You will need:
- Internet connection. The classes work best with Chrome.
- A computer with microphone and camera.
- Earphones/headphones/speakers.
We will contact you with joining instructions before your course starts.

What will we cover?

What will we cover?
• advanced word processing skills to enable you work at the highest level in any office environment. Including:
• formatting text and tables, working with referencing features and creating tables of contents
• improving productivity by using fields, forms and templates
• using advanced mail merge and macros
• working with master documents and subdocuments, watermarks, sections, headers and footers

• Advanced Excel functions including:
• using sophisticated functions
• creating charts and applying advanced chart formatting features, working with tables and lists to analyse, filter and sort data
• creating and using scenarios and pivot tables
• validating and auditing spreadsheet data
• working with named cell ranges, macros and templates
• applying spreadsheet security features.

• Developing advanced skills in using Microsoft Access including:
• understanding key concepts in database development and usage
• creating a relational database
• designing and refining queries using wildcards, parameters and calculations
• using controls and sub forms to enhance forms and improve functionality
• creating report controls to perform calculations and enhance productivity by working with macros

• Making advanced PowerPoint presentations including:
• how to understand your target audience
• creating and modifying templates and formatting slide backgrounds
• using built-in drawing and image tools
• applying advanced chart formatting features
• creating and editing diagrams, inserting movies and sound and applying built-in animation features
• working with custom slide shows, applying slide show settings, and controlling a slide show

• Improving your productivity in general through IT use:
• how to plan, evaluate and improve procedures involving the use of IT tools and systems in order to improve the productivity and efficiency of work activities.

What will I achieve?
By the end of this course you should be able to...

• pass BCS ITQ Level 3 ECDL qualification
• use advanced word processing skills to enable you work at the highest level in any office environment. Including:
• formatting text and tables, working with referencing features and creating tables of contents
• improving productivity by using fields, forms and templates
• using advanced mail merge and macros
• working with master documents and subdocuments, watermarks, sections, headers and footers

• use Advanced Excel functions including:
• using sophisticated functions 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
• creating and using scenarios and pivot tables
• validating and auditing data
• working with named cell ranges, macros and templates
• applying spreadsheet security features.

• use advanced skills in Microsoft Access including:
• understanding key concepts in database development and usage
• creating a relational database using advanced table creation features and complex relationships between tables
• designing and refining queries using wildcards, parameters and calculations
• using controls and sub forms to enhance forms and improve functionality
• creating report controls to perform calculations and enhance productivity by working with macros

• Make advanced PowerPoint presentations including:
• understanding your target audience and consider your venue considerations when planning
• creating and modifying templates and formatting slide backgrounds
• enhancing a presentation using built-in drawing and image tools
• applying advanced chart formatting features
• creating and editing diagrams, inserting movies and sound and applying built-in animation features
• working with custom slide shows, applying slide show settings, and controlling a slide show

• Improve your productivity in general through IT use.

What level is the course and do I need any particular skills?

This is an advanced Level 3 course. All students need to have a passed the ECDL level 2 course or have relevant experience. You will need an interview and assessment if you are new to City Lit before enrolling on this course.

How will I be taught, and will there be any work outside the class?

You will learn in a supportive and welcoming environment with an emphasis on your discovering how to do and complete tasks and functions, with guidance from the tutor. You will learn in a step by step manner so you can achieve challenging aims in an enjoyable and productive way. You will have lots of opportunities to practise as well as understand what you are doing and why. Everyone will be encouraged to participate and interact in a way that is best for them, including working in pairs and groups, as well as on your own. You will need to do work outside the classroom and use Google Classroom to help you.

Are there any other costs? Is there anything I need to bring?

The course fee is £1200. If you’re unable to pay this upfront, you can choose to apply for an Advanced Learning Loan from the Student Loans Company to help cover the course fee, repayable after the course ends, plus a deposit of £200 to secure your place (refundable after you complete the course).

For more information, please call English, Maths and Essential Computing on 0207 492 2511.
Please also bring a folder, pens and paper. There are no additional costs.
.
For more information, please call English, Maths and Essential Computing on 0207 492 2511.

When I've finished, what course can I do next?

There are a variety of courses you can do either after this course or at the same time. These include our advanced Microsoft Office courses designed for the workplace. There are also a number of specialist Excel courses. Our How to be an Administrator series might also interest you. Your tutor will advise you on the best course. You can also ccontact our administrator on 0207 492 2511 / universal.skills@citylit.ac.uk.

We’re sorry. We don’t have a bio ready for the tutor of this class at the moment, but we’re working on it! Watch this space.