Excel Slicers WITHOUT PivotTables? The Disconnected Table Trick

Sign up for our free Insiders program and get the example file: Click here: https://exceloffthegrid.com/insiders/ File Reference for this video: 0282 Dynamic Slicer Reporting ★ Want to become an Excel ninja? Check out our training academy ★ https://exceloffthegrid.com/ ★ About this video ★ Slicers are commonly used with PivotTables; they are a great method for providing user interactivity. But we don't need to be restricted to PivotTables, we can Slicers for anything we like. In this step-by-step build, I’ll show you the disconnected table technique and how to wire it up for dynamic formula-driven calculations. 00:00 Introduction 00:30 Scenario 01:04 Stage 1 - Create Disconnected Tables 04:54 Stage 2 - Create Slicers 06:00 Stage 3 - Getting Slicer Values 10:00 Stage 4 - Using Selected Values 18:40 Wrap up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel

Join Today
Power BI Data Modeling Crash Course Learn Fast and Build Smarter Models! Full Course
▶︎

Power BI Data Modeling Crash Course Learn Fast and Build Smarter Models! Full Course

The Excel Timeline chart you'll actually keep using (free template included)
▶︎

The Excel Timeline chart you'll actually keep using (free template included)

Excel's GROUPBY Function Has Hidden Features That Nobody Knows
▶︎

Excel's GROUPBY Function Has Hidden Features That Nobody Knows

FILTER + Wildcards in Excel: The NEW and BETTER Techniques
▶︎

FILTER + Wildcards in Excel: The NEW and BETTER Techniques

Drop‑Down Lists From Tables: Stop Using INDIRECT (Do This Instead)
▶︎

Drop‑Down Lists From Tables: Stop Using INDIRECT (Do This Instead)

Secret trick to use slicers with GROUPBY or PIVOTBY
▶︎

Secret trick to use slicers with GROUPBY or PIVOTBY

One Column Change Destroys Everything... Unless You Do This!
▶︎

One Column Change Destroys Everything... Unless You Do This!

LAMBDA Explained in Simple Terms - Excel’s Most Confusing Function... Finally Made Easy
▶︎

LAMBDA Explained in Simple Terms - Excel’s Most Confusing Function... Finally Made Easy

Excel PivotTables Made Easy in 2026 (+ What's Changed!)
▶︎

Excel PivotTables Made Easy in 2026 (+ What's Changed!)

The Advanced Excel Method Nobody Told You About [The DROP REDUCE LAMBDA STACK Combo]
▶︎

The Advanced Excel Method Nobody Told You About [The DROP REDUCE LAMBDA STACK Combo]

Stop Using Pivot Tables! 7 New Excel GROUPBY Tricks
▶︎

Stop Using Pivot Tables! 7 New Excel GROUPBY Tricks

How to use Power Pivot in Excel | Full Tutorial
▶︎

How to use Power Pivot in Excel | Full Tutorial

Formulas vs PivotTables vs Power Pivot: Which You Should Use (and When)?
▶︎

Formulas vs PivotTables vs Power Pivot: Which You Should Use (and When)?

Excel GROUPBY Problem Solved: Sort Months the Right Way
▶︎

Excel GROUPBY Problem Solved: Sort Months the Right Way

You DON'T Need PivotTables Anymore (Here Is Why)
▶︎

You DON'T Need PivotTables Anymore (Here Is Why)

Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX)
▶︎

Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX)

Something is jamming GPS over Europe. Here's what we found
▶︎

Something is jamming GPS over Europe. Here's what we found

Excel’s Ultimate FILTER Hack - Multiple Columns, Multiple Values 😲
▶︎

Excel’s Ultimate FILTER Hack - Multiple Columns, Multiple Values 😲

Double Dash: The Secret to Smarter Excel Formulas
▶︎

Double Dash: The Secret to Smarter Excel Formulas

STOP Making Basic Drop-Downs! Try These 5 Advanced Methods Instead
▶︎

STOP Making Basic Drop-Downs! Try These 5 Advanced Methods Instead