Excel Consulting Services - Projects

This section includes examples on how Monte Carlo simulation with the use of Excel VBA can be utilized. Two examples, hydraulic engineering and market analysis, are demonstrated. The web application example demonstrates how an Excel spreadsheet can be used on the web.

Excel Consulting|Excel Consultant|Excel Consultancy|Excel Services

Simulation Analysis and Web Application

The database programming example demonstrates extracting data from a MS-Access database and present them in an Excel spreadsheet. The reporting automation example demonstrates how the raw data can be extracted and populated into different reports.

Database Programming and Reporting Automation

The quotation calculator example demonstrates how a complex calculator can be generated using Excel. The customized function examples demonstrate the use of user-defined Excel functions with context-sensitive help. The Black-Scholes option pricing model is used for this example. Our Excel consulting services will suit your needs.

Quotation Calculator and Customized Functions

Excel Consulting Projects

This section demonstrates how MS-Access can be used on various kinds of applications such as data entry forms, query tools, and reporting.

Data Entry and Query Tools

Check out our XL Modeling product demo - Free download trials

This program involves sampling without replacement. The sub-procedure, DoubleSort( ), sorts the numbers of one array based on the numbers of another array. It is a demonstration of array manipulation.

This program generates 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.

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

Download

At Excel Business Solutions we offer Excel consulting, data mining and forecasting, and data management services. In this section, we provide a demonstration of the techniques that we applied to some of the Excel and database projects that our Excel consultants have done in the past. These demos 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 processes can be enhanced by Excel programming and modeling techniques through our Excel consulting services.