• This course is suitable for anyone who is required to analyse data, present reports or construct dashboards in an organisation. Participants should have an elementary understanding of Excel in order to benefit from this course
• The course is also ideal for anyone looking to improve their skills in Excel. It will be of particular benefit to corporate and project financiers, finance managers, accountants and bankers.

Financial modeling is one of the most highly valued, but thinly understood, skills in financial analysis.  The objective of financial modeling is to combine accounting, finance, and business metrics to create an abstract representation of a company in Excel, forecasted into the future. This course will explore the new charting and analysis features of Excel and covers dashboard reporting, balanced scorecards as well as visual design of charts and tables. Learn how to synthesise information into a logical framework, summarise it into a meaningful format, and then display the summary into easy-to-read tables and graphs in this two day course. Covering dashboard reporting, balanced scorecards, visual design of charts and tables, this course will also explore the new charting and analysis features of Excel.

By the end of this course, participants will understand :

• Improve their efficiency in using Excel shortcuts
• Use several of the support tools and techniques in spreadsheet programs
• Build a robust financial model
• How to forecast working capital using excel
• Analyse results from excel sheet based on financial statement input

• Data Analysis Tools
• Tool selection –Excel vs. other BI alternatives
• What’s new in the latest version of Excel
• Shortcuts for data manipulation in Excel
• Pivot Tables
• Overview of the free Microsoft add-in to Excel, PowerPivot
• Using Excel as a Data Analysis Tool
• Essential Excel tools and functions
• Working with text
• Cleaning data
• Creating a robust formula
• Charting in Excel
• Working with charts in Excel
• Charting on different axis
• Bubble and Waterfall charts
• Charting with dynamic ranges