Course: Data analysis with Excel
Data analysis with Excel
14/04/26 to 30/04/26
15 hours in 6 sessions
10:30 to 13:00 Tuesdays and Thursdays
240€
Bonus:
- Partial
Who is it aimed at?
This course is designed for those who already work regularly with Excel and want to transform their approach to analysis. It is especially useful for:
- Those responsible for administration, finance or management, who need to prepare reports on a recurring basis and want to gain agility, accuracy and control in each delivery.
- Data analysts interested in optimizing their time and simplifying complex processes without losing depth or rigor.
- Technicians and advanced Excel users who want to go beyond isolated tricks and adopt a more structured and scalable working method.
- Companies using Microsoft 365 that want to incorporate Copilot as a real analytics accelerator, starting from a clear and well-organized work base.
What will you learn?
Upon completion of the course, the student will be able to:
- Structuring and cleaning data in Excel using functions.
- Consolidate and enrich information with XLOOKUP, LET, LAMBDA and dynamic array functions.
- Create interactive analyses with PivotTables, slicers, and timelines.
- Automate the data extraction and transformation process with Power Query.
- Get started in data modeling with Power Pivot and take the first steps in the DAX language.
- Build a dashboard.
- Leverage Copilot in Excel to generate formulas, summaries, insights, and visualizations using natural language.
How do we deliver the online courses?
Practical methodology
Practical 100% course from the first class.
Live classes
- Online or in person, you decide.
- Duration: 2 hours per session.
- They are developed over 2 weeks.
- Dates and times defined for each course.
Overtime
2 additional weeks after completion for:
- Submission of exercises.
- Answering questions.
24/7 Virtual Campus
- Access available every day, at any time.
- Theoretical and practical material and exercises included.
- Exercises corrected and evaluated by an expert tutor.
Specialized tutor
- Personalized and thorough follow-up.
- Progress evaluation with feedback.
- Possibility of extra activities, adapted to each student.
Direct communication
- Direct line to the tutor for questions and queries.
- Space for interaction with other students.
- Knowledge exchange that enriches learning.
Bonus courses for companies
Did you know that companies have access to credit? annual non-refundable grant of Fundae to use in employee training?
Training credit
All companies have a credit for subsidized training for their employees.
Expiration
The credit is lost if it is not used before the December 31.
Conditions
The workers must be hired and contribute to the general scheme (not self-employed or civil servants) and the company must have sufficient credit.
Processing
Us We handle all the documentation to apply for the bonus.
