Financial Modeling in MS Excel

PwC Academy invites you to participate in seminar «Financial Modeling in MS Excel»

 

Target audience 

The seminar is designed for professionals working in finance, economics, analysts and other specialists responsible for economic calculations and supporting management decisions.

Participants should have basic proficiency in MS Excel.

 

Objectives of the seminar are to help participants to:

  •  clearly understand the methodology for effective analytical modeling;
  •  understand the universal tools used in financial modeling;
  •  acquire the skills needed for constructing reliable and transparent financial models;
  •  get acquainted with modern financial modeling best practices.

 

PwC Academy methodology is based on the following principles: 

  •  Clearly presenting the material
  •  Re-enforcing acquired skills through practical exercises and analysis of examples in MS Excel

 

Main topics of the seminar

  •  Financial modeling best practices
  •  Optimal structure of a financial model in MS Excel
  •  Rules for entering and processing financial data, presentation of analytical results
  •  Working with ranges:

– Required settings

– Restrictions and recommendations for the use of  range names

–  Specifics of using range names in formulas

  •  Step-by-step creation of a model in MS Excel
  •  Quality control and audit of a model
  •  Sensitivity analysis - substitution tables

 

Practical exercises

During the workshop, participants work on a detailed case study in building a financial model for an investment project in MS Excel.

The most useful techniques of financial modeling will be illustrated with additional examples.

 

Duration of the seminar

16 academic hours / 4 days

 

Dates

20 - 23 October 2014

Training sessions start at 2:00 pm and end at 6:00 pm

 

Fee

280 USD (excluding VAT)

 

Registration deadline

12 October 2014
 

Language

The seminar will be conducted in Georgian using training materials in Georgian.

  

In order to register for the seminar please fill-out and submit

online registration form.

 

Upon obtaining your application, we will send confirmation message. Registration requests will be addressed on a first-come first-served basis until the training program has been fully booked.

 

For more details please see the attached booklet 

 

If you have any question, please contact us at below details:

Program Management

George Okroashvili, ACCA

Assurance Manager

office.: +995 32 250 80 50

mobile.: +995 577 50 10 15

george.okroashvili@ge.pwc.com

 

Administrative Support

Irma Gogotishvili

Marketing Coordinator

office.: +995 32 250 80 22

mobile.: +995 577 42 22 09

irma.gogotishvili@ge.pwc.com