Free Excel Training and Courses

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Top Models

Calculate the earnings of top models based on scenarios

### Top Models

Calculate the earnings of top models based on scenarios

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

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

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

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

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

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

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

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

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

Making more practice by using workday function.

### Practice: Workday Function

Making more practice by using workday function.

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

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

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

### Good Biscuit

Understanding formulas with "Sales" operations.

### Good Biscuit

Understanding formulas with "Sales" operations.

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

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

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

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

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

### Sunshine Events

Summarizing data with pivot table.

### Sunshine Events

Summarizing data with pivot table.

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

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

### Sales

Using and testing some values.

### Sales

Using and testing some values.

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

Making more practice by using time functions.

### Practice: Time Function

Making more practice by using time 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: 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.

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

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Top Models

Calculate the earnings of top models based on scenarios

### Oil Production

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

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

### Employee List

Lookup employee information from the employee list based on different parameters

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

Making more practice by using workday function.

### Hotel California

Basic revenue calculation by implementing stays, discounts and tax.

### Pie Chart

Using pie chart for your data.

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

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

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

Making more practice by using date functions.

### Most Popular Movies

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

### Practice: Networkday Function

Making more practice by using networkday function.

### Practice: Time Function

Making more practice by using time functions.

### Practice: Date Functions

Making more practice by using date functions.

### Regional Sales Data

Revisit your sales data, calculate regional totals, conditional totals

### Body Mass Index Calculation

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

### Trigonometry Cheat Sheet

Create a handy trigonometry cheat sheet for commonly used angles.

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

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.

### Good Biscuit

Understanding formulas with "Sales" operations.

### Social Security Numbers

Working on Social Security.

### Financial Convenience

Using populer finance functions.

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

### Sunshine Events

Summarizing data with pivot table.

### Privileged Customers

Matching nested IF() and IFS() functions.

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

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

### Other Functions

Using some specific functions.

### Sales

Using and testing some values.

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

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.

### Stoner

Getting values with VLOOKUP:

### New Text Functions

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

### Customer & Order Table

Getting special information from the table.