{"id":2026,"date":"2026-11-16T12:00:32","date_gmt":"2026-11-16T12:00:32","guid":{"rendered":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/?p=2026"},"modified":"2026-11-16T12:23:46","modified_gmt":"2026-11-16T12:23:46","slug":"excel-puzzle-blogs-issue-2","status":"publish","type":"post","link":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/2026\/11\/16\/excel-puzzle-blogs-issue-2\/","title":{"rendered":"Excel Puzzle Blogs: Issue #2"},"content":{"rendered":"<p>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.<\/p>\n<p>You can find the solution to the previous month\u2019s puzzle <a href=\"https:\/\/computingservices.sharepoint.com\/:v:\/r\/sites\/ExcelPuzzleblogs\/Shared%20Documents\/Excel%20Puzzle%20Blog%20%231%20Solution.mp4?d=wc49a305e5f374dce8251cbe763b74132&amp;csf=1&amp;web=1&amp;e=1Y7kDC\">here<\/a>.<\/p>\n<p>This month, we\u2019re looking at one of Excel\u2019s most useful tools: filters.<\/p>\n<h2>Too much info? Filter it!<\/h2>\n<p>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.<br \/>\nThis is where filters come in.<br \/>\nA filter allows you to temporarily hide information that you don\u2019t need, so you can focus on the rows that meet your criteria. The information isn\u2019t deleted or changed in any way; you\u2019re simply choosing what you want to see.<\/p>\n<h2>Know your table<\/h2>\n<p>As we discussed in last month\u2019s 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.<\/p>\n<p>To apply a filter, select all the cells with your data, then select <strong>Data<\/strong> &gt; <strong>Filter<\/strong> from the top ribbon.<\/p>\n<p>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.<br \/>\nYou 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.<\/p>\n<h2>Ready to beat the sheet?<\/h2>\n<p>Download the Excel spreadsheet here and see if you can crack the puzzle:<\/p>\n<p><a href=\"https:\/\/computingservices.sharepoint.com\/sites\/ExcelPuzzleblogs\/_layouts\/download.aspx?SourceUrl=https:\/\/computingservices.sharepoint.com\/sites\/ExcelPuzzleblogs\/Shared%20Documents\/Puzzle%20blog%202.xlsx\">Puzzle Blog 2.xlsx (48KB)<\/a><\/p>\n<p>If you figure it out and are hungry for more, remember to subscribe to the Academic &amp; Employability Skills blog so you don't miss next month's issue.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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\u2019s puzzle...<\/p>\n","protected":false},"author":1974,"featured_media":2027,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[91,89,62],"tags":[372,108,116,405],"class_list":["post-2026","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-academic-skills","category-critical-thinking","category-maths-and-statistics","tag-academic-skills","tag-data-literacy","tag-digital-skills","tag-microsoft-excel"],"acf":[],"jetpack-related-posts":[{"id":1979,"url":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/2026\/10\/15\/excel-puzzle-blogs-issue-1\/","url_meta":{"origin":2026,"position":0},"title":"Excel Puzzle Blogs: Issue #1","author":"Femke Davis","date":"October 15, 2026","format":false,"excerpt":"Microsoft Excel can seem a bit overwhelming when you first open it, especially if you\u2019ve not had much reason to use it before. But Excel is a really useful tool that can make your life much easier if you know how to use it. In your studies you can use\u2026","rel":"","context":"In &quot;Academic skills&quot;","block_context":{"text":"Academic skills","link":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/category\/academic-skills\/"},"img":{"alt_text":"A lined-paper grid with A MS Excel logo and the words \"Excel Puzzle Blogs, Issue #1.\"","src":"https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2026\/09\/Excel-puzzle-blog-thumbnail-1.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2026\/09\/Excel-puzzle-blog-thumbnail-1.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2026\/09\/Excel-puzzle-blog-thumbnail-1.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2026\/09\/Excel-puzzle-blog-thumbnail-1.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1140,"url":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/2023\/12\/06\/skills-journal-what-i-learned-from-placement\/","url_meta":{"origin":2026,"position":1},"title":"Skills journal: what I learned from placement","author":"Asha Dey","date":"December 6, 2023","format":false,"excerpt":"Like many, I recently completed an industrial placement as part of my degree. It was a great learning experience, and I\u2019m super grateful for the opportunities I had. At the same time, adjusting to being back at university and applying for graduate roles can be daunting. In this blog, I\u2019ll\u2026","rel":"","context":"In &quot;Communication&quot;","block_context":{"text":"Communication","link":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/category\/capabilities-framework\/communication\/"},"img":{"alt_text":"Asha Dey outside the GSK building where she did her industrial placement.","src":"https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2023\/12\/Asha-Dey.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2023\/12\/Asha-Dey.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2023\/12\/Asha-Dey.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2023\/12\/Asha-Dey.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1376,"url":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/2024\/12\/07\/exploring-linkedin-learning\/","url_meta":{"origin":2026,"position":2},"title":"Exploring LinkedIn Learning","author":"Lola Osinoiki","date":"December 7, 2024","format":false,"excerpt":"While my lectures provide core subject knowledge, LinkedIn Learning offers focused, practical courses that have already helped me approach my studies and build employability skills. How LinkedIn Learning Works LinkedIn Learning courses typically begin with an introductory section, followed by chapters broken into bite-sized video lessons. These are often accompanied\u2026","rel":"","context":"In &quot;Employability&quot;","block_context":{"text":"Employability","link":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/category\/employability\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1669,"url":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/2025\/09\/03\/myskills-the-resource-i-wish-id-used-sooner\/","url_meta":{"origin":2026,"position":3},"title":"MySkills: The resource I wish I'd used sooner","author":"Lily Ward","date":"September 3, 2025","format":false,"excerpt":"Heading into my final year of an integrated master\u2019s has given me a reason to pause and take stock of what\u2019s really helped me at university. Along the way, I\u2019ve discovered tools that made a tangible difference, and one of the most valuable, once I actually explored it, was MySkills.\u00a0\u2026","rel":"","context":"In &quot;Academic skills&quot;","block_context":{"text":"Academic skills","link":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/category\/academic-skills\/"},"img":{"alt_text":"A laptop sitting on a desk with MySkills displayed on the screen","src":"https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2025\/09\/MySkills-Blog-Image_new.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2025\/09\/MySkills-Blog-Image_new.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2025\/09\/MySkills-Blog-Image_new.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2025\/09\/MySkills-Blog-Image_new.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1394,"url":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/2024\/12\/17\/__trashed\/","url_meta":{"origin":2026,"position":4},"title":"Step into Semester 2: Building your Digital Skills for Success","author":"Ana Bertolossi","date":"December 17, 2024","format":false,"excerpt":"As you prepare for the inter-semester break and step back from your studies, now is the perfect moment to reflect on your experiences from Semester 1. Were you able to maintain your well-being while juggling deadlines? How did you find managing communications and collaborative work? Did your presentations and posters\u2026","rel":"","context":"In &quot;Academic skills&quot;","block_context":{"text":"Academic skills","link":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/category\/academic-skills\/"},"img":{"alt_text":"Three students sat at a round table looking at their laptops.","src":"https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2024\/12\/Library-students.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2024\/12\/Library-students.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2024\/12\/Library-students.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2024\/12\/Library-students.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":723,"url":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/2021\/12\/06\/meet-the-skills-co-creator-team\/","url_meta":{"origin":2026,"position":5},"title":"Meet the Skills Co-Creator team","author":"Kerry Vevers","date":"December 6, 2021","format":false,"excerpt":"Four student ambassadors will be working with the Skills Centre this academic year to help develop our skills resources and communicate our skills opportunities to other students. The Skills Co-Creators introduce themselves here. Asha Dey Hi everyone! My name is Asha, and I am a second year Psychology student here\u2026","rel":"","context":"In &quot;Student experience&quot;","block_context":{"text":"Student experience","link":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/category\/student-skills-ambassador\/"},"img":{"alt_text":"Table ornament spelling out the word 'hello' in cursive font.","src":"https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2021\/12\/hello.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2021\/12\/hello.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2021\/12\/hello.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2021\/12\/hello.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2021\/12\/hello.png?resize=1050%2C600&ssl=1 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-content\/uploads\/sites\/84\/2026\/11\/November-Issue.png","_links":{"self":[{"href":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-json\/wp\/v2\/posts\/2026","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-json\/wp\/v2\/users\/1974"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-json\/wp\/v2\/comments?post=2026"}],"version-history":[{"count":0,"href":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-json\/wp\/v2\/posts\/2026\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-json\/wp\/v2\/media\/2027"}],"wp:attachment":[{"href":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-json\/wp\/v2\/media?parent=2026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-json\/wp\/v2\/categories?post=2026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.bath.ac.uk\/academic-and-employability-skills\/wp-json\/wp\/v2\/tags?post=2026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}