Charts
Excel Pie Chart: make one and label it properly
Make an Excel pie chart in four steps, add percentage labels, and know when a bar chart is the better choice.
Author: Srini Vanamala
Sorting, Filtering & Lists
Data Validation in Excel: only allow the right values
Data validation in Excel: limit a cell to whole numbers, a date range, a list, or text length, with your own error message.
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.
Fixes & Errors
Excel Formula Not Calculating? 5 causes and fixes
Excel formula not calculating or showing the formula as text? Five causes in order of likelihood, each with a 10-second fix.
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.
Shortcuts
Excel Keyboard Shortcuts: the 25 worth learning
The 25 Excel keyboard shortcuts that save real time, grouped by what they do. Learn three a week.
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.
Formatting
Conditional Formatting in Excel: colour cells automatically
Conditional formatting in Excel: highlight values over a number, duplicates, top 10, and colour a whole row with a formula.
Formatting
Merge Cells in Excel: the right way (and the trap)
Merge cells in Excel for a heading, unmerge them, and the better alternative — Center Across Selection — that avoids the sorting trap.
152 tutorials · Page 16 of 17
