Formation Excel 2019 Expert (certification TOSA incluse)

Module 1: Excel Fundamentals

Understanding a workbook's structure

Autofill feature

Introduction to functions

Cell formatting styles

Managing files with different formats

Module 2: Data Management

Advanced sorting techniques

Advanced filtering options

Conditional formatting

Pivot tables for dynamic analysis

Module 3: Excel Functions

Data type conversion

Text and date manipulation

Lookup functions

Logical functions

Error handling

Tracking dependencies

Module 4: Data Visualization

Selecting appropriate visualizations

Understanding visualization types

Customizing visualizations

Module 5: Pivot Tables

Building pivot tables

Modifying metric calculations

Adding segments

Creating pivot charts

Module 6: Data Analysis

Statistical reminders

Using numerical functions

Module 7: External Data

Data reprocessing

Creating relationships

Integration into spreadsheets

Module 8: Macros and VBA

Recording macros

Introduction to VBA

Table manipulation

Dynamic form creation

Task automation

Custom function creation