Computer Tutoring Logo

Flexible Training Options

Choose a single focused 90-minute session, combine several sessions into a short course, or ask us about ongoing training support for your team.
  • Focused 90-minute sessions for specific skills
  • Grouped sessions to build a complete learning path
  • Ongoing support options for teams who need regular help
Tell us what you need

Tell Me More






First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.

Testimonials

FMG Consulting

"Very engaging & helpful, Simon my course teacher was great!"

Bedfordshire OPCC

"Simon was a fantastic training facilitator and made the session fun and easy to engage with. When one of my colleagues was concerned about how the skills learnt would transfer to her role, Simon took the time to design an activity (on the spot) that would apply to her and her role. Thank you for the brilliant session Simon - we can't wait to put our new skills to the test!"

BUUK Infrastructure

" I found the training excellent, I thought Simon's knowledge was great and he helped with some slightly off topic excel queries - I learnt so much from this workshop! I have undertaken this course before and the learning did not stick, but Simon's story telling and contextulisation has made it much more memorable."

GKN Aerospace

"Great, Gary was amazing and taught me loads "

Learn Excel Basics in 90 Minutes - Part 3: Sorting and Filtering Data

Learn Excel Basics in 90 Minutes - Part 3: Sorting and Filtering Data Overview

Need to organise and analyse your data more effectively? This session is part of our Excel training courses, designed to help you build practical spreadsheet skills in short, focused sessions.

This Excel training session focuses on sorting and filtering data so you can quickly find, organise, and analyse information. In this 90-minute Excel training session, you will learn how to sort data into a logical order and apply filters to focus on exactly what you need.

You will also learn how to structure your data properly so that sorting and filtering work reliably. This includes working with clean column headings, consistent data, and layouts that make your spreadsheets easier to manage.

By the end of the session, you will be able to work more efficiently with lists and datasets, quickly identify key information, and keep your spreadsheets organised and easy to use.

Excel Beginners Training Series

This session forms part of our Excel Beginners training programme. Each 90-minute session focuses on a specific Excel skill and can be taken individually or combined to create a structured Excel training course for beginners.

What You'll Learn

  • Sort data into a clear and logical order
  • Use filters to quickly focus on specific information
  • Structure data so it can be sorted and filtered reliably
  • Identify and manage duplicate or inconsistent data
  • Work more efficiently with lists and datasets

Who This Excel Course Is For

  • Users working with lists or datasets in Excel
  • Staff managing reports or spreadsheets
  • Anyone who needs to find, filter, and organise data quickly

Course Duration: 90 Minutes

Course Prerequisites

  • Basic Excel knowledge such as entering data and simple formulas
  • Familiarity with working in spreadsheets (rows, columns, and basic navigation)
  • Access to Microsoft Excel (Excel 365 or a recent desktop version recommended)

Not sure which version of Excel you have?

Open Excel and go to File > Account to check your version and confirm whether you are using Excel 365 or another edition.

If you are unsure, please contact us and we will be happy to advise before the session.

Complete Course Outline

Preparing Data

  • Structuring data correctly for sorting and filtering
  • Avoiding common layout issues
  • Making data easier to work with

Sorting Data

  • Sorting by one or more columns
  • Using custom sorting options
  • Organising data in a logical way

Filtering Data

  • Applying and removing filters
  • Filtering by text, numbers and dates
  • Using multiple filters together

Managing Data Lists

  • Identifying duplicate values
  • Using simple data clean-up techniques
  • Improving overall data quality

Hands-on Exercises

  • Sort a dataset by different columns to organise information
  • Apply filters to find specific records quickly
  • Combine multiple filters to narrow down results
  • Identify and remove duplicate data from a list

Training Locations and Delivery Options

This course is available online instructor-led, at client premises, and at selected training venues across the UK.

View training centres and venue information