Array Formula using MAX()/MIN() and IF() - 2 criteria

• Beginner
• 250
• 250 points

 Building MAX + IF and MIN + IF with one condition - Example 2

• Beginner
• 250
• 250 points

 Building MAX + IF and MIN + IF with one condition - Example 2

• Beginner
• 250
• 250 points

Calculate Data with MAXIFS() and MINIFS()

• Beginner
• 800
• 800 points

Using MAXIFS() and MINIFS() at a basic level.

Calculate Data with MAXIFS() and MINIFS()

• Beginner
• 800
• 800 points

Using MAXIFS() and MINIFS() at a basic level.

Expense Sheet

• Unknown
• 1500
• 1.500 points

Using Nested IF.

Expense Sheet

• Unknown
• 1500
• 1.500 points

Using Nested IF.

MAX() in Financial Modeling

• Beginner
• 250
• 250 points

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

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: Basic functions-I

• Unknown
• 500
• 500 points

Using basic functions with more practices.

Practice: Basic functions-II

• Unknown
• 300
• 300 points

Using basic functions with more practices.

Practice: Basic functions-II

• Unknown
• 300
• 300 points

Using basic functions with more practices.

Practice: Basic functions-III

• Beginner
• 800
• 800 points

Using basic functions with more practices.

Practice: Basic functions-III

• Beginner
• 800
• 800 points

Using basic functions with more practices.

Practice: Basic functions-IV

• Beginner
• 1000
• 1.000 points

Using basic functions with more practices.

Practice: Understanding Absolute References-II

• Unknown
• 500
• 500 points

Using basic functions with more practices.

Practice: Understanding Absolute References-II

• Unknown
• 500
• 500 points

Using basic functions with more practices.

Profitability of a Theater

• Beginner
• 1300
• 1.300 points

Using four operations and statistical functions over a scenario about play tickets status of a theater.

Special Use of Lookups

• Intermediate
• 2400
• 2.400 points

Try using vertical lookup instead of if statements

World Internet Users Statistics

• Intermediate
• 700
• 700 points

Create meaningful insights from internet users of top 25 countries between 2013-2015.