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 Templates

Exchange Rates for Excel
Exchange Rates for Excel is a practical tool in which you can update automatically through Internet the currency exchange rates into your Excel spreadsheets. No more manual and tedious updates or risk of using no updated data. Exchange Rates for Excel is like any other Excel function, when the function is inserted in any cell or inside a formula, the add-in automatically refreshes the exchange rates with the latest data. Exchange Rates for Excel includes a wizard to help you to use the tool. Additionally it includes different refreshing data options and reports with the exchange rates and currency codes.

Profit Contribution Breakdown Excel
Profit Contribution Breakdown allows you to identify the level of surplus/profit generated by components of your business. By applying relative indicators to reflect the amount of variable and fixed expense (resource) a component consumes surplus and contribution levels are calculated. This component performance is combined with indicators for future potential and business ability to identify areas that will maximize current and future performance. Summary recommendations are provided for each breakdown and results presented in graphical and tabular form. This business tool can analyze any chosen component of an overall business or product line. Default breakdown is five Customer Segments and five Product Groups.

Product and Supplier Profitability Excel
Determine your profit by product and supplier. Product and Supplier Profitability allows you to identify the true costs associated with your products. It does this by considering initial costs (purchase, transport, receiving, and reject), on-going costs (storage, overheads), as well as finance and customer return costs. Calculations are presented in both Form and Table view for effective display. Supplier/Product profiles are created in Form view and cost analysis by unit and profile applied. Sensitivity functions allow you to test variations for Stockturn and Customer Returns.

Pricing and Breakeven Analysis Excel
Pricing and Breakeven Analysis uses break even analysis to calculate your current business break even point using revenue, variable, and fixed cost inputs. This is combined with price elasticity (estimates for price and sales volume variations) to produce revenue and surplus (profit/loss) forecasts by price. The model determines the Optimum Pricing to maximize your surplus and can be applied to new or established businesses, product/service lines, or individual items.

Instant Quote Professional
Instant Quote Professional, now powered by MS Office Access 2007, is a feature rich software application designed for Any business that requires quotes and invoices. Instant Quote Pro takes the burden out of quoting and invoicing, and allows you to easily create them in seconds! With this software, you will be highly organized.

Sales Leads 2008 for Excel 2007
Our Sales Leads 2008 CD for Excel 2007 supplies over 10 million sales contacts and addresses sorted in to 51 States.Excel 2007 has expanded capacities from 65,000 maximum rows in Excel 2003 to one million, and this enables Excel 2007 to provide this huge store of of sales leads.

Quick 3 Year Plan
Three year cash flow plan helps you combine monthly forecasts quickly easily and convert into cash flows Forecasting calculations are so easy with Excel. Excel links spreadsheets together so that you can filter and sort records just anyway you want.

Monte Carlo Forecasting Sims
The Sales & Profit Forecasting Simulator will accurately predict your company sales and profits by combining up to 15 different product or profit center estimates of incoming sales leads, costs per lead, leads conversion rates, price yields, gross profit margins, G&A recovery rates and their upper and lower limits. Forecasts probabilities achieving any sales or profit targets using Monte Carlo simulations.

Inventory Manager PRO For Excel
Inventory Manager provides manufacturing and operations decision support for inventory management and scheduling with Excel. Maximum 10,000 inventory items capacity. Determine the best inventory re-order schedules (includes safety stocks), optimize the lowest cost re-order quantities, establish ordering frequencies and lot sizes, receive alerts when you need to re-order, includes seasonality, trends and forecasting, quality control inventory analysis. Improve efficiencies and enhance customer service with INVENTORY MANAGER PRO.

Financial Ratios with Excel
Windex calculates all major financial ratios in Excel. Calculates these financial ratios from balance sheet, income statement and cash flow templates provided.

FastPlan 2008 Five Year Company Forecasting
FastPlan version 9.6 provides a complete five year financial plan incorporating monthly fixed asset schedules with depreciation spreadsheets, 60 x 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 plus all core ratios and five years financial summary overview.

FASTPLAN Version 9.6
FastPlan version 9.6 provides a complete five year financial plan incorporating monthly fixed asset schedules with depreciation spreadsheets, 60 x 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.

Excel Costing 2008
Standard costs, activity based costs, overhead cost recovery ratios, cost drivers, absorption costs and cost allocation ratios in Excel. Complete range of product costing formula with eight ready to use costing templates iin the first workbook with Excel costing formula provide unit costs for pricing and profit recovery calculations.

Excel Budgeting & Financial Forecasting
Master Budgets 4.6 helps you combine up to 10 department budgets quickly and easily and tracks actuals and variances. Create seperate 12 monthly budgets and Excel consolidates to a Year to Date summary tracking actuals vs budgets. Cash Flow Forecasting 2008.xls will convert any list of AR-AP accounts into a daily and calendar month cash flow forecast up to 150 days ahead from users starting date. Import accounts payable and receivable into this Excel workbook from any accounting package and generate an instant 150 day cash flow forecast. Manage slow payers and accounts payable more effectively with closer identification of cash flow forecasts.

Complete Excel Templates Collection
The Complete Excel Templates 2008 Collection provides 150 business finance spreadsheets, Excel add–ins and Excel Learning Modules plus nine Risk Analysis Forecasting spreadsheets which will help you manage financial risks and set goals quickly and effectively. Investment-Calc 2008 spreadsheets for Present values and internal rate of return of periodic cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, present value of periodic investments. The new 2008 edition includes acquisition synergy net present values, cost of capital, terminal (to infinity) net present values plus an updated Quick Guide to Investment Decisions.

Complete Excel Collection - 2008 Edition
Complete Excel 2008 Collection - Upgrade/

Cash Flow & Liquidity Forecasting 2008
150 days Cash flow control and forecasting in Excel plus liquidity forecasting and goal setting. Export your current accounts receivable and payable from your accounting software into this Excel workbook and you instantly create a complete analysis of Late (receivable) and Overdue (payable) accounts together with daily, weekly and monthly summaries of total cash flow forecasts and closing cash balances.

Budgeting Spreadsheets for Excel
Our complete collection of our Budgeting workbooks provides 50 business finance spreadsheets plus 9 Excel Add-ins and full Excel Training Course to help you create, control and value your budgets quickly and easily. The following is a partial summary: Master Budgets 4.6 helps you combine up to 10 department budgets quickly easily

Wage Calculator Excel
The Wage Calculator allows you to define roster schedules and will automatically calculate associated wage costs by staff, Area, and Department for each day, and the week. It uses a base wage and up to six additional wage loadings to determine the wage structure. Wage classifications, and staff can be freely added. The roster format is by Department and Area, with two staff work periods per day to accommodate split shifts.

Shift Scheduler Continuous Excel
The Shift Scheduler will build a roster structure to your specifications, allocate staff automatically, and generate a printable roster, all at the click of a button. It is compact and user friendly allowing you to add staff and shifts (maximum 150) with ease. Default values for continuous shifts mean that the only shift data required is the start date/time and length for the first shift, everything else is automated. For non-continuous or varying shifts you have the capacity to overwrite default data and structure shift settings to suit your specific requirements.

Profit Contribution Breakdown Excel
Profit Contribution Breakdown allows you to identify the level of surplus/profit generated by components of your business. By applying relative indicators to reflect the amount of variable and fixed expense (resource) a component consumes surplus and contribution levels are calculated. This component performance is combined with indicators for future potential and business ability to identify areas that will maximize current and future performance.

Product and Supplier Profitability Excel
Determine your profit by product and supplier. Product and Supplier Profitability allows you to identify the true costs associated with your products. It does this by considering initial costs (purchase, transport, receiving, and reject), on-going costs (storage, overheads), as well as finance and customer return costs. Calculations are presented in both Form and Table view for effective display. Supplier/Product profiles are created in Form view and cost analysis by unit and profile applied. Sensitivity functions allow you to test variations for Stockturn and Customer Returns.

Pricing and Breakeven Analysis Excel
Pricing and Breakeven Analysis Excel will determine the impact of a price change on your business. It calculates current breakeven points using revenue, variable cost, and fixed cost inputs. These are combined with estimates for price and sales volume variations to produce revenue and surplus (profit/loss) forecasts by price. The model determines the Optimum Pricing to maximize your surplus and can be applied to new or established businesses, product/service lines, or individual items.

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
1