SEU - Georgian National University

No, thanks.

Training Center

CERTIFICATE COURSE IN FINANCIAL DATA ANALYSIS IN EXCEL

SCHEDULE

Start date:

20 May, 2021

Training Period:

Monday, Wednesday from 19:00 to 21:30.

End date:

24 Jun, 2021

OVERVIEW

During the course, participants will learn to create and update databases, compile interactive spreadsheets from different databases, compile statistical-analytical spreadsheets, compile and analyze effective interest rate amortization tables for financial functions.

The course is designed for financial managers, analysts, sales, banking professionals and anyone who wants to study and/or improve Excel knowledge in financial data processing and analysis.

To take the course, participants must have knowledge of the basic capabilities of Excel.

During the course, each topic is processed based on practical examples. Participants will have the opportunity to perform the operations themselves.

Upon completion of the course, participants will be able to avoid mistakes made during the financial analysis and perform various financial transactions in the shortest possible time: 

  • Working with complex formulas;
  • Calculating financial statements through large databases;
  • Compilation of statistical-analytical tables;
  • Converting large spreadsheets into simple reports;
  • Analysis of the geographical area;
  • Creating interactive spreadsheets from different databases;
  • Financial data analysis;

Participants will be provided with study materials.

Upon completion of the course, a certificate of the Georgian National University will be issued!

20% discount for SEU students and graduates!

10% discount in case of registration of two or more persons from one organization!

Contact information: 

  • Tbilisi, Tsinandali ST.#9 Georgia
  • Email: [email protected]
  • Tel: 032 2 90 00 00; 555 29 63 28
  • Bank of Georgia GE82BG0000000304043700GEL

TOPIC

  • Mathematical and statistical formulas (Sumif; Sumifs; Countif; Countifs; Averageif; Averageifs) for analyzing various data from a large database.
  • Clear summary databases of huge databases through Name Manager.
  • Pivot Table - Interactive spreadsheets, interactive graphs, data updates via new pivot table settings.
  • Geographic area analysis with 3D map.
  • Powerful Pivot Analysis with seconds accuracy Assembling interactive spreadsheets from various databases of the most profitable products.
  • Calculate premium schemes by means of logical formulas.
  • Solver profit maximization in conditions of limited resources.
  • Loan Sensitivity Analysis via Data Table.
  • Dates related formulas.
  • Accounts Receivable and Lending Control via Ganti Chart-Dynamic Task Bar.

TRAINERS

Price

320 Gel

REGISTER
Message body empty