MS Excel Tips & tricks

MS Excel Tips & tricks We Help People to Advance Their Microsoft Excel & Office Skills with our free Resources Here.

Follow Me✅️👍
For Microsoft Office Tips and Tricks,"Learn Advanced Office skills with Me,Or "Stay Updated on the latest Office Features -
Follow Now!👍✅️

🔹 Fundamental VLOOKUP Function in Microsoft ExcelVLOOKUP ka use Excel mein table se data search karne ke liye hota hai —...
05/01/2026

🔹 Fundamental VLOOKUP Function in Microsoft Excel

VLOOKUP ka use Excel mein table se data search karne ke liye hota hai — jaise kisi ID, Name ya Code ke basis par related value nikalna.

---

📌 VLOOKUP Syntax

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Microsoft office Specialist Excel Tricks Excel shortcuts

Excel Keyboard Shortcuts that professionals use to work faster & smarter 🚀(Windows version)🔹 Navigation & SelectionCtrl ...
04/01/2026

Excel Keyboard Shortcuts that professionals use to work faster & smarter 🚀
(Windows version)
🔹 Navigation & Selection
Ctrl + Arrow Keys → Jump to last filled cell
Ctrl + Shift + Arrow Keys → Select data till last cell
Ctrl + Home → Go to A1
Ctrl + End → Go to last used cell
Shift + Space → Select entire row
Ctrl + Space → Select entire column
🔹 Editing & Formatting
F2 → Edit active cell
Ctrl + Enter → Fill selected cells with same value
Ctrl + D → Fill Down
Ctrl + R → Fill Right
Ctrl + 1 → Format Cells dialog
Alt + Enter → New line in same cell
🔹 Data & Tables
Ctrl + T → Convert range to Table
Alt + A + T → Filter ON/OFF
Ctrl + Shift + L → Apply / Remove Filter
Alt + ↓ → Open filter dropdown
Ctrl + ; → Insert current date
Ctrl + Shift + : → Insert current time
🔹 Formulas & Functions
= + Tab → Auto-complete function
Ctrl + ` → Show / Hide formulas
F4 → Toggle absolute ($) references
Ctrl + Shift + Enter → Array formula (legacy Excel)
Alt + = → AutoSum
🔹 Pivot Tables
Alt + N + V → Insert Pivot Table
Alt + ↓ → Open Pivot field list
Ctrl + Alt + F5 → Refresh all piv.
Microsoft office Specialist Excel Tricks STP Computer Education Excel shortcuts

Collection of Excel formulas (basic to advanced) that you can use for daily work, interviews, and content creation 📊👇🔹 B...
02/01/2026

Collection of Excel formulas (basic to advanced) that you can use for daily work, interviews, and content creation 📊👇
🔹 Basic Excel Formulas
SUM
Copy code
Excel
=SUM(A1:A10)

Adds numbers in a range
AVERAGE
Copy code
Excel

=AVERAGE(A1:A10)
Finds the average value
COUNT
Copy code
Excel

=COUNT(A1:A10)
Counts numeric values
COUNTA
Copy code
Excel

=COUNTA(A1:A10)
Counts non-empty cells
MAX / MIN
Copy code
Excel

=MAX(A1:A10)
=MIN(A1:A10)
🔹 Logical Formulas
IF
Copy code
Excel
=IF(A1>=50,"Pass","Fail")
IFS
Copy code
Excel

=IFS(A1>=90,"A",A1>=75,"B",A1>=50,"C",TRUE,"Fail")
AND / OR
Copy code
Excel

=AND(A1>50,B1>50)
=OR(A1>50,B1>50)
🔹 Lookup & Reference
VLOOKUP
Copy code
Excel
=VLOOKUP(A1,A2:D10,3,FALSE)
HLOOKUP
Copy code
Excel
=HLOOKUP(A1,A1:D5,2,FALSE)
XLOOKUP (Modern)
Copy code
Excel
=XLOOKUP(A1,A2:A10,B2:B10)
INDEX + MATCH
Copy code
Excel
=INDEX(B2:B10,MATCH(A1,A2:A10,0))
🔹 Text Formulas
LEFT / RIGHT / MID
Copy code
Excel
=LEFT(A1,4)
=RIGHT(A1,2)
=MID(A1,2,3)
LEN
Copy code
Excel
=LEN(A1)
TRIM
Copy code
Excel
=TRIM(A1)
CONCAT / TEXTJOIN
Copy code
Excel
=CONCAT(A1," ",B1)
=TEXTJOIN(" ",TRUE,A1:C1)
🔹 Date & Time
TODAY / NOW
Copy code
Excel
=TODAY()
=NOW()
DATEDIF
Copy code
Excel
=DATEDIF(A1,B1,"D")
YEAR / MONTH / DAY
Copy code
Excel
=YEAR(A1)
=MONTH(A1)
=DAY(A1)
🔹 Math & Rounding
ROUND
Copy code
Excel
=ROUND(A1,2)
**ROUNDUP / R
Excel Tricks Microsoft office Specialist Excel shortcuts

📅 Easy Way to Change Date Format using Excel ShortcutsYou can quickly change date formats in Microsoft Excel without ope...
02/01/2026

📅 Easy Way to Change Date Format using Excel Shortcuts
You can quickly change date formats in Microsoft Excel without opening the Format menu 👇
🔹 Shortcut Method (Fastest)
Select the date cell(s)
Press Ctrl + 1 → Format Cells box opens
Press Alt + D → Select Date
Use Arrow keys to choose the format
Press Enter
🔹 Instant Date Formats (One-Key Shortcuts)
Shortcut
Date Format
Ctrl + Shift + #
dd-mmm-yy (01-Jan-25)
Ctrl + Shift + @
Time format
Ctrl + Shift + ~
General format
🔹 Custom Date Format (Quick)
Select cell → Ctrl + 1
Press Alt + C → Custom
Type format:
dd-mm-yyyy
mm/dd/yyyy
dd-mmm-yyyy
Press Enter
✅ Pro Tip
Excel stores dates as numbers — formatting only changes how the date looks, not the actual value.
If you want,
Microsoft office Specialist Excel Tricks

What is Ctrl+shift+L in Excel? 🌟💻Microsoft office Specialist Excel Tricks
30/12/2025

What is Ctrl+shift+L in Excel?
🌟💻
Microsoft office Specialist Excel Tricks

👉 70 Excel Shortcut Keys ✅ For Finance⚡ Microsoft office Specialist Excel Tricks
30/12/2025

👉 70 Excel Shortcut Keys ✅ For Finance⚡
Microsoft office Specialist Excel Tricks

Clean Data in a Few seconds in Excel
27/12/2025

Clean Data in a Few seconds in Excel


25/12/2025

I got over 200 reactions on my posts last week! Thanks everyone for your support! 🎉

How Decisions Work in Excel (IF Function) ✅In Excel, decisions are made using the IF function. It checks a condition and...
24/12/2025

How Decisions Work in Excel (IF Function) ✅
In Excel, decisions are made using the IF function. It checks a condition and then decides what to do if the condition is TRUE or FALSE.
Basic IF Formula Structure
Copy code

=IF(condition, value_if_true, value_if_false)
How It Works (Step-by-Step)
Condition → Excel checks a logical test
TRUE result → What happens if the condition is met
FALSE result → What happens if the condition is not met
Example 1: Pass / Fail Decision
Marks are in cell A1
Copy code

=IF(A1>=40,"Pass","Fail")
✔ If marks are 40 or more → Pass
❌ If marks are less than 40 → Fail
Example 2: Salary Bonus Decision
Salary in B1
Copy code

=IF(B1>=30000,"Bonus","No Bonus")
Example 3: Numeric Result Instead of Text
Copy code

=IF(A1>100, A1*10%, 0)
✔ If value is greater than 100 → 10% calculation
❌ Otherwise → 0
Nested IF (Multiple Decisions)
Grade system:
Copy code

=IF(A1>=90,"A",
IF(A1>=75,"B",
IF(A1>=60,"C","Fail")))
Excel checks from top to bottom and stops when it finds TRUE.
Decision Operators Used in IF
Operator
Meaning
>
Greater than
<
Less than
>=
Greater than or equal
=40,B1>=40),"Pass","Fail")
OR Example
Copy code

=IF(OR(A1>=40,B1>=40),"Pass","Fail")
Simple Decision Flow
Copy code

Check condition → TRUE → Result 1
→ FALSE → Result 2
Microsoft office Specialist Excel Tricks Excel shortcuts STP Computer Education

Windows Shortcut Keys that help you work faster and smarter 💻👇🔹 General Windows Shortcut KeysCtrl + C → CopyCtrl + X → C...
22/12/2025

Windows Shortcut Keys that help you work faster and smarter 💻👇
🔹 General Windows Shortcut Keys
Ctrl + C → Copy
Ctrl + X → Cut
Ctrl + V → Paste
Ctrl + Z → Undo
Ctrl + Y → Redo
Ctrl + A → Select all
Ctrl + S → Save
Ctrl + P → Print
Ctrl + F → Find
Alt + F4 → Close active window
🔹 Windows Key Shortcuts
Win + D → Show / Hide Desktop
Win + E → Open File Explorer
Win + L → Lock your PC
Win + I → Open Settings
Win + R → Open Run dialog
Win + Tab → Task View
Win + M → Minimize all windows
🔹 File Explorer Shortcuts
Ctrl + N → New window
Ctrl + Shift + N → New folder
Alt + Enter → File/Folder Properties
Backspace → Go back
F2 → Rename selected item
🔹 Screenshot Shortcuts
PrtScn → Copy entire screen
Alt + PrtScn → Capture active window
Win + PrtScn → Save screenshot automatically
Win + Shift + S → Snipping Tool
🔹 System & Task Management
Ctrl + Shift + Esc → Task Manager
Alt + Tab → Switch between apps
Ctrl + Alt + Del → Security options
If you want:
Excel Tricks Microsoft office Specialist Excel shortcuts STP Computer Education

Address

Handwara
Kupwara
193221

Website

Alerts

Be the first to know and let us send you an email when MS Excel Tips & tricks 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