Excel Functions for Beginners

We offer a tutorial on how to use functions in Excel. You can find 50 Excel functions with examples. If you are beginner in Excel, no worry.

We have given very easy examples to understand each function.

We have arranged all functions sequence wise. So you can learn and understand easily. These functions are using frequently almost in all office work and excel work. 

After completing this section, you will become an expert at the beginner level. And you will be able to use these functions in your office work.

This section will cover all functions on a basic level.

1 MIN() Function: This function picks the lowest value from a list of data.

2 MAX() Function: This function picks the highest value from a list of data.

3 AVERAGE() Function: This function used to calculate the average from a list of numbers.

4 SUM() Function: This function used to create a total from a list of numbers.

5 SUMIF() Function: This function used to create a total from a list of numbers that match criteria set by the user.

6 SUMIFS() Function: This function used to create a total from a list of numbers that match multiple criteria (more than one criteria) set by the user.

7 LEFT() Function:  This function displays a specified number of characters from the left-hand side of a piece of text or number

8 RIGHT() Function: This function displays a specified number of characters from the right-hand side of a piece of text or number.

9 LOWER() Function: This function converts all characters into lower case.

10 UPPER() Function: This function converts all characters into upper case.

11 PROPER() Function: This function converts the first letter of each word to uppercase and all subsequent letters are converted to lower case.

12 TIME() Function: This function will convert three separate numbers to an actual time.

13 DATE() Function: This function creates a real date by using three normal numbers typed into separate cells.

14 NOW() Function: This function shows the current date and time.

15 SECOND() Function: The function will show the second of the minute based upon a time or a number. 

16 MINUTE() Function: The function will show the minute of the hour based upon a time or a number. 

17 HOUR() Function: The function will show the hour of the day based upon a time or a number.

18 TODAY() Function: This function shows the current system date. 

19 DAY() Function: This function extracts the day of the month from a complete date.

20 WEEKDAY() Function: This function shows the day of the week from a date.

21 MONTH() Function: This function extracts the month as a number from a complete date.

22 YEAR() Function: This function extracts the year a number from a date.

23 DATEDIF() Function: This function calculates the difference between two dates. It can show the result in weeks, months, or years.

24 SMALL() Function: This function examines a list of values and picks the value at a user-specified position in the list.

25 LARGE() Function: This function examines a list of values and picks the value at a user-specified position in the list.

26 OR() Function: This function tests two or more conditions to see if any of them are true. 

27 AND() Function: This function tests two or more conditions to see if all of them are true.

28 NOT() Function: This function performs a test to see if the test fails. (A type of reverse logic). 

29 LEN() Function: This function counts the number of characters, including spaces and numbers, in a cell.

30 TRIM() Function: This function removes unwanted spaces from a piece of text. 

31 CLEAN() Function: This function removes any non-printable characters from text.

32 ROUND() Function: This function rounds a number to a specified amount of decimal places. 

33 N() Function: This function converts a numeric entry to its mathematical value. 

34 NA() Function: This function is a place marker used to indicate that required information is Not Available. 

35 INT() Function: This function rounds a number down to the nearest whole number.

36 RANK() Function: This function calculates the position of a value in a list relative to the other values in the list.

37 DOLLAR() Function: This function converts a number into a piece of text formatted as currency.

38 COUNT() Function: This function counts the number of numeric entries in a list. It will ignore blanks, text, and errors.

39 COUNTA() Function: This function counts the number of numeric or text entries in a list. It will ignore blanks.

40 COUNTIF() Function: This function counts the number of items that match criteria set by the user.

41 COUNTIFS() Function: This function counts the number of items that match multiple criteria set by the user.

42 COUNTBLANK() Function: This function counts the number of blank cells in a range.

43 TEXT() Function: This function returns a number in a given number format, as text.

44 TRUNC() Function: This function counts the number of items that match criteria set by the user.

45 VLOOKUP() Function: This function scans down the row headings at the side of a table to find a specified item. 

46 HLOOKUP() Function: This function scans across the column headings at the top of a table to find a specified item. 

47 FIND() Function: This function looks for a specified character or blank space inside cell value. 

48 SEARCH() Function: This function looks for a specified character or blank space inside cell value. 

49 REPLACE() Function: This function replaces a portion of text with a new piece of text. 

50 IF() Function: This function tests a condition. If the condition is met it is considered to be TRUE. If the condition is not met it is considered FALSE. 

So these are 50 excel functions that can help in your daily office work. You can be a champ at the beginner level and can start your job from the basics.