Skip to content
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

Modules

  1. 01Excel basics4 lessons
  2. 02Excel tools3 lessons
  3. 03Printing Excel3 lessons
  4. 04Word, done properly3 lessons
  5. 05Practice1 lessons

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
  1. Module 01

    Excel basics

    Find your way around, move like a pro, and number 1 to 200 without typing 200 numbers.

    1. 01Your practice fileOne messy store stock list with six problems. By the end of the course you'll fix all of them.3 min
    2. 02The Excel screenSix parts you'll use every single day.4 min
    3. 03Numbering 1 to 200Four ways to number a list, and the one that never skips a number.6 min
    4. 04Clean the data firstTidy text before you make it pretty.6 min
  2. Module 02

    Excel tools

    Formatting, formulas and charts that look professional.

    1. 05Format like a professionalSeven steps from plain grid to finished table.6 min
    2. 06Formulas that do the workFormulas point at cells, not numbers.7 min
    3. 07Charts that make one pointThe question decides the chart, not the colours.6 min
  3. Module 03

    Printing Excel

    Every column on the page, the header on every sheet, page numbers, no blank pages.

    1. 08Why printouts go wrongSix common problems, six settings.4 min
    2. 09Print setup, step by stepEight settings, in this order, every time.6 min
    3. 10Before you press printThe nine-point checklist.2 min
  4. Module 04

    Word, done properly

    Styles, automatic numbering, tables, charts and printing: documents that format themselves.

    1. 11The golden rule: use stylesNever format by hand. Change a style once and the whole document updates.5 min
    2. 12Numbering and tables in WordLet Word count, and build a numbered table that survives page breaks.7 min
    3. 13Structure, charts and printingEverything that numbers or repeats itself, three ways to add a chart, and a clean printout.8 min
  5. Module 05

    Practice

    Format the store stock list from start to finish.

    1. 14Class exercise: the store stock listEight tasks that use everything in the course.45 min