Brief Description
The course uses hands-on software examples to provide students with the advanced skills needed to become proficient in using Microsoft Excel. The goal is to make learners more efficient, increase their productivity and prepare them for more advanced challenges in data analysis and information management. By the end of the course, students will be able to use Excel in an advanced way to solve complex business problems.
The course program is divided into 4 modules
- Using formulas and functions: Analysis of some advanced functions
- From creating worksheet structures, to using linked workbooks and charts
- Conditional formatting: formatted tables
- Tables: from Pivot tables to the introduction to Power Query
Who addresses
The course is designed for those who already have a basic understanding of Microsoft Excel and wish to deepen their skills. During the course, you will learn to use pivot tables, create complex formulas, automate repetitive tasks with macros, and work with external data. This course provides the skills needed to tackle more advanced challenges in data analysis and management, making the Excel user more effective and efficient.
Students
The professionals
Anyone who wants to improve their productivity by mastering more advanced features of Excel