4.4.2 Function

1 Sum, Min, Max, Product: The most used functions in Excel.

Example:

SUM

fsum

MAX

fmax

MINfmin

PRODUCTfproduct
 

2 Logical: Learn how to use Excel's logical functions such as the IF, AND and OR function.

Example:

IF

fif

3 Cell References: Cell references in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to success.

4 Date & Time: To enter a date in Excel, use the "/" or "-" characters. To enter a time, use the ":" (colon). You can also enter a date and a time in one cell.

Example:

NOW

fdate

5 Text: Excel has many functions to offer when it comes to manipulating text strings.

Example:

Join Strings

text

TRIMtrim

6 Lookup & Reference: Learn all about Excel's lookup & reference functions such as the VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE function.

7 Financial: This chapter illustrates Excel's most popular financial functions.

8 Statistical: An overview of some very useful statistical functions in Excel.

Example:

AVERAGE

average

COUNT
fcount

9 Round: This chapter illustrates three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function.

Example:

ROUND

round