Excel – Level 3
Organize your files and automate your tasks with Excel
In this training you will discover how to properly organize your files, how to automate your administrative tasks using macro commands, deepen some powerful Excel functions and discover Power Query
Objectives :
- Upgrade of several Excel concepts
- The Sumproduct matrix function
- Efficient organization of an Excel workbook
- The Power Query add-in
- The use of macro-commands
- The Microsoft Excel development environment
Duration : 4 hours
Requirements :
Advanced user with good knowledge of Microsoft Excel