Perform Operations with formulas and functions

Select a chapter above and press 'Show Content'. Click a video topic below to view.

    Chapter 4 Perform Operations with formulas and functions ( 10 videos)  (Practice Test)

      4.1: Summarize data by using functions
      Summarize data using functions
    1. Summarize data using functions
      2. Solution Practice Task 4.1 Project 1
    2. Solution Practice Task 4.1 Project 1
      3. Solution Practice Task 4.1 Project 2
    3. Solution Practice Task 4.1 Project 2
      4.2: Perform conditional operations by using functions (Practice Test)
      Conditional functions using IF and COUNTIF
    1. Conditional functions using IF and COUNTIF
      2. Conditional functions IF and AVERAGEIF
    2. Conditional functions IF and AVERAGEIF
      3. Solution Practice Task 4.2 Project 1
    3. Solution Practice Task 4.2 Project 1
      4. Solution Practice Task 4.2 Project 2
    4. Solution Practice Task 4.2 Project 2
      5. Solution Practice Task 4.2 Project 3
    5. Solution Practice Task 4.2 Project 3
      4.3: Format and modify text by using functions
      Format, Modify and Combine text using functions
    1. Format, Modify and Combine text using functions
      2. Solution Practice Task 4.3
    2. Solution Practice Task 4.3