Start a conversation ↗

Description

Excel — Essential Office Tools: Writing, Calculating and Presenting Day to Day

Three days to cover the three everyday desktop tools and stop working by approximation

  • 3 days — 21 h
  • In-person or virtual
  • Foundation
  • Up to 6 participants

Documents are laid out with rows of spaces and tab stops. The tracking table is added up on a calculator before the total is typed back in. Presentations reuse the layout of an old file whose origin nobody remembers. Every task remains possible, but takes three times longer than it should.

These 21 hours cover the three tools found on every workstation. Participants structure a long document using styles, build a calculation table that updates itself and produce a presentation that can actually be read. Moving from one tool to the next is addressed explicitly, through the reuse of tables and charts.

Learning objectives

  • Structure a long document using styles and an automatic table of contents
  • Build a calculation table based on formulas and cell references
  • Represent a set of figures with an appropriate chart
  • Produce a readable presentation from a written outline
  • Reuse a table or chart across tools without losing the automatic update

What makes this programme different

The three tools worked on through a single business case used as a common thread
A long document fully rebuilt with styles rather than patched up by hand
Links between spreadsheet and presentation set up and then tested

Programme

1Structured documents

Putting an end to manual formatting

  • Heading styles and body text styles
  • Automatic table of contents and numbering
  • Page breaks, headers and footers
  • Inserting tables and images within the text

2Distributed documents and mail merge

Producing in volume

  • Reusable document templates
  • Merging a letter with a list of recipients
  • Tracking changes and comments
  • Exporting to PDF and protecting the document

3Tables and calculations

Letting the machine do the maths

  • Data entry and cell formats
  • Formulas and basic functions
  • Relative and absolute references
  • Sorting, filters and conditional formatting

4Charts and reporting figures

Showing a number

  • Choosing the chart according to the message
  • Building and formatting a chart
  • PivotTable to summarise a list
  • Page setup and printing a table

5Presentations and moving between tools

Standing up to speak

  • Outlining a presentation before creating any slide
  • Slide master and visual consistency
  • Reusing a table or chart from the spreadsheet
  • Presenter view and export for distribution

Who is it for

Employees in any department who use office tools without ever having been trained on them, and people returning to professional activity.

Prerequisites

Be able to use a computer and navigate through folders.

Dates & locations

36 scheduled dates between November 2026 and December 2027. Seats are confirmed in the order enquiries are received.

November 2026

December 2026

January 2027

February 2027

March 2027

April 2027

May 2027

June 2027

September 2027

October 2027

November 2027

December 2027

None of these dates suit you? We open additional sessions on request, and any programme can be run privately for your team.

Practical details

Before the programme
Online positioning questionnaire. Your development objectives are shared with the trainer, who tailors the practical case studies to your context.
Teaching methods
Theoretical input, workshops and practical case studies. Digital course materials and method sheets provided.
Assessment
Multiple-choice tests and role-play exercises. Assessment of learning at the start and end of the programme, with immediate and 60-day follow-up evaluations.
After the programme
One year of access to the e-learning platform. Self-assessment of the skills acquired and a 30-day follow-up session with your trainer.
How to register
Registration online or on the basis of a quotation.
Lead time
11 working days after confirmation of registration.
Accessibility
Accessible to people of determination. Contact our accessibility coordinator to design a suitable solution: contact@mpf-academy.ae
Start dates
Rolling intake: in addition to the scheduled sessions, this programme can start on request.