Create, organize and format data tables.
Use basic formulas to perform simple calculations.
Find specific information in a table.
Training Program
1 – Construction technique of a good database.
2 – Mastering relative, absolute and mixed addresses.
3 – Name cells (a cell or cell range) and use them in formulas (facilitates the design and understanding of a formula)
4 – Mastering logical functions: SI, AND, OR, SIERREUR
5 – Mastering the functions of synthesis : SUMME.SI – SUMME.SI.ENS
6 – Mastering the simple search function : RESEARCHV
Target Audience
All public
Duration (Days)
2
Minimum Number of Seats
4
Maximum Number of Seats
15
Trainer
Rivo RAHALIJAONA (EXPERT Formation), Coach, Consultant et formateur spécialiste en Excel