Course Overview

This 2-day training is your opportunity t learn how to get the most from Excel's forecasting and planning capabilities and how with the help of an add-in, you can overcome the more challenging aspects of using Excel's scenario analysis tools.

The training also engages higher-level pivot table use with more sophisticated analysis tools to help managers reduce the time and efort it takes to build and update budgets and model forecasts using Microsoft Excel. 

Objectives: 

Participants in this highly interactive and practical 2-day course will learn; 

• Easily create one-variable models
• Create dozens of what-if scenarios for two-variable models
• Use Excel's Scenario Manager
• Extend data tables for three-variable models
• Build a model that helps the finance team understand the impact and implications of budget and forecasts
• Quickly create and customize charts using a variety of formatting tricks to create eye-catching effects 
• Determine when to use the lesser-known charts such as radar., bar-of-pie, and stock charts.

For registration and Enquiries call: 

0307030572 or 0244856218

Website: www.ieslearning.com

Next Session 

• Financial Modelling

Most Finance Teams spend several hours every month to consolidate data, perform financial analysis and generate several reports. The Financial Modelling with Excel course demonstrates through numerous practical examples, how to fully use all the reports and analytics rich capabilities of Excel to create any most business intelligence for workplace including data analysis, interactive charts and data visualization, management reports and modelling.