Office Administration & Digital Productivity · Beginner level

Beginner level · Module 5: Office Productivity Tools · Lesson 1 of 3

Office Suites for Administration

Use word processing, spreadsheets and mail merge for everyday office tasks.

In this lesson you will

  • Use mail merge for letters and labels
  • Keep simple registers in spreadsheets

Key concepts

Microsoft 365Google Workspacemail mergeregisters

The lesson

Microsoft 365 and Google Workspace both provide documents, spreadsheets, presentations, email, calendars and file storage.

Mail merge combines a template with a list to produce personalised letters, certificates or labels in minutes.

Spreadsheets keep simple registers — visitors, assets, supplies — with filters to find entries.

Step by step

  1. Prepare a list of recipients.
  2. Create a mail-merge letter.
  3. Produce merged letters.
  4. Build a visitor register.

Practice activity

Produce merged invitation letters and a visitor register.

Expected result: Correctly merged letters and a working register.

Check your understanding

  1. What does mail merge combine?

    Show answer

    A template with a list of data.

  2. Give one register an office might keep in a spreadsheet.

    Show answer

    Visitors, assets or supplies.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.