In this session, you will learn basic skills to make calculations in Excel using simple formulas and functions.

‍

A very good knowledge of the basic skills in Excel is required (file management, data editing, spreadsheet structure, formatting).

Classroom or virtual training with attention to individual guidance: on the basis of exercises, the student can put the possibilities into practice.

‍

• 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