Richest Business People
Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...
Richest Business People
Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...
Oil Production
Learn absolute and relative referencing using a sample data about oil production in Northern American countries.
Oil Production
Learn absolute and relative referencing using a sample data about oil production in Northern American countries.
Regional Sales Data
Revisit your sales data, calculate regional totals, conditional totals
Regional Sales Data
Revisit your sales data, calculate regional totals, conditional totals
Most Popular Movies
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
Most Popular Movies
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
World Internet Users Statistics
Create meaningful insights from internet users of top 25 countries between 2013-2015.
World Internet Users Statistics
Create meaningful insights from internet users of top 25 countries between 2013-2015.
Electronic Sales
Using formulas for "Electronic Sales" operations.
Electronic Sales
Using formulas for "Electronic Sales" operations.
Practice: Adding values that meet a single criteria - Part III
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Practice: Adding values that meet a single criteria - Part III
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Practice: Adding values that meet a single criteria - Part II
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Practice: Adding values that meet a single criteria - Part II
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Practice: Basic functions-III
Using basic functions with more practices.
Practice: Basic functions-III
Using basic functions with more practices.
Practice: Basic functions-I
Using basic functions with more practices.
Practice: Basic functions-I
Using basic functions with more practices.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Profitability of a Theater
Using four operations and statistical functions over a scenario about play tickets status of a theater.
Good Biscuit
Understanding formulas with "Sales" operations.
Good Biscuit
Understanding formulas with "Sales" operations.
Practice: Adding values that meet a single criteria - Part IV
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Practice: Adding values that meet a single criteria - Part IV
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Practice: Basic functions-II
Using basic functions with more practices.
Practice: Basic functions-II
Using basic functions with more practices.
Weekly Timesheet
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
Weekly Timesheet
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
International Tourist Data
Calculate which country recieves the most tourists in each continent.
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 - V
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Practice: IF Functions 3 - Other Functions and If
Making more practice by using IF() function.
Practice: IF Functions 3 - Other Functions and If
Making more practice by using IF() function.
Practice: Basic functions-IV
Using basic functions with more practices.
Practice: Basic functions-IV
Using basic functions with more practices.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I
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.
Beverage Sales
Drill down your sales data using an alternative lookup method.
Practice: Adding values that meet a single criteria - Part V
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Practice: Adding values that meet a single criteria - Part V
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Salesperson Ratings
Create a summary of salesperson sales stats with the help of range lookup.
Salesperson Ratings
Create a summary of salesperson sales stats with the help of range lookup.
Hotel California
Basic revenue calculation by implementing stays, discounts and tax.
Hotel California
Basic revenue calculation by implementing stays, discounts and tax.
Practice: Working with operators
Using basic functions with more practices.
Practice: Working with operators
Using basic functions with more practices.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Practice: Time Function
Making more practice by using time functions.
Practice: Time Function
Making more practice by using time functions.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II
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.
Practice: Adding values that meet a single criteria - Part I
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Practice: Adding values that meet a single criteria - Part I
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Highest Paid Celebrities
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
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.
iPhone vs Samsung
Checking formulas results with Iphone-Samsung sales.
Practice: Understanding Absolute References-II
Using basic functions with more practices.
Practice: Understanding Absolute References-II
Using basic functions with more practices.
Richest Business People
Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...
Oil Production
Learn absolute and relative referencing using a sample data about oil production in Northern American countries.
Most Popular Movies
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
Practice: Adding values that meet a single criteria - Part III
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Practice: Adding values that meet a single criteria - Part II
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Practice: Basic functions-III
Using basic functions with more practices.
Practice: Adding values that meet a single criteria - Part IV
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Weekly Timesheet
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
Practice: Basic functions-IV
Using basic functions with more practices.
Practice: Adding values that meet a single criteria - Part V
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Hotel California
Basic revenue calculation by implementing stays, discounts and tax.
Practice: Working with operators
Using basic functions with more practices.
Practice: Time Function
Making more practice by using time functions.
Practice: Adding values that meet a single criteria - Part I
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Practice: Understanding Absolute References-II
Using basic functions with more practices.
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.
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.
Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II
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.
