Free Excel Training and Courses

Employee List

Lookup employee information from the employee list based on different parameters

Employee List

Lookup employee information from the employee list based on different parameters

Body Mass Index Calculation

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

Body Mass Index Calculation

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

Special Use of Lookups

Try using vertical lookup instead of if statements

Special Use of Lookups

Try using vertical lookup instead of if statements

Top Models

Calculate the earnings of top models based on scenarios

Top Models

Calculate the earnings of top models based on scenarios

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.

Good Biscuit

Understanding formulas with "Sales" operations.

Good Biscuit

Understanding formulas with "Sales" operations.

My First Invoice

Creating an invoice with base functions.

My First Invoice

Creating an invoice with base functions.

International Tourist Data

Calculate which country recieves the most tourists in each continent.

International Tourist Data

Calculate which country recieves the most tourists in each continent.

IBAN Numbers

Working on banking operations.

IBAN Numbers

Working on banking operations.

Stoner

Getting values with VLOOKUP:

Stoner

Getting values with VLOOKUP:

New Text Functions

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

New Text Functions

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

Customer & Order Table

Getting special information from the table.

Customer & Order Table

Getting special information from the table.

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

Practice: Date Functions

Making more practice by using date functions.

Practice: Date Functions

Making more practice by using date functions.

Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

Social Security Numbers

Working on Social Security.

Social Security Numbers

Working on Social Security.

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

GYM Complaints Sheet

Master date functions using the complaints data for a gym.

GYM Complaints Sheet

Master date functions using the complaints data for a gym.

Staff Data

Getting some information with VLOOKUP on "Employee Data"

Staff Data

Getting some information with VLOOKUP on "Employee Data"

Privileged Customers

Matching nested IF() and IFS() functions.

Privileged Customers

Matching nested IF() and IFS() functions.

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

Using Nested IF.

Using Nested IF.

Employee List

Lookup employee information from the employee list based on different parameters

Special Use of Lookups

Try using vertical lookup instead of if statements

Top Models

Calculate the earnings of top models based on scenarios

Practice: Date Functions

Making more practice by using date functions.

GYM Complaints Sheet

Master date functions using the complaints data for a gym.

Coffee Shop Price Table

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

Body Mass Index Calculation

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

Salesperson Ratings

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

Good Biscuit

Understanding formulas with "Sales" operations.

My First Invoice

Creating an invoice with base functions.

International Tourist Data

Calculate which country recieves the most tourists in each continent.

IBAN Numbers

Working on banking operations.

Stoner

Getting values with VLOOKUP:

New Text Functions

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

Customer & Order Table

Getting special information from the table.

Highest Paid Celebrities

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

Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

Social Security Numbers

Working on Social Security.

Vacation Day Calculator

Calculate vacation days based on years worked and other conditions

Staff Data

Getting some information with VLOOKUP on "Employee Data"

Privileged Customers

Matching nested IF() and IFS() functions.