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 FunctionShortcut Keys
Close a WorkbookCtrl + W
Repeat Last Command ActionsF4
Open OptionsAlt + F + T
Open HelpF1
UndoCtrl + Z
RedoCtrl + Y
CopyCtrl + C
CutCtrl + X
PasteCtrl + V
Display Paste Special Dialogue BoxCtrl + Alt + V
Find BoxCtrl + F
Find and ReplaceCtrl + H
Find next matchShift + F4
Find Previous MatchCtrl + Shift + F4
Create an Embedded ChartAlt + F1 –
Create Chart in new WorksheetF11
New WorkbookCtrl + N
Open WorkbookCtrl + O
Save WorkbookCtrl + S
Save AsF12
Print FileCtrl + P
Open Print PreviewCtrl + F2
Close WorkbookCtrl + F4
Close ExcelAlt + F4
Expand or close RibbonCtrl + F1
Activate Access KeysAlt
Move to next control on RibbonTab
HelpF1
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
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)

DescriptionExcel Shortcuts
1. To create a new workbookCtrl + N
2. To open an existing workbookCtrl + O
3. To save a workbook/spreadsheetCtrl + S
4. To close the current workbookCtrl + W
5. To close ExcelCtrl + F4
6. To move to the next sheetCtrl + PageDown
7. To move to the previous sheetCtrl + PageUp
8. To go to the Data tabAlt + A
9. To go to the View tabAlt + W
10. To go the Formula tabAlt + M
11. To edit a cellF2
12. To copy and paste cellsCtrl + C, Ctrl + V
13. To italicize and make the font boldCtrl + I, Ctrl + B
14. To center align cell contentsAlt + H + A + C
15. To fill colorAlt + H + H
16. To add a borderAlt + H + B
17. To remove outline borderCtrl + Shift + _
18. To add an outline to the select cellsCtrl + Shift + &
19. To move to the next cellTab
20. To move to the previous cellShift + Tab
21. To select all the cells on the rightCtrl + Shift + Right arrow
22. To select all the cells on the leftCtrl + Shift + Left Arrow
23. To select the column from the selected cell to the end of the tableCtrl + Shift + Down Arrow
24. To select all the cells above the selected cellCtrl + Shift + Up Arrow
25. To select all the cells below the selected cellCtrl + Shift + Down Arrow
26. To add a comment to a cellShift + F2
27. To delete a cell commentShift + F10 + D
28. To display find and replaceCtrl + H
29. To activate the filterCtrl + Shift + L, Alt + Down Arrow
30. To insert the current dateCtrl + ;
31. To insert current timeCtrl + Shift + :
32. To insert a hyperlinkCtrl + k
33. To apply the currency formatCtrl + Shift + \$
34. To apply the percent formatCtrl + Shift + %
35. To go to the “Tell me what you want to do” boxAlt + Q
36. To select the entire rowShift + Space
37. To select the entire columnCtrl + Space
38. To delete a columnAlt+H+D+C
39. To delete a rowShift + Space, Ctrl + –
40. To hide selected rowCtrl + 9
41. To unhide selected rowCtrl + Shift + 9
42. To hide a selected columnCtrl + 0
43. To unhide a selected columnCtrl + Shift + 0
44. To group rows or columnsAlt + Shift + Right arrow
45. To ungroup rows or columnsAlt + Shift + Left arrow
46. To group pivot table itemsAlt + Shift + Right arrow
47. To ungroup pivot table itemsAlt + Shift + Left arrow
48. To hide pivot table itemsCtrl + –
49. To create a pivot chart on the same sheetAlt + F1
50. To create a pivot chart on a new worksheetF11

### 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.