Excel: expert

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

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

Facilities

Location

Start date

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

Start date

Different dates availableEnrolment now open

About this course

Achieve fluency with important selected Excel functions
Gain a strong working understanding of array formulas
Learn how to record and use basic Excel macros.
Acquire a deeper understanding of pivot table functionality.
Recognise some of the key issues in spreadsheet construction that facilitate the use of pivot tables.

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

An introduction to array formulas
Understanding Indirect Function
Use of Offset Function
Use of the Match and Index Functions
The Intersect operator in formula construction
Macros (including the macro button)
Combo boxes, spin control
Drop-down lists
Constructing a simple user form
Issues in spreadsheet design
Additional pivot table features, including the Slicer and how to query XML and Access data.

Additional information

Excel: financial modelling, Introduction to VBA, data analysis with Power BI. 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: expert

£ 189 VAT inc.

The best Excel courses

See all

See all