Excel - Intermediate 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.

Intermediate Level, 2 Days.

Detailed scope of workshop

Different levels of data protection

Work with large amounts of data and extensive tables

Basic and advanced filters

Charts’ formatting

Name manager – work with named ranges

Principles of data and results validation

Advanced functions for aggregation and data analysis

Types of errors and troubleshooting problems (#REF, # N/A, #NAME)

Pivot tables – basics

Pivot charts – basics

newsletter bądź zawsze na bieżąco