Free Excel Training and Courses
Special Use of Lookups

Special Use of Lookups

Try using vertical lookup instead of if statements



Learn By Doing

Special Use of Lookups

Special Use of Lookups

Try using vertical lookup instead of if statements



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

Top Models

Top Models

Calculate the earnings of top models based on scenarios



Learn By Doing

Top Models

Top Models

Calculate the earnings of top models based on scenarios



Learn By Doing

Body Mass Index Calculation

Body Mass Index Calculation

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



Learn By Doing

Body Mass Index Calculation

Body Mass Index Calculation

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



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

Win a lottary ticket

Win a lottary ticket

Working with advanced functions.



Learn By Doing

Win a lottary ticket

Win a lottary ticket

Working with advanced functions.



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

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

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

Practice: IF Functions 4 - Bets

Practice: IF Functions 4 - Bets

Making more practice by using IF() function.



Make Practice

Practice: IF Functions 4 - Bets

Practice: IF Functions 4 - Bets

Making more practice by using IF() function.



Make Practice

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: 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: IF Functions 6 - Students

Practice: IF Functions 6 - Students

Making more practice by using IF() function.



Make Practice

Practice: IF Functions 6 - Students

Practice: IF Functions 6 - Students

Making more practice by using IF() function.



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

Social Security Numbers

Social Security Numbers

Working on Social Security.



Learn By Doing

Social Security Numbers

Social Security Numbers

Working on Social Security.



Learn By Doing

Error Handling

Error Handling

Correcting value errors.



Learn By Doing

Error Handling

Error Handling

Correcting value errors.



Learn By Doing

Vacation Day Calculator

Vacation Day Calculator

Calculate vacation days based on years worked and other conditions



Learn By Doing

Vacation Day Calculator

Vacation Day Calculator

Calculate vacation days based on years worked and other conditions



Learn By Doing

Practice: IF Functions 8 - Sale Rent

Practice: IF Functions 8 - Sale Rent

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



Make Practice

Practice: IF Functions 8 - Sale Rent

Practice: IF Functions 8 - Sale Rent

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

GYM Complaints Sheet

GYM Complaints Sheet

Master date functions using the complaints data for a gym.



Learn By Doing

GYM Complaints Sheet

GYM Complaints Sheet

Master date functions using the complaints data for a gym.



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: IF Functions 2 - Text

Practice: IF Functions 2 - Text

Making more practice by using IF() function.



Make Practice

Practice: IF Functions 2 - Text

Practice: IF Functions 2 - Text

Making more practice by using IF() function.



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

Privileged Customers

Privileged Customers

Matching nested IF() and IFS() functions.



Learn By Doing

Privileged Customers

Privileged Customers

Matching nested IF() and IFS() functions.



Learn By Doing

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

Calculate Data with MAXIFS() and MINIFS()

Calculate Data with MAXIFS() and MINIFS()

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



Learn By Doing

Calculate Data with MAXIFS() and MINIFS()

Calculate Data with MAXIFS() and MINIFS()

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



Learn By Doing

Practice: IF Functions 7 - Customers

Practice: IF Functions 7 - Customers

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



Make Practice

Practice: IF Functions 7 - Customers

Practice: IF Functions 7 - Customers

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

Stoner

Stoner

Getting values with VLOOKUP:



Learn By Doing

Stoner

Stoner

Getting values with VLOOKUP:



Learn By Doing

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: IF Functions 1 - Numbers

Practice: IF Functions 1 - Numbers

Making more practice by using IF() function.



Make Practice

Practice: IF Functions 1 - Numbers

Practice: IF Functions 1 - Numbers

Making more practice by using IF() function.



Make Practice

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: IF Functions 5 - Items

Practice: IF Functions 5 - Items

Making more practice by using IF() function.



Make Practice

Practice: IF Functions 5 - Items

Practice: IF Functions 5 - Items

Making more practice by using IF() function.



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

New Employee ID Badge

New Employee ID Badge

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



Learn By Doing

New Employee ID Badge

New Employee ID Badge

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



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

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

Special Use of Lookups

Special Use of Lookups

Try using vertical lookup instead of if statements



Learn By Doing

Top Models

Top Models

Calculate the earnings of top models based on scenarios



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

Travel Budget

Travel Budget

Create a "Travel Budget" sample.



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

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

GYM Complaints Sheet

GYM Complaints Sheet

Master date functions using the complaints data for a gym.



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

New Employee ID Badge

New Employee ID Badge

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



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

Regional Sales Data

Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals


Pro

Learn By Doing

Body Mass Index Calculation

Body Mass Index Calculation

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


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

Win a lottary ticket

Win a lottary ticket

Working with advanced functions.


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

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

Social Security Numbers

Social Security Numbers

Working on Social Security.


Pro

Learn By Doing

Error Handling

Error Handling

Correcting value errors.


Pro

Learn By Doing

Vacation Day Calculator

Vacation Day Calculator

Calculate vacation days based on years worked and other conditions


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

Privileged Customers

Privileged Customers

Matching nested IF() and IFS() functions.


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

Calculate Data with MAXIFS() and MINIFS()

Calculate Data with MAXIFS() and MINIFS()

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


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

Stoner

Stoner

Getting values with VLOOKUP:


Pro

Learn By Doing

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - I

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


Pro

Make Practice

My First Invoice

My First Invoice

Creating an invoice with base functions.


Pro

Learn By Doing