How To Make Excel Advanced Filter Dashboard | Auto Filter by Typing Text

Learn how to create a dynamic search and filter system in Excel without Power BI!
In this tutorial, we build a smart dashboard that lets you filter data by typing any text (even partial words) — and choose filter type (Region, Salesperson, Product, or Category) using Option Buttons.

💡 This system uses:

FILTER + SEARCH functions for dynamic results

Option Buttons (Form Controls) linked to a cell (for filter type)

VBA Auto Recalculation (for live typing filter)

👉 Perfect for dashboards, reports, and inventory systems!

📘 Topics Covered:

Excel FILTER function

SEARCH for partial text matching

Linking Option Buttons to a cell

Live auto-update filter using VBA

Building a professional Excel dashboard

✅ Works in Excel 365 and Excel 2021

#ExcelDashboard #ExcelFilter #ExcelSearch #ExcelFormula #ExcelVBA #DynamicFilter #ExcelTutorial #ExcelTips #ExcelLearning #microsoftexceltraining
#ShahabIslam
#SalarySheet
#Salesreport
#Attendancesheet
#Advanceexcel
#Marksheet
#billEntry
#dataentry
_/LINKS\
► Facebook:➜   / shahabislam123  
► Twitter:➜  / shahabislam123  
► Instagram:➜   / shahabislam6  
► Website:➜ https://advanceexcelonline.blogspot.com/
================================================

How To Make Salary Sheet in MS Excel # 43
   • How To Make Salary Sheet In MS Excel # 43  

Microsoft Word - Create Form (Office 2019)
   • Microsoft Word - Create Form (Office 2013)  

How to Calculate gross Profit From Income Statement
   • how to calculate gross Profit From Income ...  

Inventory Management excel formulas
   • inventory management excel formulas  

How To Make Sale Report in Excel # 26
   • HOW TO MAKE SALES REPORT IN EXCEL # 26  

how to maintain store inventory in excel
   • how to maintain store inventory in excel  

#159 How To Make Food Cost Profit Sheet in Excel Hindi
   • #159 How To Make Food Cost Profit  sheet i...  

advance Excel Training For Job | Data Entry | functions for data analysis
   • advance Excel Training For Job | Data Entr...  

hide excel sheet with password
   • hide excel sheet with password  

#107 How To Make a Stock Management in MS Excel
   • #107 How To Make a Stock Management in MS ...  

How To Make Experience Certificate and Latter on MS word Hindi
   • How To Make Experience Certificate and Lat...  

How To Make Automatic student fee Collection and status system in Excel
   • How To Make Automatic student fee collecti...  

How To Make General Ledger Trial Balance Sheet in Excel
   • How To Make General Ledger | Trial Balance...  

#219 How To Make Daily Production Report in Excel Hindi
   • #219 How To Make Daily Production Report i...  

How To Make Salary Pay Slip In MS Excel # 37
   • How To Make Salary Pay Slip In MS Excel # 37  

how to Maintain petrol pump accounts in excel Hindi
   • how to maintain petrol pump accounts in Ex...  

How To Make ID Card Design In Ms Word Urdu Tutorial
   • How To Make ID Card Design In Ms Word Urdu...  

#283 How To Make Stock Sale/purchase or Profit and Loss Sheet in Excel Hindi
   • #283 How To Make Stock Sale/purchase or Pr...  

How To Make Resume / CV with Microsoft Word
   • How To Make Resume / CV with Microsoft Word  

How To Make Daily Production Report For Garment industry on Excel Hindi
   • How To Make Daily Production Report for Ga...  

how to Create Notifications or Reminders Automatically in Excel
   • how to Create Notifications or Reminders A...  

#132 How To Make Monthly Interest amount Calculate Sheet in Excel Hindi
   • #132 How To Make Monthly Interest amount C...  

Click to see all our videos||
   / @shahabislam4912  

subcribe to our Channel ||
   / @shahabislam4912  

How To Make Bill / cash Book On MS word Hindi
   • How To Make Bill / cash Book On MS word Hindi  

How To Make Sale Price Sheet IN MS Excel Tutorial In Hindi # 51
   • How To Make Sale Price Sheet IN MS Excel T...  

#88 How To Make Debit Credit sheet in Excel Hindi
   • #88 How To Make Debit Credit sheet in Exce...  

#91 How To Make Balance Sheet in Excel Hindi
   • #91 How To Make Balance Sheet In Excel HIndi  

how to calculate retirement date in Excel
   • how to calculate retirement date in Excel  

Top 50 Excel Shortcut in Hindi
   • Top 50 Excel Shortcut in Hindi  

#269 How TO Maintain Cash Book ans Petty Cash Record in Excel 2019 Hindi
   • #269 How TO Maintain Cash Book ans Petty C...  

MS Excel Complete Course Hindi ||
   • #231 How To Make Revenue Sales Report & Ch...  

File Download Link Click Link goto Website
https://advanceexcelonline.blogspot.c...