Special Use of Lookups
Try using vertical lookup instead of if statements
Special Use of Lookups
Try using vertical lookup instead of if statements
Regional Sales Data
Revisit your sales data, calculate regional totals, conditional totals
Regional Sales Data
Revisit your sales data, calculate regional totals, conditional totals
Top Models
Calculate the earnings of top models based on scenarios
Top Models
Calculate the earnings of top models based on scenarios
Body Mass Index Calculation
Create a body mass index calculator using height and weight of a person
Body Mass Index Calculation
Create a body mass index calculator using height and weight of a person
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...
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...
Practice: IF Functions 4 - Bets
Making more practice by using IF() function.
Practice: IF Functions 4 - Bets
Making more practice by using IF() function.
iPhone vs Samsung
Checking formulas results with Iphone-Samsung sales.
iPhone vs Samsung
Checking formulas results with Iphone-Samsung sales.
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.
Practice: IF Functions 6 - Students
Making more practice by using IF() function.
Practice: IF Functions 6 - Students
Making more practice by using IF() function.
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.
Vacation Day Calculator
Calculate vacation days based on years worked and other conditions
Vacation Day Calculator
Calculate vacation days based on years worked and other conditions
Practice: IF Functions 8 - Sale Rent
Making more practice by using IF() and OR() functions.
Practice: IF Functions 8 - Sale Rent
Making more practice by using IF() and OR() functions.
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.
GYM Complaints Sheet
Master date functions using the complaints data for a gym.
GYM Complaints Sheet
Master date functions using the complaints data for a gym.
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: IF Functions 2 - Text
Making more practice by using IF() function.
Practice: IF Functions 2 - Text
Making more practice by using IF() function.
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.
Privileged Customers
Matching nested IF() and IFS() functions.
Privileged Customers
Matching nested IF() and IFS() functions.
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.
Calculate Data with MAXIFS() and MINIFS()
Using MAXIFS() and MINIFS() at a basic level.
Calculate Data with MAXIFS() and MINIFS()
Using MAXIFS() and MINIFS() at a basic level.
Practice: IF Functions 7 - Customers
Making more practice by using IF() and AND() functions.
Practice: IF Functions 7 - Customers
Making more practice by using IF() and AND() functions.
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: 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.
Practice: IF Functions 1 - Numbers
Making more practice by using IF() function.
Practice: IF Functions 1 - Numbers
Making more practice by using IF() function.
Practice: IF Functions 5 - Items
Making more practice by using IF() function.
Practice: IF Functions 5 - Items
Making more practice by using IF() function.
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.
New Employee ID Badge
Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...
New Employee ID Badge
Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...
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...
Special Use of Lookups
Try using vertical lookup instead of if statements
Top Models
Calculate the earnings of top models based on scenarios
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...
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 V
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Most Popular Movies
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
GYM Complaints Sheet
Master date functions using the complaints data for a gym.
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 IV
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
New Employee ID Badge
Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...
Weekly Timesheet
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
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
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.
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.
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.
