Regional Sales Data
Revisit your sales data, calculate regional totals, conditional totals
Body Mass Index Calculation
Create a body mass index calculator using height and weight of a person
Highest Paid Celebrities
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
iPhone vs Samsung
Checking formulas results with Iphone-Samsung sales.
International Tourist Data
Calculate which country recieves the most tourists in each continent.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Salesperson Ratings
Create a summary of salesperson sales stats with the help of range lookup.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Vacation Day Calculator
Calculate vacation days based on years worked and other conditions
World Internet Users Statistics
Create meaningful insights from internet users of top 25 countries between 2013-2015.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Calculate Data with MAXIFS() and MINIFS()
Using MAXIFS() and MINIFS() at a basic level.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
