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

Employee List

• Intermediate
• 1300
• 1.300 points

Lookup employee information from the employee list based on different parameters

Social Media Statistics

• Intermediate
• 1100
• 1.100 points

Create some statistics to better understand the social media adoption

GYM Complaints Sheet

• Unknown
• 900
• 900 points

Master date functions using the complaints data for a gym.

Coffee Shop Price Table

• Unknown
• 900
• 900 points

Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...

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