Free · No account · English and 한국어
Learn Excel, Word and PowerPoint by doing.
Step-by-step written guides that show the exact formula or menu path for every step. Many Excel guides end with a live sheet: type the real formula, press Enter and see whether it works.
168 tutorials · 48 Excel practice files · 63 free templatesGet the files →
Practice right here. No sign-up.
Try it0 of 2 done
- In B6, add up the costs in B2:B5.
- In B7, find the cost of the most expensive item.
Click a dashed cell, type a formula in the bar and press Enter.
| A | B | |
|---|---|---|
| 1 | Item | Cost |
| 2 | Notebook | 4.5 |
| 3 | Pens | 3.2 |
| 4 | Calculator | 12 |
| 5 | Backpack | 25 |
| 6 | Total | |
| 7 | Most expensive |
Browse by product
Coming next: Google Sheets and Google Docs.
Free tools and downloads
Learning paths
All learning paths →Each course runs from beginner to expert. Follow a path in order, or jump to the tutorial you need.
- Microsoft 365PowerPoint4 paths · 35 tutorials · about 8 hours
- PowerPoint BasicsBeginner
- Intermediate PowerPointIntermediate
- Advanced PowerPointAdvanced
- Expert PowerPointExpert
Featured tutorials
Excel
How to Use VLOOKUP in Excel
Look up a value in a table and return a matching value from the same row with VLOOKUP, and fix the #N/A and #REF! errors it can return.
Excel
How to Use XLOOKUP in Excel
Find a value in one column and return the matching value from another with XLOOKUP, including a fallback for missing values, nearest matches and wildcards.
Excel
How to Use the IF Function in Excel
Make a formula return one result when a condition is true and another when it's false, with text, numbers or calculations.
Excel
How to Create a PivotTable in Excel
Summarize a list by category, month or region in a few clicks with a PivotTable, then change the calculation, format the numbers and refresh it.
Excel
How to Use Conditional Formatting in Excel
Color cells automatically by rule: flag values over a limit, catch duplicates, highlight top values, add data bars and write your own formula rules.
Excel
How to Use SUMIF and SUMIFS in Excel
Add up only the numbers that meet a condition with SUMIF, or several conditions at once with SUMIFS.
How it works
- Find your answerSearch for a task or browse by product. Every guide starts with what you'll be able to do.
- Follow numbered stepsShort steps with the exact formula or menu path, plus tips where versions differ.
- Practice on the pageFinish with a practice task. Many Excel guides let you type the formula right in the page and check it.