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.
If you work with Microsoft Excel daily, you already know how powerful formulas can be. From simple calculations to complex data analysis, formulas make Excel an essential tool for every professional.
To help you master Excel, we’ve compiled the Top 150 Excel Formulas PDF download, a comprehensive and easy-to-follow Excel formulas PDF list covering all major functions — from SUM and IF to VLOOKUP, INDEX MATCH, and more.
In this post, you’ll find:
✅ Direct download link for the Excel Formulas PDF
✅ Categorized list of 150 most-used Excel formulas
✅ Examples and explanations for each formula
✅ A bonus cheat sheet to help you work faster
Why You Need an Excel Formulas PDF List
Whether you’re a student, accountant, data analyst, or business professional, Excel formulas are your best friend for automating repetitive work. Having an Excel formulas PDF list means you can quickly refer to any formula without searching online.
Also Read: Download IELTS Vocabulary List PDF (Free Word List for Band 7+)
Here’s what you’ll get in the Top 150 Excel Formulas PDF download:
- Error handling (IFERROR, ISBLANK, ISNUMBER)
- Arithmetic formulas (SUM, AVERAGE, COUNT, ROUND)
- Logical formulas (IF, AND, OR, NOT)
- Lookup formulas (VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH)
- Text formulas (LEFT, RIGHT, CONCATENATE, LEN)
- Date & Time formulas (TODAY, NOW, DATEDIF, EOMONTH)
- Statistical formulas (MAX, MIN, MEDIAN, MODE)
Financial formulas (PMT, FV, NPV, IRR)
Understanding Top 150 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.
Most Commonly Used Excel Formulas
Here are some of the most used formulas from the Top 150 Excel Formulas PDF download:
| Category | Formula | Example |
|---|---|---|
| Basic | =SUM(A1:A10) | Adds values in A1 to A10 |
| Logical | =IF(A1>100,"Yes","No") | Returns “Yes” if A1 > 100 |
| Lookup | =VLOOKUP(B2, A1:C10, 3, FALSE) | Finds data in a table |
| Text | =CONCATENATE(A1," ",B1) | Joins text from two cells |
| Date | =TODAY() | Displays current date |
| Error Handling | =IFERROR(VLOOKUP(...),"Not Found") | Avoids #N/A error |
How to Use the Excel Formulas Cheat Sheet PDF
- Download the PDF file from the link above.
- Print or keep it on your desktop for quick reference.
- Use Ctrl + F in the PDF to search any formula instantly.
- Practice each formula on real Excel data for better understanding.
Some Excel Formulas in Top 150 Excel Formulas
| 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.
Bonus: Excel Keyboard Shortcuts List
Along with formulas, mastering Excel shortcuts can save hours of work. Your PDF includes a bonus section of 50+ Excel shortcuts, such as:
- Ctrl + T → Create a Table
- Alt + = → AutoSum
- Ctrl + Shift + L → Add/Remove Filters
- F4 → Repeat last action
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 Top 150 Excel Formulas PDF List
You can download the Top 150 Excel Formulas list in PDF format using the link given below.
The Top 150 Excel Formulas PDF download is the ultimate reference for anyone who wants to improve their Excel productivity. Keep this Excel formulas PDF list handy to save time, boost accuracy, and become an Excel pro.
1 thought on “Top 150 Excel Formulas PDF Download | Complete Excel Formulas PDF List”