Lookup employee information from the employee list based on different parameters
Create a body mass index calculator using height and weight of a person
Try using vertical lookup instead of if statements
Calculate the earnings of top models based on scenarios
Create a summary of salesperson sales stats with the help of range lookup.
Understanding formulas with "Sales" operations.
Creating an invoice with base functions.
Calculate which country recieves the most tourists in each continent.
Working on banking operations.
Getting values with VLOOKUP:
Combine text strings using TEXTJOIN() and CONCAT().
Getting special information from the table.
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
Making more practice by using date functions.
Resolving VLOOKUP errors.
Working on Social Security.
Calculate vacation days based on years worked and other conditions
Master date functions using the complaints data for a gym.
Getting some information with VLOOKUP on "Employee Data"
Matching nested IF() and IFS() functions.
Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...
Working with advanced functions.
Using Nested IF.
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.