fbpx

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Next Training Countdown

Day(s)

:

Hour(s)

:

Minute(s)

:

Second(s)

DATA MODELLING

Financial Services Training

Through the use of various software the organization assist it clients in managing, analyzing and evaluating huge amount of data to draw conclusion on various issues that ore of concern to the organization. This includes data coding, data mining, and data summarization and presentation just to name a few. Among the methods used include Power BI, Business Analytics and Financial Modeling.

The success of every, Private, Public, NGO’s or Government Parastatals is squarely based on the competence and efficiency of its human resource. To uniquely offer solutions to this, the CYNET E.A. Corporate Training Centre was established to meet specific and dynamic training needs in fields of finance, data management, leadership and Business Research within the Corporate World.

Financial Modelling using spreadsheets like MS Excel are used in many fields like investment banking, M&A, equity research, risk analysis, valuations, investment management, credit analysis, scenario analysis, budgeting, sales forecast, financial projections, project evaluation, etc. This is a program where practicing Investment Bankers and Treasury Professionals teach the latest techniques and modeling skills that are used in the industry.

Lot of financial professionals who do all kinds of financial modelling feel handicapped to quite a large extent in implementing certain models that requires them to do considerable amount of programming in VBA.

 

 

 Merely knowing how to record or even write some odd macros in VBA is not of any help to them. There is no specialized course in IT domain that teaches “VBA Programming for Finance”, a course that teaches VBA programming with exclusive focus on Financial Applications.

Power query is another important tool for data analysis, data organization and business intelligence. There is no specialized course in IT course that teaches “power BI for Finance or business intelligence, a course that teaches power query with exclusive focus on Financial Applications and business analytic. This is why we have designed this course tailor-made for imparting these skills. This course, apart from teaching financial modeling, we also teach advanced dashboard reporting and Power BI using advanced excel.

.

COURSE OUTLINE

DATA SORTING, SUMMARIZING AND ANALYSIS  

  • Power query
  • Excel Data Model
  • Advanced Pivot Table Options

UNDERSTANDING FINANCIAL MODELING  

  • Advanced Excel Tables
  • Mixed Cell References
  • Excel Add-Inns

EXCEL FUNCTIONS AND TOOLS  

  • Look up & Reference Functions (Lookup, Offset, Choose, Get Pivot Data, Index, Match
  • Logical Functions (Nested IF, And, True, False, Not, Or)
  • Working with Array Formulas
  • Conditional formatting using Formulae
  • Application of Excel camera

USE OF EXCEL FOR INFORMED DECISION MAKING  

  • Scenario Manager
  • One Way Data Tables
  • Two Way Data Tables

 

DESIGNING EFFECTIVE EXCEL MODELS  

  • Elements of Excel Models
  • Good Excel Models Building Habits
  • Types of Errors in Excel Models
  • Dealing with Errors
  • In-Built Auditing Tools
  • Model Documentation
  • Data Validation using Formula

MORE EXCEL FUNCTIONS AND TOOLS  

  • Writing, Editing and using Macros
  • Form Controls and Active Controls
  • Button, Combo Box, Check Box, Spin Button, Option Button, Scroll Bar etc.

DATA VISUALIZATION

  • Designing Charts
  • 3D Formatting
  • Review of Charts
  • Changing source Data
  • Introduction to interactive chart
  • Power Views
  • Interactive Charts
  • Advanced Chart Formatting
  • Trending Tricks

COLLABORATING WITH OTHERS  

  • Sharing Workbooks
  • Editing a shared Workbook
  • Stopping sharing a Workbook

COORPRATES  WE HAVE TRAINED

Total Number Of trained Clients

DOWNLOAD COURSE OUTLINE

You want to know what we have you can check out our course outline for Data Modeling. Keep in mind we provide practical based lessons,
error: Content is protected !!