Description
In this session, you will learn basic skills to make calculations in Excel using simple formulas and functions.
Audience
A very good knowledge of the basic skills in Excel is required (file management, data editing, spreadsheet structure, formatting).
Methods
Classroom or virtual training with attention to individual guidance: on the basis of exercises, the student can put the possibilities into practice.
Contents
- Introduction
- Distinguish between formula and function
- Enter, change, delete formulas and functions (general)
- Formulas
- Components of formulas
- Arguments (cell addresses, constants,...)
- Operation signs and calculation priority
- Calculating with dates
- Calculating with times
- Functions
- The different input methods
- Nested features
- Copy formulas and functions
- The possible sticking methods
- Relative, absolute, and mixed cell references
Certification
Participation certificate: participants receive a certificate that they have completed this training at the end of the training.