Excel Avancé : formules, TCD, macros et VBA
Start date
—
Duration
30h
Mode
—
Level
Advanced
Overview
Ce thème approfondit la maîtrise d'Excel au-delà des fondamentaux : formules complexes, tableaux croisés dynamiques, automatisation par macros et introduction à la programmation VBA pour créer des outils sur mesure.
Target audience
Comptables, contrôleurs de gestion, analystes, managers, assistants de direction, tout professionnel
Learning objectives
- Maîtriser les formules avancées (RECHERCHEX, INDEX/EQUIV, matricielles)
- Construire et exploiter des tableaux croisés dynamiques
- Automatiser les tâches répétitives avec les macros
- Créer des outils personnalisés en VBA
- Mettre en forme des rapports professionnels
Training program30h
Fundamentals and framing
- Introduction and training objectives
- Assessment of current practices
- Theoretical and methodological framework
Deep dive and hands-on practice
- Case studies and practical exercises
- Group work and presentation
- Operational tools and templates
Application and action plan
- Professional role-play scenarios
- Individual action plan development
- Assessment and training wrap-up
Your trainer
GRH-Services Expert
Experienced trainer with over 10 years of corporate practice. Certified in their field of expertise, they support Guinean professionals in developing their skills.
What our participants say
“Very hands-on training. I was able to apply the tools as soon as I returned to work. The trainer is a true expert in the field.”
Participant
Mining sector
“Excellent teaching quality. The case studies are contextualized for Guinea, making the training immediately useful.”
Participant
Industrial sector
Frequently asked questions
This training as in-house
Want to organize this training as a private session for your team? We adapt the content and schedule to your needs.
Similar programs
