When a worksheet contains a large amount of information, sorting and filtering make it easier to find and analyze specific data. Excel provides tools that allow users to arrange information, display selected records, and identify basic patterns within datasets.
Sorting changes the order of records according to a selected column or field. For example, a list of employees can be sorted alphabetically by name or a list of products can be sorted according to price.
Excel can sort data using more than one column. For example, employee information could first be sorted by department and then by employee name within each department.
Filtering temporarily displays only the records that meet selected conditions. Records that do not meet the selected criteria remain in the worksheet but are hidden from the current view.
Suppose a sales worksheet contains information about products, employees, cities, quantities, and sales amounts. Filters can be used to display:
Converting a dataset into an Excel table provides useful features such as automatic formatting, filter buttons, structured organization, and easier data management.
Filters can be removed when the user wants to display all records again. It is important to understand that filtering normally does not delete records; it changes which records are currently displayed.
Basic data analysis involves examining information to identify totals, averages, highest and lowest values, categories, trends, and other useful observations.
For example, a sales dataset can be analyzed to identify the total sales, highest-selling product, lowest sales transaction, and sales generated by different employees or locations.
Create a worksheet named Sales Data containing the following columns:
Using the sales dataset, answer the following questions:
After completing this section, learners will be able to sort and filter Excel data, create structured tables, organize large datasets, and perform basic analysis using formulas and Excel’s data management tools.