Formulas & Functions
How to Count Cells with Text in Excel (any text, or specific text)
Count cells that contain any text in Excel with COUNTIF and a wildcard, count cells with specific text, and count non-empty cells including numbers.
Category: Formulas & Functions
Formulas & Functions
How to Use VLOOKUP in Excel: a beginner’s walkthrough
How to use VLOOKUP in Excel from a blank sheet: build the lookup table, write the formula piece by piece, copy it down, and fix #N/A.
Formulas & Functions
How to Calculate Percentage in Excel: 4 everyday cases
How to calculate percentage in Excel: marks out of total, share of a whole, increase from last year, and a discount — each in two steps.
Formulas & Functions
Excel LEN Function: count characters in a cell
The Excel LEN function counts characters — use it to find cells that are too long, spot hidden spaces, and check codes are the right length.
Formulas & Functions
Excel Subtract Formula: minus one cell from another
There is no SUBTRACT function in Excel — use the minus sign. Subtract two cells, a column from another, a fixed number, and dates.
Formulas & Functions
ROUND in Excel: to 2 decimals, to the nearest 10, up or down
ROUND in Excel: round to decimals, to whole numbers, to the nearest 10 or 100, always up or always down, and why formatting is not rounding.
Formulas & Functions
Excel LEFT Function: the first few characters of a cell
The Excel LEFT function: take the first N characters, everything before a dash or space, and turn the result back into a number.
Formulas & Functions
Excel IF with AND / OR: test two conditions at once
Combine IF with AND or OR in Excel: pass only if both conditions hold, or if either does, with a bonus example that uses both.
Formulas & Functions
Excel IF Cell Contains Text: flag rows with a word in them
Excel formula to check if a cell contains specific text, using ISNUMBER and SEARCH — case-insensitive, partial match, with a Yes/No result.
28 tutorials · Page 1 of 4
