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

Consulting Services in Excel and VBA

Free Quotations
From small projects ($100) to much larger ones

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


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 I have been working as Consultant in Excel and VBA for the last 15 years. I design simple formulas, simple macros, simple automated reports or complex business data analysis and models.

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.

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