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

HOPPE UK

"Fantastic really informative and interesting" "Excellent very enjoyable really good presenter"

St Johns Packaging (UK) LTD

"The training was highly beneficial and significantly enhanced my Excel skills. Simon was an engaging and approachable instructor, it was an absolute pleasure to learn from him."

Hahnemuehle

"Really good and really informative. Would recommend to a company needing excel training."

Ottolenghi Ltd

"I found the basic excel training useful and excel cheatsheet is very handy. I learnt some new things from the exercise and looking forward to the next session. "

This course in other locations

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

This Excel training session focuses on organising and analysing data more effectively. In just 90 minutes, you will learn how to sort and filter data to quickly find what you need, as well as structure your spreadsheets so they are easier to use and understand.

Excel Beginners Training Series

What You'll Learn

  • Sort your data into a clear and logical order
  • Use filters to quickly focus on specific information
  • Structure your data so it is easier to analyse
  • Spot and manage duplicate or inconsistent data

Who This Course Is For

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

Course Duration: 90 Minutes

Course Prerequisites

  • Basic Excel knowledge such as entering data and simple formulas

Not sure which version of Excel you have?
Go to File > Account to check.

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

Computer Tutoring Training Centres

We can also arrange instructor-led training from these Computer Tutoring training centres.

Birmingham Brentwood Cambridge Coventry Guildford Ipswich Leicester Luton Milton Keynes Northampton Norwich Oxford Peterborough London (Chiswick) London (Hammersmith) London (Heathrow) London (Kensington) Reading