All Excel Formulas PDF Download link is given in the middle of the article, you can direct download it online on your mobile or laptop.
Excel is a spreadsheet that Microsoft develops. Excel is widely used for analyzing, organizing, and manipulating the various data for the organization. In today’s article, you should be known all the formula of Excel which is given below and also you can download the All Excel Formulas PDF on your mobile with the help of the link, which is given in the article. so stay with us.
All Excel Formulas PDF Overview
| PDF Name | All Excel Formulas PDF |
| No. Of Pages | 8 |
| PDF Size | 200 KB |
| Language | English |
| Category | Education |
| Source/credit | Drive.google.com |
| Download | available |
All Excel Formulas PDF Download Link
What Is Excel ?
In today’s time making data and analyzing them is very easy with the help of Excel tool. this tool is developed by the giant software company, Microsoft. With the help of Excel, you can make any chart data or report within minutes.
This is a very powerful tool that is now used by all the company and organizations to make their data and report very easily. It also offers a lot of features and functions that allow a user to perform thought calculations, and make data in a visually appealing manner.
Now Excel sheet is commonly used in financial accounting, data analysis, and many other areas where analysis is required.
All Excel Formulas PDF List For Online
an excel formula is an expression to perform various tasks, like sum, average, count, and many more. here I am given a list of formula which is commonly used in Excel spreadsheet.
| S.N. | Description | Shortcut |
| 1 | To create a new Sheet | Ctrl + N |
| 2 | To open an existing spreadsheet | Ctrl + O |
| 3 | To save a spreadsheet | Ctrl + S |
| 4 | To close the current spreadsheet | Ctrl + W |
| 5 | To close Excel | Ctrl + F4 |
| 6 | To move to the next sheet | Ctrl + PageDown |
| 7 | To move to the previous sheet | Ctrl + PageUp |
| 8 | To go to the Data tab | Alt + A |
| 9 | go to the View tab | Alt + W |
| 10 | go the Formula tab | Alt + M |
| 11 | To edit a cell | F2 |
| 12 | copy and paste cells | Ctrl + C, Ctrl + V |
| 13 | To center align cell contents | Alt + H + A + C |
| 14 | go to the Formula tab | To fill color in cell |
| 15 | To add a border | Alt + H + B |
| 16 | To fill color in cell | Ctrl + Shift + _ |
| 17 | To add an outline to the select cells | Ctrl + Shift + & |
| 18 | To move to the next cell | Tab |
| 19 | To move to the previous cell | Shift + Tab |
| 20 | To select all the cells on the right | Ctrl + Shift + Right arrow |
| 21 | To Select all the cells on the left | Ctrl + Shift + Left Arrow |
| 22 | To select the column from the selected cell to the end of the table | Ctrl + Shift + Down Arrow |
| 23 | To select all the cells above the selected cell | Ctrl + Shift + Up Arrow |
| 24 | To select all the cells below the selected cell | Ctrl + Shift + Down Arrow |
| 25 | To add a comment to a cell | Shift + F2 |
| 26 | To delete a cell comment | Shift + F10 + D |
| 27 | To display find and replace | Ctrl + H |
| 28 | To activate the filter | Ctrl + Shift + L, Alt + Down Arrow |
| 29 | To insert the current date | Ctrl + |
| 30 | To remove the outline border | Ctrl + Shift + |
| 31 | To insert a hyperlink | Ctrl + k |
| 32 | To apply the currency format | Ctrl + Shift + $ |
| 33 | To select the entire row | Shift + Space |
| 34 | To select the entire column | Ctrl + Space |
| 35 | To delete a column | Alt+H+D+C |
| 36 | To delete a row | Shift + Space |
| 37 | To hide selected row | Ctrl + 9 |
| 38 | To insert the current time | Ctrl + Shift + 9 |
| 39 | To hide a selected column | Ctrl + 0 |
| 40 | To unhide a selected column | Ctrl + Shift + 0 |
| 41 | To group rows or columns | Alt + Shift + Right arrow |
| 42 | To ungroup rows or columns | Alt + Shift + Left arrow |
| 43 | To group pivot table items | Alt + Shift + Right arrow |
| 44 | To ungroup pivot table items | Alt + Shift + Left arrow |
| 45 | To hide pivot table items | Ctrl + – |
MS Excel Formula list
| SUM Excel Formula : | SUM(number1, [number2] ) | calculate the sum of a cell |
| AVERAGE Excel Formula : | AVERAGE(number1, [number2], …) | Calculate the average of the cell |
| MAX & MIN Excel Formula : | =MAX(A2:A5) =MIN(A2:A5) | return the min & max value of cell |
| COUNT & COUNTA Formula : | COUNT(value1, [value2], …) | count the number of cell that contain a number |
| IF Excel Formula : | IF(logical_test, [value_if_true], [value_if_false]) | if perform a logical test |
| TRIM Excel Formula : | = TRIM (A1) | |
| LEN Excel Formula : | =LEN (text) | Return the number of character |
| CONCATENATE Excel Formula : | CONCATENATE(text1, [text2], …) | join together two or more text |
Conclusion:
So a friend in this article you can get all the detail of the All Excel Formulas PDF, and also you will find the All Excel Formulas PDF link available in the above article. if you like this article then please share this article with your friend and colleague.