Courses and resources

Microsoft Excel 2013: Intermediate (Level 2)


About this course:

The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting, filtering and conditional formatting.

You will discover how Excel spreadsheets are constructed and be given a clear path on how to create templates.

Learning outcomes:


As a result of attending this course, you will be able to:.

- Calculate with Advanced Formulas.

- Organise Worksheet Data.

- Apply Basic Filters.

- Apply Conditional Formatting.

Who should attend this course:


This course is open to all staff groups and grades.




Before the course:


Delegates must be able to:.

- Create basic spreadsheets.

- Select and edit data.

- Perform basic formatting.

- Open, close and save files.

- Create basic formulas - AutoSum.

- Use Insert Function to create built-in functions.

- Work with absolute references.

- Use the AutoFill feature.


Learning Provider:.

This course is administered by People Development; please contact for more details.

19/03/2018 Streatham: Old Library, Computer Cluster 09:30 16:30 Free 2

Book your place

Add your name to the waiting list
Please ensure you have permission from your line manager to attend.