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 up Your Sales
Round your sales data do decimals, nearest thousand and many more
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...
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: Pivot Tables-III
Practice your skills about pivot tables.
Practice: Working with operators
Using basic functions with more practices.
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.
Practice: Pivot Tables-IV
Practice your skills about pivot tables.
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.
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...
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: Understanding Absolute References-II
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: 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.
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.
