* Excel Course - Level:
1) Excel Data Analysis Complete - medium
2) Excel Data Visualization - medium-advanced
3) Excel Expertise Complete - advanced - expert
4) Excel Automation Reports - module 1 (Power Query & Power Pivot) - beginner - medium in Power Query - 16 hours Power Query, 4 hours Power Pivot
Note: Courses 2), 3), 4) can be completed in any order, provided that the notions from course 1) are known
Our way of working:
- We work together, trainer and participants, on scenarios we meet in our day-to-day work
- We work in groups of 5-12 participants, to make sure we give the proper attention to each individual
- We limit the daily hours to 4, to ensure efficient information assimilation
- We go through the features step by step, from fundamentals to advanced and expert concepts
- We learn through practice and exercise, so that the notions taught are used hand-on
- We answer all participants’ questions
Excel Courses - depending on the job:
- It is the necessary training for any type of job and is the first we would recommend
- Within this course, we go through both the data processing for the purpose of reporting, and the final report build
- We learn over 50 business applied functionsÂ
- We implement the functionalities of pivot tables
- At the end, we learn how to protect our reports
- This is the follow-up to the Excel Data Analysis Complete Course
- We chose to build a training based strictly on dashboards, since not everybody works with them
- This is the Excel course in which we build dynamic graphics that interact with one anotherÂ
- We learn graphics from pivot tables, maps and other advanced graphics
- Through this training, we reach the expert level in Excel
- The Excel Expertise Complete course gives us autonomy in any job scenario
- This is a complex training, using advanced notions: working with strings, smart tables, dynamic data ranges
- This is where we learn all the new functions in Excel 365: XLOOKUP, FILTER, UNIQUE, SORT
- This training is extraordinarily useful in automating recurrent reports
- We use Power Query, an Add-In less known, but extremely usefulÂ
- We work on automation projects: reporting data about customers, products etc
- During the course, we automate 3-4 work specific cases – our target, as trainers, is that we work together with participants to automate their reportsÂ