ITQ level 3 ECDL: advanced fast-track

Course

In London

£ 1 VAT inc.

Description

  • Type

    Course

  • Location

    London

  • Start date

    Different dates available

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.

Facilities

Location

Start date

London
See map
Keeley Street, Covent Garden, WC2B 4BA

Start date

Different dates availableEnrolment now open

About this course

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

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).(If you are 18 at the start of the course, the fee may be less - please contact us).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,...

This will be a practical hands-on course. You will be encouraged to practise as much as possible. An interactive whiteboard will help make demonstrations easy to understand. Each student has their own computer. You will receive regular handouts and information via Google classroom so you can practise at home. You will need to do homework.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Word
  • Powerpoint
  • Access
  • ECDL
  • Word Processing
  • Office IT
  • Spreadsheet
  • Database
  • Database training
  • Animation
  • Sound
  • Drawing
  • Image
  • Ms Office
  • MS Excel
  • Ms PowerPoint
  • Microsoft Access
  • Ms Word

Course programme

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.

Additional information


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. Your tutor will advise you on the best course.

General information and advice on courses at City Lit is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00.
See the course guide for term dates and further details

ITQ level 3 ECDL: advanced fast-track

£ 1 VAT inc.