Free Excel Programs Download

Lotto Number Generator

This lotto numbers generator allows you to choose your own number set. Two scroll bars are available – one controls the number of lotto numbers (ex: 6) and the other controls the number of population (ex: 54). This program demonstrates “sampling without replacement”.

Normal Distribution Random Number Generator

This random numbers generator populates random numbers from a normal probability distribution. Histograms are also generated for each of the generated distributions based on the parameters. It is a demonstration of statistical simulation.

European Option Pricing Models With Greeks

This option pricing calculator builds financial functions using the Black-Scholes option model. Option "greeks" are produced. It is a demonstration of customized functions.

Excel Consulting and Data Services Projects

Projects Sample Directory Map

Quick Contact

At Excel Business Solutions we offer Excel consulting, database marketing, data mining and forecasting, and data management services. In this section, we provide examples on some of the Excel and database programming projects that our Excel consultants have done in the past. These demonstrations are modified and simplified from the original projects and are provided for illustrative purposes only. These examples show some of the possibilities on how your business intelligence can be enhanced by Excel programming, data analysis and reporting through our Excel consulting services.

A very powerful feature of Excel VBA function is its ability to interact with different database servers and databases (MS-Access, SQL Server, Oracle, Sybase and etc). In this database programming example, it demonstrates the data extracting process from a MS-Access database and presents them in a spreadsheet report through ActiveX Data Objects (ADO) programming.

Database Programming and Reporting

Beside the basic Excel data management and reporting tools (which are useful, but sometimes limited), Excel offers a more flexible reporting function through Excel VBA programming. This reporting automation example demonstrates how the raw data can be extracted and populated into different reports.

Reporting Automation

Quotation Calculator

Quotation systems and calculators are being used in many different businesses (insurance, real estate, investment, pension, technology and other types good and services). This quotation calculator example demonstrates how a complex calculator can be generated using Excel. You can also check out our online interactive examples of Mortgage Calculator, Quotation Tool, and Query Tool.

Ever ran out of Excel built-in functions to use? Through Excel VBA programming, customized functions can be built. This customized function example demonstrates the use of user-defined Excel functions with context-sensitive help. The Black-Scholes option pricing model is used for this example. Check to see how our consulting services can meet your needs.

Customized Functions

Simulation Programming and Analysis

Simulations programming is another popular use of Excel. A Monte Carlo algorithm is often used to find solutions to mathematical problems (which may have many variables) that cannot easily be solved. This Monte Carlo simulation section illustrates two examples on how Excel VBA can be utilized for building simulation models. Hydraulic engineering and market analysis examples are demonstrated.

Data Entry Forms

MS-Access is a relational database management system from Microsoft which combines the relational Microsoft Jet Database Engine with a graphical user interface. It is a wonderful tool for building data entry forms for databases with many-to-many relationship tables. This section provides such an example.

A Monte Carlo algorithm is often a numerical Monte Carlo method used to find solutions to mathematical problems (which may have many variables) that cannot easily be solved, for example, by integral calculus, or other numerical methods. For many types of problems, its efficiency relative to other numerical methods increases as the dimension of the problem increases. Or it may be a method for solving other mathematical problems that relies on (pseudo-)random numbers. Monte Carlo methods are useful for modeling phenomena with significant uncertainty in inputs, such as the calculation of risk in business. Monte Carlo methods have also proven efficient in solving coupled integral differential equations of radiation fields and energy transport, and thus these methods have been used in global illumination computations which produce photorealistic images of virtual 3D models, with applications in video games, architecture, design, computer generated films, special effects in cinema, business, economics and other fields. The advantage Monte Carlo methods offer increases as the dimensions of the problem increase.

Microsoft ActiveX Data Objects (ADO) is a set of Component Object Model objects for accessing data sources. It provides a layer between programming languages and OLE DB (a means of accessing data stores, whether they be databases or otherwise, in a uniform manner), which allows a developer to write programs which access data, without knowing how the database is implemented. You must be aware of your database for connection only. No knowledge of SQL is required to access a database when using ADO, although one can use ADO to execute arbitrary SQL commands.

The Black–Scholes model is a mathematical model of the market for an equity, in which the equity's price is a stochastic process. Its PDE is an equation which (in the model) the price of a derivative on the equity must satisfy. The Black–Scholes formula is the result obtained by applying the Black-Scholes PDE to European put and call options. The formula was derived by Fischer Black and Myron Scholes and published in 1973. They built on earlier research by Edward O. Thorp, Paul Samuelson, and Robert C. Merton. The fundamental insight of Black and Scholes is that the option is implicitly priced if the stock is traded.

A database is a structured collection of records or data which is stored in a computer so that a program can consult it to answer queries. A database server is a computer program that provides database services to other computer programs or computers, as defined by the client-server model. The term may also refer to a computer dedicated to running such a program. Database management systems frequently provide database server functionality, and some DBMS's (e.g., MySQL) rely exclusively on the client-server model for database access.

Reference *

Monte Carlo Simulation

Database Server

ActiveX Data Objects (ADO)

Black–Scholes Option Pricing Model

* Information obtained from en.wikipedia.org.

A pivot table is a powerful data summarization tool in Microsoft Excel. It allows you to create an interactive view of your dataset. We call this view a pivot table report. With a pivot table report, you can quickly and easily categorize your data into groups, summarize large amounts of data into meaningful information, and perform a wide variety of calculation.

Pivot Tables

Copyright © Excel Business Solutions. All Rights Reserved.