Excel: advanced

City Lit

Course

In London

£ 189 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Start date

    Different dates available

It builds on the Excel Beginners course and introduces the more advanced features of the application.

Facilities

Location

Start date

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

Start date

Different dates availableEnrolment now open

About this course

Sort and filter data using specified criteria
Analyse data using pivot tables
Set up best/worst case scenarios
Produce calculations using functions and values from different worksheets/workbooks
Automate tasks using macros
Work with large and more complicated worksheets with confidence.

No.

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

  • MS Excel
  • Excel

Course programme

Advanced sorting of data
Advanced filtering of data
More advanced linking of worksheets for calculations
More advanced formulas incorporating various functions
Using pivot tables
Recording macros
Using data tables
Scenarios
Auditing
Naming data ranges
VLOOKUP.

Each student has their own computer. Presentations will be made using computers, whiteboard, overhead screen and printed notes. Step by step instruction, with demonstrations where appropriate, will help you grasp the concepts.

Additional information

Further excel courses eg - Excel: expert, Excel: financial modelling, Introduction to VBA. 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

See related categories

Excel: advanced

£ 189 VAT inc.

The best Excel courses

See all

See all