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.

Copyright © Excel Business Solutions. All Rights Reserved.

Call Us