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
Learn absolute and relative referencing using a sample data about oil production in Northern American countries.
Learn absolute and relative referencing using a sample data about oil production in Northern American countries.
Round your sales data do decimals, nearest thousand and many more
Round your sales data do decimals, nearest thousand and many more
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
Lookup employee information from the employee list based on different parameters
Lookup employee information from the employee list based on different parameters
Create a handy trigonometry cheat sheet for commonly used angles.
Create a handy trigonometry cheat sheet for commonly used angles.
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 various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order...
Create various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order...
Create some statistics to better understand the social media adoption
Create some statistics to better understand the social media adoption
Making more practice by using text functions for date operations.
Making more practice by using text functions for date operations.
Making more practice by using workday function.
Making more practice by using workday function.
Basic revenue calculation by implementing stays, discounts and tax.
Basic revenue calculation by implementing stays, discounts and tax.
Practice your skills about pivot tables.
Practice your skills about pivot tables.
Practice your skills about pivot tables.
Practice your skills about pivot tables.
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 SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Practice your skills about pivot tables.
Practice your skills about pivot tables.
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 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...
Practice your skills about pivot tables.
Practice your skills about pivot tables.
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
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...
Using filters and subtotal functions.
Using filters and subtotal functions.
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.
Making more practice by using networkday function.
Making more practice by using networkday function.
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.
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 time functions.
Making more practice by using time 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.
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.
Try using vertical lookup instead of if statements
Calculate the earnings of top models based on scenarios
Learn absolute and relative referencing using a sample data about oil production in Northern American countries.
Round your sales data do decimals, nearest thousand and many more
Lookup employee information from the employee list based on different parameters
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
Create various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order...
Create some statistics to better understand the social media adoption
Making more practice by using text functions for date operations.
Making more practice by using workday function.
Basic revenue calculation by implementing stays, discounts and tax.
Practice your skills about pivot tables.
Practice your skills about pivot tables.
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...
Making more practice by using date functions.
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
Making more practice by using networkday function.
Making more practice by using time functions.
Making more practice by using date functions.
Revisit your sales data, calculate regional totals, conditional totals
Create a body mass index calculator using height and weight of a person
Create a handy trigonometry cheat sheet for commonly used angles.
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
Using filters and subtotal functions.
Create meaningful insights from internet users of top 25 countries between 2013-2015.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
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...
Combine text strings using TEXTJOIN() and CONCAT().
Getting special information from the table.