Fundamental

Ten Must-Know Functions

There are almost 500 functions built into Microsoft Excel, but the vast majority of work is carried out by these top-ten powerhouses. Starting with the venerable Sum function, you’ll quickly move into Aggregate functions that will count how many, calculate the highest number and average large sums. But functions are just about numbers. You’ll also learn how to combine text with Excel’s latest functions and calculate today’s date on the fly.

  1. Sum()
  2. Average()
  3. Max()
  4. Count()
  5. CountA()
  6. Round()
  7. Concat() 
  8. TextJoin()
  9. Left()
  10. Today()