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 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 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 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 INDIRECT function
Excel INDIRECT function returns a reference indicated by a text value. Other Languages and Syntax Details are as listed.
How to use Excel OFFSET function
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 Excel MATCH function
Excel MATCH function looks up values in a reference or array. Other Languages and Syntax Details are as listed.
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.
Go back to FAQ Center