Filter Data Like an Expert in Excel

Filter Data Like an Expert in Excel

by Assemble You Limited
Released March 2024
Publisher(s): Assemble You
ISBN: None

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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.

Learning Objectives

  • Discover how to filter data in Microsoft Excel using traditional filter dropdowns within tables and the FILTER function.

Table of contents

  1. Filter Data Like an Expert in Excel

Product information

  • Title: Filter Data Like an Expert in Excel
  • Author(s): Assemble You Limited
  • Release date: March 2024
  • Publisher(s): Assemble You
  • ISBN: None