Conteúdo do Curso

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**.

Tudo estava claro?