Excel Formulas

28 Advanced Excel Formulas & Functions Examples

Posted on

Here our team summarizes some very useful collections of Excel formulas. Take advantage of some of these Excel formulas, even if you need to memorize them.

There are several Excel formulas that will make it easier for you to get the job done. Check out the following collection of Excel formulas compiled by the Weblogue.net team.

Maybe you are still confused, why is Microsoft Excel one of the skills that must be mastered by office workers? Yes, actually not only Microsoft Excel, but some Microsoft Office software that you must master are also Microsoft Word and PowerPoint.

That’s because Microsoft Office is very often used in various fields of work. Microsoft Word is a word processing program used to write documents, letters, proposals, and so on. While PowerPoint is useful for making presentations.

Microsoft Excel is useful for processing data in various forms such as formulas, basic calculations, data processing, table creation, graphing to data management.

The Microsoft Excel program will really help you in making work reports, especially reports related to numbers.

For those of you who work in the field of data such as administrative staff, finance, marketing, accountants, and others, you must use Microsoft Excel more often to create, edit, analyze and summarize data in the form of numbers.

Also Read: How to open Password Protected Excel File

This is because Microsoft Excel has dozens of calculation formulas that can help you when you want to calculate addition, subtraction, or find the average of the number of data you have. So you don’t have to bother calculating using a calculator, right!

Top 28 Excel Formulas You Should Know

excel formulas pdf

The collection of Excel formulas consists of various kinds, the following is a collection of Excel formulas that are important for you to remember so that you can use them in the world of work:

  • AND: Returns TRUE if all criteria are met True (TRUE)
  • AREAS: Displays the Total Area (range or cell)
  • AVERAGE: Finding Average Score
  • CHOOSE: Displays Selected Results Based on Index Number
  • CONCATENATE: Used to combine several texts into one sentence
  • COUNTA: Total Cells Filled
  • COUNTIF: Counts the number of cells in a range with certain criteria
  • DATE: Get-Date Value
  • DAY: Looking for Day
  • HLOOKUP: Searching for data from a table arranged in a horizontal format
  • LOWER: Changes all text containing uppercase letters to lowercase
  • MATCH: Displays the position of a specified cell address
  • MAX: Used to find the highest value from a set of data
  • MID: Used to retrieve certain characters from a series of characters
  • MIN: Used to find the lowest value from a set of data
  • MONTH: Looking for the Moon
  • MULTI IF: Combination of several single if
  • NOT: The opposite of AND, returns TRUE if the condition being tested is FALSE
  • OR: Finding Value by Comparison Or
  • PROPER: Changes the Initial Character of Text to Uppercase
  • SINGLE IF: Tests the truth of a condition whose logic is only one
  • STDEV: Used to estimate standard deviation based on a sample
  • SUM: Sum up
  • UPPER: Changes all text containing lowercase letters to uppercase
  • VALUE: Used to convert text data into numeric data type
  • VAR: Used to estimate variance based on one sample
  • VLOOKUP: Searching for data from a table arranged in vertical format
  • YEAR: Find the Year

Also Read: How to Calculate Average Percentage in Excel

That’s a collection of the most frequently used Excel Formulas to help you get work done faster and easier. Good luck and memorize the Excel formula above!