Excel Functions Overview

The Excel Functions Guide provides a list of top Excel functions with examples and links to related in-depth tutorials. The functions listed below are categorized into different types - Financial Functions in Excel, Logical Functions in Excel, Date and time Function in Excel, Text Functions in Excel, Lookup Reference Functions in Excel, Maths Function in Excel and Statistical Function in excel.

Financial Functions in Excel

Start Now

WHAT YOU'LL LEARN

Here we discuss the top financial functions in excel including the Yield Function, FV Function, NPV, and IRR Function, PV function, Rate Function, IRR Function, PMT and PPMT Function in excel.

Logical Functions in Excel

Start Now

WHAT YOU'LL LEARN

Here we discuss the logic functions like IF Function, AND / OR Function, NOT Function and True Function.

TEXT Functions in Excel

Start Now

WHAT YOU'LL LEARN

Text functions help us manipulate the text within an excel. Here we discuss functions like PROPER, RIGHT, LEFT, TEXT, MID, LEN and Concatenate.

Lookup Reference Functions in Excel

Start Now

WHAT YOU'LL LEARN

Lookup functions are very important for financial analysis as it helps locate the right dataset from the large reference date. Here we discuss functions like VLOOKUP, HLOOKUP, Match, INDEX etc

Date and Time Function in Excel

Start Now

WHAT YOU'LL LEARN

Date and Time Functions are very useful as they help us quickly perform calculations using date functions with much ease. Here we discuss TODAY, DATE, TIME, NOW, WEEKDAY and more.

Statistical Functions in Excel

Start Now

WHAT YOU'LL LEARN

Statistical Functions in excel helps us easily calculate statistical measures. Here we discuss AVERAGE, CORREL, COUNT and COUNTIF