# Sitemap of ExcelTable.com

Content of web pages of ExcelTable.com site. Structure and organization of website sections. Enhanced navigation menu of the website. Convenient information search by categories.

## Examples of spreadsheet by categories

Master-class

Free inventory control in – there is the program without macros and programming.

The table of expenses and incomes of the family budget in .

How to create a sales plan in with a forecast graph.

Calculation of production costs in .

Working with array formula examples.

Calculation of break-even point with examples in .

The searching of the value in a range table in columns and rows.

Analysis of the investment project to download in .

How to calculate discounts in .

The table of expenses and incomes of the family budget in .

How to create a sales plan in with a forecast graph.

Calculation of production costs in .

Working with array formula examples.

Calculation of break-even point with examples in .

The searching of the value in a range table in columns and rows.

Analysis of the investment project to download in .

How to calculate discounts in .

VBA Macros

Analyses and reports

ABC and XYZ analysis in with example of calculation.

There is calculation of KPI in the : examples and formulas.

The calculation of credit in and the formula of monthly payments.

Regression and correlation analysis in : instruction execution.

Goal Seek selection of parameters and examples of its use.

Download template of the investment project analysis in .

Labor Force Participation Rate: application and calculation in .

Subtotals in with examples of functions.

Forecasting sales in and time series analysis algorithm.

SWOT analysis: the weak and strong sides of the enterprise in example.

Coefficient of variation: formula and calculation in . Interpretation of results.

Calculating IRR in using functions and chart.

Management accounting in with examples.

BCG Matrix: construction and analysis in with example.

Factor and variance analysis in with automated calculations.

Working capital ratio for inventories availability.

Calculation of the moving average in and forecasting.

Transport task in with example and description.

Macro analysis using pest analysis in with example.

Current assets to equity ratio in .

Return On Equity – ROE in .

Time series analysis and forecasting in with examples.

Sensitivity analysis of the investment project download in .

Solving equations in using the Cramer and Gauss iterations method.

The example of construction the financial model of the enterprise in .

The data consolidating in with examples of usage.

The program for calculation the seniority of work in download.

The turnover ratio of receivables in .

Budgeting of the enterprise in with discounts.

The calculation of the effective interest rate on loan in .

The coefficient of pair correlation in .

There is calculation of KPI in the : examples and formulas.

The calculation of credit in and the formula of monthly payments.

Regression and correlation analysis in : instruction execution.

Goal Seek selection of parameters and examples of its use.

Download template of the investment project analysis in .

Labor Force Participation Rate: application and calculation in .

Subtotals in with examples of functions.

Forecasting sales in and time series analysis algorithm.

SWOT analysis: the weak and strong sides of the enterprise in example.

Coefficient of variation: formula and calculation in . Interpretation of results.

Calculating IRR in using functions and chart.

Management accounting in with examples.

BCG Matrix: construction and analysis in with example.

Factor and variance analysis in with automated calculations.

Working capital ratio for inventories availability.

Calculation of the moving average in and forecasting.

Transport task in with example and description.

Macro analysis using pest analysis in with example.

Current assets to equity ratio in .

Return On Equity – ROE in .

Time series analysis and forecasting in with examples.

Sensitivity analysis of the investment project download in .

Solving equations in using the Cramer and Gauss iterations method.

The example of construction the financial model of the enterprise in .

The data consolidating in with examples of usage.

The program for calculation the seniority of work in download.

The turnover ratio of receivables in .

Budgeting of the enterprise in with discounts.

The calculation of the effective interest rate on loan in .

The coefficient of pair correlation in .

Inserting the current date in different ways.

Taking into account time in : addition and subtraction inequality between hours and minutes.

The Function VLOOKUP in for for beginners.

The Function «IF» in with a few examples of conditions.

Logical functions in with the examples of their use.

Examples of using SUMIF function with some criteria in .

Random number generator in functions and data analysis.

COUNTIF function in and examples of using it.

How to round numbers in large and smaller side of the .

How to use the VLOOKUP function in two tables .

How to find the arithmetic mean in ?.

The concatenate function in : syntax and usage examples.

Functions for working with a matrix in .

Functions for working with text in .

Taking into account time in : addition and subtraction inequality between hours and minutes.

The Function VLOOKUP in for for beginners.

The Function «IF» in with a few examples of conditions.

Logical functions in with the examples of their use.

Examples of using SUMIF function with some criteria in .

Random number generator in functions and data analysis.

COUNTIF function in and examples of using it.

How to round numbers in large and smaller side of the .

How to use the VLOOKUP function in two tables .

How to find the arithmetic mean in ?.

The concatenate function in : syntax and usage examples.

Functions for working with a matrix in .

Functions for working with text in .

The work in excel with formulas and tables for dummies.

Cost of production with the example of calculation in .

Add and take the percent from number in with the examples.

How to calculate margin and extra charge in .

The way of calculating the percentage from the sum of numbers in .

Absolute link in fixes the cell in the formula.

How to raise a number to a power in using the formula and operator.

Finding of the value in the column and the row of the table.

How to find an error in the table according to the formula?.

Cost of production with the example of calculation in .

Add and take the percent from number in with the examples.

How to calculate margin and extra charge in .

The way of calculating the percentage from the sum of numbers in .

Absolute link in fixes the cell in the formula.

How to raise a number to a power in using the formula and operator.

Finding of the value in the column and the row of the table.

How to find an error in the table according to the formula?.

Merging and splitting data into cells in with formatting.

Protecting cells from value or format changing and editing in .

4 methods to change comma to decimal point in .

How to copy a table in by saving the format cells.

Conditional formatting training in with examples.

Comparison of two tables in for finding matches in columns.

How to find Identifying Duplicate values in column?.

The conversion of the number in the currency format on the condition.

Three ways how to transpose the table to .

How to hide or display rows and columns in .

The transformation of the text to a number in the cell.

How to make a selection in from the list with conditional formatting?.

Filling cells in by the signs after decimal separator.

Transfer of data from one table to another one.

Protecting cells from value or format changing and editing in .

4 methods to change comma to decimal point in .

How to copy a table in by saving the format cells.

Conditional formatting training in with examples.

Comparison of two tables in for finding matches in columns.

How to find Identifying Duplicate values in column?.

The conversion of the number in the currency format on the condition.

Three ways how to transpose the table to .

How to hide or display rows and columns in .

The transformation of the text to a number in the cell.

How to make a selection in from the list with conditional formatting?.

Filling cells in by the signs after decimal separator.

Transfer of data from one table to another one.