Consulting Services in Excel and VBA
My professional and academic backgrounds are in accounting, finance and management. My field of expertise is business data analysis and my tool is Excel.
I have been tested by Microaoft and certified as Expert in Excel and Access.
I have been using Excel for the last 30 years and working as Consultant in Excel for over 10 years. I design simple formulas, simple macros, automated reports and complex business data analysis and business models.
Whatever your centralized database, accounting, sales or production management program, you can extract data from it. You can then bring the data into Excel and develop significant analyses and reports to help you make rapid and crucial business decisions.
Your goal is to save time and money....I can help you achieve your goals
Serving clients online since 1997
Mobile: 613-749-4695 (Peter)
I can show you how to do it, I can help you do it or I can do it for you
It is your choice
This website and the downloadable home course on Excel Macros are divided in three sections:
Section 1: Excel Macros Programming: Lessons 1 to 10
This section is about recording, writing, modifying and testing macros in the Visual Basic Editor. You will also learn about security and discover "events" (an event is what starts the macro).
Section 2: Excel VBA Vocabulary: Lessons 11 to 23
Developing a macro is communicating with Excel and to do so you need to use a language called Visual Basic for Applications (VBA). In section 2 you will learn all the VBA vocabulary that is essential to work with business data (accounting, sales, production and others).
Section 3: Forms and Controls in VBA for Excel: Lessons 24 to 33
The userform is a small or large dialog window that you create and allows the user to submit values that will be used by your macros. To these userforms you will add controls (command buttons, text boxes, list boxes and others) and program them.
The Home Course on Excel Macros (VBA)
In a single, easy and quick download
Click on the image to the left to
Download this tutorial on your own computer
And learn at your own pace
Reviewed and improved each year
Covering Excel 1997 to 2011