Excel: analysing your spreadsheet with pivot tables

Course Dates: 16/05/19
Time: 18:00 - 21:00
Location: KS - Keeley Street
Tutor: Aurica Jalba

Learn how to create and edit pivot tables to analyse large lists of data with multiple views and calculated fields using drag and drop. You should have a good understanding of Excel.


What is the course about?

Come and learn this popular data analysis tool. Use drag and drop to easily create multiple views, calculated fields and calculated items to analyse your spreadsheet data.

What will we cover?

• Preparing and structuring your data
• Creating and formatting a Pivot table
• Creating a Pivot chart
• Adding calculated fields and items
• Grouping Data
• Filtering Data.

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

Use Pivot tables with confidence to analyse your data.

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

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?

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.

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

No, just bring a notepad and pen.

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

Excel: expert, Excel: financial modelling, Excel: analysing data, Excel: advanced, 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


Book your place

Course Code: CEXL01

Thu, eve, 16 May - 16 May '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.