Link to Excel Financial Analysis — forecasts, dynamic charting

Excel Financial Analysis — forecasts, dynamic charting

This is a financial analysis control screen showing the company’s sales and financial results. The target group of such solutions in Excel is the management, who can move the company forward by making adequate fact based decisions. The attachment looks at the sales pillars by...

Link to SUMAVGIN  Excel VBA  — average and sum of numbers without a single cell selection in Excel

SUMAVGIN Excel VBA — average and sum of numbers without a single cell selection in Excel

English: This is an Excel function written in VBA. It helps you to calculate the average or the sum on numbers,that  are located in non-consecutive cells. The function is called SUMAVGIN (Vektor, Step, Funk). In the Vektor argument  the user selects the column or row region,...

Link to Population forecast for Bulgaria according to NSI (Excel VBA)

Population forecast for Bulgaria according to NSI (Excel VBA)

The population of Bulgaria according to NSI until 2070 — graphical expression of the forecast by years (dynamic charting) I had a wish and I did it. This is a control screen in Excel, through which you can follow the forecast made by the National...

Link to Date and time of cell change in Excel TENTRY () function

Date and time of cell change in Excel TENTRY () function

A feature created in Excel VBA that will report a change in the contents of the cell, showing the day and time of the change. Pressing Enter would also update the value of the cell, since the code shown below references the current system time....

Forecast tool linear trends 0.1 free VBA Excel

Ексел ВБА позволяващ на потребителя да прави прогноза за бъдещ период базирана на исторически данни