Try using vertical lookup instead of if statements
Try using vertical lookup instead of if statements
Calculate the earnings of top models based on scenarios
Calculate the earnings of top models based on scenarios
Revisit your sales data, calculate regional totals, conditional totals
Revisit your sales data, calculate regional totals, conditional totals
Round your sales data do decimals, nearest thousand and many more
Round your sales data do decimals, nearest thousand and many more
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...
Calculate work days considering holidays, weekends and number of days worked
Calculate work days considering holidays, weekends and number of days worked
Create a handy trigonometry cheat sheet for commonly used angles.
Create a handy trigonometry cheat sheet for commonly used angles.
Lookup employee information from the employee list based on different parameters
Lookup employee information from the employee list based on different parameters
Create some statistics to better understand the social media adoption
Create some statistics to better understand the social media adoption
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 workday function.
Making more practice by using workday function.
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.
Using four operations and statistical functions over a scenario about play tickets status of a theater.
Understanding formulas with "Sales" operations.
Understanding formulas with "Sales" operations.
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 basic functions with more practices.
Using basic functions with more practices.
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...
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.
Using basic functions with more practices.
Using basic functions with more practices.
Combine text strings using TEXTJOIN() and CONCAT().
Combine text strings using TEXTJOIN() and CONCAT().
Getting special information from the table.
Getting special information from the table.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Drill down your sales data using an alternative lookup method.
Drill down your sales data using an alternative lookup method.
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.
Making more practice by using TODAY() and NOW() functions
Making more practice by using TODAY() and NOW() 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 date functions.
Making more practice by using date functions.
Using basic functions with more practices.
Using basic functions with more practices.
Making more practice by using date functions.
Making more practice by using date functions.
Calculate vacation days based on years worked and other conditions
Calculate vacation days based on years worked and other conditions
Using basic functions with more practices.
Using basic functions with more practices.
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.
Using formulas for "Electronic Sales" operations.
Using formulas for "Electronic Sales" operations.
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 some information with VLOOKUP on "Employee Data"
Getting some information with VLOOKUP on "Employee Data"
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 time functions.
Making more practice by using time functions.
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
Using basic functions with more practices.
Using basic functions with more practices.
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.
Try using vertical lookup instead of if statements
Calculate the earnings of top models based on scenarios
Round your sales data do decimals, nearest thousand and many more
Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...
Calculate work days considering holidays, weekends and number of days worked
Lookup employee information from the employee list based on different parameters
Create some statistics to better understand the social media adoption
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Making more practice by using workday function.
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...
Using basic functions with more practices.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Making more practice by using TODAY() and NOW() functions
Making more practice by using date functions.
Using basic functions with more practices.
Making more practice by using date functions.
Using basic functions with more practices.
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.
Making more practice by using time functions.
Using basic functions with more practices.
Revisit your sales data, calculate regional totals, conditional totals
Create a handy trigonometry cheat sheet for commonly used angles.
Create a summary of salesperson sales stats with the help of range lookup.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Calculate which country recieves the most tourists in each continent.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Combine text strings using TEXTJOIN() and CONCAT().
Getting special information from the table.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Drill down your sales data using an alternative lookup method.
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...
Calculate vacation days based on years worked and other conditions
Create meaningful insights from internet users of top 25 countries between 2013-2015.
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Using MAXIFS() and MINIFS() at a basic level.