Top 150 Excel Formulas PDF List Download
Excel Formulas List PDF read online or download for free from the drive.google.com link given at the bottom of this article.
Welcome to our comprehensive guide on Excel formulas, where we dive deep into the world of data analysis and empower you with the knowledge to harness Excel's full potential. Whether you're a beginner or an experienced user, this article will provide valuable insights, essential functions, and practical tips to enhance your Excel skills.
Microsoft Excel is a great tool to work with data. Excel is so popular that there are only a few people who have never used it. Excel is widely used in many industries to create reports and gain business insights. Excel has several built-in applications to make it easier to operate. Let's get started!
Excel formulas are one of the features that make Excel stand out. We will examine the Top 150+ most important Excel formulas to know when working with Excel.
Understanding Excel Formulas
In this section, we'll cover the basics of Excel formulas and equip you with a solid foundation to build upon. You'll learn about cell references, operators, and functions, and how to create simple formulas to perform calculations. Understanding these fundamental concepts is crucial for effectively utilizing Excel.
What is Excel Formula?
A formula in Microsoft Excel is an expression that operates on the values of a set of cells. Even if the formula returns an error, it will still return a result. Excel formulas allow you to perform addition, subtraction, and multiplication as well as division. Excel formulas allow you to perform calculations such as addition, subtraction, multiplication, and division.
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.
Some Excel Formulas List
| 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 in MS Excel
Excel's sum function is one of the most commonly used functions for computing data. This function sums up a set of numbers within a particular cell. You don't have to enter a cumbersome formula to sum up all your data. Microsoft Excel's newer versions have a button for this function because of its popularity.
TEXT Function in MS Excel
The Text Function is a handy tool to convert a number or date into a text in a specific format. This formula converts numeric values into a string. This formula is useful when users want to display numeric data as a readable form. Note that "TEXT", the formula, only converts numeric values into text.
Download link of PDF of Excel Formulas List
You can download the Excel Formulas List in PDF format using the link given below.
{getButton} $text={Download} $icon={download} $color={#1bc517}