Our Sponsors

Free Online Games
Play Your Favorite Games Free. Arcade, Card, Action Games & More. Over 2800 games to choose from!
www.freegamesfactory.com


Ready To Run Excel Models
37 finance & statistic Excel programs with VBA source code.
www.excel-modeling.com


Super Online Shopping Center
Your prime source for finding all the greatest deals on items and goods online.
www.buy.sc


Buy Domains?
Offer premium domain names for different industries and interests.
www.thedomaincity.com


Excel Consulting Services
Spreadsheet Design, Custom Macro, Data Mining and VBA Programming.
www.excel-business-solutions.com

Excel Finance Templates

Profit Loss Report Spreadsheet
The Forecast and Budget Builder Excel is a streamlined tool for developing a 3 year business forecast and a 12 month budget. It requires minimal inputs and generates Optimistic to Pessimistic forecasts for your business. From your forecasts a 12 month master budget is built. You then have the capacity to refine this budget as required.

Forecast and Budget Builder Excel
The Forecast and Budget Builder Excel is a streamlined tool for developing a 3 year business forecast and a 12 month budget. It requires minimal inputs and generates Optimistic to Pessimistic forecasts for your business. From your forecasts a 12 month master budget is built. You then have the capacity to refine this budget as required.

Budget Tool Business Excel
The Budget Tool Business Excel provides an effective means to generate a budget for up to five years. Full flexibility allows you to add Revenue, Variable Cost, and Fixed Cost categories and lines to suit any business. Operation is via an easy to use toolbar and function buttons. The budget can be displayed in any combination of month, quarter, or year. Change indicators provide means to adjust revenue and costs year on year with initial default values applied to minimize input requirements and simplify use. Full what if and sensitivity analysis is available by varying the Change indicators. Budgets can be freely formatted for printing and graphing. The Budget Tool Business is suitable for both existing and proposed businesses.

Budget Compiler QuickBooks Excel
The Budget Compiler will apply and format your Profit and Loss data from QuickBooks. Using this information it will compile a flexible Excel Profit and Loss report allowing you to select the amount of detail displayed and use the data for performance review and budget formulation. The created budget can be imported to the Quickbooks budget or used as a standalone tool. Applying your existing data in a flexible and easy to read layout with the capacity to automate budget creation provides substantial benefits. These include an improved understanding of business operations, enhanced budget development, and significant time saving in performance reviews and budget creation. Display view options include by Month, Quarter, and Full Year with Current Year, Last Year, and Budget values. Charts display both Actual and Budget values.

Universal Pricing Calculators
The Universal Pricing Excel Spreadsheets calculate price - demand relationships and uses standard accounting formula to give you the exact price which will produce the maximum profit for any product. The user supplies two datasets, demand1@price1 and demand2@price2. The program calculates elasticity of demand (change in demand for $1 change in price) and the price which yields the maximum profit.

Savings & Investment Planner
Savings & Investment Planner provides the perfect financial assistance if you want to seriously improve your personal finances. Savings template. Personal expenses spreadsheet to enter all your expenses as they occur. Use + values for really essential expense items and values for non essential expenses. Excel works out the exact amounts of essential/non essential expenses, monthly savings if you eliminate all non essential costs and the percentage spent on non essentials.

QuickValue PRO 2008
QuickValue PRO 5.0 provides all our company valuation spreadsheets plus eight free bonus Excel Add-in files to make your Excel 100 times more productive. Quick Value helps you create valuations quickly and easily. The following is a partial summary:

Quick Five Year Financial Plans Plus Ratios
FastPlan provides a complete five year financial plan using Microsoft Excel to create balance sheets, income statements and cash flow forecasts. Also included in the CD edition are our Company Valuation spreadsheets using multiple ratios to obtain valuations, plus a complete Agreement to Buy or Sell a Business (legal Agreement template Word file).

Lease/Loan Organizer
Loans & Lease Organizer will manage up to 100 lease/loan accounts into combined month end reports. Combines current period payments of principal and interest, provides outstanding balances, months remaining, payments remaining and asset book values (S/L or DDB depreciation).

Investment-Calc 2008 - NPV - IRR Solutions
Investment Appraisal (Monte Carlo investment outcome simulation). This spreadsheet will run 1,000 forecasts combining up to 80 variables of any investment project to predict the most probable 10 year pre-tax profits, cash flows, NPV, IRR and ROIC.

Instant Balance Sheets Excel Templates
Instant Balance Sheets provides 12 monthly linked balance sheet templates which always balance. You can quickly and easily create 12 month profit & loss schedules and cash flows (source and application of funds) which automates all the figures in your 12 monthly balance sheets. Ideal for when you want to turn your monthly profit and loss forecasts or last 12 months data into monthly and year end balance sheets and cash flows.

INVESTMENT-CALC PRO 2008 IRR & NPV Solutions
Investment Appraisal (Monte Carlo investment outcome simulation). This spreadsheet will run 1,000 forecasts combining up to 80 variables of any investment project to predict the most probable 10 year pre-tax profits, cash flows, NPV, IRR and ROIC.

Google Spreadsheets Excel Templates Collection
25 Excel files in total. 23 upload and run in Google Docs Spreadsheets, plus 2 Cash Flow Forecasting with file sizes that are greater then the Google Docs limit which enables larger data volumes.

Funding Plan PRO 10 Year Plan for Excel
Funding Plan PRO provides a complete ten year financial plan incorporating monthly fixed asset schedules with depreciation spreadsheets, monthly and three monthly sales forecasts for multi products, forecast expenses, share capital inputs, three loan notes providing monthly interest charges and declining loan balances, plus working capital forecasts to generate five annual and monthly balance sheets, income statements and cash flow forecasts with supporting financial ratios and five years financial summary overview.

Fixed Asset Accounting With Excel
Our fixed asset accounting workbooks provide all with all you need to manage and keep track of up to 10,000 asset records in Excel plus depreciation and book values. Each asset is defined by location (100 possible), asset class (100 possible) and depreciation months and salvage percentage.

Recent News

10/8/2008
To provide easy and convenient access to our site, we have transitioned to a new layout. If you prefer to view the classic version, please click the link below.

Classic View





regression.jpg







option.jpg
Excel VBA Basic Tutorial Series  
 
Excel VBA Basic Tutorial Series 1  
 
Creating Your First Macro  
In this sub section, we will show you how to create your first macro (VBA program). We will use the world classic "Hello World!" example.  
 
Recording a Marco  
In this example, we will record a macro that sets the cell background color to light yellow. 
 
See the Recorded Syntax

Before we run the marco, let's look into the syntax. 
 
Run the Recorded Marco  
Run the recorded macro in the worksheet. 
 
Modules and Procedures and Their Scope  
A module is a container for procedures as shown in our prior examples.  A procedure is a unit of code enclosed either between the Sub and End Sub statement or between the Function and End Function statements.

 

Calling Sub Procedures and Function Procedures  
There are two ways to call a sub procedure.  This example shows how a sub procedure can be called by other sub procedures.... 
 
Passing Argument by Value or by Reference

If you pass an argument by reference when calling a procedure, the procedure access to the actual variable in memory.  As a result, the variable's value can be changed by the procedure.

 
Excel VBA Basic Tutorial Series 2  
 
Objects and Collections

Objects are the fundamental building blocks of Visual Basic.  Anobject is a special type of variable that contains both data and codes.  A collection is a group of objects of the same class.  The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and Range.

 
Workbook and Worksheet Object

A workbook is the same as an Excel file.  The Workbook collection contains all the workbooks that are currently opened.  Inside of a workbook contains at least one worksheet.

 
Range Object and Cells Property

Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.  We will show you some examples on how Range object can be used.

Methods and Property

Each object contains its own methods and properties.  A Property represents a built-in or user-defined characteristic of the object.  A method is an action that you perform with an object.

 
Assigning Object Variables and Using Named Argument

Sometime a method takes more than one argument.  For example, the Open method for the Workbook object, takes 12 arguments.

 
Excel VBA Basic Tutorial Series 3  
 
Objects and Collections

Objects are the fundamental building blocks of Visual Basic.  An object is a special type of variable that contains both data and codes.  A collection is a group of objects of the same class.  The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and Range.

 
Workbook and Worksheet Object

A workbook is the same as an Excel file.  The Workbook collection contains all the workbooks that are currently opened.  Inside of a workbook contains at least one worksheet.

 
Range Object and Cells Property

Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.  We will show you some examples on how Range object can be used.

 

Methods and Property

Each object contains its own methods and properties.  A Property represents a built-in or user-defined characteristic of the object.  A method is an action that you perform with an object.

 
Assigning Object Variables and Using Named Argument

Sometime a method takes more than one argument.  For example, the Open method for the Workbook object, takes 12 arguments.

Excel VBA Simulation Basic Tutorial 101

 

Creating and Managing Array

This is an essential skill for creating a simulation.  Topics in this section cover declare an array, resize an array, manage dynamic array, create multi-dimensional array, and find the array size.

 

Decision Structure - IF and Select Case

Contains tutorial using If...Else, If...ElseIf, and Select Case statements.

 

Loop Structure - For...Next and Loops

Provides examples on all the loop structures: For...Next with Step, Do...While...Loop, So Until...Loop, and etc.

 

Sorting Numbers in an Array

This tutorial shows how to call a sort sub procedure, passes the array to it, and returns a sorted array.

 

Finding Max and Min in Array

Extract the maximum and the minimum values in an array using sorting method.

 

Double Sorting - The Secret of Resampling Without Replacement

This example shows how to derive unique random values by sorting one array based on another array.

 

 

Simulation Basic Tutorial Series

Excel VBA Simulation Basic Tutorial 102

 

Random Number and Randomize

One of the most essential 'Must Know' in simulation.

 

Standard Deviation and Mean

Two of the mostly used statistic estimates in action.

 

Skewness and Kurtosis

Second tier statistic estimates.

 

Percentile and Confidence Interval

Compute the simulated values at a specific percentile.

 

Profitablity

Compute the probability at a specific value (or profit).

 

Creating a Histogram

A tutorial on how to create a histogram by passing array into the histogram sub procedure and returns the frequency distribution from the array.

 

 

Excel VBA Statistics and Math

 

Finding Median

Compute the median from an array

 

Generate Random Number From Uniform Distribution

Generate uniform random number within a range.

 

Sum Number in an Array

Sum up number in a array using loop.

 

Compute Factorial

Compute binomial coefficient.

 

Binomial Coefficient

Compute the probability at a specific value (or profit).

 

Cumulative Standard Normal Distribution

Compute the probabilty from a standard normal distribution. 

Excel VBA Basic Tutorial Series

Excel VBA Basic Tutorial Series 1

Creating Your First Macro
In this sub section, we will show you how to create your first macro (VBA program). We will use the world classic "Hello World!" example.

Recording a Marco
In this example, we will record a macro that sets the cell background color to light yellow.

See the Recorded Syntax
Before we run the marco, let's look into the syntax.

Run the Recorded Marco
Run the recorded macro in the worksheet.

Modules and Procedures and Their Scope
A module is a container for procedures as shown in our prior examples.  A procedure is a unit of code enclosed either between the Sub and End Sub statement or between the Function and End Function statements.
 
Calling Sub Procedures and Function Procedures
There are two ways to call a sub procedure.  This example shows how a sub procedure can be called by other sub procedures....

Passing Argument by Value or by Reference
If you pass an argument by reference when calling a procedure, the procedure access to the actual variable in memory.  As a result, the variable's value can be changed by the procedure.

Excel VBA Basic Tutorial Series 2 

Objects and Collections
Objects are the fundamental building blocks of Visual Basic.  Anobject is a special type of variable that contains both data and codes.  A collection is a group of objects of the same class.  The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and Range.

Workbook and Worksheet Object
A workbook is the same as an Excel file.  The Workbook collection contains all the workbooks that are currently opened.  Inside of a workbook contains at least one worksheet.

Range Object and Cells Property
Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.  We will show you some examples on how Range object can be used.
Methods and Property
Each object contains its own methods and properties.  A Property represents a built-in or user-defined characteristic of the object.  A method is an action that you perform with an object.

Assigning Object Variables and Using Named Argument
Sometime a method takes more than one argument.  For example, the Open method for the Workbook object, takes 12 arguments.

Excel VBA Basic Tutorial Series 3

Objects and Collections
Objects are the fundamental building blocks of Visual Basic.  An object is a special type of variable that contains both data and codes.  A collection is a group of objects of the same class.  The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and Range.

Workbook and Worksheet Object
A workbook is the same as an Excel file.  The Workbook collection contains all the workbooks that are currently opened.  Inside of a workbook contains at least one worksheet.

Range Object and Cells Property
Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.  We will show you some examples on how Range object can be used.
 
Methods and Property
Each object contains its own methods and properties.  A Property represents a built-in or user-defined characteristic of the object.  A method is an action that you perform with an object.

Assigning Object Variables and Using Named Argument
Sometime a method takes more than one argument.  For example, the Open method for the Workbook object, takes 12 arguments.
Excel VBA Simulation Basic Tutorial 101
 
Creating and Managing Array
This is an essential skill for creating a simulation.  Topics in this section cover declare an array, resize an array, manage dynamic array, create multi-dimensional array, and find the array size.
 
Decision Structure - IF and Select Case
Contains tutorial using If...Else, If...ElseIf, and Select Case statements.
 
Loop Structure - For...Next and Loops
Provides examples on all the loop structures: For...Next with Step, Do...While...Loop, So Until...Loop, and etc.
 
Sorting Numbers in an Array
This tutorial shows how to call a sort sub procedure, passes the array to it, and returns a sorted array.
 
Finding Max and Min in Array
Extract the maximum and the minimum values in an array using sorting method.
 
Double Sorting - The Secret of Resampling Without Replacement
This example shows how to derive unique random values by sorting one array based on another array.
Simulation Basic Tutorial Series
Excel VBA Simulation Basic Tutorial 102
 
Random Number and Randomize
One of the most essential 'Must Know' in simulation.
 
Standard Deviation and Mean
Two of the mostly used statistic estimates in action.
 
Skewness and Kurtosis
Second tier statistic estimates.
 
Percentile and Confidence Interval
Compute the simulated values at a specific percentile.
 
Profitablity
Compute the probability at a specific value (or profit).
 
Creating a Histogram
A tutorial on how to create a histogram by passing array into the histogram sub procedure and returns the frequency distribution from the array.
Excel VBA Statistics and Math
 
Finding Median
Compute the median from an array
 
Generate Random Number From Uniform Distribution
Generate uniform random number within a range.
 
Sum Number in an Array
Sum up number in a array using loop.
 
Compute Factorial
Compute binomial coefficient.
 
Binomial Coefficient
Compute the probability at a specific value (or profit).
 
Cumulative Standard Normal Distribution
Excel and VBA Examples