Excel - Advanced Level
Microsoft ExcelAbout training
Workshop on using Excel at work in various areas: finance, processes, logistics, sales with taking into account the specificity of the functional area or/and industry.
Advanced Level, 2 DAYS.
Detailed scope of workshop
Different levels of data protection
Name manager – work with named ranges and advanced references
Advanced functions for analysis and reports
Basic financial formulas and functions
Work with large amounts of data and extensive tables
Basic and advanced filters
Advanced chart formatting
Macros
Table formulas
Circular references
Construction of value search formulas
Dynamic ranges
Excel - use of alternative databases
Building and using drop-down lists and dynamic lists
Dashboards for managers – basics
powiązane szkolenia
gwarantujemy najwyższą jakość
