Adil Computer Center

Adil Computer Center I talk about this topic
❤️ MS Office
❤️ Tech Updates
❤️ Computer Hardware
❤️ Graphic Designing
❤️ Web Development
❤️ Digital Marketing

30/05/2026

Dynamic Sales Dashboard in Excel | INDEX + XMATCH Formula Trick 🔥

Learn how to create a dynamic sales dashboard in Excel using INDEX and XMATCH formulas. Simply enter a salesman name and instantly get state-wise sales data. You can also switch between states dynamically for fast analysis and reporting. This Excel trick is perfect for dashboards, MIS reports, data analysis, and office productivity.

✅ Dynamic Lookup
✅ State-wise Sales Report
✅ INDEX + XMATCH Formula
✅ Excel Dashboard Automation
✅ No VBA Required

Follow for more Excel tips, formulas, and automation tricks!

19/05/2026

Excel IF Formula Trick 🤯 Auto Add Mr & Ms in Seconds
Learn this amazing Excel IF Formula trick to automatically add Mr. and Ms. before names based on gender 🔥
Perfect for employee lists, student records, office databases, and Excel beginners.
Formula Used:
Excel Formula
=IF(D4="Male","Mr. ",IF(D4="Female","Ms. ",""))&C4
✅ Easy Excel Trick
✅ Smart Name Formatting
✅ Beginner Friendly
✅ Excel Automation
Save this trick and follow for more Excel shortcuts & formulas 🚀

15/05/2026

Smart Order Tracking System in Excel 🔥
Built a Dynamic Shipping & Order Tracking Dashboard in Excel using Checkboxes, XLOOKUP Formula, Progress Bar, and Automatic Status Updates 🔥
✅ Order Dispatch Tracking
✅ On The Way Status
✅ Delivery Today Update
✅ Delivered Automatically
✅ XLOOKUP Formula Used
✅ Dynamic Progress Bar
✅ Smart Excel Dashboard Design
As each checkbox is selected, the shipping status updates automatically from Dispatch → On The Way → Delivery Today → Delivered 📦🚚
Perfect Excel automation project for office work, inventory management, shipping tracking, and dashboard creation.

13/05/2026

XLOOKUP Magic in Excel 🔥 Branch Wise Price Auto Fetch
Learn how to use the powerful Microsoft Excel XLOOKUP formula to automatically fetch item prices from multiple branches.
Just type the item name and instantly get branch-wise prices like Branch 1, Branch 2, Branch 3, and Branch 4.
Perfect for:
✔ Inventory Management
✔ Stock Tracking
✔ Store Price List
✔ Excel Automation
✔ Office Work
Save time and make your Excel dashboard smarter with this easy formula trick. 🚀

11/05/2026

Excel Dashboard Filter Formula 📊 | Out Of Stock List in One Click
Learn how to create an Excel Stock Dashboard using FILTER Formula.
In this video, when you select “Out Of Stock”, all out of stock items automatically appear in the dashboard sheet.

✅ FILTER Formula
✅ Stock Management Dashboard
✅ In Stock / Low Stock / Out Of Stock Status
✅ Excel Automation Trick
✅ Dynamic List in Excel

Perfect for beginners and office work users.

10/05/2026

Excel Employee Rating Formula Using IFS Function | Excellent Good Average
Create an Employee Rating System in Excel using the IFS Formula.
In this Excel tutorial:
85 and above = Excellent
65 and above = Good
35 and above = Poor
Below 35 = Needs Improvement
Learn how to use:
✔ IFS Formula in Excel
✔ Employee Performance Rating
✔ Conditional Excel Formula
✔ Smart Excel Automation
Perfect for office work, beginners, and daily Excel users.

09/05/2026

Employee Rating System in Excel Using SWITCH Formula
Learn how to create an Employee Rating System in Excel using the SWITCH Formula.
In this tutorial:
1 = Excellent
2 = Good
3 = Poor
This video will help you understand: ✔ SWITCH Formula in Excel
✔ Employee Performance Rating
✔ Exact Match Formula
✔ Easy Excel Automation
Perfect for beginners, office work, and daily Excel practice.

Excel Roadmap
05/05/2026

Excel Roadmap

Hi Creators!Maine ek Smart Excel Upload Tracker launch kiya hai, jo personally mujhe consistency maintain karne mein mad...
25/04/2026

Hi Creators!

Maine ek Smart Excel Upload Tracker launch kiya hai, jo personally mujhe consistency maintain karne mein madad kar raha hai. 🚀

Ye dashboard aapko motivate karta hai automatic reminders ke saath:

⏳ Pending hai toh 'Get to Work!' alert.

✅ Complete hote hi 'All Done for Today!' logic.

Isme streaks, dynamic progress gaiges, aur built-in quotes bhi hain.

Hi Creators!Maine ek Smart Excel Upload Tracker launch kiya hai, jo personally mujhe consistency maintain karne mein mad...
20/04/2026

Hi Creators!

Maine ek Smart Excel Upload Tracker launch kiya hai, jo personally mujhe consistency maintain karne mein madad kar raha hai. 🚀

Ye dashboard aapko motivate karta hai automatic reminders ke saath:

⏳ Pending hai toh 'Get to Work!' alert.

✅ Complete hote hi 'All Done for Today!' logic.

Isme streaks, dynamic progress gaiges, aur built-in quotes bhi hain.

Agar aap ise try karna chahte hain, toh ye abhi Limited-Time for ₹49 INR par available hai.

Address

BARWA MEER CHHPAR
Deoria

Website

Alerts

Be the first to know and let us send you an email when Adil Computer Center posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category