Adil Computer Center

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

20/09/2026
17/09/2026

Learn Computer Shutdown Shortcut Key!

In this video, Adil learns from his Papa how to shut down a Windows computer using a simple keyboard shortcut.

⌨️ *Shutdown Shortcut:* Windows + X + U + U

This easy computer tip is perfect for beginners, students, and anyone who wants to learn useful Windows keyboard shortcuts.

👨‍👦 Join Adil and Papa in this fun, educational computer tutorial!

👍 Like the video
🔔 Subscribe to *adilcomputercenter* for more computer tips and tutorials.

07/09/2026

Excel SUMIFS Formula to Calculate Paid & Unpaid Totals Automatically | Excel Tips & Tricks
Learn how to automatically calculate Paid and Unpaid totals in Excel using the SUMIFS formula.
In this tutorial, we create a simple Payment Tracking Table with:
✅ Client Name
✅ Due Amount
✅ Paid / Unpaid Status
✅ SUMIFS Formula
✅ Total Paid Amount
✅ Total Unpaid Amount
When you select Paid or UnPaid for a client, the respective total amount automatically updates at the top. 🔥
This Excel trick is useful for Payment Tracking, Client Payments, Invoice Management, and Office Work.
📌 Formula Used: =SUMIFS(Due_Amount,Paid_Unpaid,"Paid")
Subscribe to ADILCOMPUTERCENTER for more useful Excel Tips & Tricks! ❤️

📊 EXCEL TIPS – DAY 6 🚀IF FUNCTION IN EXCELWant Excel to make decisions automatically? 🤔💻The IF function helps you test a...
02/09/2026

📊 EXCEL TIPS – DAY 6 🚀

IF FUNCTION IN EXCEL

Want Excel to make decisions automatically? 🤔💻

The IF function helps you test a condition and return the result you need. ✅

📌 Example:

"=IF(B2>=50,"Pass","Fail")"

👉 If marks are 50 or more → Pass
👉 If marks are below 50 → Fail

🔥 In Day 6, You’ll Learn:

✅ How to use the IF function
✅ IF formula structure
✅ IF with Text
✅ IF with Numbers
✅ Nested IF
✅ Practical uses of IF function

💡 Quick Tip:
Combine IF with functions like AND, OR, COUNT & SUM to create powerful Excel formulas. 🚀

🔖 Save this post for future reference!
❤️ Like • 💬 Comment • 🔖 Save • ↗️ Share

🎓 ADIL COMPUTER CENTER
Excel Tips • Tricks • Tutorials

🔥 One Tip Every Day — Excel Skills All the Way!

📊 EXCEL TIPS – DAY 5 🚀AVERAGE, COUNT, MAX & MINReady to make Excel calculations faster? 💻⚡In today’s Day 5, learn 4 powe...
30/08/2026

📊 EXCEL TIPS – DAY 5 🚀

AVERAGE, COUNT, MAX & MIN

Ready to make Excel calculations faster? 💻⚡

In today’s Day 5, learn 4 powerful Excel formulas:

🔹 AVERAGE → Find the average of numbers
🔹 COUNT → Count the number of numeric values
🔹 MAX → Find the highest value
🔹 MIN → Find the lowest value

📌 Example:
"=AVERAGE(B2:B6)"
"=COUNT(B2:B6)"
"=MAX(B2:B6)"
"=MIN(B2:B6)"

💡 These simple formulas are extremely useful for reports, marksheets, sales data and daily office work.

⚡ Quick Tip: Use AutoSum (Σ) and press Alt + = to work faster!

🔖 Save this post for future reference.
❤️ Like • 💬 Comment • 🔖 Save • ↗️ Share

🎓 ADIL COMPUTER CENTER
Excel Tips • Tricks • Tutorials

🔥 One Tip Every Day — Excel Skills All the Way!

📸 DAY 3 — SHOOT BETTER PHOTOS & VIDEOS FOR REELS! 🎬A great Reel starts with a great shot! 🔥In Day 3, learn the basics of...
27/08/2026

📸 DAY 3 — SHOOT BETTER PHOTOS & VIDEOS FOR REELS! 🎬
A great Reel starts with a great shot! 🔥
In Day 3, learn the basics of shooting better photos and videos for your Reels — from camera settings, lighting, angles and composition to stabilization and recording tips.
🎯 Good Shot = Great Edit!
Follow SK Creators Hub for daily Reels, Photography & Editing tips.
📺 ADILCOMPUTERCENTER — Tips • Tricks • Tutorials

📊 EXCEL TIPS – DAY 4 🚀SUM FORMULA IN EXCELWant to calculate totals in Excel quickly? 💻The SUM formula makes calculations...
27/08/2026

📊 EXCEL TIPS – DAY 4 🚀

SUM FORMULA IN EXCEL

Want to calculate totals in Excel quickly? 💻
The SUM formula makes calculations fast, easy, and accurate! ⚡

📌 Example:
"=SUM(B2:B6)"
➡️ Instantly adds all numbers from B2 to B6.

🔥 What You’ll Learn:

✅ How to use the SUM formula
✅ Add numbers from a selected range
✅ Use SUM with multiple ranges
✅ Use AutoSum for quick calculations
✅ Save time and reduce calculation errors

💡 Quick Tip:
Press ALT + = to quickly insert the AutoSum formula in Excel.

🔖 Save this post for future reference!
❤️ Like • 💬 Comment • 🔖 Save • ↗️ Share

🎓 ADIL COMPUTER CENTER
Excel Tips • Tricks • Tutorials

🚀 One Tip Every Day — Excel Skills All the Way!

📊 EXCEL TIPS – DAY 3 🚀SORT & FILTER IN EXCELWant to organize your Excel data quickly? 💻Learn how to Sort & Filter your d...
25/08/2026

📊 EXCEL TIPS – DAY 3 🚀

SORT & FILTER IN EXCEL

Want to organize your Excel data quickly? 💻
Learn how to Sort & Filter your data and find exactly what you need!

🔹 SORT — Arrange data from Small → Large or A → Z
🔹 FILTER — Show only the data you want to see
🔹 Quickly find important information
🔹 Keep your data organized
🔹 Save time and improve productivity ⚡

💡 Quick Tip:
Use Sort to arrange your data and Filter to focus only on important information.

🔖 Save this post for future reference!
❤️ Like | 💬 Comment | 🔖 Save | ↗️ Share

🎓 ADIL COMPUTER CENTER
Excel Tips • Tricks • Tutorials

🔥 DAY 4 COMING SOON!

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