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

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

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

Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...

Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: Adding values that meet a single criteria - Part I

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part I

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

Using Nested IF.

Using Nested IF.

### 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: IF Functions 4 - Bets

Making more practice by using IF() function.

### Practice: IF Functions 4 - Bets

Making more practice by using IF() function.

### Travel Budget

Create a "Travel Budget" sample.

### Travel Budget

Create a "Travel Budget" sample.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### Practice: Adding values that meet a single criteria - Part V

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part V

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() 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.

### Practice: IF Functions 6 - Students

Making more practice by using IF() function.

### Practice: IF Functions 6 - Students

Making more practice by using IF() function.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Social Security Numbers

Working on Social Security.

### Social Security Numbers

Working on Social Security.

### Error Handling

Correcting value errors.

### Error Handling

Correcting value errors.

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

### Practice: IF Functions 8 - Sale Rent

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

### Practice: IF Functions 8 - Sale Rent

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

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

### World Internet Users Statistics

Create meaningful insights from internet users of top 25 countries between 2013-2015.

### World Internet Users Statistics

Create meaningful insights from internet users of top 25 countries between 2013-2015.

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

### Practice: Adding values that meet a single criteria - Part III

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part III

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: IF Functions 2 - Text

Making more practice by using IF() function.

### Practice: IF Functions 2 - Text

Making more practice by using IF() function.

### Practice: Adding values that meet a single criteria - Part II

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part II

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Privileged Customers

Matching nested IF() and IFS() functions.

### Privileged Customers

Matching nested IF() and IFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Calculate Data with MAXIFS() and MINIFS()

Using MAXIFS() and MINIFS() at a basic level.

### Calculate Data with MAXIFS() and MINIFS()

Using MAXIFS() and MINIFS() at a basic level.

### Practice: IF Functions 7 - Customers

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

### Practice: IF Functions 7 - Customers

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

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

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

Making more practice by using IF() function.

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

Making more practice by using IF() function.

### Stoner

Getting values with VLOOKUP:

### Stoner

Getting values with VLOOKUP:

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Practice: IF Functions 1 - Numbers

Making more practice by using IF() function.

### Practice: IF Functions 1 - Numbers

Making more practice by using IF() function.

### My First Invoice

Creating an invoice with base functions.

### My First Invoice

Creating an invoice with base functions.

### Practice: IF Functions 5 - Items

Making more practice by using IF() function.

### Practice: IF Functions 5 - Items

Making more practice by using IF() function.

### Practice: Adding values that meet a single criteria - Part IV

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part IV

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() 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...

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

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Top Models

Calculate the earnings of top models based on scenarios

Look at the some of richest people in the world using a table their age, earnings and their companies. And get informati...

### Practice: Adding values that meet a single criteria - Part I

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Travel Budget

Create a "Travel Budget" sample.

### Practice: Adding values that meet a single criteria - Part V

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Most Popular Movies

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

### GYM Complaints Sheet

Master date functions using the complaints data for a gym.

### Practice: Adding values that meet a single criteria - Part III

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part II

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

### Practice: Adding values that meet a single criteria - Part IV

Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.

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

### Weekly Timesheet

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

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

### Body Mass Index Calculation

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

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

Using Nested IF.

### Highest Paid Celebrities

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

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### Salesperson Ratings

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

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Social Security Numbers

Working on Social Security.

### Error Handling

Correcting value errors.

### Vacation Day Calculator

Calculate vacation days based on years worked and other conditions

### World Internet Users Statistics

Create meaningful insights from internet users of top 25 countries between 2013-2015.

### Privileged Customers

Matching nested IF() and IFS() functions.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Calculate Data with MAXIFS() and MINIFS()

Using MAXIFS() and MINIFS() at a basic level.

### International Tourist Data

Calculate which country recieves the most tourists in each continent.

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### Stoner

Getting values with VLOOKUP:

### Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.

### My First Invoice

Creating an invoice with base functions.