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...

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...

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...