SQL for Excel Users: 10 Queries That Replace Everyday Excel Work
Learn SQL through tasks you already do in Excel — filters, sorting, pivot tables, VLOOKUP and remove duplicates — with 10 queries you can…
Read article →Excel, SAP, Oracle & automation tips — plus wacky facts
Learn SQL through tasks you already do in Excel — filters, sorting, pivot tables, VLOOKUP and remove duplicates — with 10 queries you can…
Read article →UPPER makes text all capitals; LOWER makes it all small letters. Useful for codes, PAN and GSTIN that must be uppercase.
Read article →VLOOKUP returns only the first match. Combine TEXTJOIN, UNIQUE and FILTER to list every matching value in one cell — plus a version for…
Read article →TextLevel: IntermediateAvailable in: Excel 2007+REPLACE swaps characters at a given position — useful for masking.Syntax=REPLACE(old_text, start_num.
Read article →PRICE returns a bond’s price per 100 face value. When market yield rises above the coupon, price falls below 100 — the see-saw every…
Read article →CLEAN removes invisible control characters (like line breaks from system exports) that break lookups and look like spaces.
Read article →Use approximate-match lookups for slabs and bands: how TRUE/-1 matching works, building a bands table, commission and grade examples, progressive tax slabs with SUMPRODUCT,…
Read article →SUBSTITUTE replaces existing text with new text — all occurrences or just the n-th one.
Read article →ACCRINT calculates interest that has built up on a bond — the amount a buyer pays the seller on top of the quoted price.
Read article →PROPER capitalises the first letter of each word; UPPER and LOWER change the whole text.
Read article →CODE returns the number of the first character. It is the detective tool for “invisible” characters that break lookups: a non-breaking space shows up…
Read article →YIELD is the reverse of PRICE: what annual return you lock in if you buy at today’s price and hold to maturity.
Read article →You blink around 15–20 times a minute.
Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry eyes.