Spreadsheets: basics and simple calculations: Training centre
Create a reliable spreadsheet with formulas and filters. Total price for the group, standard programme. Digital materials and standard assessment included.
9 hr
2 sessions
On site
People included : 8
BUR-02-CENTRE
Illustration of training in office software.
01
Who this offer is for
For training centres organising the programme for their group with the stated equipment and prerequisites.
The intended outcome
You learn to build a consistent table with simple calculations and filters for everyday data. The standard pathway spans two sessions with progressive exercises. It targets reliable routine operations without promising a complete business tool or advanced spreadsheet mastery.
02
What is included
Scope and limits
Create a reliable spreadsheet with formulas and filters. Total price for the group, standard programme. Digital materials and standard assessment included.
What we work on in practice
Organise table data
A practice dataset distinguishes columns, rows and expected information types. You create a table with consistent headings and entry. Common errors become visible to understand why misplaced data can distort interpretation or simple calculation.
Build and check calculations
Programme formulas use understandable cases and are compared with expected results. You observe data changes and copied formulas. Exercises concern simple calculations without macro development or creation of a production management system.
Filter and find information
Filters find useful rows without unintentionally changing table data. You check chosen criteria and result consistency. Digital materials and standard assessment support repeating exercises; external certification or validation of real data is not included.
03
A practical example
Example: a fictional expense table lets you calculate totals and display only rows from one category. You check formulas after changing values. Training explains these actions; it does not deliver an approved company budget or management software.
04
How the service works
Choose a suitable objective
The subject follows the planned programme, your starting level and intended uses. Group prerequisites and equipment must allow participants to follow the exercises.
Understand and practise
Guidance combines explanations with practice on the selected subject. Progress depends on the starting level, available time and participation.
Review the key points
Review what was practised and what needs further work. Materials and assessments are included when the offer explicitly lists them. Complete mastery is not guaranteed by attending training.
05
What your purchase pays for
Guidance time on the selected subject, with explanations and guided practice.
Attention to difficulties during exercises, in the agreed individual or group format.
Digital materials and a standard assessment only where stated. Equipment, licences and subscriptions follow the offer’s terms.
06
What to prepare
Arrange the programme's spreadsheet tool and a usable workstation; know basic actions and use non-sensitive practice data.
The centre validates group level, programme, exercises, expertise, training obligations and dates.
Supply a room, equipment and licences for up to eight people; seven teaching hours and nine hours on site per session.
Prerequisites
Basic computer use. Programme, exercises, expertise, training obligations and dates confirmed.
Exclusions
Licences, room, equipment, guaranteed funding, external certification and production development.
07
Understanding the price
Indicative price€1,100.00 Excl. tax (HT)
On-site attendance per session540 min
Number of sessions2
Participants included8
DeliveryOn site
08
Questions about this offer
What is included for the group?
The standard programme includes digital materials and standard assessment for the accepted group. You supply room, equipment and licences. Programme, exercises and dates are approved before agreement.
Does this training include certification or production work delivery?
External certification and production development are excluded; funding is not guaranteed. Exercises serve learning. A project to deploy needs another approved scope.
These explanations describe the proposed work. Tasks, quantities, deliverables, dates and options are confirmed in the quote or order. The published limits still apply.