For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Organising Data in Excel: Mini Masterclass Series

Overview

Organising your data in Excel using the SORT and FILTER functions is not just a matter of convenience; it's essential for effective data management and analysis. These functions empower you to extract insights, spot trends, and make informed decisions efficiently, maximising the value of your data and enhancing your productivity. 

In this course, we will cover how to effectively use the SORT function to organise your data and the FILTER function to view subsets of data that meet the required criteria easily. Whether you're a business professional, researcher, or student, mastering these Excel functions is a fundamental skill for working with data effectively.

Learning Outcomes

  • Understand how to use the Sort command to sort a list of items alphabetically and numerically while using custom criteria.
  • Explore how to apply Filters to columns and extract just the items that match the specified criteria.

Audience

Anyone looking to explore the basics of Excel.