SOME ADVANCE FORMULAS OF EXCEL & WORD
⚡ SOME SPECIAL SHORTCUTS OF EXCEL . WORD⚡
✦ GOLDEN WEB TOOLS ✦
EXCEL
🧹 TRIM – remove extra spaces
=TRIM(A1)
➜ " Hello World " → "Hello World"
EXCEL
🔤 PROPER – capitalize each word
=PROPER(A1)
➜ "john doe" → "John Doe"
EXCEL
🔠 UPPER – all caps
=UPPER(A1)
➜ "hello" → "HELLO"
EXCEL
🔡 LOWER – all lowercase
=LOWER(A1)
➜ "HELLO" → "hello"
EXCEL
🧩 CONCATENATE – join text
=CONCATENATE(A1, " ", B1)
➜ A1="John", B1="Doe" → "John Doe"
EXCEL
🔍 VLOOKUP – vertical lookup
=VLOOKUP(G1, A:B, 2, FALSE)
➜ finds G1 in col A, returns matching value from col B
EXCEL
✅ IF – conditional logic
=IF(A1>100, "High", "Low")
➜ if A1=150 → "High"
EXCEL
➕ SUMIF – conditional sum
=SUMIF(A:A, "Apples", B:B)
➜ sums col B where col A = "Apples"
EXCEL
🔢 COUNTIF – conditional count
=COUNTIF(A:A, ">100")
➜ counts cells in col A with value > 100
EXCEL
📅 TEXT – format numbers/dates
=TEXT(A1, "dd-mmm-yyyy")
➜ 26/07/2026 → "26-Jul-2026"
EXCEL
⬅️ LEFT – extract left chars
=LEFT(A1, 4)
➜ "ExcelMaster" → "Exce"
EXCEL
➡️ RIGHT – extract right chars
=RIGHT(A1, 4)
➜ "ExcelMaster" → "ster"
EXCEL
🎯 MID – extract from middle
=MID(A1, 3, 4)
➜ "ExcelMaster" → "celM"
EXCEL
📏 LEN – character count
=LEN(A1)
➜ "Hello" → 5
EXCEL
🔎 FIND – position of text
=FIND("@", A1)
➜ "john@email.com" → 5 (position of "@")
EXCEL
🔄 SUBSTITUTE – replace text
=SUBSTITUTE(A1, "old", "new")
➜ "old car" → "new car"
EXCEL
🧽 TRIM + CLEAN (ultimate)
=TRIM(CLEAN(A1))
➜ removes spaces + non‑printable + line breaks
EXCEL 365
🔢 Number → words (spellout)
=TEXT(A1, "spellout")
➜ 123 → "one hundred twenty-three"
EXCEL
💵 Number → currency words
=DOLLAR(A1)
➜ 1234.5 → "$1,234.50" (text)
WORD field
📄 Page count minus cover
{ = { NUMPAGES } - 1 }
➜ returns total pages minus 1
WORD field
🔢 Number → words (CardText)
{ = 1250 \* CardText }
➜ one thousand two hundred fifty
WORD field
🥇 Ordinal (1st, 2nd, 3rd…)
{ = 1250 \* Ordinal }
➜ 1250th | { = 3 \* Ordinal } → 3rd
WORD field
💵 UPPERCASE words (DollarText)
{ = 1250 \* DollarText }
➜ ONE THOUSAND TWO HUNDRED FIFTY
WORD field
🔠 Title Case (FirstCap)
{ = 1250 \* FirstCap }
➜ One Thousand Two Hundred Fifty
WORD field
📅 Date (DD/MM/YYYY)
{ DATE \@ "dd/MM/yyyy" }
➜ 26/07/2026 (auto-updates)
WORD field
📅 Full date (Day, Month dd, yyyy)
{ DATE \@ "dddd, MMMM dd, yyyy" }
➜ Sunday, July 26, 2026
WORD field
⏰ Current time (am/pm)
{ TIME \@ "h:mm am/pm" }
➜ 10:15 am
WORD field
🎄 Conditional message (IF)
{ IF { DATE \@ "M" } = "12" "Merry Christmas!" "Welcome back!" }
➜ Welcome back! Use code SAVE10
WORD field
🧮 Math + formatting
{ = 25000 * 0.18 \# "₹#,##0.00" }
➜ calculates 18% → ₹4,500.00
SHORTCUT
🎨 Copy / Paste formatting
Ctrl + Shift + C then Ctrl + Shift + V
➜ copy format from one place, apply to another
SHORTCUT
⚡ Flash Fill (pattern)
Ctrl + E
➜ auto‑fill based on example (no formulas)
SHORTCUT
📋 Convert to table
Ctrl + T
➜ structured table with filters & auto‑expand
SHORTCUT
📆 Today / now
Ctrl + ; (date) Ctrl + Shift + ; (time)
➜ static date/time inserted instantly
SHORTCUT
🔄 Repeat last action
F4
➜ re‑do the last formatting / action anywhere
SHORTCUT
🎯 Select similar formatting
right‑click → Select Similar Formatting
➜ change all headings / styles at once
SHORTCUT
🧹 Paste as values
Ctrl + Alt + V → V
➜ pastes only values (removes formulas)
SHORTCUT
📊 AutoSum
Alt + =
➜ instantly sums the column/row above/left
SHORTCUT
⬇️ Copy down / ➡️ Copy right
Ctrl + D Ctrl + R
➜ copies the cell/formula down or right
SHORTCUT
🔍 Find & Replace
Ctrl + H
➜ replace text or formatting across entire document
SHORTCUT
📈 Filter toggle
Ctrl + Shift + L
➜ adds/removes filters to your data headers
🧪 TEST:
hello world
Shiben
As you came here, so you must go. So don't delay, do the main thing, many real genes will know or understand.
