Free Excel Training and Courses

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

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

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

### Social Media Statistics

Create some statistics to better understand the social media adoption

### Social Media Statistics

Create some statistics to better understand the social media adoption

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

### Practice: VLOOKUP-IV

Making more practice by using lookup functions.

### Practice: VLOOKUP-IV

Making more practice by using lookup functions.

### Profitability of a Theater

Using four operations and statistical functions over a scenario about play tickets status of a theater.

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

### Weekly Timesheet

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

### Weekly Timesheet

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

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

### Practice: HLOOKUP

Making more practice by using lookup functions.

### Practice: HLOOKUP

Making more practice by using lookup functions.

### IBAN Numbers

Working on banking operations.

### IBAN Numbers

Working on banking operations.

### Stoner

Getting values with VLOOKUP:

### Stoner

Getting values with VLOOKUP:

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

### Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

### Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

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

### Electronic Sales

Using formulas for "Electronic Sales" operations.

### Electronic Sales

Using formulas for "Electronic Sales" operations.

### Practice: VLOOKUP-I

Making more practice by using lookup functions.

### Practice: VLOOKUP-I

Making more practice by using lookup functions.

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

### Practice: VLOOKUP-III

Making more practice by using lookup functions.

### Practice: VLOOKUP-III

Making more practice by using lookup 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() ...

### Practice: VLOOKUP-V

Making more practice by using lookup functions.

### Practice: VLOOKUP-V

Making more practice by using lookup functions.

### Win a lottary ticket

Working with advanced functions.

### Win a lottary ticket

Working with advanced functions.

Using Nested IF.

Using Nested IF.

### Practice: VLOOKUP-II

Making more practice by using lookup functions.

### Practice: VLOOKUP-II

Making more practice by using lookup functions.

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Top Models

Calculate the earnings of top models based on scenarios

### Employee List

Lookup employee information from the employee list based on different parameters

### Social Media Statistics

Create some statistics to better understand the social media adoption

### Weekly Timesheet

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

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

### Practice: VLOOKUP-IV

Making more practice by using lookup functions.

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

### Practice: HLOOKUP

Making more practice by using lookup functions.

### IBAN Numbers

Working on banking operations.

### Stoner

Getting values with VLOOKUP:

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

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### Vacation Day Calculator

Calculate vacation days based on years worked and other conditions

### Electronic Sales

Using formulas for "Electronic Sales" operations.

### Practice: VLOOKUP-I

Making more practice by using lookup functions.

### Staff Data

Getting some information with VLOOKUP on "Employee Data"

### Privileged Customers

Matching nested IF() and IFS() functions.

### Practice: VLOOKUP-III

Making more practice by using lookup functions.

### Practice: VLOOKUP-V

Making more practice by using lookup functions.

### Win a lottary ticket

Working with advanced functions.

Using Nested IF.

### Practice: VLOOKUP-II

Making more practice by using lookup functions.