Free Excel Training and Courses
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Regional Sales Data

Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals


Pro

Learn By Doing

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - II

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


Pro

Make Practice

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

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - III

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


Pro

Make Practice

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

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

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


Pro

Make Practice

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

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