### This is an excerpt from Pierre Leclerc (www.excel-vba.com)

The 2 Most Important

Excel Functions AND
Formulas

SUMPRODUCT

AND

INDEX/MATCH

## Excel Functions and Formulas Sitemap

This website is divided in 4 sections:

#### Section 1: Useful Excel Functions by Category

 Lesson 1: Excel Database Functions Lesson 2: Excel Date and Time Functions Lesson 3: Excel Engineering Functions Lesson 4: Excel Financial Functions Lesson 5: Excel Information Functions Lesson 6: Excel Logical Functions Lesson 7: Excel Lookup and Reference Functions Lesson 8: Excel Mathematical Functions Lesson 9: Excel Statistical Functions Lesson 10: Excel Text Functions

#### Section 2: Special Excel Functions

 Lesson 11: SUMPRODUCT Lesson 12: INDEX/MATCH Lesson 13: SUBTOTAL Lesson 14: ISERROR Lesson 15:New functions in Excel 2007

#### Section 3: Other Pages on Excel Functions and Formulas

 Lesson 17: The Signs in Excel Formulas Lesson 18: Absolute and Relative References Lesson 19: The Analysis Toolpak

#### Section 4: Annexes on All Functions by Category

 Annex 1: All the Database Excel Functions Annex 6: All the Logical Excel Functions Annex 10: All the Text Excel Functions

The most useful and powerful function in Excel
SUMPRODUCT

 Excel has not changed much since the 1980's but the computer on your desk has changed dramatically. It is hundreds of times faster and more powerful than 10 years ago. It is also connected to multiple sources of data within your enterprise and connected to data sources from around the world through the Internet. Due to these changes to your computer and its network, Excel macros have become powerful tools to develop data analysis and reporting program. With 45 years of expertise as C.E.O. and owner of my company, I will help you develop powerful solutions to do more with your business data.

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

Retour à la page d'accueil