Excel Function

Excel has no dedicated tick-mark button, but it offers five distinct ways to insert one. The Symbol dialog works for one-off insertions with no setup. Alt+0252 in Wingdings is the fastest keyboard-only method. Shift+P in Wingdings 2 is even quicker once the column is pre-formatted. The CHAR function brings ticks inside formulas — combine it with IF to show a tick when a task is done and a cross when it isn’t. Unicode ✓ and ✔ paste directly into any font without changing a thing. This guide covers all five methods, then shows how to count ticks with COUNTIF, restrict a column to ticks and crosses only using data validation, and color entire rows green or red with conditional formatting

Excel has no built-in SPELLNUMBER function, but three methods fill the gap. The VBA NumToWords function is the most flexible — paste the code once into a module, save as .xlsm, and use =NumToWords(A1) anywhere in the workbook. The AmountToWords extension adds currency and sub-unit names, producing invoice-ready output like “One Thousand Two Hundred Fifty Dollars and Seventy-Five Cents” automatically. For macro-restricted environments, a LAMBDA function defined in the Name Manager achieves the same result with no VBA at all — fully compatible with .xlsx files. This guide covers all three methods with eight practical examples: basic conversion, multi-currency invoice lines (USD, GBP, AED, INR, EUR), cheque format with the XX/100 fraction convention, a dynamic currency table driven by XLOOKUP, and how to lock the output as static text before sharing a finalised document.

Linear trends add a fixed amount each period. Exponential trends multiply by a fixed rate. User

Most sales data follows a pattern: higher in December, slower in January, up again in spring.

Learn when to use VAR.S vs VAR.P in Excel. Covers population vs sample variance, portfolio risk, R² decomposition, conditional variance, and why variances add but standard deviations don’t.

Learn when to use STDEV.S and STDEV.P in Excel. This tutorial blog covers Bessel’s correction, quality control, financial volatility, z-scores, rolling standard deviation, and 8 practical examples with formulas. Explore other tutorials to learn more about Excel Functions.

Master Excel’s PERCENTILE.INC, PERCENTILE.EXC, QUARTILE.INC, PERCENTRANK, and RANK.EQ functions. This tutorial blog covers eight practical examples covering performance banding, salary analysis, outlier detection, grading curves, and executive dashboards.

You run a quartile formula on your data and share the report. A colleague checks the same numbers in R and gets different results. Another uses a TI-84 calculator and gets a third set. All three are correct — they just use different methods.
Excel exposes both major approaches through two functions. QUARTILE.INC uses the inclusive method, matching R, Python, and the legacy QUARTILE function. QUARTILE.EXC uses the exclusive method, matching academic textbooks and TI calculators. Choosing the wrong one doesn’t break your spreadsheet, but it produces numbers that don’t match your team’s expectation.
This guide covers the full syntax, the quart 0–4 support table (including why QUARTILE.EXC returns #NUM! for quart = 0 and 4), and eight practical examples: side-by-side comparison on the same dataset, IQR calculation, outlier detection with the 1.5×IQR fence rule, the five-number summary, salary band classification, box-and-whisker chart preparation, academic grade analysis, and the relationship between QUARTILE and PERCENTILE functions.

When a dataset has two equally popular values, Excel’s MODE function silently returns only one — dropping the other without warning. The MODE.MULT function corrects this by returning all modes as a vertical array. This matters for survey analysis, quality control, and any task where knowing every most-common value changes the conclusion. This guide covers 8 practical examples: basic multimodal detection, IFERROR clean output, TRANSPOSE for horizontal display, COUNTIF frequency verification, survey polarisation analysis, sales order mode detection, a TEXTJOIN mode-list label, and how to handle all-unique datasets that have no mode at all.

Chapter headings, legal sections, Super Bowl editions, and copyright years all use Roman numerals. Writing them manually for large numbers like MMXXVI is slow and error-prone. Excel’s ROMAN function converts any integer from 1 to 3999 into its Roman numeral equivalent instantly. It also offers five notation levels — from strict classical (CDXCIX) to simplified (ID) — and pairs with the ARABIC function to convert back for calculations. This guide covers 8 practical examples including chapter labels, self-updating copyright years, lowercase preface numbering, sequential outlines with ROW, event edition labels, and everything you need to know about the form argument.

Excel has no built-in English function that converts numbers to words — but it does have BAHTTEXT (Thai only) and the Microsoft-published Spell Number VBA macro (English, any currency). This guide covers both fully. You will find all BAHTTEXT examples for Thai invoices, the complete Spell Number VBA code with plain-English annotations, step-by-step installation instructions, examples for cheques and payment vouchers, how to customize Spell Number for pounds, euros, or rupees, and a full comparison of every available method — including the GOOGLETRANSLATE workaround in Google Sheets and LAMBDA-based alternatives in Excel 365.

Concatenating a number with text in Excel instantly strips its formatting — the dollar sign, commas, and decimal places all disappear. The DOLLAR function solves this by converting a number directly to a formatted currency text string, preserving the symbol and precision in the output. It also rounds to any number of decimal places, including negative values that round to the nearest ten, hundred, or thousand — useful for executive summaries. This guide covers 8 practical examples: standard formatting, zero decimals, rounding to thousands, embedding currency in concatenated labels, dynamic precision from a control cell, conditional labels with IF, non-USD currencies with TEXT, and self-updating dashboard KPI strings.