Filter data like an expert in Excel
This lesson explores the fundamental distinction between filtering and conditional formatting. It covers how to hide and reveal data based on your specified criteria. Explore filter dropdowns and how to leverage them directly within your Excel table. Discover how to apply filters without converting...
| Corporate Author: | |
|---|---|
| Format: | Video |
| Language: | Inglés |
| Published: |
[Place of publication not identified] :
Assemble You
2024.
|
| Edition: | [First edition] |
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009825865406719 |
| Summary: | This lesson explores the fundamental distinction between filtering and conditional formatting. It covers how to hide and reveal data based on your specified criteria. Explore filter dropdowns and how to leverage them directly within your Excel table. Discover how to apply filters without converting your data into a table and learn the versatility of the FILTER function. Doing so allows you to filter data in place and extract refined lists to different parts of your spreadsheet. We'll guide you through setting up data validation and demonstrate how to use dynamic functions like UNIQUE to enhance filtering. |
|---|---|
| Physical Description: | 1 online resource (1 video file (8 min.)) : sound, color |
