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.
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.
- 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