Excel Formulas List PDF
Excel Formulas List PDF Download for free using the direct download link given at the bottom of this article.
Excel Formulas List PDF can be downloaded from the link given at the bottom of this page. Excel Formula Mean is calculated by adding a set of numbers and then dividing the sum by the count of those numbers. In Microsoft Excel, the mean can be calculated by using one of the following functions: AVERAGE – Returns the average number.
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. If you want to expert in Excel then you must know the Excel formula. Excel Formulas List PDF can be downloaded from the link given at the bottom of this page.
Excel Formulas List PDF
| Excel Function | Shortcut Keys |
|---|---|
| Close a Workbook | Ctrl + W |
| Repeat Last Command Actions | F4 |
| Open Options | Alt + F + T |
| Open Help | F1 |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y |
| Copy | Ctrl + C |
| Cut | Ctrl + X |
| Paste | Ctrl + V |
| Display Paste Special Dialogue Box | Ctrl + Alt + V |
| Find Box | Ctrl + F |
| Find and Replace | Ctrl + H |
| Find next match | Shift + F4 |
| Find Previous Match | Ctrl + Shift + F4 |
| Create an Embedded Chart | Alt + F1 – |
| Create Chart in new Worksheet | F11 |
| New Workbook | Ctrl + N |
| Open Workbook | Ctrl + O |
| Save Workbook | Ctrl + S |
| Save As | F12 |
| Print File | Ctrl + P |
| Open Print Preview | Ctrl + F2 |
| Close Workbook | Ctrl + F4 |
| Close Excel | Alt + F4 |
| Expand or close Ribbon | Ctrl + F1 |
| Activate Access Keys | Alt |
| Move to next control on Ribbon | Tab |
| Help | F1 |
| Select all contents of a worksheet. | Ctrl+A |
| Bold all cells in the highlighted section. | Ctrl+B |
| Fill the Content of the selected cell on top to bottom. CTRL + D (i.e. Ctrl+ Down) | Ctrl+D |
| “Search the current sheet. | Ctrl+F |
| Go to a certain area. | Ctrl+G |
| Find and replace. | Ctrl+H |
| Puts italics on all cells in the highlighted section. | Ctrl+I |
| Inserts a hyperlink. | Ctrl+K |
| Print the current sheet. | Ctrl+P |
| Fill Right. | Ctrl+R |
| Saves the open worksheet. | Ctrl+S |
| Underlines all cells in the highlighted section. | Ctrl+U |
| Pastes everything copied onto the clipboard. | Ctrl+V |
| Closes the current workbook. | Ctrl+W |
| Cuts all cells within the highlighted section. | Ctrl+X |
| Repeats the last entry. | Ctrl+Y |
| Undo the last action. | Ctrl+Z |
| Changes the format of the selected cells. | Ctrl+1 |
| Bolds all cells in the highlighted section. | Ctrl+2 |
| Puts italics all cells in the highlighted section. | Ctrl+3 |
| Underlines all cells in the highlighted section. | Ctrl+4 |
| Puts a strikethrough all cells in the highlighted section. | Ctrl+5 |
| Shows or hides objects. | Ctrl+6 |
| Shows or hides the toolbar. | Ctrl+7 |
| Toggles the outline symbols. | Ctrl+8 |
| Hides rows. | Ctrl+9 |
| Hides columns. | Ctrl+0 |
Excel Shortcuts List PDF (Top 50)
| Description | Excel Shortcuts |
|---|---|
| 1. To create a new workbook | Ctrl + N |
| 2. To open an existing workbook | Ctrl + O |
| 3. To save a workbook/spreadsheet | Ctrl + S |
| 4. To close the current workbook | 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. To go to the View tab | Alt + W |
| 10. To go the Formula tab | Alt + M |
| 11. To edit a cell | F2 |
| 12. To copy and paste cells | Ctrl + C, Ctrl + V |
| 13. To italicize and make the font bold | Ctrl + I, Ctrl + B |
| 14. To center align cell contents | Alt + H + A + C |
| 15. To fill color | Alt + H + H |
| 16. To add a border | Alt + H + B |
| 17. To remove outline border | Ctrl + Shift + _ |
| 18. To add an outline to the select cells | Ctrl + Shift + & |
| 19. To move to the next cell | Tab |
| 20. To move to the previous cell | Shift + Tab |
| 21. To select all the cells on the right | Ctrl + Shift + Right arrow |
| 22. To select all the cells on the left | Ctrl + Shift + Left Arrow |
| 23. To select the column from the selected cell to the end of the table | Ctrl + Shift + Down Arrow |
| 24. To select all the cells above the selected cell | Ctrl + Shift + Up Arrow |
| 25. To select all the cells below the selected cell | Ctrl + Shift + Down Arrow |
| 26. To add a comment to a cell | Shift + F2 |
| 27. To delete a cell comment | Shift + F10 + D |
| 28. To display find and replace | Ctrl + H |
| 29. To activate the filter | Ctrl + Shift + L, Alt + Down Arrow |
| 30. To insert the current date | Ctrl + ; |
| 31. To insert current time | Ctrl + Shift + : |
| 32. To insert a hyperlink | Ctrl + k |
| 33. To apply the currency format | Ctrl + Shift + $ |
| 34. To apply the percent format | Ctrl + Shift + % |
| 35. To go to the “Tell me what you want to do” box | Alt + Q |
| 36. To select the entire row | Shift + Space |
| 37. To select the entire column | Ctrl + Space |
| 38. To delete a column | Alt+H+D+C |
| 39. To delete a row | Shift + Space, Ctrl + – |
| 40. To hide selected row | Ctrl + 9 |
| 41. To unhide selected row | Ctrl + Shift + 9 |
| 42. To hide a selected column | Ctrl + 0 |
| 43. To unhide a selected column | Ctrl + Shift + 0 |
| 44. To group rows or columns | Alt + Shift + Right arrow |
| 45. To ungroup rows or columns | Alt + Shift + Left arrow |
| 46. To group pivot table items | Alt + Shift + Right arrow |
| 47. To ungroup pivot table items | Alt + Shift + Left arrow |
| 48. To hide pivot table items | Ctrl + – |
| 49. To create a pivot chart on the same sheet | Alt + F1 |
| 50. To create a pivot chart on a new worksheet | F11 |
MS Excel Formulas List
| SUM Excel Formula : | SUM(number1, [number2] ) |
| AVERAGE Excel Formula : | AVERAGE(number1, [number2], …) |
| MAX & MIN Excel Formula : | =MAX(A2:A5) =MIN(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], …) |
Sum Function
The sum function is the most used function when it comes to computing data on Excel. This function works to sum a group of numbers in a specific set of cells. This means you don’t need to type a long cumbrous formula just to calculate the sum of all the data you need. Because of its popularity, newer versions of Microsoft Excel have a button specifically for this function.
TEXT Function
Text function is a useful tool that helps convert a date (or number) into a text string in a particular format. It falls in the category of string formulas that converts numerical values to a string. It is handy when users need to view numeric data in a readable format. Take note that the “TEXT” formula only works to convert numeric values to text.
You can download the Excel Formulas List in PDF format using the link given below.
can i get all formulas of excels ?
yes you can download the Excel Formuls List PDF using the link given at the bottom of this article
i cant see the link please