You are tasked with two challenges to level up your Excel skills. Challenge 1 ᎓ Analyse: You are a Data Detective investigating a retail company᎙s sales. Using a dataset of at least 25 rows with Product Name, Category, Region, Sales Amount, Quantity Sold, Month, and Salesperson, identify the highest-selling product, lowest-performing region, and average sales per category. Apply formulas like SUMIF, AVERAGEIF, and COUNTIF, use conditional formatting to highlight low sales, filter top-performing salespeople, and create one column chart and one pie chart. Conclude which category performs best and which region needs improvement. (Google -2023) (ANA)
Syllabus
0/1
Lecture Notes
0/9
Puzzles
0/5
Resource Links
0/2
Assignments
0/2
YouTube Videos
0/7