Filter data like an expert in Excel
- Published
- [Place of publication not identified] : Assemble You, 2024.
- Edition
- [First edition].
- Physical Description
- 1 online resource (1 video file (8 min.)) : sound, color
- Additional Creators
- Assemble You Limited
Access Online
- 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.
- Subject(s)
- Genre(s)
- Duration
- ["00:08:00"]
- Sound Characteristics
- digital
- Digital File Characteristics
- video file
- Form of work
- Instructional films
- Participant/Performer Note
- Assemble You Limited, instructor.
View MARC record | catkey: 43941159