Excel Consulting

Excel functions                              Microsoft Excel Examples

 

 

Excel tips on functions and formulas

Excel Functions and Formulas

Excel examples

Excel and VBA Expert

Excel fonctions et formules

The Most Important

Excel Functions

sumproduct

index-match

 

 

 

 

 

 

 

 

 

 

 

 

 

Excel Macros and VBA

Help and Consulting Services in Excel and VBA

Free Quotations

Serving clients online since 1997
Mobile: 613-749-4695 (Peter)
Email: peter@excel-vba.com


Free Help on Excel Macros

- You will find on this website hundreds free tips on Excel macros.

- Follow the links https://groups.google.com/forum/#!forum/microsoft.public.excel or https://groups.google.com/forum/#!forum/microsoft.public.excel.programming and ask your questions. I am "vbaexcel" within these Microsoft/Google newsgroups and I often supply tips and answers to visitors.


Support on Excel

- Download my tutorials and you will find hundreds of tips, examples and ideas in a well structured learning tool. Install the tutorial on your own computers (home and office) and learn at your own pace.

- If you have purchased and downloaded my tutorials on Excel support is included. You can use the address that you will find in the tutorial to ask any questions that you might have on Excel and macros


Consulting Services in Excel and VBA (Macros)

I serve all my clients personnaly

Free Quotations

My background is in accounting, finance and management. My field of expertise is business data analysis and my tool is Excel.

I have completed a Bachelor's degree in Accounting and a Master's degree in Business Management. I have also been certified as Expert in Excel and Access by Microsoft.

I have been using Excel for the last 30 years and working as Consultant in Excel and VBA for the last 15 years. I design simple formulas, simple macros, simple automated reports and complex business data analysis applications.

With Excel you can extract data from one or many sources, organize it,  validate it, analyse it and develop important reports. This whole process can be automated.

With macros Excel becomes the cheapest, most customisable and user friendly reporting program on the market.

Whatever your centralized database, accounting, sales or production management program, you can extract data from it, bring the data into Excel and develop the most significant analyses and reports to make rapid and crucial business decisions.

I can help you achieve your goals

Peter

Serving clients online since 1997
Mobile: 613-749-4695 (Peter)
Email: peter@excel-vba.com


Among my clients:  Merck Pharmaceuticals (New Jersey ), Proctor Financial (Massachusetts), Delray Investments (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.


The most useful and powerful function in Excel
SUMPRODUCT


Excel Functions and Formulas Sitemap

 

 

 

Excel tips on functions and formulas

Excel Functions and Formulas

Excel examples

Excel and VBA Expert

Excel fonctions et formules

SUMPRODUCT  ¦  INDEX/MATCH  ¦  SUBTOTAL  ¦  ISERROR  ¦  COUNTIF  ¦  SUMIF  ¦  HLOOKUP  ¦  LOOKUP  ¦  VLOOKUP
AVERAGEIF  ¦  AVERAGEIFS  ¦  COUNTIFS  ¦  SUMIFS  ¦  IFERROR