# 23 TRUE Tutorials Free Excel Training from SheetZoom

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

### Body Mass Index Calculation

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

### Coffee Shop Price Table

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

### Coffee Shop Price Table

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

### Customer & Order Table

Getting special information from the table.

### Customer & Order Table

Getting special information from the table.

### Employee List

Lookup employee information from the employee list based on different parameters

Using Nested IF.

Using Nested IF.

### Good Biscuit

Understanding formulas with "Sales" operations.

### Good Biscuit

Understanding formulas with "Sales" operations.

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

### IBAN Numbers

Working on banking operations.

### IBAN Numbers

Working on banking operations.

### International Tourist Data

Calculate which country recieves the most tourists in each continent.

### My First Invoice

Creating an invoice with base functions.

### New Text Functions

Combine text strings using TEXTJOIN() and CONCAT().

### Practice: Date Functions

Making more practice by using date 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.

### Social Security Numbers

Working on Social Security.

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Staff Data

Getting some information with VLOOKUP on "Employee Data"

### Staff Data

Getting some information with VLOOKUP on "Employee Data"

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

### Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

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