Goal Seek and Data Tables: What-If Analysis in Excel
Answer “what would it take?” questions in Excel: Goal Seek for break-even units, target price and affordable loan; one- and two-variable Data Tables for…
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
ARABIC Function in Excel: Roman Numerals to Numbers
ARABIC Function in Excel: Roman Numerals to Numbers
ARABIC reads Roman numerals so you can sort “Part IX” correctly after “Part VIII”.
Read article →UNICHAR Function in Excel: Any Unicode Symbol
UNICHAR Function in Excel: Any Unicode Symbol
UNICHAR returns a character from its Unicode number — arrows, ticks, the rupee sign — without hunting through Insert › Symbol.
Read article →ROMAN Function in Excel: Numbers to Roman Numerals
ROMAN Function in Excel: Numbers to Roman Numerals
MathLevel: BeginnerAvailable in: Excel 2007+ROMAN turns 1–3999 into Roman numerals — chapter numbers, annual-report years.Syntax=ROMAN(number.
Read article →XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One Should You Use?
XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One Should You Use?
A practical comparison of VLOOKUP, XLOOKUP and INDEX-MATCH in Excel — when each one works, when it breaks, and which to use in 2025.
Read article →CHAR Function in Excel: Character From a Code (Line Breaks, Symbols)
CHAR Function in Excel: Character From a Code (Line Breaks, Symbols)
CHAR returns the character for a code number. CHAR(10) is a line break — the key to multi-line cells built by formula. CODE does…
Read article →UNICODE Function in Excel: Unicode Number of a Character
UNICODE Function in Excel: Unicode Number of a Character
UNICODE returns the code point of the first character. Unlike CODE it is correct for Hindi, emoji and symbols.
Read article →LOWER Function in Excel: Convert Text to Small Letters
LOWER Function in Excel: Convert Text to Small Letters
LOWER converts all letters to lowercase — handy when comparing emails or usernames typed inconsistently.
Read article →UPPER Function in Excel: Convert Text to Capitals
UPPER Function in Excel: Convert Text to Capitals
UPPER makes text all capitals; LOWER makes it all small letters. Useful for codes, PAN and GSTIN that must be uppercase.
Read article →Return ALL Matches in One Cell: TEXTJOIN + FILTER (the VLOOKUP Upgrade)
Return ALL Matches in One Cell: TEXTJOIN + FILTER (the VLOOKUP Upgrade)
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 →REPLACE Function in Excel: Replace Characters by Position
REPLACE Function in Excel: Replace Characters by Position
TextLevel: IntermediateAvailable in: Excel 2007+REPLACE swaps characters at a given position — useful for masking.Syntax=REPLACE(old_text, start_num.
Read article →PRICE Function in Excel: Bond Price From Its Yield
PRICE Function in Excel: Bond Price From Its Yield
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 →