Event photo

Advanced Excel Course

Event type

IT skills training

Event bookings can only be created between

06/01/2020 - 20/02/2020

Seats in waiting list



Advanced Excel Course


Bite Size Ltd

Course Documents


What are the benefits?

• This course explains how to re-use data in other places by linking and also covers how to convert data to a Table to give extra functionality.
• Delegates will understand how to format numbers and how to do calculations with dates and times.
• The course covers Pivots to enable delegates to summarise large amounts of data.

Topics covered include:

Working across multiple worksheets and workbooks
• Linking across worksheets / workbooks
• Working in Group mode

Working with Tables
• Creating Tables
• Formatting Tables
• Using Slicers with Tables

Formatting Numbers

Working with Dates and Times

Pivot Tables and Charts
• Creating a Pivot Table
• Formatting a Pivot
• Updating your Pivot (refresh and source)
• Creating Pivot Charts

Who should attend?

This course is aimed at those who have a good knowledge of MS Excel and know how to create formulas such as sum, average, min, max, counta, countblank and countif. Delegates should also be able to work with named ranges, use lookups create charts and conditional formatting.

Occasions for this event

Details about the occasions for this event is shown below. To add or edit occasions click on edit event to the right.

Occasion(s) Weekday Location Location status
Confirmed19/02/2020 13:30 - 16:30 Wednesday Room 2B, 2nd floor, Library Confirmed