Tired of manually filtering your Excel chart to see the last 7, 14, or 28 days of data? Say goodbye to time-consuming analysis and create this game-changing dynamic slicer!
In this video, you'll discover:
How to create a custom slicer that instantly updates your chart with the Last N Days view you need.
Unlock hidden trends and patterns in seconds with just a few clicks.
No more clunky filters or endless scrolling!
Say YES to effortless data exploration and dynamic insights.
Make your Excel dashboards rival those of Data Studio with this dark theme slicer for a sleek, professional look.
Ready to transform your Excel experience? ⚡️ Grab your data and click play to unlock the power of Last N Days views!
File Link Used in Video:
drive.google.c...
Keywords: Last N Days, Excel charts, dynamic slicer, data analysis, time-saving, insights, effortless, trends, patterns, custom slicer, data exploration, dark theme, Data Studio, rival, sleek, Professional
===CHAPTERS===
0:00 Introduction
0:28 Creating Slicer Table
1:15 Formatting Slicer
2:06 Writting Subtotal Function
2:45 Calculating Last N Days date
3:15 Writing filter function with subtotal conditions
4:06 Create basic Column Chart + Formatting
7:36 Showing Last N Days Total Sales
18 авг 2024