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.
Everything was clear?