Some Additional Functions

• You can not be expected to memorize all of the functions in excel.
  • If you start to look, there must be hundreds.
• But there are some very common functions you will probably want to know.
  • Basic math
  • Statistical
  • Counting
  • Dates
• I am going to use this data.
  • This is fictional data.
  • For 20 people it has
    • A first and last name.
    • A date
    • A donation of money amount
    • A donation of time amount
• use the sum function in cells d23 and E23
• use the max function in cells d24 and E24
• use the min function in cells d25 and E25
• use the mean function in cells d26 and E26
• use the median function in cells d27 and E27
• use the count function in cells d28 and E28
• use the countblank function in cells d29 and E29
• use the counta function in cells d30 and E30
• use the day function in cell f2
• use the month function in cell g2
• use the weekday function in cell h2
• use today()-c2 in cell i2