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



18 - 21 May 2015

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



280 USD (excluding VAT)


Registration deadline

11 May 2015


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


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


Administrative Support

Irma Gogotishvili

Marketing Coordinator

office.: +995 32 250 80 22

mobile.: +995 577 42 22 09