All courses
03 · Beginner masterclass · Microsoft Office
Excel & Word, the professional way
Number 1 to 200 in seconds, clean and format tables, write formulas, make clear charts, build Word documents that format themselves, and print right the first time.
Beginner · 5 modules · 14 lessons · about 1 h 55 min
Start the course
00/14
Modules
What you’ll be able to do
- 1Move around Excel with shortcuts and never type a sequence of numbers by hand
- 2Clean messy data and turn a plain grid into a finished table
- 3Write formulas that update themselves and charts that make one clear point
- 4Print any sheet with repeating headers, page numbers and no blank pages
- 5Use Word styles, automatic numbering, tables and a table of contents
Module 01
Excel basics
Find your way around, move like a pro, and number 1 to 200 without typing 200 numbers.
- 01Your practice fileOne messy store stock list with six problems. By the end of the course you'll fix all of them.3 min
- 02The Excel screenSix parts you'll use every single day.4 min
- 03Numbering 1 to 200Four ways to number a list, and the one that never skips a number.6 min
- 04Clean the data firstTidy text before you make it pretty.6 min
Module 02
Excel tools
Formatting, formulas and charts that look professional.
Module 03
Printing Excel
Every column on the page, the header on every sheet, page numbers, no blank pages.
Module 04
Word, done properly
Styles, automatic numbering, tables, charts and printing: documents that format themselves.
- 11The golden rule: use stylesNever format by hand. Change a style once and the whole document updates.5 min
- 12Numbering and tables in WordLet Word count, and build a numbered table that survives page breaks.7 min
- 13Structure, charts and printingEverything that numbers or repeats itself, three ways to add a chart, and a clean printout.8 min
Module 05
Practice
Format the store stock list from start to finish.