Excel functions

Special

Excel Functions

2003

Special

Excel Functions

2007

Excel Functions and Formulas

Excel Sitemap

This website is divided into 5 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: COUNTIF

Lesson 15: SUMIF

Lesson 16: ISERROR

Lesson 17: LOOKUP

Lesson 18: HLOOKUP

Lesson 19: VLOOKUP

Lesson 20:SMALL and LARGE instead of MIN and MAX

Section 3: Excel New Functions in 2007

Lesson 21: AVERAGEIF (Excel 2007)

Lesson 22: AVERAGEIFS (Excel 2007)

Lesson 23: COUNTIFS (Excel 2007)

Lesson 24: SUMIFS (Excel 2007)

Lesson 25: IFERROR (Excel 2007)

Section 4: Other Pages on Excel Functions and Formulas

Lesson 26: 5 Useful Tips on Excel Functions and Formulas

Lesson 27: The Signs in Excel Formulas

Lesson 28: Absolute and Relative References

Lesson 29: The Analysis Toolpak

Section 5: All Functions by Category

Annex 1: All the Database Excel Functions

Annex 2: All the Date and Time Excel Functions

Annex 3: All the Engineering Excel Functions

Annex 4: All the Financial Excel Functions

Annex 5: All the Information Excel Functions

Annex 6: All the Logical Excel Functions

Annex 7: All the Lookup and Reference Excel Functions

Annex 8: All the Mathematical Excel Functions

Annex 9: All the Statistical Excel Functions

Annex 10: All the Text Excel Functions

The most useful and powerful function in Excel
SUMPRODUCT

Learn more on Excel
Discover our Products

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