Special Use of Lookups

• Intermediate
• 2400
• 2.400 points

Try using vertical lookup instead of if statements

Top Models

• Intermediate
• 1500
• 1.500 points

Calculate the earnings of top models based on scenarios

Richest Business People

• Intermediate
• 1600
• 1.600 points

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

• Advanced
• 1600
• 1.600 points

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

Practice: Adding values that meet a single criteria - Part IV

• Intermediate
• 2000
• 2.000 points

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

New Employee ID Badge

• Intermediate
• 1300
• 1.300 points

Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...

Weekly Timesheet

• Intermediate
• 700
• 700 points

Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...

Practice: Adding values that meet a single criteria - Part V

• Advanced
• 1000
• 1.000 points

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

Travel Budget

• Beginner
• 1100
• 1.100 points

Create a "Travel Budget" sample.

Most Popular Movies

• Intermediate
• 2300
• 2.300 points

Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...

GYM Complaints Sheet

• Unknown
• 900
• 900 points

Master date functions using the complaints data for a gym.

Practice: Adding values that meet a single criteria - Part III

• Advanced
• 1600
• 1.600 points

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

Practice: Adding values that meet a single criteria - Part II

• Advanced
• 1800
• 1.800 points

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.