Consulting Services in Excel and VBA
|
|
My background is in accounting, finance and management. My field of expertise is business data analysis and my tool is Excel. With Excel you will extract data from any source, arrange, validate it, analyse it and develop automated reports. Excel is the most customisable and powerful reporting application on the market. Pierre Leclerc |
Serving clients online in USA and Canada for the past 15 years
Mobile: 613-749-4695 (Peter)
Email: peter@excel-vba.com
My academic and professional backgrounds are in accounting, finance and production planning. I have worked during 20 years in the real world developing reports for me and my bosses, requiring reports from my employees and developing business models. Then in 1997 I became an online consultant in Excel and VBA (macros).
Because of this background I can understand your needs rapidly so we will concentrate and use our precious time on developing powerful solutions that will help you get results much faster and make these crucial business decisions to improve your bottom line.
Among my clients: Merck Pharmaceuticals (New Jersey ), Proctor Financial (Massachusetts), Delray Investements (Florida), Woska & Hayes LLC (Oklahoma), Gibraltar Bank and Trust (Florida), SCI (Texas), Bombardier (Valcourt), National Bank of Canada (Toronto), Gildan Activewear (Montreal), MedCompliance (Florida), Atlas Paper Mills (Florida) and many small business owners, investors and free lance professionals around the world.
This website and the downloadable tutorial 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.