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.

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

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

### Employee List

Lookup employee information from the employee list based on different parameters

### Employee List

Lookup employee information from the employee list based on different parameters

### Body Mass Index Calculation

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

### Body Mass Index Calculation

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

### Top Models

Calculate the earnings of top models based on scenarios

### Top Models

Calculate the earnings of top models based on scenarios

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Special Use of Lookups

Try using vertical lookup instead of if statements

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

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

### Project Work Days

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

### Project Work Days

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

### Trigonometry Cheat Sheet

Create a handy trigonometry cheat sheet for commonly used angles.

### Trigonometry Cheat Sheet

Create a handy trigonometry cheat sheet for commonly used angles.

### Sales Pivot

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

### Sales Pivot

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

### Social Media Statistics

Create some statistics to better understand the social media adoption

### Social Media Statistics

Create some statistics to better understand the social media adoption

### Practice: Text Functions

Making more practice by using text functions for date operations.

### Practice: Text Functions

Making more practice by using text functions for date operations.

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

### Practice: Workday Function

Making more practice by using workday function.

### Practice: Workday Function

Making more practice by using workday function.

### Practice: VLOOKUP-IV

Making more practice by using lookup functions.

### Practice: VLOOKUP-IV

Making more practice by using lookup functions.

### Practice: Filters 2

Making more filtering practices.

### Practice: Filters 2

Making more filtering practices.

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

### Practice: IF Functions 6 - Students

Making more practice by using IF() function.

### Practice: IF Functions 6 - Students

Making more practice by using IF() function.

### Practice: Date Formatting

Changing cell properties as date formats.

### Practice: Date Formatting

Changing cell properties as date formats.

### Practice: Working with operators

Using basic functions with more practices.

### Practice: Working with operators

Using basic functions with more practices.

### Pie Chart

Using pie chart for your data.

### Pie Chart

Using pie chart for your data.

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

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

### Practice: IF Functions 4 - Bets

Making more practice by using IF() function.

### Practice: IF Functions 4 - Bets

Making more practice by using IF() function.

### Travel Budget

Create a "Travel Budget" sample.

### Travel Budget

Create a "Travel Budget" sample.

### Practice: Date Functions

Making more practice by using date functions.

### Practice: Date Functions

Making more practice by using date functions.

### Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

### Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

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

### Formatting Numbers

Formating cell range which are formatted different type.

### Formatting Numbers

Formating cell range which are formatted different type.

### Practice: Time Function

Making more practice by using time functions.

### Practice: Time Function

Making more practice by using time functions.

### Practice: VLOOKUP-II

Making more practice by using lookup functions.

### Practice: VLOOKUP-II

Making more practice by using lookup functions.

### Practice: Basic Date Functions

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

### Practice: Basic Date Functions

Making more practice by using TODAY() and NOW() 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.

### Stoner

Getting values with VLOOKUP:

### Stoner

Getting values with VLOOKUP:

### New Text Functions

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

### New Text Functions

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

### Customer & Order Table

Getting special information from the table.

### Customer & Order Table

Getting special information from the table.

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

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

Making more practice by using lookup functions.

### Practice: HLOOKUP

Making more practice by using lookup functions.

### Line Chart

Using line chart for your data.

### Line Chart

Using line chart for your data.

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

### IBAN Numbers

Working on banking operations.

### IBAN Numbers

Working on banking operations.

### Formatting Cells

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

### Formatting Cells

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

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

### Practice: IF Functions 1 - Numbers

Making more practice by using IF() function.

### Practice: IF Functions 1 - Numbers

Making more practice by using IF() function.

### My First Invoice

Creating an invoice with base functions.

### My First Invoice

Creating an invoice with base functions.

### Automobile Leasing Calculator

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

### Automobile Leasing Calculator

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

### Practice: IF Functions 5 - Items

Making more practice by using IF() function.

### Practice: IF Functions 5 - Items

Making more practice by using IF() function.

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

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

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

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

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

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

### Practice: Remove Duplicates

Removing duplicate information from the table.

### Practice: Remove Duplicates

Removing duplicate information from the table.

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

### Practice: VLOOKUP-III

Making more practice by using lookup functions.

### Practice: VLOOKUP-III

Making more practice by using lookup functions.

### Calculate Data with MAXIFS() and MINIFS()

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

### Calculate Data with MAXIFS() and MINIFS()

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

### Practice: IF Functions 7 - Customers

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

### Practice: IF Functions 7 - Customers

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

### Coffee Shop Price Table

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

### Coffee Shop Price Table

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

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

### Other Functions

Using some specific functions.

### Other Functions

Using some specific functions.

### Practice: VLOOKUP-V

Making more practice by using lookup functions.

### Practice: VLOOKUP-V

Making more practice by using lookup functions.

### Practice: Filters 1

Making more filtering practices.

### Practice: Filters 1

Making more filtering practices.

### Practice: Sort Data 1

Sorting data by given criteria.

### Practice: Sort Data 1

Sorting data by given criteria.

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

### Column Chart

Creating a column chart and edit it.

### Column Chart

Creating a column chart and edit it.

### Practice: Understanding Absolute References-I

Using basic functions with more practices.

### Practice: Understanding Absolute References-I

Using basic functions with more practices.

### Practice: Date Functions

Making more practice by using date functions.

### Practice: Date Functions

Making more practice by using date functions.

### Social Security Numbers

Working on Social Security.

### Social Security Numbers

Working on Social Security.

### Financial Convenience

Using populer finance functions.

### Financial Convenience

Using populer finance functions.

### Error Handling

Correcting value errors.

### Error Handling

Correcting value errors.

### Practice: Sort Data 2

Sort data by given criteria.

### Practice: Sort Data 2

Sort data by given criteria.

### Vacation Day Calculator

Calculate vacation days based on years worked and other conditions

### Vacation Day Calculator

Calculate vacation days based on years worked and other conditions

### Practice: Basic Counting functions

Using basic functions with more practices.

### Practice: Basic Counting functions

Using basic functions with more practices.

### Practice: IF Functions 8 - Sale Rent

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

### Practice: IF Functions 8 - Sale Rent

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

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

### Auto Filter and Subtotal Function

Using filters and subtotal functions.

### Auto Filter and Subtotal Function

Using filters and subtotal functions.

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

### GYM Complaints Sheet

Master date functions using the complaints data for a gym.

### GYM Complaints Sheet

Master date functions using the complaints data for a gym.

### Electronic Sales

Using formulas for "Electronic Sales" operations.

### Electronic Sales

Using formulas for "Electronic Sales" operations.

### Sunshine Events

Summarizing data with pivot table.

### Sunshine Events

Summarizing data with pivot table.

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

Making more practice by using lookup functions.

### Practice: VLOOKUP-I

Making more practice by using lookup functions.

### Practice: IF Functions 2 - Text

Making more practice by using IF() function.

### Practice: IF Functions 2 - Text

Making more practice by using IF() function.

### Staff Data

Getting some information with VLOOKUP on "Employee Data"

### Staff Data

Getting some information with VLOOKUP on "Employee Data"

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

Making more practice by using networkday function.

### Practice: Networkday Function

Making more practice by using networkday function.

### Privileged Customers

Matching nested IF() and IFS() functions.

### Privileged Customers

Matching nested IF() and IFS() functions.

### First Course

Making a simple budget by using basic functions.

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

### Employee List

Lookup employee information from the employee list based on different parameters

### Top Models

Calculate the earnings of top models based on scenarios

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Oil Production

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

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

### Project Work Days

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

### Sales Pivot

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

### Social Media Statistics

Create some statistics to better understand the social media adoption

### Practice: Text Functions

Making more practice by using text functions for date operations.

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

Making more practice by using workday function.

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

### Practice: Date Formatting

Changing cell properties as date formats.

### Practice: Working with operators

Using basic functions with more practices.

### Pie Chart

Using pie chart for your data.

### Travel Budget

Create a "Travel Budget" sample.

### Practice: Date Functions

Making more practice by using date functions.

### Practice: Understanding Absolute References-II

Using basic functions with more practices.

### Practice: Time Function

Making more practice by using time functions.

### Practice: Basic Date Functions

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

### Practice: Basic functions-IV

Using basic functions with more practices.

### Formatting Cells

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

### Automobile Leasing Calculator

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

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

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

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

Using basic functions with more practices.

### Practice: Basic functions-I

Using basic functions with more practices.

### Coffee Shop Price Table

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

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

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

### Column Chart

Creating a column chart and edit it.

### Practice: Understanding Absolute References-I

Using basic functions with more practices.

### Practice: Date Functions

Making more practice by using date functions.

### Practice: Basic Counting functions

Using basic functions with more practices.

### Most Popular Movies

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

### GYM Complaints Sheet

Master date functions using the complaints data for a gym.

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

Making more practice by using networkday function.

### Body Mass Index Calculation

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

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

### Trigonometry Cheat Sheet

Create a handy trigonometry cheat sheet for commonly used angles.

### Salesperson Ratings

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

### Practice: VLOOKUP-IV

Making more practice by using lookup functions.

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

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

### Highest Paid Celebrities

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

### Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### Formatting Numbers

Formating cell range which are formatted different type.

### Practice: VLOOKUP-II

Making more practice by using lookup functions.

### Stoner

Getting values with VLOOKUP:

### New Text Functions

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

### Customer & Order Table

Getting special information from the table.

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

### International Tourist Data

Calculate which country recieves the most tourists in each continent.

### Practice: HLOOKUP

Making more practice by using lookup functions.

### Line Chart

Using line chart for your data.

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

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

### IBAN Numbers

Working on banking operations.

### Good Biscuit

Understanding formulas with "Sales" operations.

### My First Invoice

Creating an invoice with base functions.

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

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

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

### Practice: VLOOKUP-III

Making more practice by using lookup functions.

### Calculate Data with MAXIFS() and MINIFS()

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

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

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

### Other Functions

Using some specific functions.

### Practice: VLOOKUP-V

Making more practice by using lookup functions.

### Sales

Using and testing some values.

Using Nested IF.

### Social Security Numbers

Working on Social Security.

### Financial Convenience

Using populer finance functions.

### Error Handling

Correcting value errors.

### Vacation Day Calculator

Calculate vacation days based on years worked and other conditions

### Auto Filter and Subtotal Function

Using filters and subtotal functions.

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

### Sunshine Events

Summarizing data with pivot table.

### Practice: VLOOKUP-I

Making more practice by using lookup functions.

### Staff Data

Getting some information with VLOOKUP on "Employee Data"

### Privileged Customers

Matching nested IF() and IFS() functions.