Analyses and reports in Excel with the description of their formatting
Constructing of financial analyses for evaluation of business activity and investment projects. Forming reports and documents forms in Excel for accounts department, marketing department, warehouse facilities, and other structures of the company.Forming of reports analyses with examples
Calculation of the effective interest rate on loan in Excel.Calculation of the effective interest rate on the loan, leasing and government bonds is performed using the functions EFFECT, IRR, XIRR, FV, etc. Let's look at examples of how real interest is considered.
There is calculation of KPI in the Excel: examples and formulas.KPI key performance indicators assess the result of the work performed. On the basis of the indices are often constructed compensation system. Formulas example of a table and KPI matrix.
Time series analysis and forecasting in Excel with examples.Time series: analysis and forecasting of values. Tool Analysis package offers the user methods of statistical processing of time series elements. Examples of analysis and forecasting of time series.
Management accounting in Excel with examples.Tables of management accounting on the example of a restaurant-cafe. Examples of filling out reports on income, expenses, profits and losses. Analysis of the property of the enterprise. How to automate the work?
Financial analysis in Excel with an example.The financial and statistical analysis in Excel: automation of calculations. How to analyze the time series and forecast sales, taking into account the trend component and seasonality?
ABC and XYZ analysis in Excel with example of calculation.ABC analysis and possible technique, the conditions for use. Example analysis of the product portfolio of the table processor means. XYZ-analysis method.
How to calculate IRR by formula in Excel for Chart.The analysis of the investment project requires the calculation of the internal rate of return IRR. Formula and example on the graph, built-in functions. Graphical method of calculating the indicator.
Calculation of credit in Excel and the formula of monthly payments.How to calculate loan payments: the formula for the annuity and differentiated method, interest and balance, overpayment and the full value of the loan. EIR new formula.
BCG Matrix: construction and analysis in Excel with example.The BCG matrix is an excellent tool for portfolio analysis. Consider the example in Excel, the construction of the matrix, the identification with its help of promising and unpromising goods.
How to do a Regression and Correlation analysis in Excel.Meaning methods of correlation and regression analysis for statistics. How to find the coefficients using Excel tools in two clicks. Construction of the correlation field.
