Back to trainings
Bureautique
Advanced Excel: Mastering Advanced Functions, PivotTables, and Power Query for Efficiency
3 jour(s) • 21h
Description
This training allows you to take your Excel skills to the next level. Over three days, you will learn to build advanced formulas, leverage pivot tables, automate data preparation with Power Query, and create impactful visualizations. You will also learn how to secure your files and perform decision-support simulations. The training is compatible with Excel 2021 and Microsoft 365.
Learning Objectives
- Build advanced formulas to ensure reliable data processing
- Analyze data using pivot tables
- Create visual reports tailored to professional needs
- Prepare and transform data with Power Query
- Implement appropriate controls, validations, and protections for the professional context
- Perform simple decision-support simulations
Target Audience
Professionals in finance, legal, HR, or sales departments, management controllers, project managers, and executive assistants seeking to leverage advanced Excel functionalities in a professional context.
Prerequisites
Good knowledge of basic Excel functionalities: data entry, simple formulas, formatting, and creating basic charts.
Equivalent knowledge to that provided by an introductory Excel training.
Program Outline
Informations
Duration
3 jour(s)
21h
Tarif
Sur demande
