Regional Sales Data
Revisit your sales data, calculate regional totals, conditional totals
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.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
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.
Beverage Sales
Drill down your sales data using an alternative lookup method.
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.
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.
