Advanced Excel Formulas List PDF Download Link is available at the end of the post. See the complete List of All Excel Formulas With Examples in the Excel Sheet.
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft Office suite of software.MS Excel is a commonly used Microsoft Office application. It is a spreadsheet program that is used to save and analyze numerical data.
A formula in Excel is a mathematical expression that returns a specific result. List of some useful Excel Formulas & Functions as Follows:
- 1+ 3 // returns 4
- 9 / 3 // returns 3
- SUM(1,3,5) // returns 9
- SUM(A1:A3) // returns A1+A2+A3
- AVERAGE(3,4,5) //returns 6
- MIN(2,5,4) // returns 2
- MAX(2,5,4) // returns 5
- COUNTIF (range, criteria) // two arguments
Advanced Excel Formulas List -Formula and Functions List PDF
Formulas – In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
Functions – Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names. For example :- =SUM(A1:A3). The function sums all the values from A1 to A3.
Some more formulas related to MS Excel are given Below in the article. If you want to download the most important formulas related to MS Excel you can download a Pdf at the end of the article.
Microsoft Excel Formula List
|SUM Excel Formula :||SUM(number1, [number2] )|
|AVERAGE Excel Formula :||AVERAGE(number1, [number2], …)|
|MAX & MIN Excel Formula :||=MAX(A2:A5)
|COUNT & COUNTA Formula :||COUNT(value1, [value2], …)|
|IF Excel Formula :||IF(logical_test, [value_if_true], [value_if_false])|
|TRIM Excel Formula :||= TRIM (A1)|
|LEN Excel Formula :||=LEN (text)|
|CONCATENATE Excel Formula :||CONCATENATE(text1, [text2], …)|
Download Microsoft Excel Formula PDF
The link to download the PDF of the Advanced Excel Formulas List is provided below; simply use the provided direct link to obtain the PDF.
For more updates related to MS Excel Visit https://www.microsoft.com/en-in