Need Support? Tel: +971 4 361 6397
Home » Courses » Finance & Accounting » Spreadsheet Skills for Planning, Forecasting & Budgeting

Spreadsheet Skills for Planning,
Forecasting
& Budgeting

21 - 25 Apr 2019 Dubai, UAE $5,950 Register
29 Jul - 02 Aug 2019 Istanbul, Turkey $5,950 Register
08 - 12 Sep 2019 Dubai, UAE $5,950 Register

Training Courses Overview

It is increasingly important for middle and senior management to have high level and sophisticated spreadsheet skills and financial modelling skills. This innovative training course combines financial management knowledge with Excel® skills and uses real world examples and case studies to improve and develop Excel® skills and to challenge delegates to find solutions to sophisticated problems.

Training Courses Objectives

By attending this COPEX training course, you should achieve these goals:

  • Navigate through the features and functions of Excel®
  • Distinguish between data and output in spreadsheet architecture
  • Analyse financial statements in order to plan ahead
  • Build effective financial planning models
  • Use forecasting techniques for budget preparation

Designed For

This COPEX training course is suitable for middle and senior managers who have responsibility for divisional or organizational success, as well as consultants and professionals who support them. For example:

  • Business advisors, analysts & staff from all functional areas who need to advise, comment or develop business forecast plans and budgets
  • Strategic Planners and Finance Officers
  • Management Accountants
  • Managers without formal financial qualifications

Training Courses Outline

Amongst a wide range of valuable topics, the following will be prioritised:

  • The Excel® environment - How to become an advanced user
  • Selecting the most appropriate function to suit the task
  • Selecting the right chart for the right task
  • Statistical analysis
  • Linear and non-linear forecasting
  • Per-cent of sales approach to forecasting
  • Using solver and what if analysis to maximise KPI’s
  • Using Excel® to optimise budgets
  • Using Excel® for ratio analysis
  • Upsides and downsides of different forms of firm financing

The Certificate

  • COPEX Certificate of Attendance will be provided to delegates who attend and complete the course



Spreadsheet Skills for Planning,
Forecasting
& Budgeting


Upcoming Dates

21 - 25 Apr 2019 in Dubai - UAE, $5,950

29 Jul - 02 Aug 2019 in Istanbul - Turkey, $5,950

08 - 12 Sep 2019 in Dubai - UAE, $5,950


Training Courses Overview

It is increasingly important for middle and senior management to have high level and sophisticated spreadsheet skills and financial modelling skills. This innovative training course combines financial management knowledge with Excel® skills and uses real world examples and case studies to improve and develop Excel® skills and to challenge delegates to find solutions to sophisticated problems.

Training Courses Objectives

By attending this COPEX training course, you should achieve these goals:

  • Navigate through the features and functions of Excel®
  • Distinguish between data and output in spreadsheet architecture
  • Analyse financial statements in order to plan ahead
  • Build effective financial planning models
  • Use forecasting techniques for budget preparation

Designed For

This COPEX training course is suitable for middle and senior managers who have responsibility for divisional or organizational success, as well as consultants and professionals who support them. For example:

  • Business advisors, analysts & staff from all functional areas who need to advise, comment or develop business forecast plans and budgets
  • Strategic Planners and Finance Officers
  • Management Accountants
  • Managers without formal financial qualifications

Training Courses Outline

Amongst a wide range of valuable topics, the following will be prioritised:

  • The Excel® environment - How to become an advanced user
  • Selecting the most appropriate function to suit the task
  • Selecting the right chart for the right task
  • Statistical analysis
  • Linear and non-linear forecasting
  • Per-cent of sales approach to forecasting
  • Using solver and what if analysis to maximise KPI’s
  • Using Excel® to optimise budgets
  • Using Excel® for ratio analysis
  • Upsides and downsides of different forms of firm financing

The Course Content


The Certificate

  • COPEX Certificate of Attendance will be provided to delegates who attend and complete the course


© 2018. Material published by Copex shown here is copyrighted. All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.

Send to Colleague

© 2018. Material published by Copex shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.





Sending your message. Please wait...

Send Successfully

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

Print Page

© 2018. Material published by Copex shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.








Sending your message. Please wait...

Close

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

Download PDF

© 2018. Material published by Copex shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.







Sending your message. Please wait...

Close

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

Give Us a Call Now to Get Started +971 4 361 6397