Spreadsheet skills for planning forecasting and budgeting: Financial Management Certification Dubai UAE : Arab Institute for Accountants & Legal (AIAL)

Accounting Certifications

Spreadsheet Skills for Planning Forecasting and Budgeting

This hands-on, practical course will demonstrate how you can develop spreadsheet models to create a forecast, which can then be utilised to generate business plans and operating budgets with the use Excel® as it is used in practice. The applications will be focused on three crucial aspects of business and financial management - strategic planning, intelligent forecasting and realistic budgeting. Delegates will learn how accessible the power of Excel® is to provide realistic forecasts and prepare flexible budgets. The impact on efficiency in planning and control and therefore return on investment for companies and/or divisions will be startling.

Certification Issued By:

IFIS logo International Financial Institution Society (IFIS - USA) IFIS is a global network of professional services organization providing Financial, Client Solutions, Assets Management and Accreditation services. We have 62,000 outstanding professionals working together to deliver value in 15 countries.

Membership By:

hacab logo HIGH AUTHORITY COUNCIL FOR ARAB BANKERS (HACAB) The council believes that the ideal platform for communication, networking, and information sharing, which gathers today under its umbrella, the elite Arabs working in the Arab World and internationally - has fostered mutual cooperation among its members and strived to serve their common interests and goals thus reinforcing the Arab Banking and finance industry. It further represents a main drive for synergizing Arab competencies

Eligibility:

You are qualified to take this certification if you have any of the below requirements:

  • Must have at least one year experience in related field
  • Bachelors or Masters Degree

Course Parts:

  • The power of Excel for building financial models
  • The Ribbons of Excel with their commands and functions
  • Using formulae: Copying, anchoring and special pasting
  • Using functions: financial, statistical and mathematical
  • Review of the financial objectives of business: ROI, ROA, ROE
  • Overview of Financial Statements
  • Classical strategic planning models
  • Cost-Volume-Profit Analysis and Break-Even as a planning example
  • Forecasting in perspective - the Past vs. the Future
  • Necessity to apply a range of different forecasting methods
  • Qualitative Models used in forecasting
  • The budget process: Timing and Cycles
  • Setting budgeting objectives and tolerance levels
  • Budgeting Techniques
  • Build your planning model
  • Build your forecasting model
  • Build your budgeting model

How to Register?

  • Register Online or
  • Fill-up the registration form and visit the Institute, with the following requirements then pay the necessary fees.
    • passport copy
    • 1 copy of passport size photo
    • eligible certificate copy

Download Course Details

Download full details of this course.