Hello and welcome to the second issue of our Excel puzzle blog series, where we share a new escape room-style challenge every month to help you build confidence with Excel.

You can find the solution to the previous month’s puzzle here.

This month, we’re looking at one of Excel’s most useful tools: filters.

Too much info? Filter it!

Spreadsheets are often used to organise a lot of information, from research findings and assignment marks to spending budgets, schedules, and contact lists. As the amount of information grows, finding a particular detail can become more and more difficult.
This is where filters come in.
A filter allows you to temporarily hide information that you don’t need, so you can focus on the rows that meet your criteria. The information isn’t deleted or changed in any way; you’re simply choosing what you want to see.

Know your table

As we discussed in last month’s issue, Excel tables are made up of rows and columns, with each column having a heading that describes the information underneath it. For example, a table might include headings such as Event, Date, and Location.

To apply a filter, select all the cells with your data, then select Data > Filter from the top ribbon.

When you apply filters to a table, small dropdown arrows appear next to the column headings. Selecting one of these arrows gives you options for filtering the information in that column.
You can choose specific entries from a list, or use options such as sorting and filtering by text, numbers or dates. You can also apply filters to more than one column at a time. For example, you could filter a table to show events only in November that are taking place on campus.

Ready to beat the sheet?

Download the Excel spreadsheet here and see if you can crack the puzzle:

Puzzle Blog 2.xlsx (48KB)

If you figure it out and are hungry for more, remember to subscribe to the Academic & Employability Skills blog so you don't miss next month's issue.

Posted in: Academic skills, Critical thinking, Maths and statistics

Check out these events to further develop your Excel skills

Respond

  • (we won't publish this)

Write a response