Free Excel Training and Courses

### First Course

Making a simple budget by using basic functions.

### First Course

Making a simple budget by using basic functions.

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

### Oil Production

Learn absolute and relative referencing using a sample data about oil production in Northern American countries.

### Oil Production

Learn absolute and relative referencing using a sample data about oil production in Northern American countries.

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

### Error Handling

Correcting value errors.

### Error Handling

Correcting value errors.

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

### Electronic Sales

Using formulas for "Electronic Sales" operations.

### Electronic Sales

Using formulas for "Electronic Sales" operations.

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

### Practice: Basic functions-III

Using basic functions with more practices.

### Practice: Basic functions-III

Using basic functions with more practices.

### Practice: Basic functions-I

Using basic functions with more practices.

### Practice: Basic functions-I

Using basic functions with more practices.

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

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

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

### Practice: Basic functions-II

Using basic functions with more practices.

### Practice: Basic functions-II

Using basic functions with more practices.

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

### Practice: Basic functions-IV

Using basic functions with more practices.

### Practice: Basic functions-IV

Using basic functions with more practices.

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

### Beverage Sales

Drill down your sales data using an alternative lookup method.

### Beverage Sales

Drill down your sales data using an alternative lookup method.

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

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

### Practice: Working with operators

Using basic functions with more practices.

### Practice: Working with operators

Using basic functions with more practices.

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

### Practice: Time Function

Making more practice by using time functions.

### Practice: Time Function

Making more practice by using time functions.

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

### Sales

Using and testing some values.

### Sales

Using and testing some values.

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

### 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: Understanding Absolute References-II

Using basic functions with more practices.

### Practice: Understanding Absolute References-II

Using basic functions with more practices.

### First Course

Making a simple budget by using basic functions.

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

### Oil Production

Learn absolute and relative referencing using a sample data about oil production in Northern American countries.

### Most Popular Movies

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

### 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: Basic functions-III

Using basic functions with more practices.

### Practice: Basic functions-I

Using basic functions with more practices.

### 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: Basic functions-II

Using basic functions with more practices.

### Weekly Timesheet

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

### Practice: Basic functions-IV

Using basic functions with more practices.

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

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

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

### Practice: Working with operators

Using basic functions with more practices.

### Practice: Time Function

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

### Travel Budget

Create a "Travel Budget" sample.

### Practice: Understanding Absolute References-II

Using basic functions with more practices.

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

### Error Handling

Correcting value errors.

### World Internet Users Statistics

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

### Electronic Sales

Using formulas for "Electronic Sales" operations.

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

Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() 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: SUMIFS, COUNTIFS, AVERAGEIFS - V

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.

### Beverage Sales

Drill down your sales data using an alternative lookup method.

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

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

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

### Sales

Using and testing some values.

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.