Who still uses filters??

@excel.ninja.xls

14.6K followers · usually 1.9K views a post

Views

60.0K

Likes

1.6K

Comments

11

Shares

626

SoundTikTok sound · original sound - excel.ninja.xls

Promoted product

Microsoft Excel

Create and edit spreadsheets online with Microsoft Excel for the web. Easy formatting, analysis, and real-time collaboration from any device.

26 videos13 creators

Why it worked

The video provides a quick, actionable tip for a common Excel pain point, demonstrating a visually appealing and efficient solution that makes the user look like a 'genius' with minimal effort.

Summary

The video demonstrates how to use slicers in Microsoft Excel as a more efficient way to filter data compared to traditional dropdown filters. It shows the steps to convert a data range into a table and then insert and customize slicers for interactive data filtering.

Structure

1Introduce the problem with traditional filters
2Introduce slicers as a better solution
3Show how to convert data to a table
4

Original caption

Filters are fine. Slicers are FINE. 🥷 If you’re still opening that dropdown, unchecking boxes, and praying you didn’t miss one, this reel is for you. Slicers give you actual BUTTONS to filter your data. One click. Instantly see what’s filtered. Zero guessing. And when someone asks “can you show me just Q3?” you tap once and look like a genius. Setup takes 10 seconds: Click your table → Insert tab → Slicer → pick your column → done. #ExcelNinja #ExcelTips #Slicers #ExcelTricks #ExcelDashboard

More from @excel.ninja.xls

Product placement

Microsoft Excel (ACTS - interface is operated to demonstrate data filtering; removing it would change what happens in the video). Slicers (ACTS - a feature of Excel that is operated to filter data; removing it would change what happens in the video).

Call to action

Join Nora and her TA team for tips and tricks to help you navigate Excel 💚🥷

On-screen text

Who still uses filters?? Slicers are the way to go... Ctrl + T Turn your range into a table Insert Slicer: Alt -> N -> S -> F Order Date State Product Category Sales Rep Sales State Arizona California Florida Georgia Illinois New York Texas Washington Columns: 4 Height: 0.28" Width: 0.89" Slicer Search Slicer Caption: State Slicer Settings Report Connections Slicer Styles New Slicer Style... Light Dark

Ever wondered how to make your Excel sheets more interactive? 🤔 Discover the s