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
Special Use of Lookups
Try using vertical lookup instead of if statements
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
Social Media Statistics
Create some statistics to better understand the social media adoption
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.
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: Basic Date Functions
Making more practice by using TODAY() and NOW() functions
Practice: Date Functions
Making more practice by using date functions.
Practice: Understanding Absolute References-II
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: Basic functions-III
Using basic functions with more practices.
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: Time Function
Making more practice by using time functions.
Practice: Basic functions-IV
Using basic functions with more practices.
