Excel as a BI tool for CFO and business controllers

The CFO’s job just may be the toughest and most demanding in the entire organization. You’re the key player in organisational strategy and development, performance management and accountability and compliance management. This course will unleash the Power of Excel and you will learn effective and powerful features like Pivot Tables, learn how to use Excel in running your business. This course uses the do and learn style of teaching, enabling you to learn the techniques and features in an easy yet definitive way, which will remain forever in the mind.

• Gather and structure large amounts of data
• Understand how to handle different types of data sources, flat files, databases and OLAP-cubes
• Use the text import wizard, MSQuery/ODBC- data sources,  connect to Analysis Service (OLAP-cube)
• Understand the differences between a list, table and pivot table
• Use category and position based consolidation
• Use data validation to check your calculation
• Build information dashboards with conditional formatting, sparklines and indicators
• Analyze budgets and actuals  by using pivot tables and drill-down on transactional data
• Create Pivot Charts to visualize complex business data
• Analyze business data from OLAP-cubes by using PowerPivot