Analysis of the data in Excel using the functions and computational tools

Perform analysis of data in tables using functions, formulas and built-in standard tools, as well as practical application of extensible settings for finding solutions.

Data analysis and the search for solutions

forecasting-sales-in-excelForecasting sales in Excel and time series analysis algorithm.
Drawing up of the forecast on sales on the basis of sales statistics for the previous periods in view of seasonality. Construction of seasonality charts and forecast. Formation of sales plans for the next year.
subtotals-examplesSubtotals in Excel with examples of functions.
Calculation of subtotals using standard tools and functions. A convenient means of processing records in a huge list of data.
turnover-ratio-of-receivablesTurnover ratio of receivables in Excel.
The factor of turnover of receivables shows the rate of conversion of goods sold into the money supply. Formula by balance, calculation of the indicator in days.
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).
coefficient-pair-correlationCoefficient of pair correlation in Excel.
The correlation coefficient (the paired correlation coefficient) allows us to discover the interconnection between the series of values. How to calculate the coefficient of pair correlation? The construction of the correlation matrix.
coefficient-variation-in-excelHow to find Coefficient of Variation in Excel.
The coefficient of variation helps to compare the expected return on assets and the risk. The indicator is useful for financial analysts.
financial-model-enterpriseExample of construction the financial model of the enterprise in Excel.
Construction of financial model: order, features, examples of tables with calculations and formulas. Details on drawing up an investment plan, forecasting incomes and expenses.
swot-analysis-exampleSWOT analysis: the weak and strong sides of the enterprise in Excel example.
How is the SWOT analysis performed at the enterprise: highlighting strengths and weaknesses, opportunities and threats, ranking elements using matrices, compiling a problematic field.
labor-force-participation-rateLabor Force Participation Rate: application and calculation in Excel.
The coefficient of labor participation is most often used when calculating salaries for employees who work as contractors. How to calculate KTU: a formula, a table with increasing and decreasing criteria.
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.
1 2 3 4 5 6 7

en ru