Services

What can I do for you?

Whichever type of Excel or Access application you need, you've come to the right place to find expert help.

Of course there are some areas I am particularly experienced in. These include:

Professionalizing your Excel model (add navigation, make formatting consistent, apply styles, add data validation, streamline the work-process within the model).
Building sophisticated and user-friendly Excel templates for modeling and data entry.
Writing professional VBA code to automate tasks within your projects.
Salvaging problematic workbooks: Getting rid of corruptions, removing excess formatting, recovering from crashes.
Enabling your Spreadsheet model to communicate with database applications to fetch data from and/or update data to them.
Developing bespoke Excel add-ins tailored to your needs.
Developing Database systems
Upsizing Access databases to SQL Server.

To get an impression of my level of expertise, a few examples of utilities developed by me are to be found on my download pages.

Take a moment to browse through the Excel articles I have posted on this site, you may find something useful there too.

Check out the products page for examples of commercially developed products.

Some examples of projects

For one of the Quote 100 companies in the USA (Banking) : Updating and developing tools to analyze and salvage problematic Excel files: Formula auditing tool, Style rationalisation tool, Corrupt range name fixing, circular reference finder and etcetera;
Shell: Building a System to assess gas storage systems projects. Excel 2003/2007/2010 + VBA.
Theodoor Gilissen Bankiers: Auditing of mission-critical (Excel) spreadsheets. Setting up a spreadsheet applications control system;
Stichting Kennisnet : Building highly complex reports using SQL Server and Excel.
Caderys Refractory Solutions: A custom built system to enable the client to make fast and accurate price estimates by tremendously easing the process of calculating the needed amounts of materials for complex industrial plants. Excel + VBA.
CP7: Creating an e-invoicing and fully electronic order processing system: MS Access 2003/VBA, SQL Server;
SNS Asset Management: Update portfolio management reporting (Excel/VBA)
Shell EP Netherlands: Develop a set of templates which are used to update project planning models. The Excel templates are downloaded from a SAP portal and use SAP Webservices to (securely) pull data from and push data to SAP XI.
Essent trading : Developing various Excel (VBA) tools for the Energy trading desk, supporting traders with their Excel related issues.
ABN AMRO bank the Netherlands (Risk Management): Developing various complex reporting systems (Excel + VBA + Lotus Notes automation) and a switchboard Application (MSAccess) to run these automatically.
For a large Bank in New York: Developing an auditing tool and a tool to remediate problematic workbooks.
For Fortis Bank The Netherlands: Assisting with a migration project from Win NT/Office 97 to WinXP/Office 2003. Analysis of hundreds of thousands of files for potential migration issues, using a customized Access application. Fixing issues during the migration.
NavigatorXL: Wizards for uploading data to and downloading data from Oracle systems directly from within Excel.
For Weka publishers: professionalize a system to create annual social reports.
For the Dutch Ministry of Social Affairs: a course on Advanced Excel VBA. Topics: Class modules (backgrounds, custom events, collections). Userforms (Create on-the-fly using code, add code programmatically, add controls at runtime, create control events using class modules). Add-ins (COM, VB6) in Excel. Smart Tags. Controlling Outlook and Word via Excel VBA. Creating and modifying databases and tables using ADO and SQL.
For Shell Brands International AG, a system to enter and analyze global advertising campaign pre-test research data (using VBA, Pivot tables, Data Validation and conditional formatting).
For a UK waste management company: updating a graphing package that is used for the analysis of nuclear waste streams (using extensive VBA coding).
A reporting system for an American company with which they calculate the weekly pay and bonuses for their technicians and which reports their sales over various periods of time. The project involves Excel and VBA programming, using Microsoft ADO to extract data from an Access database.
For an American financial consultancy company: A system to import email messages from Outlook into Excel in order to be able to process the name and address data (entered in a webform) from people subscribing to a newsletter. This project involved programming Outlook from Excel, using VBA from within Excel.