Most Used Excel Functions and Formula Details

Most Used Excel Functions, Examples and Resources

Probably you are not the only one out there who wants to improve Excel skills. It is always great to learn how to create professional spreadsheets and present data that will “wow” your boss.

Check this Excel Functions category and learn about the most common formulas & functions to get closer to working more effectively in Excel!

How To Use Excel DAY MONTH YEAR DATE Functions

How to use Excel YEAR function

Excel YEAR function returns a four-digit year (a number from 1900 to 9999) given a date value. Other Languages and Syntax Details are listed.

How to use Excel MONTH function

Excel MONTH function returns the month (a number from 1 to 12) given a date value. Other Languages and Syntax Details are as listed.

How to use Excel DAY function

Excel DAY function returns the day of the month (a number from 1 to 31) given a date value. Other Languages and Syntax Details are as listed.

How To Use Excel ROUND ROUNDUP ROUNDDOWN Functions

How to use Excel ROUNDDOWN function

Excel ROUNDDOWN function returns a number rounded down to a specified number of digits. Other Languages and Syntax Details are as listed.

How to use Excel ROUNDUP function

Excel ROUNDUP function returns a number rounded up to a specified number of digits. Other Languages and Syntax Details are as listed.

How to use Excel SUMIFS function

Excel SUMIFS function adds the cells in a range that meet multiple criteria. Other Languages and Syntax Details are as listed.

How to se countifs in excel

Excel COUNTIFS function counts the number of cells within a range that meet multiple criteria. Other Languages and Syntax Details are as listed.

How to Use INDIRECT in Excel

Excel INDIRECT function returns a reference indicated by a text value. Other Languages and Syntax Details are as listed.

How to Use OFFSET in Excel

Excel OFFSET function returns a reference offset from a given reference. Other Languages and Syntax Details are as listed.

How to use Excel MID function

Excel MID function returns a specific number of characters from a text string starting at the position you specify. Other Languages and Syntax Details are as listed.

How to Use MATCH in Excel

Excel MATCH function looks up values in a reference or array. Other Languages and Syntax Details are as listed.

How to Use INDEX Function in Excel

Excel INDEX function uses an index to choose a value from a reference or array. Other Languages and Syntax Details are as listed.

Go back to FAQ Center