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 Add-ins & Softwares

Conditional Formatting for Excel
In order to ease the analysis of specific data in your spreadsheet, you might give it a special format (for example: highlighting it), using one of the most useful tool that Microsoft Excel has, \"Conditional Formatting\", but the bad thing is that it just supports until 3 conditional levels. Well, Jabsoft, thinking of this lack, has created: Excel Conditional Formatting, an excellent addin, which allows you formatting all the cells and ranges that you need, using \"n\" conditions (in other words, all of conditions you desire)

Color Palette for Excel
Bring life, color and style to your Excel charts and reports. Color Palette for Excel will allow you to add new, brilliant and professionally selected colors to Excel and give a new and personal look to your charts and reports.

Chart Tools for Excel
Using Chart Tools for Excel, you will become convinced that it has never been so easy to handle Excel charts.

Categorizing Data for Excel
If your problem consists in categorizing or stratifying specific data of your Excel spreadsheet information, then Categorizing Data for Excel is the solution.

VehiCalc Car Loan/Lease Analyzer Home Ed
VehiCalc Car Loan/Lease Analyzer allows you to quickly calculate lease and loan payments as well as compare the true overall cost of your lease versus purchase. This will allow you to determine whether leasing truly is the better option even if the payment amount is significantly lower than borrowing. Prepared to be surprised! Want even more money saving tools? The Loan Amortization Schedules included allow you to generate flexible schedules that allow extra, skipped and varying payment amounts. Amortization Tables, a Solve for Missing Number calculator, plus dozens of financial calculators round out this offering.

QuikCalc Mortgage & Loan Manager Personal Edition
Mortgage and loan software includes the powerful Amortization Schedules Plus! feature that allows you to override, skip or add any number of payments. The Loan Management feature allows you to track actual loan terms and varying interest rates, as well as your actual payments made and projected payments. The Loan Manager also allows you to assess late fees and charges and track insurance, taxes, etc. Includes 14 different Day Count Conventions including 30/360 and Actual/Actual, plus many different Payment Types including Normal, Continually Adjusting Payments, Fixed Principal plus Interest and Interest Only.

QuikCalc Mortgage & Loan Manager Lite Edition
Mortgage and loan software includes the powerful Amortization Schedules Plus! feature that allows you to override, skip or add any number of payments. Includes 14 different Day Count Conventions including 30/360 and Actual/Actual, plus many different Payment Types including Normal, Continually Adjusting Payments, Fixed Principal plus Interest and Interest Only. Compare schedules side-by-side and see before and after results of your changes. Also includes dozens of powerful calculators as well as many reports including annual summaries.

QuikCalc Amortization Premium Edition
Mortgage and loan software includes the powerful Amortization Schedules Plus! feature that allows you to override, skip or add any number of payments. The Loan Management feature allows you to track actual loan terms and varying interest rates, as well as your actual payments made and projected payments. The Loan Manager also allows you to assess late fees and charges and track insurance, taxes, etc. Includes 14 different Day Count Conventions including 30/360 and Actual/Actual, plus many different Payment Types including Normal, Continually Adjusting Payments, Fixed Principal plus Interest and Interest Only. Also includes dozens of powerful calculators as well as many reports including annual summaries and a Solve for Missing Number Calculator. Data file backup, integrated calculator.

QuikCalc Amortization Plus! Edition
Mortgage and loan software includes the powerful Amortization Schedules Plus! feature that allows you to override, skip or add any number of payments. Includes 14 different Day Count Conventions including 30/360 and Actual/Actual, plus many different Payment Types including Normal, Continually Adjusting Payments, Fixed Principal plus Interest and Interest Only. Compare schedules side-by-side and see before and after results of your changes. Also includes access for up to 5 loans to the Premium Edition"s Loan Manager and a Solve for Missing Number Calculator. Also includes dozens of powerful calculators as well as many reports including annual summaries. Data file backup, integrated calculator. Also available in three additional versions.

Loan Payment Calculator
Loan Payment calculator software includes easy to use amortization tables and schedules that allow any interest rate, payment and compounding frequency, including accelerated payments. Includes many reports including annual summaries. See before and after comparisons of your changes. Data file backup and integrated field level popup calculator also included. Also available in three additional versions, QuikCalc Plus!

QuikCalc Amortization
Mortgage and loan software includes easy to use amortization tables and schedules that allow any interest rate, payment and compounding frequency, including accelerated payments. Includes many reports including annual summaries. See before and after comparisons of your changes.

DebtCalc Debt Elimination Planner Home Edition
Quickly add any number of debts. Whether you have two or ten debts (or even 100 for that matter), DebtCalc can handle it. The Debt Elimination Planner allows you to enter all manner of debts including loans, mortgages, credit cards and lines of credit.

DebtCalc Debt Elimination Calc Plus! Ed.
Quickly add any number of debts. Whether you have two or ten debts (or even 100 for that matter), DebtCalc can handle it. The Debt Elimination Planner allows you to enter all manner of debts including loans, mortgages, credit cards and lines of credit.

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. Department, Area and staff can be configured to suit almost any business strucure and size. Once you have set up your wage and roster frame work you can easily allocate staff to work periods to build your weekly roster and at the click of a button calculate wage costs by day and week. Standard Excel print functions are available providing flexible print formats. Using the Wage Calculator you can define your staff roster schedules and calculate your wage costs with ease.

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.

Password Page Protection Software
Password Page Protection Software allows you to add password protection to any web page. It generates password protection code which is added to the top of a web page to prevent unauthorized access. When the web page is called from the server the password protection code runs before the web page is sent to the user. Instead a password request page is displayed in the users browser. When the user submits a password it is compared to the password set in the page protection code. If they match the protected web page is sent from the server. This provides a high level of security and reliability.

MailMailer Software
MailMailer is a compact easy to use server (web) based email mailer. It is specifically designed for the small business market, not to be the biggest or most featured but to be a clean efficient contact tool helping you to send newsletters to your clients, contact your staff, send one email or many.

Form1 Builder Software
Investment Analysis Software provides the capacity to easily analyze the performance of any investment. It applies basic input variables to build an investment analysis by year. Investment performance is converted to equivalent current year values enabling the actual investment performance to be determined. Applying this approach allows comparisons to be made between different investment types. It also provides an effective means of projecting investment performance and determining the results of different investment mixes.

Loan & Bank Refund Claim Software 2008
Our software enables you to calculate the additional interest you can claim over and above the overcharges debited by your lender plus it will help you write the letter to send your lender substanting your claim for a refund check.

Five Keys To Business Success (Excel Add-Ins)
Excel add-ins provide ready made solution for forecasting, investment economics, portfolio optimization, business resource optimization and material planning.

Excel Add-ins & Training Bible Complete Collection
Combined Excel Add-ins and Excel Training Bible package. Nine Excel add-ins plus the Complete Excel Training Bible modules 101-701.

Excel Add-Ins Collection
Share Offering Memorandum pro-forma wording and layout to make it quick and easy for you to raise $1,000,000 new equity or loan capital. Save $10,000 - $25,000 on legal fees. Just add the figures and your business plan into the document provided following the guidance notes. Share subscription agreements are supplied. Help provided for non US companies how to structure an offering to secure finance. Popular with start ups, franchises, entrepreneurs and small businesses. List of capital sources supplied.

SiteMap XML Software
SiteMap XML Dynamic SiteMap Generator Software, is a php based sitemap generator for Google, RSS, HTML and Text SiteMaps. It includes a range of configurable variables to define the SiteMap type and content and can be run as an online form for Static SiteMaps or to create real time Dynamic SiteMaps that can be directly called. It is designed for ease of use, with the ability to define the desired site map type, content and settings. SiteMap XML is best suited to medium size sites of up to 5000 pages. Google is currently using XML site maps to assist the indexing process.

Site Builder Software
Site Builder Software allows you to easily build a dynamic web site with an automatically generated menu structure, auto keyword and description meta tag generation, inbuilt RSS feeds and valid XHTML coding.

Budget Compiler QuickBooks Excel
Budget Compiler QuickBooks Excel

PL Compiler MYOB Excel
The PL Complier will import and format your monthly Profit and Loss data from MYOB. 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. 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.

Investment Analysis Software
Investment Analysis Software provides the capacity to easily analyze the performance of any investment. It applies basic input variables to build an investment analysis by year. Investment performance is converted to equivalent current year values enabling the actual investment performance to be determined. Applying this approach allows comparisons to be made between different investment types. It also provides an effective means of projecting investment performance and determining the results of different investment mixes.

Form1 Builder MYSQL
With Form1 Builder MYSQL you can automatically have form submission data added to your MYSQL database. To use the MYSQL option you must have a server based MYSQL database and it must have an existing table with field names that correspond to form field names.

Form1 Builder GoldMine
With Form1 Builder GoldMine you can automatically use GoldMine"s WebImport function to add form submission data directly to your GoldMine database. It also allows you to specify the full range of GoldMine functions. This includes running duplication checks and automatic processes. Instructions for these are easily set in the form and processed when GoldMine reads the GoldMine formatted email with the form data. Use Form1 Builder GoldMine to add WebImport forms to your site.

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. The methodology used applies relationships between current data and relative indicators for future performance to produce a verifiable budget quickly and easily. This forecast and budget tool can be utilized for existing and proposed businesses, products, or services. Outputs include a 3 Year Forecast with Sensitivity Analysis, and a Budget by Month in tabular and graphical form.

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