# Examples of data analysis in Excel

Examples and effective solutions for complex tasks in the creation of reports, analysis and the formation of documents. Application of formulas, functions and analytical tools in the process of working with spreadsheets.## Analyzes and calculations with formulas and charts

Return On Equity – ROE in Excel.

Coefficient of turnover of own financial resources: the formula for the balance sheet, the normative value, the dynamics of the parameter on the graph. The reasons for the increase, decrease and normative values of the coefficient.

Coefficient of turnover of own financial resources: the formula for the balance sheet, the normative value, the dynamics of the parameter on the graph. The reasons for the increase, decrease and normative values of the coefficient.

Current assets to equity ratio in Excel.

The essence and normative value of the coefficient of maneuverability of equity. Formula by balance, example of calculation. Dynamics of the indicator on the graph, evaluation of the results.

The essence and normative value of the coefficient of maneuverability of equity. Formula by balance, example of calculation. Dynamics of the indicator on the graph, evaluation of the results.

Macro analysis using pest analysis in Excel with example.

The essence and purpose of PEST-analysis of the enterprise. Determination of external factors affecting sales and profits. Example of the application of a marketing tool in Excel (shop research).

The essence and purpose of PEST-analysis of the enterprise. Determination of external factors affecting sales and profits. Example of the application of a marketing tool in Excel (shop research).

Transport task in Excel with example and description.

The order of the solution of the transport task: the instruction for the closed and open type. Selection of optimal values using the tool for finding solutions.

The order of the solution of the transport task: the instruction for the closed and open type. Selection of optimal values using the tool for finding solutions.

Calculation of the moving average in Excel and forecasting.

For calculation, the AVERAGE function and the Moving Average of the Data Analysis Package add-in are used. Procedure for using the program's capabilities and making forecasts.

For calculation, the AVERAGE function and the Moving Average of the Data Analysis Package add-in are used. Procedure for using the program's capabilities and making forecasts.

Working capital ratio for inventories availability.

The factor of supply of reserves and expenses by own means shows the degree of coverage of material stocks by own sources of financing.

The factor of supply of reserves and expenses by own means shows the degree of coverage of material stocks by own sources of financing.

Factor and variance analysis in Excel with automated calculations.

Factor and variance analysis is easily carried out using the Data Analysis tool. For visual attention concentration on significant parameters, a diagram is added.

Factor and variance analysis is easily carried out using the Data Analysis tool. For visual attention concentration on significant parameters, a diagram is added.

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.

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.

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?

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?

Calculating IRR in Excel using functions and 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.

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.