Many of us struggle to make sense of all the data that is available in this information age. With such a deluge of reports and statistics, it’s no wonder that data is often misinterpreted or not communicated at all.
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.
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.
This course is very hands-on and practical. Each participant will be expected to create their own reports, charts and models utilizing the tools and techniques covered during the course.
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.
In this course, participants will:
- 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
- Interpretation of financial statements
- How to read financial information
- Ratio analysis covering : Profitability solvency and stability, liquidity, efficiency, techniques for improving working capital management and investor ratios
- Limitations and pitfalls of numerical analysis
- Qualitative measures of performance
- Financial decision making
- How financial decisions are made
- Net present value, internal rate of return, payback period
- Relevant cash flows
- Opportunity costs
- Time value of money
- Cost behaviours and management
- Different types of costs
- Direct and indirect costs
- Fixed, variable costs, semi variable and stepped costs
- How much does something cost?
- Absorption and activity based costing
- Impact on pricing
- Break even analysis
- Budgeting and forecasting
- Perceptions around budgeting
- Planning, budgeting and forecasting and it’s difference
- The budget cycle and how to prepare a budget
- Monitoring performance against budget
There are no scheduled dates for this course. Fill out the form to check future dates or deliver the course in-house