September 23, 2023

Formulas and Functions in Excel

Formulas and functions are the bread and butter of Excel. They drive almost everything interesting and useful you will ever do in a spreadsheet. This article introduces the basic concepts you need to know to be proficient with formulas in Excel.

Formulas and Functions in Excel - Formulas and Functions in Excel

  1. How to count cells in excel
  2. Counta excel function
  3. How to use countif in excel
  4. How to use countifs in excel
  5. Sum excel formula
  6. Sumif excel example
  7. How to use sumifs in excel
  8. Average excel formula
  9. How to use averageif in excel
  10. How to use averageifs in excel
  11. What is countblank function in excel
  12. How to use sumproduct in excel
  13. How to use max function in excel
  14. How to use the Excel MAXA function
  15. How to use min function in excel
  16. How to use the Excel MINA function
  17. How to use if function in excel
  18. How to use the Excel AND function
  19. How to use the Excel OR function
  20. How to use the Excel YEAR function
  21. How to use month function in excel
  22. How to use Day function in excel
  23. How to use the Excel DAYS function
  24. How to use now function in excel
  25. How to use the Excel HOUR function
  26. Excel minute function
  27. How to use the Excel SECOND function
  28. How to use the Excel TIME function
  29. How to use the Excel DATEDIF function
  30. How to use the Excel WEEKDAY function
  31. How to use the Excel TEXT function