skip to Main Content

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 DAY MONTH YEAR DATE Functions

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 MONTH YEAR DATE Functions

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 COUNTIF Function

How to use Excel COUNTIFS function

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 Excel MID Function

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 Excel INDEX Function

How to use Excel INDEX function

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