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