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

Round up Your Sales

Round up Your Sales

Round your sales data do decimals, nearest thousand and many more



Learn By Doing

Round up Your Sales

Round up Your Sales

Round your sales data do decimals, nearest thousand and many more



Learn By Doing

Employee List

Employee List

Lookup employee information from the employee list based on different parameters



Learn By Doing

Employee List

Employee List

Lookup employee information from the employee list based on different parameters



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

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

Trigonometry Cheat Sheet

Trigonometry Cheat Sheet

Create a handy trigonometry cheat sheet for commonly used angles.



Learn By Doing

Trigonometry Cheat Sheet

Trigonometry Cheat Sheet

Create a handy trigonometry cheat sheet for commonly used angles.



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

Project Work Days

Project Work Days

Calculate work days considering holidays, weekends and number of days worked



Learn By Doing

Project Work Days

Project Work Days

Calculate work days considering holidays, weekends and number of days worked



Learn By Doing

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

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

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

Social Media Statistics

Social Media Statistics

Create some statistics to better understand the social media adoption



Learn By Doing

Social Media Statistics

Social Media Statistics

Create some statistics to better understand the social media adoption



Learn By Doing

Sales Pivot

Sales Pivot

Create various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order...



Learn By Doing

Sales Pivot

Sales Pivot

Create various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order...



Learn By Doing

Practice: Mail Address

Practice: Mail Address

Practice your text functions skills.



Make Practice

Practice: Mail Address

Practice: Mail Address

Practice your text functions skills.



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

Other Functions

Other Functions

Using some specific functions.



Learn By Doing

Other Functions

Other Functions

Using some specific functions.



Learn By Doing

Practice: VLOOKUP-V

Practice: VLOOKUP-V

Making more practice by using lookup functions.



Make Practice

Practice: VLOOKUP-V

Practice: VLOOKUP-V

Making more practice by using lookup functions.



Make Practice

Practice: Filters 1

Practice: Filters 1

Making more filtering practices.



Make Practice

Practice: Filters 1

Practice: Filters 1

Making more filtering practices.



Make Practice

Practice: Sort Data 1

Practice: Sort Data 1

Sorting data by given criteria.



Make Practice

Practice: Sort Data 1

Practice: Sort Data 1

Sorting data by given criteria.



Make Practice

Practice: Customer

Practice: Customer

Practice your text functions skills.



Make Practice

Practice: Customer

Practice: Customer

Practice your text functions skills.



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

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

Badly Formatted Data

Badly Formatted Data

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.



Learn By Doing

Badly Formatted Data

Badly Formatted Data

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.



Learn By Doing

Practice: Remove Duplicates

Practice: Remove Duplicates

Removing duplicate information from the table.



Make Practice

Practice: Remove Duplicates

Practice: Remove Duplicates

Removing duplicate information from the table.



Make Practice

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

Practice: VLOOKUP-III

Making more practice by using lookup functions.



Make Practice

Practice: VLOOKUP-III

Practice: VLOOKUP-III

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

Coffee Shop Price Table

Coffee Shop Price Table

Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...



Learn By Doing

Coffee Shop Price Table

Coffee Shop Price Table

Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...



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

Practice: Date Functions

Practice: Date Functions

Making more practice by using date functions.



Make Practice

Practice: Date Functions

Practice: Date Functions

Making more practice by using date functions.



Make Practice

Why VLOOKUP doesn't work?

Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.



Learn By Doing

Why VLOOKUP doesn't work?

Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.



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

Practice: NameList

Practice: NameList

Practice your text functions skills.



Make Practice

Practice: NameList

Practice: NameList

Practice your text functions skills.



Make Practice

Formatting Numbers

Formatting Numbers

Formating cell range which are formatted different type.



Learn By Doing

Formatting Numbers

Formatting Numbers

Formating cell range which are formatted different type.



Learn By Doing

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

Stoner

Stoner

Getting values with VLOOKUP:



Learn By Doing

Stoner

Stoner

Getting values with VLOOKUP:



Learn By Doing

New Text Functions

New Text Functions

Combine text strings using TEXTJOIN() and CONCAT().



Learn By Doing

New Text Functions

New Text Functions

Combine text strings using TEXTJOIN() and CONCAT().



Learn By Doing

Customer & Order Table

Customer & Order Table

Getting special information from the table.



Learn By Doing

Customer & Order Table

Customer & Order Table

Getting special information from the table.



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

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

Practice: VLOOKUP-II

Making more practice by using lookup functions.



Make Practice

Practice: VLOOKUP-II

Practice: VLOOKUP-II

Making more practice by using lookup functions.



Make Practice

Practice: Basic Date Functions

Practice: Basic Date Functions

Making more practice by using TODAY() and NOW() functions



Make Practice

Practice: Basic Date Functions

Practice: Basic Date Functions

Making more practice by using TODAY() and NOW() functions



Make Practice

Practice: Arrangement

Practice: Arrangement

Practice your text functions skills.



Make Practice

Practice: Arrangement

Practice: Arrangement

Practice your text functions skills.



Make Practice

Practice: Text Functions

Practice: Text Functions

Making more practice by using text functions for date operations.



Make Practice

Practice: Text Functions

Practice: Text Functions

Making more practice by using text functions for date operations.



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

Practice: Workday Function

Making more practice by using workday function.



Make Practice

Practice: Workday Function

Practice: Workday Function

Making more practice by using workday function.



Make Practice

Practice: VLOOKUP-IV

Practice: VLOOKUP-IV

Making more practice by using lookup functions.



Make Practice

Practice: VLOOKUP-IV

Practice: VLOOKUP-IV

Making more practice by using lookup functions.



Make Practice

Practice: Filters 2

Practice: Filters 2

Making more filtering practices.



Make Practice

Practice: Filters 2

Practice: Filters 2

Making more filtering practices.



Make Practice

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: 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: Pivot Tables-III

Practice: Pivot Tables-III

Practice your skills about pivot tables.



Make Practice

Practice: Pivot Tables-III

Practice: Pivot Tables-III

Practice your skills about pivot tables.



Make Practice

Practice: Date Formatting

Practice: Date Formatting

Changing cell properties as date formats.



Make Practice

Practice: Date Formatting

Practice: Date Formatting

Changing cell properties as date formats.



Make Practice

Practice: Pivot Tables-II

Practice: Pivot Tables-II

Practice your skills about pivot tables.



Make Practice

Practice: Pivot Tables-II

Practice: Pivot Tables-II

Practice your skills about pivot tables.



Make Practice

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

Pie Chart

Pie Chart

Using pie chart for your data.



Learn By Doing

Pie Chart

Pie Chart

Using pie chart for your data.



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

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

Practice: HLOOKUP

Making more practice by using lookup functions.



Make Practice

Practice: HLOOKUP

Practice: HLOOKUP

Making more practice by using lookup functions.



Make Practice

Practice: Product ID

Practice: Product ID

Practice your text functions skills.



Make Practice

Practice: Product ID

Practice: Product ID

Practice your text functions skills.



Make Practice

Line Chart

Line Chart

Using line chart for your data.



Learn By Doing

Line Chart

Line Chart

Using line chart for your data.



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

IBAN Numbers

IBAN Numbers

Working on banking operations.



Learn By Doing

IBAN Numbers

IBAN Numbers

Working on banking operations.



Learn By Doing

Formatting Cells

Formatting Cells

Applying basic text and numeric formats. In this exercise you will learn very simple formatting in the Excel.



Learn By Doing

Formatting Cells

Formatting Cells

Applying basic text and numeric formats. In this exercise you will learn very simple formatting in the Excel.



Learn By Doing

Practice: Pivot Tables-IV

Practice: Pivot Tables-IV

Practice your skills about pivot tables.



Make Practice

Practice: Pivot Tables-IV

Practice: Pivot Tables-IV

Practice your skills about pivot tables.



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

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

Automobile Leasing Calculator

Automobile Leasing Calculator

Calculate the monthly payments, total interest and the cost of leasing. The exercise is formulated on a sample about Aut...



Learn By Doing

Automobile Leasing Calculator

Automobile Leasing Calculator

Calculate the monthly payments, total interest and the cost of leasing. The exercise is formulated on a sample about Aut...



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

Practice: Text

Practice: Text

Practice your text functions skills.



Make Practice

Practice: Text

Practice: Text

Practice your text functions skills.



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

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

Column Chart

Column Chart

Creating a column chart and edit it.



Learn By Doing

Column Chart

Column Chart

Creating a column chart and edit it.



Learn By Doing

Practice: Pivot Tables-V

Practice: Pivot Tables-V

Practice your skills about pivot tables.



Make Practice

Practice: Pivot Tables-V

Practice: Pivot Tables-V

Practice your skills about pivot tables.



Make Practice

Practice: Understanding Absolute References-I

Practice: Understanding Absolute References-I

Using basic functions with more practices.



Make Practice

Practice: Understanding Absolute References-I

Practice: Understanding Absolute References-I

Using basic functions with more practices.



Make Practice

Practice: Date Functions

Practice: Date Functions

Making more practice by using date functions.



Make Practice

Practice: Date Functions

Practice: Date Functions

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

Financial Convenience

Financial Convenience

Using populer finance functions.



Learn By Doing

Financial Convenience

Financial Convenience

Using populer finance functions.



Learn By Doing

Practice: Sort Data 3

Practice: Sort Data 3



Make Practice

Practice: Sort Data 3

Practice: Sort Data 3



Make Practice

Error Handling

Error Handling

Correcting value errors.



Learn By Doing

Error Handling

Error Handling

Correcting value errors.



Learn By Doing

Practice: Sort Data 2

Practice: Sort Data 2

Sort data by given criteria.



Make Practice

Practice: Sort Data 2

Practice: Sort Data 2

Sort data by given criteria.



Make Practice

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: Basic Counting functions

Practice: Basic Counting functions

Using basic functions with more practices.



Make Practice

Practice: Basic Counting functions

Practice: Basic Counting functions

Using basic functions with more practices.



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

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

Auto Filter and Subtotal Function

Auto Filter and Subtotal Function

Using filters and subtotal functions.



Learn By Doing

Auto Filter and Subtotal Function

Auto Filter and Subtotal Function

Using filters and subtotal functions.



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

Practice: Corrupted data

Practice your text functions skills.



Make Practice

Practice: Corrupted data

Practice: Corrupted data

Practice your text functions skills.



Make Practice

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

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

Sunshine Events

Sunshine Events

Summarizing data with pivot table.



Learn By Doing

Sunshine Events

Sunshine Events

Summarizing data with pivot table.



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

Practice: VLOOKUP-I

Making more practice by using lookup functions.



Make Practice

Practice: VLOOKUP-I

Practice: VLOOKUP-I

Making more practice by using lookup functions.



Make Practice

Practice: Separation and merge

Practice: Separation and merge

Practice your text functions skills.



Make Practice

Practice: Separation and merge

Practice: Separation and merge

Practice your text functions skills.



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

Staff Data

Staff Data

Getting some information with VLOOKUP on "Employee Data"



Learn By Doing

Staff Data

Staff Data

Getting some information with VLOOKUP on "Employee Data"



Learn By Doing

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

Practice: Networkday Function

Making more practice by using networkday function.



Make Practice

Practice: Networkday Function

Practice: Networkday Function

Making more practice by using networkday function.



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

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

First Course

First Course

Making a simple budget by using basic functions.



Learn By Doing

Round up Your Sales

Round up Your Sales

Round your sales data do decimals, nearest thousand and many more



Learn By Doing

Employee List

Employee List

Lookup employee information from the employee list based on different parameters



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

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

Project Work Days

Project Work Days

Calculate work days considering holidays, weekends and number of days worked



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

Social Media Statistics

Social Media Statistics

Create some statistics to better understand the social media adoption



Learn By Doing

Sales Pivot

Sales Pivot

Create various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order...



Learn By Doing

Practice: Mail Address

Practice: Mail Address

Practice your text functions skills.



Make Practice

Practice: Customer

Practice: Customer

Practice your text functions skills.



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

Coffee Shop Price Table

Coffee Shop Price Table

Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...



Learn By Doing

Travel Budget

Travel Budget

Create a "Travel Budget" sample.



Learn By Doing

Practice: Date Functions

Practice: Date Functions

Making more practice by using date functions.



Make Practice

Practice: Understanding Absolute References-II

Practice: Understanding Absolute References-II

Using basic functions with more practices.



Make Practice

Practice: NameList

Practice: NameList

Practice your text functions skills.



Make Practice

Practice: Basic functions-IV

Practice: Basic functions-IV

Using basic functions with more practices.



Make Practice

Practice: Time Function

Practice: Time Function

Making more practice by using time functions.



Make Practice

Practice: Basic Date Functions

Practice: Basic Date Functions

Making more practice by using TODAY() and NOW() functions



Make Practice

Practice: Arrangement

Practice: Arrangement

Practice your text functions skills.



Make Practice

Practice: Text Functions

Practice: Text Functions

Making more practice by using text functions for date operations.



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

Practice: Workday Function

Making more practice by using workday function.



Make Practice

Hotel California

Hotel California

Basic revenue calculation by implementing stays, discounts and tax.



Learn By Doing

Practice: Pivot Tables-III

Practice: Pivot Tables-III

Practice your skills about pivot tables.



Make Practice

Practice: Date Formatting

Practice: Date Formatting

Changing cell properties as date formats.



Make Practice

Practice: Pivot Tables-II

Practice: Pivot Tables-II

Practice your skills about pivot tables.



Make Practice

Practice: Working with operators

Practice: Working with operators

Using basic functions with more practices.



Make Practice

Pie Chart

Pie Chart

Using pie chart for your data.



Learn By Doing

Practice: Product ID

Practice: Product ID

Practice your text functions skills.



Make Practice

Formatting Cells

Formatting Cells

Applying basic text and numeric formats. In this exercise you will learn very simple formatting in the Excel.



Learn By Doing

Practice: Pivot Tables-IV

Practice: Pivot Tables-IV

Practice your skills about pivot tables.



Make Practice

Automobile Leasing Calculator

Automobile Leasing Calculator

Calculate the monthly payments, total interest and the cost of leasing. The exercise is formulated on a sample about Aut...



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

Practice: Text

Practice your text functions skills.



Make Practice

Practice: Basic functions-II

Practice: Basic functions-II

Using basic functions with more practices.



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

Column Chart

Column Chart

Creating a column chart and edit it.



Learn By Doing

Practice: Pivot Tables-V

Practice: Pivot Tables-V

Practice your skills about pivot tables.



Make Practice

Practice: Understanding Absolute References-I

Practice: Understanding Absolute References-I

Using basic functions with more practices.



Make Practice

Practice: Date Functions

Practice: Date Functions

Making more practice by using date functions.



Make Practice

Practice: Basic Counting functions

Practice: Basic Counting functions

Using basic functions with more practices.



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

Practice: Corrupted data

Practice your text functions skills.



Make Practice

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: Separation and merge

Practice: Separation and merge

Practice your text functions skills.



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

Practice: Networkday Function

Making more practice by using networkday function.



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

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

Trigonometry Cheat Sheet

Trigonometry Cheat Sheet

Create a handy trigonometry cheat sheet for commonly used angles.


Pro

Learn By Doing

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

Other Functions

Other Functions

Using some specific functions.


Pro

Learn By Doing

Practice: VLOOKUP-V

Practice: VLOOKUP-V

Making more practice by using lookup functions.


Pro

Make Practice

Win a lottary ticket

Win a lottary ticket

Working with advanced functions.


Pro

Learn By Doing

Sales

Sales

Using and testing some values.


Pro

Learn By Doing

Expense Sheet

Expense Sheet

Using Nested IF.


Pro

Learn By Doing

Badly Formatted Data

Badly Formatted Data

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.


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

Practice: VLOOKUP-III

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

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

Why VLOOKUP doesn't work?

Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.


Pro

Learn By Doing

iPhone vs Samsung

iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.


Pro

Learn By Doing

Formatting Numbers

Formatting Numbers

Formating cell range which are formatted different type.


Pro

Learn By Doing

Stoner

Stoner

Getting values with VLOOKUP:


Pro

Learn By Doing

New Text Functions

New Text Functions

Combine text strings using TEXTJOIN() and CONCAT().


Pro

Learn By Doing

Customer & Order Table

Customer & Order Table

Getting special information from the table.


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

Beverage Sales

Beverage Sales

Drill down your sales data using an alternative lookup method.


Pro

Learn By Doing

Practice: VLOOKUP-II

Practice: VLOOKUP-II

Making more practice by using lookup 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: VLOOKUP-IV

Practice: VLOOKUP-IV

Making more practice by using lookup functions.


Pro

Make Practice

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

Practice: SUMIFS, COUNTIFS, AVERAGEIFS - IV

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

Practice: HLOOKUP

Making more practice by using lookup functions.


Pro

Make Practice

Line Chart

Line Chart

Using line chart for your data.


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

IBAN Numbers

IBAN Numbers

Working on banking operations.


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

Social Security Numbers

Social Security Numbers

Working on Social Security.


Pro

Learn By Doing

Financial Convenience

Financial Convenience

Using populer finance functions.


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

Auto Filter and Subtotal Function

Auto Filter and Subtotal Function

Using filters and subtotal functions.


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

Sunshine Events

Sunshine Events

Summarizing data with pivot table.


Pro

Learn By Doing

Practice: VLOOKUP-I

Practice: VLOOKUP-I

Making more practice by using lookup functions.


Pro

Make Practice

Staff Data

Staff Data

Getting some information with VLOOKUP on "Employee Data"


Pro

Learn By Doing

Privileged Customers

Privileged Customers

Matching nested IF() and IFS() functions.


Pro

Learn By Doing