Big Data and AI

Lesson 4.2 – Sorting and Filtering in Tables Sorting and filtering are two of the most powerful features of Excel Tables. They allow you to organize, analyze, and explore your data quickly and efficiently. In questa lezione impari come ordinare e filtrare i dati in modo professionale. 1. Sorting Data in a Table Sorting means arranging your data in a specific order, such as: Alphabetical (A → Z or Z → A) Numeric (smallest → largest or largest → smallest) Date order (oldest → newest or newest → oldest) How to sort: Click the filter arrow in the column header. Select Sort A to Z or Sort Z to A . Sorting inside a Table keeps all rows aligned, preventing data corruption. 2. Filtering Data in a Table Filtering allows you to show only the rows that match specific criteria. How to filter: Click the filter arrow in the column header. Check or uncheck the values you want to display. Use Text Filters , Number Filters , or Date F...