Catalog
details
Ajoutez votre titre ici
Ajoutez votre titre ici
EXCEL ADVANCE
Category
INFORMATION TECHNOLOGY
Subcategory
Office automation
Code
BUR004
Training Objectives
Use Excel fluidly and efficiently.. Analyze complex data using advanced functions. Be able to create a dashboard from a TCD
Training Program
1 – Import and Transform Data with Power Query
2 – Complex conditional formatting.
3- Advanced filters from Excel (data extractions with calculated criteria)
4 – Dynamic cross tables and graphs
Add custom calculations: fields and calculated elements
Optimize their formatting
Display values in percentage
Grouping data: texts, dates, numbers
Using segments and chronologies to filter a dynamic cross-table
5 – Simulation tools.
Target value
Scenario Manager
Data tables with 1 or 2 variables
