Try using vertical lookup instead of if statements
Learn absolute and relative referencing using a sample data about oil production in Northern American countries.
Calculate the earnings of top models based on scenarios
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...
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.
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Making more practice by using workday function.
Basic revenue calculation by implementing stays, discounts and tax.
Practice your skills about pivot tables.
Using basic functions with more practices.
Using basic functions with more practices.
Applying basic text and numeric formats. In this exercise you will learn very simple formatting in the Excel.
Practice your skills about pivot tables.
Calculate the monthly payments, total interest and the cost of leasing. The exercise is formulated on a sample about Aut...
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.
Using basic functions with more practices.
Using basic functions with more practices.
Making more practice by using date functions.
Using basic functions with more practices.
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
Master date functions using the complaints data for a gym.
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.
Making more practice by using networkday function.
Using basic functions with more practices.
Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...
Adding values that meet a single criteria by using SUMIF(), AVERAGEIF() and COUNTIF() functions.
Making more practice by using TODAY() and NOW() functions
Making more practice by using time functions.