Excel - Advanced Level
Microsoft Excel
nowość
About 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
-
2 dni MICROSOFT EXCELEXCEL DASHBOARD WORKSHOPS
-
2 dni MICROSOFT EXCELEXCEL - INTERMEDIATE LEVEL
-
2 dni MICROSOFT EXCELEXCEL - BASIC LEVEL
-
2 dni VBACUSTOM INDIVIDUAL EXCEL WORKSHOPS
-
2 dni MICROSOFT EXCELMICROSOFT EXCEL – ANALIZA FINANSOWA FIRMY
-
2 dni MICROSOFT EXCELMICROSOFT EXCEL – FUNKCJE FINANSOWE