Русский Русская версия English English version

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

roe-in-excelReturn 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.
assets-equity-ratioCurrent 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.
using-pest-analysis-exampleMacro 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).
transport-task-in-excelTransport 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.
calculation-moving-averageCalculation 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.
capital-ratio-for-inventoriesWorking 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.
factor-variance-analysisFactor 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.
bcg-matrix-exampleBCG 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.
management-accountingManagement 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?
calculating-irr-functionsCalculating 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.
1 2 3 4