Filter data like an expert in Excel

• Titel: Filter data like an expert in Excel
• Institutionen: Assemble You Limited, [MitwirkendeR]
• Ausgabe: [First edition].
• Verlagsort: [Place of publication not identified]
• Verlag: Assemble You
• Jahr: 2024
• Umfang: 1 online resource (1 video file (8 min.))
• Illustrationen: sound, color.
• Fussnoten: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
• Datenträger: Online-Ressource
• Sprache: eng
• Sach-SW: Tableurs ; Logiciels
• Sach-SW: Instructional films
• Sach-SW: Nonfiction films
• Sach-SW: Internet videos
• Sach-SW: Films de formation
• Sach-SW: Films autres que de fiction
• Sach-SW: Vidéos sur Internet
• K10plus-PPN: 1885008643
• K10plus-PPN:
  Universitätsbibliothek
• Lokale URL UB: Zum Volltext
• Lokale URL UB: Bibliothek der Medizinischen Fakultät Mannheim der Universität Heidelberg
• Bibliothek/Idn: UW / m4507226961
• Lokale URL Inst.: Zum Volltext

Abstract

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.