How to use this course
- Do one lesson at a time, in order. Each one takes about 20 minutes.
- Read it here, or press play to listen. Every lesson has audio.
- Open the practice workbook in Excel and do the Try it part. Each lesson has its own sheet at the bottom of the workbook.
- Answer the quiz. Tap Show the answer to check yourself.
No Excel? Use Excel for free at office.com (sign in, then click Excel), or use Google Sheets at sheets.google.com. Both open the practice workbook. This course shows Windows Excel, with short notes for Mac and the web.
The lessons
- Lesson 1: Meet ExcelThe screen, cells, sheets, and saving your work
- Lesson 2: Typing and EditingEnter data, fix mistakes, copy, and let Excel fill in for you
- Lesson 3: Making It Look NiceBold, colors, borders, money and date formats, and freezing the top row
- Lesson 4: Your First FormulasLet Excel do the math: plus, minus, SUM, AVERAGE and more
- Lesson 5: Smart FunctionsIF, COUNTIF, SUMIF, TODAY, joining text, cleaning text, ROUND, and XLOOKUP
- Lesson 6: Organizing Your ListsSort, filter, remove duplicates, find and replace, tables, and colors that warn you
- Lesson 7: ChartsTurn numbers into a picture: column, pie, and line charts
- Lesson 8: Printing and SharingPrint neatly on one page, save as PDF, share a link, and protect your sheet
- Lesson 9: Pivot Tables, Made GentleSummarize a long list in a few clicks, with no formulas
- Lesson 10: All the TricksShortcuts, Flash Fill, quick tricks, and how to fix common errors
Excel Made Easy. Free course. Not made by or connected to Microsoft. Button names can be a little different in older versions of Excel.