Overview of Excel Functions

This lesson introduces functions generally, using the SUM function as an example. We discuss what functions are and how they are used, how you can find and use any particular function, and common ways of including functions within formulas.

It's a long lesson. The start times of various sections within the video are listed below.

Video sections and timestamps:

  1. Lesson outline (0:00)
  2. Example 1: Adding numbers using the addition operator (+) (0:40)
  3. Example 2: Using the SUM function with individual cell references (1:02)
  4. Example 3: The SUM function with a range reference (2:35)
  5. Example 4: The SUM function typed in (2:59)
  6. Syntax (3:39)
  7. Arguments (3:54)
  8. Finding and using functions (5:29)
  9. Searching with the 'Insert Function' dialogue box (6:51)
  10. Help articles (9:34)
  11. Searching online for help (12:24)
  12. Formula AutoComplete (15:34)
  13. Point mode (17:01)