Office & productivity

Microsoft Office 2024: Practical Skills

Create polished documents, useful spreadsheets and confident presentations.

Enrollment openView fees & enrollment ↓

Learn Word, Excel and PowerPoint step by step for study, office work and everyday tasks. Explore the 25 sections below to see what you will learn.

Course curriculum

Choose a section to see its topics.

Word 2024 — Documents

1. Start using Word

Find tools on the ribbon; create, open and save files; switch views and use Immersive Reader.

2. Write and format text

Type and edit; change fonts; apply styles; set tabs and indents; cut, copy and paste.

3. Organise paragraphs

Find and replace words; show formatting marks; copy formatting; make numbered and bulleted lists.

4. Add pictures and tables

Insert and position pictures; create tables and adjust their layout.

5. Set up your pages

Choose paper size, orientation and margins; add breaks, columns, watermarks, headers, footers, page numbers and a contents page.

6. Check your document

Check spelling, grammar and word count; set up AutoCorrect; check accessibility.

7. Share and print

Share documents, leave comments and choose print settings.

Excel 2024 — Spreadsheets

1. Start using Excel

Find ribbon tools; create, open and save workbooks; enter information.

2. Work with cells

Format text; use AutoFill; copy, edit and delete data; add borders and colours; merge cells; find and replace; explore data types.

3. Manage worksheets

Add, rename, delete, move and group sheets.

4. Arrange rows and columns

Resize, hide, delete, insert and move rows or columns; freeze headings while scrolling.

5. Use formulas

Understand cell references; write and copy formulas; total numbers with AutoSum; find values with XLOOKUP; split text into columns.

6. Understand your data

Sort and filter; build PivotTables; highlight values with conditional formatting; create charts and charts that update with tables.

7. Print and share

Print selected sheets or workbooks; share files; protect cells from unwanted changes.

PowerPoint — Presentations

1. Create your first presentation

Choose a theme or template; create and save slides.

2. Build your slides

Reorder slides; change layouts, backgrounds and text; use Slide Master and Designer.

3. Add pictures and shapes

Format, align, layer and group objects; copy formatting; remove backgrounds; crop pictures into shapes.

4. Explain with visuals

Build charts and SmartArt diagrams.

5. Add movement and media

Insert video, audio, animations, transitions, Morph, Zoom and Cameo.

6. Make slides accessible

Use accessibility tools and check that everyone can follow your slides.

7. Prepare with others

Add speaker notes; rehearse timings with Presenter Coach; share, collaborate and review earlier versions.

8. Present confidently

Use Presenter View or set slides to play automatically.

9. Reuse and export

Save themes and templates; record with a teleprompter; export PDF, JPEG or GIF.

10. Try Copilot

Create presentations and slides; summarise content with AI.

11. Practise creative effects

Animate turning gears and place an image inside text.

Who this course is for

Beginners and students with basic computer skills who want to create documents, work with numbers and prepare presentations.

Software you will need

Word and Excel topics follow Office 2024. PowerPoint includes Microsoft 365 features. Some tools, including Copilot, depend on your app version, account and licence. Access to the relevant apps is needed for practice; a Microsoft software licence is not included.

Course outline

  1. Word 2024: 7 sections for documents and page layout
  2. Excel 2024: 7 sections for spreadsheets and data
  3. PowerPoint: 11 sections for slides and presentations

Practice that counts

Course activities may include guided lessons, practical assignments, live sessions and assessments. Your portal shows the exact requirements for your enrolled course. Certificates follow successful completion of the required activities, or administrator confirmation of classes already completed with the academy.

Age and course suitability

We welcome students from age 8. Course placement depends on readiness. Students under 18 need a parent-managed account; third-party tools may have additional age requirements. Marketing and advertising topics use supervised practice.

Student reviews

No published reviews yet. Student reviews will appear here after moderation.

Read or write a course review →