Excel: applying formulae and functions

Course Dates: 08/07/19
Time: 14:00 - 17:00
Location: KS - Keeley Street
Tutor: Aurica Jalba

Move beyond basic arithmetic in Excel and learn to use the power of formulas and functions to save time and extract new information from your data.

Description

What is the course about?

You will be engaging with the principles of using formulas and functions in your spreadsheets.

What will we cover?

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.

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

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

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

The course is at an intermediate level. An understanding of the basic features of Excel, such as the general layout of a spreadsheet and entering data, is required.

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

Your tutor will introduce and demonstrate topics. You will do practical exercises using Excel on your own computer.

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

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.

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

Excel: expert, Excel: financial modelling, Excel: analysing data, Excel: advanced, Introduction to VBA, Excel: analysing your spreadsheet with pivot tables.

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

Reviews

Book your place

Course Code: CEXF03

Mon, day, 08 Jul - 08 Jul '19

Duration: 1 session

Full fee: £49.00
Senior fee: £39.00
Concession: £25.00

Or call to enrol: 020 7831 7831

Download form & post

Any questions? computing@citylit.ac.uk
or call 020 7492 2515

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online Help Center. You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.