25 Excel Formulas for Beginners

Excel formulas are equations that you enter into a cell to perform calculations. Here are some basic formulas that beginners should know:

  1. Ctrl + C : Copy the selected cell(s)
  2. Ctrl + V : Paste the copied content
  3. Ctrl + X : Cut the selected cell(s)
  4. Ctrl + Z : Undo the last action
  5. Ctrl + Y : Redo the last action
  6. Ctrl + A : Select all cells in the worksheet
  7. Ctrl + B : Bold the selected text
  8. Ctrl + I : Italicize the selected text
  9. Ctrl + U : Underline the selected text
  10. Ctrl + F : Open the Find and Replace dialog box
  11. Ctrl + P : Open the Print dialog box
  12. Ctrl + S : Save the active worksheet
  13. F2 : Edit the active cell
  14. F5 : Open the Go To dialog box
  15. F7 : Check the spelling in the active worksheet
  16. F11 : Create a chart of the selected data in a new sheet
  17. Alt + = : Insert the SUM function in the selected cells
  18. Ctrl + Shift + ; : Insert the current date in the active cell
  19. Ctrl + ; : Insert the current time in the active cell
  20. Ctrl + Shift + : : Insert the current date and time in the active cell
  21. Sum: Adds the values in a range of cells. For example, "=SUM(A1:A5)" adds the values in cells A1 through A5.
  22. Average: Calculates the average of a range of cells. For example, "=Average(A1:A5)" calculates the average of the values in cells A1 through A5.
  23. Count: Counts the number of cells in a range that contain numbers. For example, "=Count(A1:A5)" counts the number of cells in range A1:A5 that contain numbers.
  24. Max: Returns the largest value in a range of cells. For example, "=Max(A1:A5)" returns the largest value in cells A1 through A5.
  25. Min: Returns the smallest value in a range of cells. For example, "=Min(A1:A5)" returns the smallest value in cells A1 through A5.

Comments

Post a Comment