Excel Functions and Formulas

Lesson 1: Database Excel Functions

Lesson 2: Date and Time Excel Functions

Lesson 3: Engineering Excel Functions

Lesson 4: Financial Excel Functions

Lesson 5: Information Excel Functions

Lesson 6: Logical Excel Functions

Lesson 7: Lookup and Reference Excel Functions

Lesson 8: Mathematical Excel Functions

Lesson 9: Statistical Excel Functions

Lesson 10: Text Excel Functions

Lesson 11: The Excel Function SUMPRODUCT

Lesson 12: The Excel Formulas INDEX/MATCH

Lesson 13: The Excel Function SUBTOTAL

Lesson 14: The Excel Function COUNTIF

Lesson 15: The Excel Function SUMIF

Lesson 16: The Excel Function ISERROR

Lesson 17: The Excel Function LOOKUP

Lesson 18: The Excel Function HLOOKUP

Lesson 19: The Excel Function VLOOKUP

Lesson 20: The Excel Functions SMALL and LARGE instead of MIN and MAX

Lesson 21: The Excel Function AVERAGEIF (Excel 2007)

Lesson 22: The Excel Function AVERAGEIFS (Excel 2007)

Lesson 23: The Excel Function COUNTIFS (Excel 2007)

Lesson 24: The Excel Function SUMIFS (Excel 2007)

Lesson 25: The Excel Function IFERROR (Excel 2007)

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