Formulas & Functions
Excel Percentage Formula: percent of total, change, and discount
The Excel percentage formula for the three jobs people need: percent of a total, percentage change, and taking a discount off a price.
Category: Formulas & Functions
Formulas & Functions
Excel Formulas Cheat Sheet: the 20 you actually use
An Excel formulas cheat sheet with the 20 formulas people use every week — what each does, the exact syntax, and a link to the full lesson.
Formulas & Functions
SUMIF in Excel: add only the rows that match
SUMIF in Excel: add sales for one person, amounts over a number, or dates in a month — one condition, one formula.
Formulas & Functions
Excel Multiply Formula: multiply two cells, a column, or by a fixed number
The Excel multiply formula with the * sign: two cells, a whole column, a fixed price or tax rate, and PRODUCT for many cells.
Formulas & Functions
CONCATENATE in Excel: join text from two cells
CONCATENATE in Excel and its shorter replacements: join first and last name, add a space, and join a whole column with TEXTJOIN.
Formulas & Functions
XLOOKUP vs VLOOKUP: which one should you use?
XLOOKUP vs VLOOKUP side by side: same task, both formulas, and the five differences that decide it.
Formulas & Functions
Excel SUM Formula: every way to add numbers
The Excel SUM formula: add a range, add separate cells, add across sheets, and AutoSum with one shortcut.
Formulas & Functions
VLOOKUP in Excel: explained with one example
VLOOKUP in Excel: the four parts of the formula, one example, and the two mistakes that cause #N/A.
Formulas & Functions
INDEX MATCH in Excel: the lookup that works in any version
INDEX MATCH in Excel, explained in two small steps. Looks left, never breaks when columns move, works in every Excel version.
29 tutorials · Page 3 of 4
