Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Create Area Chart in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Remove Duplicates Example in Excel
  • Create Scatter Chart in Excel
  • Conditional Formatting New Rule with Formulas in Excel

References

  • Extract data with helper column in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Create hyperlink with VLOOKUP in Excel
  • How to use Excel LOOKUP Function
  • How to get first column number in range in Excel

Data Validations

  • Excel Data validation whole percentage only
  • Excel Data validation require unique number
  • Prevent invalid data entering in specific cells
  • Excel Data validation date in specific year
  • Excel Data validation must contain specific text

Popularly Used Excel Functions and their examples

by

10 Excel Functions every regular worker should know

Excel functions are predefined formulas that are designed for the purpose of data analysis, manipulation and visualization. These functions are already available in Excel.

To get detailed information about a function, click its name in the first column.

Here are list of 10 functions that commonly used in Excel

Function

Description

SUM function Use this function to add the values in cells.
IF function Use this function to return one value if a condition is true and another value if it’s false. Here’s a video about using the IF function.
VLOOKUP function Use this function when you need to find things in a table or a range by row. For example, look up an employee’s last name by her employee number, or find her phone number by looking up her last name (just like a telephone book). Check out this video about using VLOOKUP.
LOOKUP function Use this function when you need to look in a single row or column and find a value from the same position in a second row or column.
CHOOSE function Use this function to select one of up to 254 values based on the index number. For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.
MATCH function Use this function to search for an item in a range of cells, and then return the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 7, and 38, then the formula =MATCH(7,A1:A3,0) returns the number 2, because 7 is the second item in the range.
DATE function Use this function to return the sequential serial number that represents a particular date. This function is most useful in situations where the year, month, and day are supplied by formulas or cell references. For example, you might have a worksheet that contains dates in a format that Excel does not recognize, such as YYYYMMDD.

Use the DATEDIF function to calculate the number of days, months, or years between two dates.

DAYS function Use this function to return the number of days between two dates.
INDEX function Use this function to return a value or the reference to a value from within a table or range.
FIND, FINDB functions FIND and FINDB locate one text string within a second text string. They return the number of the starting position of the first text string from the first character of the second text string.

Post navigation

Previous Post:

CUBEVALUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

CLEAN function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • IF with wildcards in Excel
  • How to return blank in place of #DIV/0! error in Excel
  • How to use Excel AND Function
  • Check multiple cells are equal in Excel

Date Time

  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Calculate time difference in hours as decimal value in Excel
  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • WORKDAY function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Group arbitrary text values in Excel
  • How to randomly assign data to groups in Excel
  • If cell contains one of many things in Excel
  • Group times into 3 hour buckets in Excel
  • Group numbers at uneven intervals in Excel

General

  • List worksheet index numbers in Excel
  • Check if multiple cells have same value with case sensitive in Excel
  • How to get original number from percent change in Excel
  • How to generate random number between two numbers in Excel
  • Excel Ribbon Quick Overview For Beginners
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning