Free Excel Training and Courses

### First Course

Making a simple budget by using basic functions.

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

### Top Models

Calculate the earnings of top models based on scenarios

### Employee List

Lookup employee information from the employee list based on different parameters

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

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.

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

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

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

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

### Practice: Basic Date Functions

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

### Practice: Time Function

Making more practice by using time functions.