Complete Your Profile

Please provide your first and last name to continue.

Sign out

Warning: You will need to sign in again to access your account.

Are you sure you want to sign out?

You will be logged out of your account.
Search
Digital Skills

Microsoft Excel - Intermediate: Data Analysis

Download PDF
Search

Course Overview

This half-day course is designed to assist those wishing to advance their knowledge of Data Analysis within Microsoft Excel.

Delegates will learn how to use Pivot Tables, Advanced Filters, Group Data, Text to Columns, and useful Analytical Formula.


Course Content

The course will cover the following topics:

  • Subtotals
  • Pivot Tables and Pivot Charts
  • Advanced Filters
  • Grouping Data
  • Text to Columns
  • Cleaning Data
  • Analytical Formulas (Proper, Upper, Lower, Trim, Left, Right, Mid)


Benefits

This course will equip delegates with sound knowledge of the Data Analysis features of Excel, using real life examples, and is the second in our Excel Series.


Prerequisites

Ideally you will have completed the ‘Beginners’ module or have a good working knowledge of other Excel versions to begin with.


Next Steps

If you would like to book a place on this course please click on the ‘Book Course’ button to the right of this page and login or register for a user account to complete your booking(s). Any queries please do not hesitate to contact us via [email protected] or call us on 01481 224570.

If no date is scheduled for this course at the present time please click on the ‘Register Interest’ button and login or register for a user account so that we can add you to our course interest register. This register allows us to contact our tutors and finalise dates for a course as soon as we have a few people who have expressed their interest, so the more delegates who register their interest, the sooner we can schedule a particular course.

Course Details

Start date

16 June 2026

CPD Points

4.0

Price

£215.00

Length

Half day (09:00-13:00)

Course Tutor

Susan Watson

Susan Watson is a senior consultant and director with over 15 years’ experience delivering business and technology solutions across finance and professional services. She specialises in making complex tools like Excel practical and accessible, with a focus on real-world application such as reporting, data analysis, and improving efficiency.

Register interest

Enter your email to be notified when new dates are available.

Select which organisation you would like to book for

Select Attendees to Book

Booking Summary

Free Course Summary

Register Interest Summary

Course
Course Title
Notification
You will be notified when this course becomes available for booking

Message

Join others bettering their lives through learning

quote left
Jacqui is excellent at explaining the process in simple terms
Tracey R
quote left
Jacqui has a very understanding way about her and no question is a stupid question.
Emma Sparks
quote left
In many ways exceeded my expectations, I didn't think it was possible to train on Excel in such an illuminating way. Jacqui is a great tutor
Peter C

Related Courses

Take your career to the next level with higher education that works for you

View all courses
Digital Skills
Microsoft Excel - Advanced: Formulae
This half-day course is designed to assist those wishing to learn advanced Formulae of Microsoft Excel. Delegates will learn to use VLOOKUP’s,...

29 June 2026

Half day (09:00-13:00)

Find out more
Digital Skills
Microsoft PowerPoint - Intermediate/Advanced
The Microsoft PowerPoint Intermediate to Advanced Level course is suitable for those with a working knowledge of PowerPoint who wish to use the more...
Find out more
Digital Skills
Microsoft Word - Beginners
On completion, delegates will be far more confident in your ability to create and amend Word documents, understanding how important it is to use the...
Find out more
Data Protection Digital Skills Director Development Finance Human Resources Law Leadership & Management Personal Development Project Management Sales & Marketing Wellbeing

Sign up to our mailing list

Sign up for more info including course updates, upcoming courses and the latest news from the GTA

Message