• Skip to content
  • Skip to footer

Financial Modeling Training by Financial Arena

Specialists in Financial Training & Consulting

  • Home
  • Financial Modeling Training
    • Overview
    • Financial Modeling using Excel
    • Advanced Financial Modeling & Risk Analysis
    • Advanced Financial Modeling
    • Upcoming Seminars – Schedule
  • Resources
    • Links
  • About Us
    • Testimonials
  • FAST Standard
  • Contact

financial modeling seminar

27/01/2016 By myfinancialmodeling.com

Advanced Financial Modeling

This seminar  builds on your existing financial modeling skills and teaches you  how to model the three major financial statements (balance sheet, income statement and cash flow statement) based on the globally recognized best practice financial modeling methodologies. Learn how to build more flexible and standardised models and better analyze financial data.

Develop a full scale model and learn how to model all respective items (assets, debt, depreciation etc). In addition, through the hands-on training approach you will learn how to perform sensitivity analysis, build alternative scenarios and tackle issues like inflation, escalation, corkscrews,error checking etc.

Financial Modeling skills are essential to professionals in the corporate, business modeling, banking, treasury, financial advisory, government and infrastructure sectors and it is critical to learn to apply those skills in a standardised manner. Even if you are an experienced modeller, through this seminar you will get to learn the advantages of applying to your everyday modeling task industry accepted best practices.

You will discover a range of sophisticated techniques that will improve the usability and reliability of your financial models. It would be a valuable opportunity to capitalize on the trainer’s well rounded experience and in-depth knowledge of the topics.

Seminar Objectives

As a result of taking this course, you should be able to:

1. Streamline model building by applying the best practices

2. Incorporate risk and uncertainty by creating scenarios and performing advanced sensitivity analysis.

3. Use advanced Excel formulas and scenario modeling techniques.

4. Minimize manual tasks and automate them by building macros into your models

5. Enhance model structure for more accurate analysis and forecasting and minimization of errors.

Course topics include:

1. a review of   logical statements, Text Functions, use of Range Names, Lookup Functions, Scenarios/sensitivity analysis using Data Tables,  Goal Seek, core Financial Functions and

2. mastering of Conditional functions , Conditional Formatting, how to Import Data into Excel , From a Text or Word File ,  The Spreadsheet Model development Process , Auditing , Error Checking.

Prerequisites

The seminar is designed for users who are competent in Excel and want to master their financial modeling skills and learn how to apply the industry best practices. It is assumed that participants have a very good knowledge of the core functionalities of Excel and use advanced spreadsheet tools and functions on a regular basis.

Instructor

Mr. Dimitris Leimonis

Application – Software Used

Participants are required to bring their own laptops and have installed Excel 2007 or 2010, Word, Adobe Acrobat Reader and PowerPoint. Mac users need Excel 2011 for the spreadsheet part and can use the respective applications for opening word documents, presentations and pdf files.

Who Should Attend

Financial Analysts, Accountants, Finance Managers, Consultants, Valuation & Budgeting Professionals, Investors, Business Students wishing to develop modeling skills.

Instructor – Short Bio

Mr. Dimitris Leimonis has more than 22 years of experience in a wide range of roles in investment management, banking, and professional financial training industry. Dimitris has extensive knowledge of the financial industry, with both practical and analytical experience, which makes him a very successful financial modeling expert. He has built, developed and used financial models to analyse risk, test scenarios, forecast results and optimize business and finance variables.

While working for a major asset management firm in SE Europe, Dimitris acquired extensive investment experience by managing a range of mutual funds and affluent client’s portfolios. He has worked as a mutual fund manager, managing money market, bond and equity mutual funds with AUM around €2billion. He has strong quantitative and analytical skills with an ability to understand complex financial structures and his a passionate financial trainer of advanced finance topics, like Financial Modeling, Portfolio Management, Derivatives, & Fixed Income.

Dimitris started his academic studies in Banking & Finance and continued with post-graduate studies with a Master of Business Administration (MBA) from Lebow College of Business – Drexel University, specializing in Management Information Systems and Investment Management.  He has extensive corporate training experience and key involvement in the development of the training program of one of Greece’s largest financial institutions.

Certified by the Hellenic Capital Markets Commission as Portfolio Manager and Investment Consultant.

Specialties/ Key Skills: Financial Modeling, Risk Analysis, Mutual Funds, ETFs, Portfolio Management, Asset Allocation, Financial Analysis, Business Analysis, Financial Education and Training

Mr. Leimonis’ Linkedin Profile

Filed Under: Seminars Tagged With: advanced financial modeling, cost of capital, financial modeling seminar, financial modelling, monte carlo simulation, project appraisal, risk analysis

27/01/2016 By myfinancialmodeling.com

Financial Modeling using Excel

A highly practical, hands-on course designed to allow participants to expand the functionality of spreadsheets and learn how to build financial models in Excel.

The course will take concepts and issues introduced in the core finance and financial accounting courses and introduce participants to the practical application of financial modeling using Excel. Seminar participants will be required to build robust and reliable model for a particular decisions while they will refresh basic and more advanced finance topics like time value of money, capital budgeting (discount cash flows analysis, weighted average cost of capital – WACC etc) and portfolio management topics.

 Seminar Objectives

As a result of taking this seminar, you should be able to:

1. Learn  important Excel concepts and functions and understand which formulas are needed in different cases.

2. Overview financial models and document model assumptions

3. Learn to use Excel for sensitivity analysis and scenarios

4. Get familiar with key features of good model design

5. Master several excel shortcuts to speed up data analysis

6. Create dynamic charts and present data effectively.

 Prerequisites

The seminar is designed for users who use Excel from time to time and want to take their skills to the next level. It is assumed that participants have a basic knowledge of the core functionalities of Excel and are in position to easily navigate within the spreadsheet, create and use simple formulas and link between workbooks.

Application – Software Used

Participants are required to bring their own laptops and have installed Excel 2007 or 2010, Word, Adobe Acrobat Reader and PowerPoint.  Mac users need Excel 2011 for the spreadsheet part and can use the respective applications for opening word documents, presentations and pdf files, although we would suggest them to work with the Windows version of Excel (via Parallels Desktop, Boot Camp, VMware Fusion or other similar applications).

Who Should Attend

Financial Analysts, Accountants, Finance Managers, Consultants, Valuation & Budgeting Professionals, Investors, Business Students wishing to develop modeling skills.

Locations / Venues

Our courses in Athens are held in our Training Center at Holargos while when we run them in other cities (Thessaloniki) are held in centrally located hotels. Registration fees include morning cofee/tea and refreshments. Detailed venue descriptions, times and logistics are included in the material we send after your register for the course.

 

Instructor – Short Bio

Mr. Dimitris Leimonis has more than 20 years of experience in a wide range of roles in investment management, banking, and professional financial training industry. Dimitris has extensive knowledge of the financial industry, with both practical and analytical experience, which makes him a very successful financial modeling expert. He has built, developed and used financial models to analyse risk, test scenarios, forecast results and optimize business and finance variables.

While working for a major asset management firm in SE Europe, Dimitris acquired extensive investment experience by managing a range of mutual funds and affluent client’s portfolios. He has worked as a mutual fund manager, managing money market, bond and equity mutual funds with AUM around €2billion. He has strong quantitative and analytical skills with an ability to understand complex financial structures and his a passionate financial trainer of advanced finance topics, like Financial Modeling, Portfolio Management, Derivatives, & Fixed Income.

Dimitris started his academic studies in Banking & Finance and continued with post-graduate studies with a Master of Business Administration (MBA) from Lebow College of Business – Drexel University, specializing in Management Information Systems and Investment Management.  He has extensive corporate training experience and key involvement in the development of the training program of one of Greece’s largest financial institutions.

Certified by the Hellenic Capital Markets Commission as Portfolio Manager and Investment Consultant.

Specialties/ Key Skills: Financial Modeling, Risk Analysis, Mutual Funds, ETFs, Portfolio Management, Asset Allocation, Financial Analysis, Business Analysis, Financial Education and Training

Mr. Leimonis’ Linkedin Profile

Filed Under: Seminars Tagged With: excel modelling, excel with finance, financial modeling seminar, financial modelling, introduction to financial modeling

20/01/2016 By myfinancialmodeling.com

Upcoming Financial Modeling Seminars – Q1 2016

Upcoming Financial Modeling Seminars by Financial Arena

financial modelling seminarsThe 5th series of our Financial Modeling seminars will begin on December with the following schedule:

1. “Financial Modeling using Excel”, Athens – Greece

    • Friday, February 26 from 9am till 5pm
    • Saturday, February 27 from 9am till 5pm

Total seminar duration: 16 hours

Click here for more details on this introductory financial modelling seminar or email us at customercare[@]financialarena.gr

2. “Advanced Financial Modeling based on FAST Modeling Standard” , Athens – Greece

    •  Friday, 4 March ,from 9am till 5pm
    • Saturday 5 March, from 9am till 5pm

Total seminar Duration: 16hours

3. “Financial Modeling Boot-camp” , Nicosia – Cyprus

  •  Friday, 18 March ,from 9am till 5pm
  • Saturday 19 March, from 9am till 5pm
  • Sunday 20 March, from 9am till 5pm

Total seminar Duration: 24 hours

Email us for more details on this financial modelling at customercare[@]financialarena.gr with any possible questions.

All financial modeling courses will take place at a centrally located hotel / venue and each class will have a maximum number of 10 participants so that to ensure the quality of training.

financial modeling seminar dealTake advantage of our early bid registration offer and save 20% of the initial seminar price. For a limited number of participants there is a special discount, when you register to attend both our seminars that saves you up to 40% of the overall investment.

For more information / feedback please contact us at customercare[@]financialarena.gr or at info[@]myfinancialmodeling.com

Check our Facebook Fan page for up-to-date news on our offerings and topics related to financial modelling and do not forget to share our page with friends and colleagues that might be interested.

Filed Under: Events Tagged With: advanced financial modeling, excel seminars, financial modeling seminar, financial modelling seminars in Athens, financial training, introduction to financial modeling, risk analysis seminars, σεμινάρια χρηματοοικονομικής ανάλυσης, χρηματοοικονομικά μοντέλα

20/01/2016 By myfinancialmodeling.com

Financial Arena announces the 5th series of Financial Modeling seminars in Athens, Greece

Financial Modeling Seminars – Q1 2016

Get crucial soft-skills by combining Excel with Finance

As you might know already Financial Modeling is one of the most important soft skills and can drastically improve your professional profile (check a recent poll by CFA Institute. Financial Arena is launching the 5th series of  Financial Modeling seminars in Athens during February 2016.


Our seminars cover a wide range of topics and are hands-on using case studies so that to apply all the needed knowledge, improving your Financial Modeling & Excel skills.

Depending on your level you can register in our introductory seminar “Introduction to Financial Modeling” or/and in the more advanced “Advanced Financial Modeling & Risk Analysis“. We have scheduled them so that you can have the option to join both of them and offer a unique price for their combination. In the following days we will be uploading an tool to assess your level and decide which seminar fits your needs.

Feel free to contact us so that to learn more details about our upcoming seminars and take advantage of an early-bird offer, valid thru 26/1!

If you want to learn more about us, you can visit our web site at Financial Arena, our Facebook fan page or contact us directly via email at customercare[@]financialarena.gr

Filed Under: Events Tagged With: advanced financial modeling, excel modelling, excel seminars, financial modeling seminar, financial modelling, introduction to financial modeling

12/11/2015 By myfinancialmodeling.com

Financial Arena announces the 4th series of Financial Modeling seminars in Athens, Greece

Financial Modeling Seminars – December 2015

Get crucial soft-skills by combining Excel with Finance

As you might know already Financial Modeling is one of the most important soft skills and can drastically improve your professional profile (check a recent poll by CFA Institute. Financial Arena is launching the 4th series of  Financial Modeling seminars in Athens during December


Our seminars cover a wide range of topics and are hands-on using case studies so that to apply all the needed knowledge, improving your Financial Modeling & Excel skills.

Depending on your level you can register in our introductory seminar “Introduction to Financial Modeling” or/and in the more advanced “Advanced Financial Modeling & Risk Analysis“. We have scheduled them so that you can have the option to join both of them and offer a unique price for their combination.

Feel free to contact us so that to learn more details about our upcoming seminars and take advantage of an early-bird offer, valid thru 18/11!

If you want to learn more about us, you can visit our web site at Financial Arena, our Facebook fan page or contact us directly via email at customercare[@]financialarena.gr

Filed Under: Events Tagged With: advanced financial modeling, excel modelling, excel seminars, financial modeling seminar, financial modelling, introduction to financial modeling

  • Page 1
  • Page 2
  • Next Page »

Footer

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • FACEBOOK
  • LINKEDIN
  • GOOGLE+
  • TWITTER

Copyright © 2025 Financial Arena, All Rights Reserved. ·Log in