Excel - Functions 1

Basic knowledge of Excel

• Be able to create formulas including one or more functions

• Use the function wizard: search, categories, arguments, help
• Use absolute references in formulas
• Statistical functions
  • MAX, MIN, AVERAGE, COUNT, COUNTIF(S), COUNTA…
• Text functions
  • MID, RIGHT, LEFT, CONCATENATE…
• Logical
  • IF
• Date and Time
  • TODAY, DATEDIF, DATE, YEAR, MONTH, DAY…