Excel | Tag
Here you can find free templates tagged with excel. These templates will hopfully help you to do a faster and better job.
Here you can download free code that gives you two examples of how a FOR loop can be used for programming in Excel and VBA.
Forecasting with exponential smoothing and trend adjustment is a free template to make a sale forecast by exponentially smoothing the demand in the previous period and make a trend adjustment.
Forecasting with regression analysis and seasonal adjustment is a free template to make a sales forecast by performing a regression analysis on the independent variable time and the dependent variable demand or sales and adjust this forecast for seasonal fluctuations.
Forecasting with weighted moving average is a free template to make a sales forecast using a 3-month weighted moving average of the previous three months sales.
Household budget is a free template to create a home budget of income and expenditure in a household per month during one year. In this template for home budget, you can set your budget for income and expenditure month by month and the actual outcome when the month is over to do a variation analysis.
Here you can download free VBA code to import data from a MS SQL database to Excel by connecting to a SQL Server, open a database and run a SQL command against the database.
Here you can download free code that shows how a multidimensional array can be used in VBA code for programming in Excel.
In this workbook, we have used the concept of object-oriented programming (OOP) when we have written VBA code to perform tasks in the workbook.
Here you can download free code that shows you how a one-dimensional array can be used in VBA code for programming in Excel.
Pareto chart is a free template to organize errors, problems or defects in a transparent diagram. A Pareto chart is showing the frequency of errors, problems or defects in bars and cumulative share percentages in a graph.