Downloads

Search

Excel Table of Contentsl

 Online Consulting

VBA Table of Contents

 

Welcome to www.excel-vba.com

My name is Peter. I am the creator of this website and of the spreadsheets that you can download from it. I have been working with business data for 35 years 20 of them with Excel and VBA (the programming language within Excel). For the last 12 years I have been working as on line consultant developing simple and powerful decision making tools with Excel and VBA.

I have created this website to help accountants, production planners, sales analysts, financial analysts and other business people who want to analyse their business data to generate savings or new profits for their business.

This website has helped visitors find a better job, do a better job or work much less to do their job. But it has also helped many people and enterprises save or make thousands of dollars by understanding better what was going on in their business.

When you know a little about Excel you can develop one solution. When you know more about Excel you can develop many different solutions and then choose the best one.

My best achievement was developing a solution for a certain consultant. With the solution he had developed he could serve 15 client per week at $100 each earning around $75,000 per year...not bad. With the solution I developed for him he could serve 50 clients per week at the same price...much better.

I hope this website allows you to improve your skills and your professional situation.

If you are a new visitor to this website I strongly suggest that you use the tables of contents above and rediscover Excel and VBA from chapter one.  If you are searching for something in particular use the search function at the top of this page.

 

[email protected]
514
-973-1984 (Peter)

 

My name is Peter

My professional and academic backgrounds are in finance, cost accounting and management (25 years). Ten years ago I changed career and became full time on line Consultant in Excel and VBA developing business models, quotation tools, data analyses, reporting workbooks and large database front and back ends. I have worked in manufacturing, banking, finance, accounting and retail.

I am trained in many database, data analysis and reporting programs. I have chosen to offer my services in Excel because it is the program that allows total customization whatever the data or the source of the data.

 

Recent Projects

Proctor Financial (MA), Steve Doucette
Development of a portfolio analyzer for 401Ks.

Robert Shaff Consultants (OK), Michelle Barry and Robert Shaff
Development of analysis and reporting tools for financial data.

Service Company International (TX), Scott Farris
Development of a pricing tool to be used by 350 managers of cemeteries.

Development of multiple analysis and reporting tools (over the last 2 years).

Novosad Hayes (TX), Jim Hayes
Development of a business model for a large firm of lawyers involved in mass actions.

Development of a business model and a production planning tool for a company producing encapsulated medications.

Merck Pharmaceutical (NJ), Robert Deuson
Development of a cost/benefit business model for a medication to treat cancer in 47 different countries with different medical programs and different price grids.

Gibraltar Private Bank & Trust (FL), Francis Didier
Development of analysis and reporting applications downstream from Silverlake.

MedCompliance (FL), Jessy Huebner
Development of a data validator for Medicair and Medicaid claims by hospitals.

 

[email protected]
514
-973-1984 (Peter)

 

Downloads

Search

Excel Table of Contentsl

 Online Consulting

VBA Table of Contents