SheetShorts

05/08/2025

03/08/2025

📊 Excel Tip: Master VLOOKUP in 60 Seconds!

Struggling with data lookup in Excel? VLOOKUP is your best friend! 🔍

✅ What it does: Finds a value in a table based on a matching key.
✅ Syntax:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

✅ Example
=VLOOKUP("Apple", A2:B10, 2, FALSE)

→ Searches for "Apple" in column A and returns the corresponding value from column B.

⚠ Pro Tip: Use FALSE for exact matches, TRUE for approximate matches.

Like 👍 if you found this helpful! Drop a comment if you want a tutorial on XLOOKUP (the upgraded VLOOKUP!).

03/08/2025

🔹 Ctrl + N - New workbook
🔹 Ctrl + 9 - Hide selected rows
🔹 Ctrl + Shift + 9 - Unhide rows
🔹 Ctrl + 0 - Hide columns
🔹 Ctrl + Shift + 0 - Unhide columns
🔹 Ctrl + E - Flash Fill
🔹 Alt + = - AutoSum
🔹 Ctrl + ; - Insert current date
🔹 Ctrl + Shift + ; - Insert current time
🔹 Ctrl + 1 - Format Cells dialog
🔹 Ctrl + T - Create table
🔹 Ctrl + Space - Select column
🔹 Shift + Space - Select row
🔹 Ctrl + Arrow Keys - Navigate data
🔹 Ctrl + Shift + L - Toggle filters
🔹 Alt + N + V - Insert PivotTable
🔹 Alt + A + M - Remove duplicates
🔹 F2 - Edit cell
🔹 F4 - Repeat last action
🔹 Ctrl + Z - Undo
🔹 Ctrl + Y - Redo
🔹 Ctrl + C - Copy
🔹 Ctrl + X - Cut
🔹 Ctrl + V - Paste
🔹 Ctrl + F - Find
🔹 Ctrl + H - Replace
🔹 Ctrl + A - Select all
🔹 Ctrl + S - Save
🔹 Ctrl + O - Open workbook
🔹 Ctrl + P - Print

Hide/Unhide Tip: Select rows and press Ctrl + 9 to hide them, then Ctrl + Shift + 9 to reveal. Works similarly for columns with Ctrl + 0 and Ctrl + Shift + 0.

21/07/2025

কোন শব্দ নাই

13/07/2025

Talk louder over phone or IP, So that ur boss realized that "মেলা কাম করে ফাটায় দিচ্ছো"

tips 2

09/07/2025

Corporate Tips 1 -
Bring foods and fruits for your boss to Secure you place.

08/07/2025

শো অফ আর চাটা বেস্ট স্কিল যেকোনো ক্ষেত্রে সাফল্যের জন্য। তেল হচ্ছে সবথেকে বড় উপঢৌকন।

07/07/2025

আপনাকে যেখানে মোটিভেশান দেওয়া হবে যে আপনি পোটেনশিয়াল, বাট, ফলাফলে নাই, Just Leave it.

17/06/2025

✍️ Boost Your Productivity with These Microsoft Word Shortcuts! 🖥️💡

Tired of clicking through menus? Speed up your work with these handy Word shortcuts:

✅ Ctrl + B – Bold text
✅ Ctrl + I – Italic
✅ Ctrl + U – Underline
✅ Ctrl + Z – Undo
✅ Ctrl + Y – Redo
✅ Ctrl + S – Save your document
✅ Ctrl + F – Find words instantly
✅ Ctrl + H – Replace text easily
✅ Ctrl + K – Insert hyperlink
✅ Ctrl + Shift + L – Apply bullet list

🔄 Memorize these and watch your workflow transform!

🔄 Memorize these and watch your workflow transform!

💬 Got a favorite shortcut I missed? Drop it in the comments! ⌨️👇

12/06/2025

Excel shortcut keys