SPECIALIZED ONLINE TRAINING OFFERS FOR ANALYSTS
Excel training workshop – Power Query and Power Pivot for controller and analyst (Level 1)
This training covers the use of dynamic arrays with the functions of the Microsoft 365 version of Excel. We show you how to benefit from the power of dynamic arrays to create more powerful and dynamic reports. Analysis of complex data is now accessible to everyone. You will be able to create reports that seem very complex to configure, but that you can design using simple functions. The introduction of dynamic arrays is the biggest change to Excel in years.
- Provide the tools to handle large databases
- Making effective and professional management reporting with data integrity
- Monitor the quality and integrity of data
- Use several advanced matrix functions to make reports
- Use the macro commands in management reports
This training was specifically developed for CPA working in companies within the finance and accounting department. Our Excel training was developed with the tasks and responsibilities of these professionals in mind. PivotTables (PT) are interactive tables that allow the user to group and synthesize large amounts of data in a concise table format. Using PT, you will be able to drill data interactively. After this training, you will be able to master all the options available to you. You will be able to customize it and ensure the integrity of your data.
The addition of the Power Suites will revolutionize the way you work with Excel. To date, “Business Intelligent” (BI) has been almost exclusively reserved for IT developers. This course explores the Power Query and Power Pivot add-ins of Excel.