Free Excel Training and Courses
First Course

First Course

Making a simple budget by using basic functions.



Learn By Doing

First Course

First Course

Making a simple budget by using basic functions.



Learn By Doing

Richest Business People

Richest Business People

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



Learn By Doing

Richest Business People

Richest Business People

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



Learn By Doing

Oil Production

Oil Production

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



Learn By Doing

Oil Production

Oil Production

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



Learn By Doing

Regional Sales Data

Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals



Learn By Doing

Regional Sales Data

Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals



Learn By Doing

Error Handling

Error Handling

Correcting value errors.



Learn By Doing

Error Handling

Error Handling

Correcting value errors.



Learn By Doing

Most Popular Movies

Most Popular Movies

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



Learn By Doing

Most Popular Movies

Most Popular Movies

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



Learn By Doing

World Internet Users Statistics

World Internet Users Statistics

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



Learn By Doing

World Internet Users Statistics

World Internet Users Statistics

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



Learn By Doing

Electronic Sales

Electronic Sales

Using formulas for "Electronic Sales" operations.



Learn By Doing

Electronic Sales

Electronic Sales

Using formulas for "Electronic Sales" operations.



Learn By Doing

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

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

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



Make Practice

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

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

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



Make Practice

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

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

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



Make Practice

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

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

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



Make Practice

Profitability of a Theater

Profitability of a Theater

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



Learn By Doing

Profitability of a Theater

Profitability of a Theater

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



Learn By Doing

Practice: Basic functions-III

Practice: Basic functions-III

Using basic functions with more practices.



Make Practice

Practice: Basic functions-III

Practice: Basic functions-III

Using basic functions with more practices.



Make Practice

Practice: Basic functions-I

Practice: Basic functions-I

Using basic functions with more practices.



Make Practice

Practice: Basic functions-I

Practice: Basic functions-I

Using basic functions with more practices.



Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

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



Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

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



Make Practice

Practice: IF Functions 3 - Other Functions and If

Practice: IF Functions 3 - Other Functions and If

Making more practice by using IF() function.



Make Practice

Practice: IF Functions 3 - Other Functions and If

Practice: IF Functions 3 - Other Functions and If

Making more practice by using IF() function.



Make Practice

Practice: Basic functions-IV

Practice: Basic functions-IV

Using basic functions with more practices.



Make Practice

Practice: Basic functions-IV

Practice: Basic functions-IV

Using basic functions with more practices.



Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

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



Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

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



Make Practice

Beverage Sales

Beverage Sales

Drill down your sales data using an alternative lookup method.



Learn By Doing

Beverage Sales

Beverage Sales

Drill down your sales data using an alternative lookup method.



Learn By Doing

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

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

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



Make Practice

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

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

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



Make Practice

Salesperson Ratings

Salesperson Ratings

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



Learn By Doing

Salesperson Ratings

Salesperson Ratings

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



Learn By Doing

Hotel California

Hotel California

Basic revenue calculation by implementing stays, discounts and tax.



Learn By Doing

Hotel California

Hotel California

Basic revenue calculation by implementing stays, discounts and tax.



Learn By Doing

Practice: Working with operators

Practice: Working with operators

Using basic functions with more practices.



Make Practice

Practice: Working with operators

Practice: Working with operators

Using basic functions with more practices.



Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

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



Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

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



Make Practice

Practice: Time Function

Practice: Time Function

Making more practice by using time functions.



Make Practice

Practice: Time Function

Practice: Time Function

Making more practice by using time functions.



Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

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



Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

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



Make Practice

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

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

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



Make Practice

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

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

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



Make Practice

Sales

Sales

Using and testing some values.



Learn By Doing

Sales

Sales

Using and testing some values.



Learn By Doing

Expense Sheet

Expense Sheet

Using Nested IF.



Learn By Doing

Expense Sheet

Expense Sheet

Using Nested IF.



Learn By Doing

Highest Paid Celebrities

Highest Paid Celebrities

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



Learn By Doing

Highest Paid Celebrities

Highest Paid Celebrities

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



Learn By Doing

Travel Budget

Travel Budget

Create a "Travel Budget" sample.



Learn By Doing

Travel Budget

Travel Budget

Create a "Travel Budget" sample.



Learn By Doing

iPhone vs Samsung

iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.



Learn By Doing

iPhone vs Samsung

iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.



Learn By Doing

Practice: Understanding Absolute References-II

Practice: Understanding Absolute References-II

Using basic functions with more practices.



Make Practice

Practice: Understanding Absolute References-II

Practice: Understanding Absolute References-II

Using basic functions with more practices.



Make Practice

Good Biscuit

Good Biscuit

Understanding formulas with "Sales" operations.



Learn By Doing

Good Biscuit

Good Biscuit

Understanding formulas with "Sales" operations.



Learn By Doing

My First Invoice

My First Invoice

Creating an invoice with base functions.



Learn By Doing

My First Invoice

My First Invoice

Creating an invoice with base functions.



Learn By Doing

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

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

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



Make Practice

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

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

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



Make Practice

Practice: Basic functions-II

Practice: Basic functions-II

Using basic functions with more practices.



Make Practice

Practice: Basic functions-II

Practice: Basic functions-II

Using basic functions with more practices.



Make Practice

Weekly Timesheet

Weekly Timesheet

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



Learn By Doing

Weekly Timesheet

Weekly Timesheet

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



Learn By Doing

International Tourist Data

International Tourist Data

Calculate which country recieves the most tourists in each continent.



Learn By Doing

International Tourist Data

International Tourist Data

Calculate which country recieves the most tourists in each continent.



Learn By Doing

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

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



Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

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



Make Practice

First Course

First Course

Making a simple budget by using basic functions.



Learn By Doing

Richest Business People

Richest Business People

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



Learn By Doing

Oil Production

Oil Production

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



Learn By Doing

Most Popular Movies

Most Popular Movies

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



Learn By Doing

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

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

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



Make Practice

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

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

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



Make Practice

Profitability of a Theater

Profitability of a Theater

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



Learn By Doing

Practice: Basic functions-III

Practice: Basic functions-III

Using basic functions with more practices.



Make Practice

Practice: Basic functions-I

Practice: Basic functions-I

Using basic functions with more practices.



Make Practice

Practice: Basic functions-IV

Practice: Basic functions-IV

Using basic functions with more practices.



Make Practice

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

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

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



Make Practice

Hotel California

Hotel California

Basic revenue calculation by implementing stays, discounts and tax.



Learn By Doing

Practice: Working with operators

Practice: Working with operators

Using basic functions with more practices.



Make Practice

Practice: Time Function

Practice: Time Function

Making more practice by using time functions.



Make Practice

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

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

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



Make Practice

Travel Budget

Travel Budget

Create a "Travel Budget" sample.



Learn By Doing

Practice: Understanding Absolute References-II

Practice: Understanding Absolute References-II

Using basic functions with more practices.



Make Practice

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

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

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



Make Practice

Practice: Basic functions-II

Practice: Basic functions-II

Using basic functions with more practices.



Make Practice

Weekly Timesheet

Weekly Timesheet

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



Learn By Doing

Regional Sales Data

Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals


Pro

Learn By Doing

Error Handling

Error Handling

Correcting value errors.


Pro

Learn By Doing

World Internet Users Statistics

World Internet Users Statistics

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


Pro

Learn By Doing

Electronic Sales

Electronic Sales

Using formulas for "Electronic Sales" operations.


Pro

Learn By Doing

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

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


Pro

Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

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


Pro

Make Practice

Beverage Sales

Beverage Sales

Drill down your sales data using an alternative lookup method.


Pro

Learn By Doing

Salesperson Ratings

Salesperson Ratings

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


Pro

Learn By Doing

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

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


Pro

Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

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


Pro

Make Practice

Sales

Sales

Using and testing some values.


Pro

Learn By Doing

Expense Sheet

Expense Sheet

Using Nested IF.


Pro

Learn By Doing

Highest Paid Celebrities

Highest Paid Celebrities

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


Pro

Learn By Doing

iPhone vs Samsung

iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.


Pro

Learn By Doing

Good Biscuit

Good Biscuit

Understanding formulas with "Sales" operations.


Pro

Learn By Doing

My First Invoice

My First Invoice

Creating an invoice with base functions.


Pro

Learn By Doing

International Tourist Data

International Tourist Data

Calculate which country recieves the most tourists in each continent.


Pro

Learn By Doing

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - V

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


Pro

Make Practice