Master classes and trainings with Excel examples

How to calculate discounts in Excel.
An example of using a data table to find the best combinations when choosing a discount for a client under certain conditions. Matrix of numbers with conditional formatting. Template with sample analysis and what if, download free.

Analysis of the investment project to download in Excel.
A detailed calculation of the investment project in Excel will help novice businessmen determine profitability, profitability index, internal rate of return and simulate risks.

Searching of the value in a range Excel table in columns and rows.
Optimal search analysis for an approximate value in the range of the data matrix. Creation of a tool for planning and setting goals according to the table with the possibility of a massive search for the most optimal indicators relative to the original value.



Calculation of break-even point with examples in Excel.
The break-even point model allows to assess the economic state of the enterprise, its financial stability. Calculate the critical level and build a schedule, will help with examples of ready solutions that you can download for free.

Working with Excel array formula examples.
Examples of using one-dimensional and two-dimensional arrays of functions. Advantages of using functions in an array. Description of the syntax of formulas.

Calculation of production costs in Excel.
A ready-made costing template with a detailed description of the formulas allows you to automate the planned calculation. Step-by-step calculation of the price of finished goods and products.

How to create a sales plan in Excel with a forecast graph.
Sales plan for the month and an example of its compilation with detailed step-by-step instructions. Detailed plan for sections with pictures and descriptions. We analyze the fulfillment of the forecast indicators.

Table of expenses and incomes of the family budget in Excel.
Create a family budget plan in the Excel spreadsheet and its advanced customization using formulas. And also to download the ready template - a personal budget for a month.

Free inventory control in Excel – there is the program without macros and programming.
How to organize warehouse accounting using formulas: tips, secrets, formulas and functions. Independently do directories, income, expenditure and turnover sheets. Automate the filling.