Excel: applying formulae and functions

City Lit

Course

In London

£ 49 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Start date

    Different dates available

You will be engaging with the principles of using formulas and functions in your spreadsheets.
Your tutor will introduce and demonstrate topics. You will do practical exercises using Excel on your own computer.

Facilities

Location

Start date

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

Start date

Different dates availableEnrolment now open

About this course

• Create formulas for use in your spreadsheets
• Understand how to structure common formulas
• Be comfortable using the Insert Function dialog box.

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

• Introduction to the structure of a formula
• Introduction to useful formulas, from simple functions such as SUM to more advanced functions such as VLOOKUP and SUMIF
• The Insert Function dialog box and finding all the possible functions
• The Formulas ribbon
• Conditional formatting using formulas.

There are no other costs. It is recommended but not required that you bring a memory stick so that you can save files provided in the class.

Additional information

Excel: expert, Excel: financial modelling, Excel: analysing data, Excel: advanced, Introduction to VBA, Excel: analysing your spreadsheet with pivot tables, Pivot tables: a deeper look. 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: applying formulae and functions

£ 49 VAT inc.

The best Excel courses

See all

See all