Start a conversation ↗

Description

Google Sheets — Online Spreadsheets: Enter, Calculate and Share Your First Tables

Build accurate, readable tables in a shared spreadsheet without going back to the email attachment

  • 2 days — 14 h
  • In-person or virtual
  • Foundation
  • Up to 6 participants

Tables circulate as email attachments and everyone works on a different version. Totals are typed in by hand and become wrong as soon as a line changes. Formatting is lost from one send to the next and no one knows which copy is authoritative. The spreadsheet is still used as a sheet of squared paper.

These 14 hours lay the foundations of working in an online spreadsheet. Participants build calculated sheets that are properly formatted and shared with controlled access rights. They write simple formulas, sort and filter their data, then produce a first readable chart.

Learning objectives

  • Create a spreadsheet file and organise its tabs
  • Enter data and apply the formats suited to its nature
  • Write simple calculation formulas and copy a formula across
  • Sort and filter a table to isolate a piece of information
  • Build a readable chart from a table
  • Share a file while choosing the access rights granted

What makes this programme different

The running case study is a budget tracker built and then enriched throughout the two days
Every formula is written by the participant before being reviewed collectively
Participants work together on the same file to test sharing rights in practice

Programme

1Getting started with the shared spreadsheet

Organising your file from the outset

  • Creating a file and organising the tabs
  • Entering data and choosing cell formats
  • Column widths, row heights and freezing headers
  • Automatic saving and version history

2Calculating without errors

Basic formulas and their pitfalls

  • Operations and the SUM and AVERAGE functions
  • Copying a formula across and relative references
  • Absolute references for parameter cells
  • Spotting and correcting displayed errors

3Formatting and working with the data

Making a table readable and searchable

  • Formatting numbers and dates
  • Sorting and filtering a data table
  • Conditional formatting based on chosen thresholds
  • Creating a chart suited to the data

4Sharing and working as a team

Collaborating without multiplying copies

  • Sharing by link and levels of access rights
  • Comments and suggestions within a file
  • Protecting sheets and sensitive ranges
  • Printing and exporting the file

Who is it for

Beginners on spreadsheets, administrative support staff, officers and team members required to produce or update shared tables.

Prerequisites

Be able to use an internet browser and hold an account giving access to the online spreadsheet.

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.