Free Excel Training and Courses

Try using vertical lookup instead of if statements

Try using vertical lookup instead of if statements

Calculate the earnings of top models based on scenarios

Calculate the earnings of top models based on scenarios

Revisit your sales data, calculate regional totals, conditional totals

Revisit your sales data, calculate regional totals, conditional totals

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

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

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

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

Lookup employee information from the employee list based on different parameters

Lookup employee information from the employee list based on different parameters

Create a handy trigonometry cheat sheet for commonly used angles.

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

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

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

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

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

Create some statistics to better understand the social media adoption

Create some statistics to better understand the social media adoption

Making more practice by using text functions for date operations.

Making more practice by using text functions for date operations.

Making more practice by using workday function.

Making more practice by using workday function.

Basic revenue calculation by implementing stays, discounts and tax.

Basic revenue calculation by implementing stays, discounts and tax.

Practice your skills about pivot tables.

Practice your skills about pivot tables.

Practice your skills about pivot tables.

Practice your skills about pivot tables.

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

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

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

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

Practice your skills about pivot tables.

Practice your skills about pivot tables.

Understanding formulas with "Sales" operations.

Understanding formulas with "Sales" operations.

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

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

Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...

Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...

Practice your skills about pivot tables.

Practice your skills about pivot tables.

Making more practice by using date functions.

Making more practice by using date functions.

Calculate vacation days based on years worked and other conditions

Calculate vacation days based on years worked and other conditions

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

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

Using filters and subtotal functions.

Using filters and subtotal functions.

Create meaningful insights from internet users of top 25 countries between 2013-2015.

Create meaningful insights from internet users of top 25 countries between 2013-2015.

Making more practice by using networkday function.

Making more practice by using networkday function.

Matching nested IF() and IFS() functions.

Matching nested IF() and IFS() functions.

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

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

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

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

Making more practice by using time functions.

Making more practice by using time functions.

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

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

Making more practice by using date functions.

Making more practice by using date functions.

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

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

Getting special information from the table.

Getting special information from the table.

Try using vertical lookup instead of if statements

Calculate the earnings of top models based on scenarios

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

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

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

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

Create some statistics to better understand the social media adoption

Making more practice by using text functions for date operations.

Making more practice by using workday function.

Basic revenue calculation by implementing stays, discounts and tax.

Practice your skills about pivot tables.

Practice your skills about pivot tables.

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

Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...

Making more practice by using date functions.

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

Making more practice by using networkday function.

Making more practice by using time functions.

Making more practice by using date functions.

Revisit your sales data, calculate regional totals, conditional totals

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

Create a handy trigonometry cheat sheet for commonly used angles.

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

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

Calculate vacation days based on years worked and other conditions

Using filters and subtotal functions.

Create meaningful insights from internet users of top 25 countries between 2013-2015.

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

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

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

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

Getting special information from the table.