Home: Services

Excel Consulting and Data Services Projects


At Excel Business Solutions we offer Excel consulting, database marketing, data mining and forecasting, and data management services. Here, we provide examples of some of the Excel and database programming projects that our Excel consultants have done in the past. These examples are modified and simplified from the original projects and are provided for illustrative purposes only.

These examples show some of the possibilities regarding how your business intelligence can be enhanced by Excel programming, data analysis and reporting through our Excel consulting services.

Database Programming and Reporting

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). This database programming example demonstrates the data extracting process from a MS-Access database with a spreadsheet report created through ActiveX Data Objects (ADO) programming.
More Info

Reporting Automation

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.


More Info

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.
More Info

Customized Functions

Ever run out of built-in Excel 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.
More Info

Simulation Programming and Analysis

Programming simulations 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 be easily solved. This Monte Carlo simulation section illustrates two examples of how Excel VBA can be utilized for building simulation models, specifically in hydraulic engineering and market analysis.
More Info

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.

More Info

Report Consolidation | Integration

A very common need for reporting is report consolidation. Depending on the format of the reports to be integrated, this process can be tedious and time consuming, incurring numerous errors. By utilizing Excel VBA Programming, different reports can be merged together, with error occurrence notably minimized.
More Info

Pivot Tables

A pivot table is a powerful data summary tool in Microsoft Excel. It allows one to create an interactive view of your data set, which we call a pivot table report. With a pivot table report, one can quickly and easily categorize your data into groups, summarize large amounts of data into meaningful information, and perform a wide variety of calculations.More Info
Interested in finding out how our Excel consulting services can help you?
Please contact us.

Quick Contact Box

Reference

Monte Carlo Simulation
Close [x]

Monte Carlo Simulation

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
ActiveX Data Objects (ADO)
Close [x]

ActiveX Data Objects (ADO)

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.
Forecasting Analysis
Close [x]

Forecasting Analysis

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.
Black-Scholes Option Pricing Model
Close [x]

Black-Scholes Option Pricing Model

Data mining is the process of automatically searching large volumes of data for patterns. It is usually used by businesses and other organizations, but is increasingly used in the sciences to extract information from the enormous data sets generated by modern experimentation.

Although data mining is a relatively new term, the technology is not. Companies for a long time have used powerful computers to sift through volumes of data such as supermarket scanner data, and produce market research reports. Continuous innovations in computer processing power, disk storage, and statistical software are dramatically increasing the accuracy and usefulness of analysis.

Data mining identifies trends within data that go beyond simple analysis. Through the use of sophisticated algorithms, users have the ability to identify key attributes of business processes and target opportunities.

The term data mining is often used to apply to the two separate processes of knowledge discovery and prediction. Knowledge discovery provides explicit information that has a readable form and can be understood by a user. Forecasting, or predictive modeling provides predictions of future events and may be transparent and readable in some approaches (e.g. rule based systems) and opaque in others such as neural networks. Moreover, some data mining systems such as neural networks are inherently geared towards prediction rather than knowledge discovery.
Database Server
Close [x]

Database Server

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..

* Source: wikipedia.org