Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Conditional Functions | Basic Data Analysis
Data Analysis with Excel
course content

Зміст курсу

Data Analysis with Excel

Data Analysis with Excel

1. Data Management and Manipulation
2. Basic Data Analysis
3. Data Visualization and Automation
4. Advanced Data Analytics Techniques

Conditional Functions

Conditional functions like SUMIFS and COUNTIFS allow users to perform complex data analyses by setting specific criteria.

These functions are critical for data-driven decision making and can then be used as a part of more complex calculations.

Task

First, please download the dataset we'll be using in this section:

Now let's use these functions to gain some insights:

  • Determine the total number of Hair Shampoos sold.
  • Find out how many transactions involved purchasing more than one Toy.
1. How many Hair Shampoos were sold?
2. How many transactions included purchasing more than one Toy?

How many Hair Shampoos were sold?

Виберіть правильну відповідь

How many transactions included purchasing more than one Toy?

Виберіть правильну відповідь

Все було зрозуміло?

Секція 2. Розділ 1
We're sorry to hear that something went wrong. What happened?
some-alt