Catalog
details
Ajoutez votre titre ici
Ajoutez votre titre ici
INTERMEDIARY EXCEL
Category
INFORMATION TECHNOLOGY
Subcategory
Office automation
Code
BUR003
Training Objectives
Exploit Excel's potential to automate and make reliable calculations: complex and intertwined formulae, matrix calculations. Create dynamic reports and interactive dashboards. Build elaborate graphs. Be able to create and analyze a dynamic cross-table.
Training Program
Import and transform data with Power Query
Mastering the functions of synthesis : SUMME.SI.ENS – SUMMEPROD
Combining complex search functions: RESEARCH – RESEARCH -RECHERCHEH – INDEX – EQUIV – DECALER – INDIRECT .
Build elaborate graphs.
Calculation of dates and times.
Simple conditional formatting.
Data validation.
Data protection.
Initiation of the dynamic cross-table.
The different elements of a dynamic cross-table
