SEU - Georgian National University

No, thanks.

Training Center

Online Certification Course in Financial Data Analysis in Excel

SCHEDULE

Start date:

23 March, 2021

Training Period:

Tuesdays and Thursdays from 19:00 to 21:30

End date:

13 April, 2021

OVERVIEW

Georgian National University SEU Training Center offers an online certification course in Financial Data Analysis in Excel!

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

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

To take the course, students must be aware of the basic capabilities of Excel.

During the course, each topic will be processed based on practical examples. The participants will have the opportunity to engage themselves in performing the operations.

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

  • Working with complex formulas;
  • Calculating financial statements through large databases;
  • Compiling statistical-analytical tables;
  • Converting spreadsheets into simple reports;
  • Analyzing geographical area;
  • Setting up interactive spreadsheets from different databases;
  • Analyzing financial data.

Students will be provided with learning materials.

The cost of the course is 300 GEL.

The duration of the course is 25 hours.

Lectures will be held twice a week on Tuesdays and Thursdays from 19:00 to 21:30.

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

The course starts on March 23! 

To register go to the following link: https://forms.gle/vwJR3spbR2BtPVZ78

20% discount for SEU students and graduates!

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

Contact information:

  • 9 Tsinandali Tt.,Tbilisi, Georgia
  • Email: info@seu.edu.ge
  • 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;
  • Interactive spreadsheets, interactive graphs, and data updates via new pivot table settings of Pivot Table;
  • Analysis of geographical area through 3D map;
  • Setting up interactive spreadsheets from various databases of the most profitable products through ultraprecision Power Pivot analysis;
  • Calculation of premium schemes by means of logical formulas;
  • Profit solver maximization under limited resources;
  • Loan sensitivity analysis via Data Table;
  • Control over receivables and payables through the Gantt Chart-Dynamic Task Bar.

TRAINERS

Price

300 Gel

REGISTER