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