SEU - Georgian National University

No, thanks.

Training Center

Online Certificate Course on Financial Data Analysis in Excel

SCHEDULE

Start date:

04 October, 2021

Training Period:

Twice a week, from 19:00 to 21:30

End date:

30 November, 2021

OVERVIEW

SEU offers an online certificate course on Financial Data Analysis in Excel!

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

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

To take the course, the applicants 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 perform the operations themselves.

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

  • Dealing with complex formulas;
  • Calculating financial statements through large databases;
  • Compiling statistical-analytical tables;
  • Converting spreadsheets to simple reports;
  • Analyzing geographical area;
  • Creating interactive spreadsheets from different databases;
  • Analyzing financial data;
     

Students will be provided with all study materials.

The course fee: 300 GEL.

The duration of the course: 25 hours.

Lectures will be held twice a week from 19:00 to 21:30.

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

 

The course starts in October!

  • To register, please follow the link: https://bit.ly/3qy12DL
  • 20% discount for SEU students and graduates!
  • 10% discount for two or more persons from the same organization!

Contact info:

Address: 9 Tsinandali St, Tbilisi, Georgia

Email: [email protected]

Tel: 032 2 90 00 00; 555 29 63 28

Bank info:

Bank of Georgia

GE82BG0000000304043700GEL

TOPIC

Curriculum:

  • Mathematical and statistical formulas (Sumif; Sumifs; Countif; Countifs; Averageif; Averageifs) for analyzing various data from a large database.
  • Clear summary databases for voluminous databases through Name Manager.
  • Pivot Table - interactive spreadsheets, interactive graphs, data updates through the new pivot table settings.
  • Analysis of geographical area with the 3D map.
  • Powerful Pivot Analysis with seconds accuracy; Compiling interactive spreadsheets from various databases of the most profitable products.
  • Calculating premium schemes by means of logical formulas.
  • Solver profit enhancement under limited resources.
  • Loan Sensitivity Analysis through Data Table.
  • Formulas related to dates.
  • Controlling receivables and payables through Ganti Chart-Dynammic Task Bar.

TRAINERS

Price

300 Gel

REGISTER
Message body empty