Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

CBA Certified Budget Analyst - Advanced Budgeting and Financial Forecasting using Advanced Excel

By: LEORON Professional Development Institute

Mozambique

12 - 16 Sep, 2016  5 days

Follow Event

  

USD 3,590

This 5 days intensive training program is for professionals, responsible for the preparation of budgets, plans and forecasts and those who are using them as well. The course will start with some exceptionally important advanced Excel tips that will be utilized during the course.

All of the tips coming together will orchestrate professional models that are dynamic and interactive. Very advanced tools like Monte Carlo simulation using Crystal Ball in Excel and Power Pivot (that is introduced recently in Excel) will be an inherent part of the program. When it comes to planning for the future in any organization, the biggest problem is how to account for uncertainty. Strictly (in financial terms), uncertainty is where there is more than one possible outcome to a course of action; the form of each possible outcome is known, but the probability of getting any one outcome is not known. It is a challenge to quantify uncertainty because it is not an observable variable, rather it's deduced from others.

However given a complete range of possible outcomes, one can make decisions that reduce this uncertainty. Monte Carlo simulation gives the power to solve a problem by directly simulating the underlying process and then calculating the possible results of the process with varying degrees of probability.

Moreover, the participants will learn how to develop Power Pivots that can handle data of up to 200 million rows of data on a standard desktop or laptop computers knowing that normal pivot tables in Excel usually choke after about 30,000 rows of data or so.

In addition, there are numerous other features in Power Pivot that will enrich the analysis of your data. For example, a Power Pivot can read data from different ranges which is something a normal pivot table cannot accomplish. A professional case study will examine the interactions within a Power Pivot example that will be a guide of something that can be implemented upon the completion of the course.

The course is very hands-on and practical in nature. That is what the trainer has been renowned for in different countries around the world. Please bring your laptop with Excel 2010 or higher. Power Pivot doesn’t work in Excel 2007.

Hamed Behairy Sep 12 - 16 Sep, 2016
USD 3,590.00
(Convert Currency)

+971 (0) 4 447 57 11 ext.654

Discounts and installments available
Hamed Behairy
Related Courses
Certified Training Program in Governance, Risk Management and Compliance Certified Training Program in Governance, Risk Management and Compliance

4 days, 25 - 28 Sep, 2017 

2017-09-25 12:09:00
Sweden

LEORON Professional Development Institute

In today’s complex global business environment, having a transparent view of information and a coordinated approach to the governance, management and assurance of performance, risk and ...

Certified Internal Auditor® - Part 1 and 2 Certified Internal Auditor® - Part 1 and 2

5 days, 20 - 24 Aug, 2017 

2017-08-20 12:08:00
United Arab Emirates

LEORON Professional Development Institute

  The IIA’s CIA Learning System Program is designed to expand your internal audit knowledge, build confidence for addressing today’s internal audit challenges, and prepare you for ...

Contract and Commercial Management Practitioner Contract and Commercial Management Practitioner

4 days, 18 - 21 Sep, 2017 

2017-09-18 12:09:00
Germany

LEORON Professional Development Institute

People enter Contract and Commercial Management discipline from a wide variety of backgrounds, often with little or no specific training. They may be financial or legal professionals, they may have ...

Senior International Project Manager Senior International Project Manager

4 days, 29 May - 01 Jun, 2017 

2017-05-29 12:05:00
Ghana

LEORON Professional Development Institute

SIPM is a fast moving and engaging seminar, focusing on a pragmatic approach and applying a series of processes that are regarded as first-class practices within project management. This course seeks ...