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
Round up Your Sales
Round your sales data do decimals, nearest thousand and many more
Employee List
Lookup employee information from the employee list based on different parameters
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: 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: Date Functions
Making more practice by using date functions.
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: Pivot Tables-IV
Practice your skills about pivot tables.
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: Time Function
Making more practice by using time functions.
