Event Registration

Mastering MS Excel

Mastering MS Excel

Course Aims

This half day instructor led course is designed to develop the practical skills of Excel users. By the end of the course delegates will be able to use to full advantage a greater range of available Excel functions in order to produce more effective spreadsheets.


• Becoming confident in using MS Excel Shortcuts

• Fixing Cells

• Improve Formatting

• Use advanced Formulas and Functions

• Work effectively with Large Spreadsheets

• Working with Pivot Tables


Delegates should already have a basic knowledge of MS Excel and be confident using a mouse and keyboard.

Course Outline

• Refresher on basic calculations, autofill options and shortcuts

• Using Brackets and Fixing Cells

• Sorting and Filtering

• Conditional Formatting

• Statistical Functions (Countif, Sumif)

• IF Statements

• Lookups

• Pivot Tables

NB – Training is based around the above topics with the precise agenda and pace of delivery tailored to meet the skill levels of the delegates and the specific features of the software version.

Registration: 9:15am
Workshop Commences: 9:30am

We can provide laptops for the attendees, but would recommend bringing your own laptop to the session if possible. This way you are using a familiar laptop and our trainer can advise on setting up correctly any shortcut features covered during the session. 

4th floor, Churchgate House,
56 Oxford Street,
M1 6EU

Price: £97.00 + vat

Total Attendees

Tuesday October 8, 2019
9:15 am to 12:30 pm


for Mastering MS Excel
Tuesday October 8, 2019

Personal Information

Do you require vegetarian meals
I confirm I am a human being and not a SPAM bot*