Microsoft Excel 365 Advanced (EN)

This advanced course empowers you to harness the full potential of Excel 365 for complex data analysis and increased productivity. You'll learn to work with dynamic array functions like SORT, FILTER, and XLOOKUP to efficiently manage and manipulate data, even across multiple criteria.

Explore custom formulas using LET and LAMBDA, and build powerful data models with Power Pivot and Power Query. You’ll also dive into advanced PivotTable and PivotChart techniques, create interactive tools using form controls, and automate tasks with macros and VBA.

As a bonus, the course introduces AI tools like Microsoft Copilot and ChatGPT to streamline workflows. By the end, you'll be fully equipped to tackle advanced data tasks and elevate your Excel expertise.