Apprenez et Maîtrisez Excel en 2025 avec 70 Cas Pratiques

Course Overview

• Course Title: Apprenez et Maîtrisez Excel en 2025 avec 70 Cas Pratiques
• Instructor: ABINAN Stephane
• Target Audience:
  • Beginners
  • Users familiar with Excel
  • Those seeking to master advanced Excel functionalities
• Prerequisites: None

Curriculum Highlights

• Key Topics Covered:
  • Excel environment navigation
  • Data entry, formatting, and layout
  • Formula and function construction principles
  • Commonly used traditional functions
  • Data visualization tools (conditional formatting, charts)
  • Structured tables for data organization
  • Pivot tables for quick and comprehensive data analysis
  • Modern Excel functions
  • Power query and Power pivot tools
  • VBA for task automation
• Key Skills Learned:
  • Mastering Excel basics
  • Utilizing key functions: IF, VLOOKUP, XLOOKUP, INDEX/MATCH, etc.
  • Creating impactful data visualizations
  • Organizing and analyzing data
  • Using Power query and Power pivot for data transformation and utilization
  • Employing modern Excel functions: SEQUENCE, UNIQUE, FILTER, SORT, etc.
  • Automating tasks with VBA and macros

Course Format

• Duration: 14 hours on-demand video
• Format: Self-paced online course
• Resources:
  • 3 downloadable resources
  • Access on mobile and TV
  • Closed captions
  • Certificate of completion