Lesson 6 - Inserting Function

Function Categories –

There are lot many inbuilt or predefined function in an Excel. So it’s a good example to categorized them all in a group. So similar function are grouping under same group like, Financial function – Group of function which helps us to add the financial function. For example –

• ACCRINT
• ACCRINTM
• DURATOIN
• DSC etc.

Group of function which helps us to add some logical function. For example –

• AND
• FALSE
• IF
• OR
• NOT etc.

Group of function which helps us to add the time function. For example –

• DAYS
• DATE
• HOUR
• MINUTE
• SECOND
• MONTH
• NOW etc.

Group of function which helps us to add the mathematical operation and Trigonometry function. For example –

• SUM
• SUMIF
• ODD
• EVEN
• SUBTOTAL
• PRODUCT etc.

Group of function which helps us to add the reference function. For example –

• ADDRESS
• ROW
• COLUMN
• HYPERLINK
• VLOOKUP

Group of function which helps us add the mostly used function in worksheet.

Next Lesson