Try using vertical lookup instead of if statements
Calculate the earnings of top models based on scenarios
Revisit your sales data, calculate regional totals, conditional totals
Learn absolute and relative referencing using a sample data about oil production in Northern American countries.
Round your sales data do decimals, nearest thousand and many more
Create a body mass index calculator using height and weight of a person
Lookup employee information from the employee list based on different parameters
Create a handy trigonometry cheat sheet for commonly used angles.
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.
Making more practice by using workday function.
Basic revenue calculation by implementing stays, discounts and tax.
Practice your skills about pivot tables.
Using pie chart for your data.
Making more practice by using SUMIFS(), COUNTIFS() and AVERAGEIFS() functions.
Working on banking operations.
Understanding formulas with "Sales" operations.
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.
Working on Social Security.
Using populer finance functions.
Calculate vacation days based on years worked and other conditions
Getting production year of popular films of the IMDB from unformatted title information with year. Calculate votes perce...
Using filters and subtotal functions.
Create meaningful insights from internet users of top 25 countries between 2013-2015.
Summarizing data with pivot table.
Making more practice by using networkday function.
Matching nested IF() and IFS() functions.
Using some specific functions.
Using and testing some values.
Making more practice by using time functions.
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
Resolving VLOOKUP errors.
Getting values with VLOOKUP:
Combine text strings using TEXTJOIN() and CONCAT().
Getting special information from the table.
Create a new account
I already have an account
You need upgrade!
You need a bigger screen to run the Sheetzoom app in Excel Online. Please switch to your PC or Tablet
Made with in Istanbul
Get notified first! Sign-up free for our newsletter.