SheetShorts

📊 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!).

🔹 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.

কোন শব্দ নাই

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

tips 2

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

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

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

✍️ 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! ⌨️👇

Excel shortcut keys