19 IF Tutorials Free Excel Training from SheetZoom

SheetZoom has 19 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

Body Mass Index Calculation

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


Error Handling

Error Handling

Correcting value errors.


Expense Sheet

Expense Sheet

Using Nested IF.


GYM Complaints Sheet

GYM Complaints Sheet

Master date functions using the complaints data for a gym.


Highest Paid Celebrities

Highest Paid Celebrities

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


International Tourist Data

International Tourist Data

Calculate which country recieves the most tourists in each continent.


iPhone vs Samsung

iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.


Most Popular Movies

Most Popular Movies

Getting produced year of popular films of the IMDB from unformatted title information with year. Also calculating votes ...


My First Invoice

My First Invoice

Creating an invoice with base functions.


New Employee ID Badge

New Employee ID Badge

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


Privileged Customers

Privileged Customers

Matching nested IF() and IFS() functions.


Salesperson Ratings

Salesperson Ratings

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


Social Security Numbers

Social Security Numbers

Working on Social Security.


Special Use of Lookups

Special Use of Lookups

Try using vertical lookup instead of if statements


Stoner

Stoner

Getting values with VLOOKUP:


Top Models

Top Models

Calculate the earnings of top models based on scenarios


Vacation Day Calculator

Vacation Day Calculator

Calculate vacation days based on years worked and other conditions


Weekly Timesheet

Weekly Timesheet

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


Win a lottary ticket

Win a lottary ticket

Working with advanced functions.


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.

Start Learning Excel Now!

Join our club of happy learners and start your journey to become an Excel ninja!

;