Banking and Financial Applications of MS Excel and Eviews

Course details

Objectives :

• Order processing and financial and non-financial data and how to deal with it.
• The use of computers in the application of the appropriate banking operations.
• Banking forecasting and strategic planning and long-term.
• Advanced Financial Analysis and Statistical.
• Analysis of the results and interpretation statistically and scientifically and employment in research and study.

Contents :

• Dealing with multiple lists of the financial statements.
• Arithmetic operations and functions of the main menus.
• Analysis of bank financing, interest rates, payments, amounts paid.
• Banking Operations Analysis: Marketing Sales.
• The impact of the interrelationships of the financial statements.
• Frequencies and percentages.
• Statistical and financial operations of the investment banking:
• Mean Mean .
• The standard deviation Standard Deviation / contrast Variance  .
• The highest value of  Maximum and the lowest value Minimum  .
• Vein Mode  mediator Median  .
• The discovery of relations through - correlation coefficients Correlation
• Correlation coefficients: Pearson correlation.
• Strength of the relationship: the shape and impact.
• Graphical representation of relations and indicators.
• Analysis of advanced banking operations:
• Forecasting and strategic planning using Regression .
• Linear Regression Simple .
• Multiple regression Multiple .
• Time Series Time Series .
• Graphical representation of relations and indicators.
• How to convert numbers to the conclusions and recommendations.
• Practical situations and different applications.