Courses - Learn Excel Online By Doing
← Back to all Courses

Master IF Statements

ALL DO WATCH PRACTICE UNLOCKED
Learn By Doing
Free

Travel Budget

Create a "Travel Budget" sample.

Learned Excel Functions: REPT(), SUM(), SUMIF()
Learn By Doing

Top Models UNLOCK NOW

Calculate the earnings of top models based on scenarios

Learned Excel Functions: AND(), FALSE(), IF(), OR(), TRUE()
Learn By Doing

Social Security Numbers UNLOCK NOW

Working on Social Security.

Learned Excel Functions: DATE(), IF(), ISEVEN(), ROUND(), ROUNDDOWN(), TODAY(), TRUE(), VLOOKUP(), YEARFRAC()
Learn By Doing

Expense Sheet UNLOCK NOW

Using Nested IF.

Learned Excel Functions: FALSE(), IF(), INDEX(), MATCH(), MAX(), RANK(), SUM(), TRUE()
Learn By Doing

Vacation Day Calculator UNLOCK NOW

Calculate vacation days based on years worked and other conditions

Learned Excel Functions: FALSE(), IF(), INT(), OR(), TODAY(), TRUE(), YEARFRAC()
Learn By Doing

iPhone vs Samsung UNLOCK NOW

Checking formulas results with Iphone-Samsung sales.

Learned Excel Functions: AVERAGE(), CHOOSE(), FALSE(), IF(), IFERROR(), MATCH(), SUM(), VLOOKUP()
Learn By Doing

Stoner UNLOCK NOW

Getting values with VLOOKUP:

Learned Excel Functions: DATE(), FALSE(), IF(), TODAY(), TRUE(), VLOOKUP()
Learn By Doing

Privileged Customers UNLOCK NOW

Matching nested IF() and IFS() functions.

Learned Excel Functions: FALSE(), IF(), IFS(), TRUE()
Learn By Doing

Calculate Data with MAXIFS() and MINIFS() UNLOCK NOW

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

Learned Excel Functions: MAX(), MAXIFS(), MIN(), MINIFS()
Practice

Practice: IF Functions 1 - Numbers UNLOCK NOW

Making more practice by using IF() function.

Learned Excel Functions: IF()
Practice

Practice: IF Functions 8 - Sale Rent UNLOCK NOW

Making more practice by using IF() and OR() functions.

Learned Excel Functions: IF()
Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I UNLOCK NOW

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

Learned Excel Functions: AVERAGEIFS(), COUNTIFS(), SUMIFS()
Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II UNLOCK NOW

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

Learned Excel Functions: AVERAGEIFS(), COUNTIFS(), SUMIFS()
Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III UNLOCK NOW

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

Learned Excel Functions: AVERAGEIFS(), COUNTIFS(), SUMIFS()
Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV UNLOCK NOW

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

Learned Excel Functions: AVERAGEIFS(), COUNTIFS(), SUMIFS()
Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V UNLOCK NOW

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

Learned Excel Functions: AVERAGEIFS(), COUNTIFS(), SUMIFS()
Learn By Watching
Free

Logical formulas: ISNUMBER(), ISTEXT(), ISBLANK(), ISERROR(), ISFORMULA() [04:19]

Learned Excel Functions: ISBLANK(), ISNUMBER(), ISTEXT()
Learn By Watching

Logical formulas: Basics of IF() and Nested IF() [05:20] UNLOCK NOW

Learned Excel Functions: IF()
Learn By Watching

Logical formulas: AND(), OR() [05:15] UNLOCK NOW

Learned Excel Functions: AND(), OR()
Learn By Watching

Logical formulas: Combining IF() w. AND() & OR() [03:30] UNLOCK NOW

Learned Excel Functions: AND(), IF(), OR()
Learn By Watching
Free

SUMIFS(): Conditional Summation (1 criteria) [04:29]

Learned Excel Functions: SUMIFS()
Learn By Watching

SUMIFS(): Conditional Summation (2 criteria) [04:11] UNLOCK NOW

Learned Excel Functions: SUMIFS()
Learn By Watching

SUMIFS(): Conditional Summation (3 criteria) w. date range [05:20] UNLOCK NOW

Learned Excel Functions: SUMIFS()
Learn By Watching

SUMIFS(): Condition based Selective Cumulative Running Total [05:32] UNLOCK NOW

Learned Excel Functions: SUMIFS()
Learn By Watching

COUNTIFS() - Single/Multiple Criteria: Duplicate Count, Instance No. [06:10] UNLOCK NOW

Learned Excel Functions: COUNTIFS()
Practice

Practice: Adding values that meet a single criteria - Part I UNLOCK NOW

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

Learned Excel Functions: AVERAGEIF(), COUNTIF(), SUMIF()
Practice

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

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

Learned Excel Functions: AVERAGEIF(), COUNTIF(), SUMIF()
Practice

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

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

Learned Excel Functions: AVERAGEIF(), COUNTIF(), SUMIF()
Practice

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

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

Learned Excel Functions: AVERAGEIF(), COUNTIF(), SUMIF()
Practice

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

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

Learned Excel Functions: AVERAGEIF(), COUNTIF(), SUMIF()
Practice

Practice: IF Functions 2 - Text UNLOCK NOW

Making more practice by using IF() function.

Learned Excel Functions: IF()
Practice

Practice: IF Functions 3 - Other Functions and If UNLOCK NOW

Making more practice by using IF() function.

Learned Excel Functions: IF(), LEN(), MONTH(), SUM(), YEAR()
Practice

Practice: IF Functions 4 - Bets UNLOCK NOW

Making more practice by using IF() function.

Learned Excel Functions: IF()
Practice

Practice: IF Functions 5 - Items UNLOCK NOW

Making more practice by using IF() function.

Learned Excel Functions: IF()
Practice

Practice: IF Functions 6 - Students UNLOCK NOW

Making more practice by using IF() function.

Learned Excel Functions: AND(), IF(), OR()
Practice

Practice: IF Functions 7 - Customers UNLOCK NOW

Making more practice by using IF() and AND() functions.

Learned Excel Functions: IF()


  • Level: Mastery
  • Exercises: 0/36
  • Steps: 0/209
  • Points: 35.950
  • Approx. Time: 13h 15m

Master IF Statements

Learn how to make decisions based on conditions in Excel, the must for a everyday user

Rating Count : 3

Courses

Excel Paths

Sheetzoom

© 2024 Sheetzoom       Legal Stuff         Made with    in Istanbul

Start learning Excel now

Get notified first! Sign-up free for our newsletter.

Follow Us