# Excel | Tag

Here you can find free templates tagged with excel. These templates will hopfully help you to do a faster and better job.

## FOR loop in Excel (VBA and VB6) | Free code

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 | Free template

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 | Free template

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 | Free template

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.

## Home budget or household budget | Free template

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.

## Import data from MS SQL database to Excel (VBA and VB6) | Free code

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.

## Multi-dimensional array in Excel (VBA and VB6) | Free code

Here you can download free code that shows how a multidimensional array can be used in VBA code for programming in Excel.

## Object-oriented VBA programming in Excel (OOP and VB6) | Free code

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.

## One-dimensional array in Excel (VBA and VB6) | Free code

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 | Free template

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.

Pages: 1 2 3 4 5