7. SLICERS 💡📊
👇 Watch & share if you love this content!
🖥️ Check this out: Pivot Table - Slicers
🔸 7.1 – How to Insert a Slicer
🔹 Step 1: Select your Pivot Table
🔹 Step 2: Go to Insert ➡️ Click Slicer
🔹 Step 3: Choose the field you want to filter
🔹 Boom! 💥 A colourful filter box appears on your sheet!
🎯 Use Case: Filter your sales by Region / Product / Month in just one click! 😍
🎨 7.2 – Slicer Styles (Style-கள் எப்படி மாற்றலாம்?)
✨ Slicer boring-ஆ இருக்கா? Let’s give it some style!
✅ Select the Slicer ➡️ Slicer Tab ➡️ Choose a style from gallery
🎨 Try Dark, Light, Colourful, or Corporate Looks
🌈 Tip: Dashboard-க்கு match ஆகும் colour choose பண்ணுங்க – visual impact 🔥
🌟 7.3 – Create Custom Style (உங்களுக்கான Style உருவாக்குங்கள்)
🛠️ Want your own slicer style?
🔸 Click on Slicer Styles
🔸 Choose New Slicer Style
🔸 Customize:
✔️ Font,
✔️ Border,
✔️ Background Colour
🎨 Pro Touch: Match your company’s theme colour for branded reports 💼
📥 7.4 – Copy Custom Style to New Workbook
📌 Custom style create பண்ணிட்டு, வேற Workbook-ல use பண்ணணுமா?
👉 Just Copy & Paste the slicer into the new workbook
🎉 Your custom style will travel with it!
💡 Pro Tip: Maintain same look across all reports for consistency 🌐
⚙️ 7.5 – Slicer Settings
🖱️ Right-click on Slicer ➡️ Select Slicer Settings
🧩 Options:
✅ Show/Hide Header
✅ Sort A-Z
✅ Hide items with no data
✅ Change display settings
🔐 Power user setting! Fine-tune how data appears in slicer 💪
📐 7.6 – Slicer Size & Properties (Size, Layout Customize பண்ணலாம்)
📏 Select the slicer ➡️ Go to Format Tab
🔸 Resize: Change height & width
🔸 Align: Place it wherever you want
🔸 Properties:
✔️ Move & size with cells
✔️ Keep slicer position fixed 📌
🖼️ Perfect for dashboards! Neat layout = professional report
🔗 7.7 – Slicer Connection for Multiple Pivot Tables (1 Slicer ➡️ பல Pivot Tables)
🤝 Want to control many Pivot Tables with one slicer?
✅ Select Slicer ➡️ Slicer tab ➡️ Click Report Connections
✅ Tick all Pivot Tables to connect!
💡 Benefit: One click filters everything – no duplication, no confusion! 🔄
🌀 7.8 – Different Ways to Filter Slicer
📌 Filter like a pro using these:
🔹 Click: Select one item
🔹 Ctrl + Click: Select multiple
🔹 Clear Filter ❌ to reset
🔹 Search 🔍 inside slicer for faster selection
✨ Cool Trick: Use dynamic data + slicer for smart dashboards!
🔁 7.9 – One Slicer for Two Pivot Tables
📍 Must use same data source for both Pivot Tables
✅ Then:
Select slicer ➡️ Slicer ➡️ Report Connections ➡️ Tick both Pivot Tables
💡 Real-life Use: Filter Sales & Profit tables together in one click 🎯
🔒 7.10 – Lock Workbook but Allow Slicer
🛡️ Protect the sheet, but allow users to use slicer:
✅ Go to Review ➡️ Click Protect Sheet
✅ Tick ➡️ "Use PivotTable & Slicer"
🔐 Secure + Interactive! Let users filter without editing the sheet! 👌
📝 Excel Slicer – Summary at a Glance 🎯
| 🔢 Topic | 📌 Summary (Tamil + English) |
|---|---|
| 7.1 – Insert Slicer | Pivot Table select பண்ணி ➡️ Insert → Slicer → Field select → Ready to use 🎉 |
| 7.2 – Slicer Styles | Slicer-க்கு அழகான styles apply பண்ணலாம் (Light, Dark, Corporate) 🎨 |
| 7.3 – Custom Style | New Slicer Style create பண்ணி உங்கள் company theme-க்கு match செய்யலாம் 🖌️ |
| 7.4 – Copy Style to Another Workbook | Slicer copy-paste பண்ணா custom style கூட வரும் 💼 |
| 7.5 – Slicer Settings | Right-click → Slicer Settings → Header, Sort, Filter options set பண்ணலாம் ⚙️ |
| 7.6 – Slicer Size & Properties | Format tab-ல் size, align, layout perfect-ஆ set பண்ணலாம் 📏 |
| 7.7 – Slicer Connections | ஒரே Slicer-ஐ பல Pivot Tables-க்கு connect பண்ணி one-click filtering 🔗 |
| 7.8 – Filtering Tricks | Click, Ctrl + Click, Search, Clear – Multiple filter ways available 🌀 |
| 7.9 – One Slicer, Two Pivot Tables | Same Data Source இருந்தா, 1 Slicer-ல 2 Pivot Tables connect செய்யலாம் 🔄 |
| 7.10 – Lock Sheet but Allow Slicer | Protect Sheet + Allow Slicer = Safe but interactive Dashboard 🔐 |
💎 Bonus Design Tips:
🧩 Use matching slicer colours with chart theme
🖼️ Arrange slicers neatly – align properly
📋 Always name slicers for easy reference in dashboards
🤩 Conclusion:
Slicer = Superpower for your Excel Reports! 🎯
Slicers = Smart, Stylish & Super Useful!
👉 Easy to use, fun to style, and perfect for dashboards!
💼 Business reports, 📊 Dashboard filters, 🎨 Stylish designs – எல்லாத்திற்கும் perfect partner.
Try பண்ணி பாருங்க – உங்கள் Excel skills next levelக்கு போகும்! 🚀
💬 Comment below: Which slicer trick are you going to try today?
Comments
Post a Comment