Excel - Advanced Level

Microsoft Excel

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


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

newsletter bądź zawsze na bieżąco