Try using vertical lookup instead of if statements
Try using vertical lookup instead of if statements
Revisit your sales data, calculate regional totals, conditional totals
Revisit your sales data, calculate regional totals, conditional totals
Calculate the earnings of top models based on scenarios
Calculate the earnings of top models based on scenarios
Create a body mass index calculator using height and weight of a person
Create a body mass index calculator using height and weight of a person
Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...
Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
Making more practice by using IF() function.
Making more practice by using IF() function.
Checking formulas results with Iphone-Samsung sales.
Checking formulas results with Iphone-Samsung sales.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Create a summary of salesperson sales stats with the help of range lookup.
Create a summary of salesperson sales stats with the help of range lookup.
Making more practice by using IF() function.
Making more practice by using IF() function.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Calculate vacation days based on years worked and other conditions
Calculate vacation days based on years worked and other conditions
Making more practice by using IF() and OR() functions.
Making more practice by using IF() and OR() functions.
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
Create meaningful insights from internet users of top 25 countries between 2013-2015.
Create meaningful insights from internet users of top 25 countries between 2013-2015.
Master date functions using the complaints data for a gym.
Master date functions using the complaints data for a gym.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Making more practice by using IF() function.
Making more practice by using IF() function.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Matching nested IF() and IFS() functions.
Matching nested IF() and IFS() functions.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Using MAXIFS() and MINIFS() at a basic level.
Using MAXIFS() and MINIFS() at a basic level.
Making more practice by using IF() and AND() functions.
Making more practice by using IF() and AND() functions.
Calculate which country recieves the most tourists in each continent.
Calculate which country recieves the most tourists in each continent.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Making more practice by using IF() function.
Making more practice by using IF() function.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Making more practice by using IF() function.
Making more practice by using IF() function.
Making more practice by using IF() function.
Making more practice by using IF() function.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...
Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
Try using vertical lookup instead of if statements
Calculate the earnings of top models based on scenarios
Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
Master date functions using the complaints data for a gym.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
Revisit your sales data, calculate regional totals, conditional totals
Create a body mass index calculator using height and weight of a person
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
Checking formulas results with Iphone-Samsung sales.
Create a summary of salesperson sales stats with the help of range lookup.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Calculate vacation days based on years worked and other conditions
Create meaningful insights from internet users of top 25 countries between 2013-2015.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Using MAXIFS() and MINIFS() at a basic level.
Calculate which country recieves the most tourists in each continent.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.