# 32 IF Tutorials Free Excel Training from SheetZoom

SheetZoom has 32 hands-on free IF tutorials/trainings. Step by step learn how use IF in Excel Online. This Excel training with IF formula is free.

### Body Mass Index Calculation

Create a body mass index calculator using height and weight of a person

### Error Handling

Correcting value errors.

### Error Handling

Correcting value errors.

Using Nested IF.

Using Nested IF.

### GYM Complaints Sheet

Master date functions using the complaints data for a gym.

### Highest Paid Celebrities

Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...

### Highest Paid Celebrities

Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...

### International Tourist Data

Calculate which country recieves the most tourists in each continent.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### Most Popular Movies

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

### Most Popular Movies

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

### My First Invoice

Creating an invoice with base functions.

### My First Invoice

Creating an invoice with base functions.

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

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

### Practice: IF Functions 1 - Numbers

Making more practice by using IF() function.

### Practice: IF Functions 2 - Text

Making more practice by using IF() function.

### Practice: IF Functions 3 - Other Functions and If

Making more practice by using IF() function.

### Practice: IF Functions 4 - Bets

Making more practice by using IF() function.

### Practice: IF Functions 5 - Items

Making more practice by using IF() function.

### Practice: IF Functions 6 - Students

Making more practice by using IF() function.

### Practice: IF Functions 7 - Customers

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

### Practice: IF Functions 8 - Sale Rent

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

### Privileged Customers

Matching nested IF() and IFS() functions.

### Privileged Customers

Matching nested IF() and IFS() functions.

### Salesperson Ratings

Create a summary of salesperson sales stats with the help of range lookup.

### Salesperson Ratings

Create a summary of salesperson sales stats with the help of range lookup.

### Social Security Numbers

Working on Social Security.

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Stoner

Getting values with VLOOKUP:

### Top Models

Calculate the earnings of top models based on scenarios

### Top Models

Calculate the earnings of top models based on scenarios

### Vacation Day Calculator

Calculate vacation days based on years worked and other conditions

### Vacation Day Calculator

Calculate vacation days based on years worked and other conditions

### Weekly Timesheet

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

# Increase your efficiency, shine like an office star.

Sheetzoom is a revolutionary way to learn Excel in your browser or desktop
and it is fun, hands-on and teaches fast.

## Learn in Excel

All exercises are done using the actual Excel software covering all daily used formulas.

## No Software Needed

You don't need to have Excel installed, just login to the Sheetzoom.

## Real Life Examples

All exercises are done using the actual Excel software

## In Browser or Excel App

Available in browser or your Excel 2016 desktop application.