Employee List
Lookup employee information from the employee list based on different parameters
Employee List
Lookup employee information from the employee list based on different parameters
Body Mass Index Calculation
Create a body mass index calculator using height and weight of a person
Body Mass Index Calculation
Create a body mass index calculator using height and weight of a person
Special Use of Lookups
Try using vertical lookup instead of if statements
Special Use of Lookups
Try using vertical lookup instead of if statements
Top Models
Calculate the earnings of top models based on scenarios
Top Models
Calculate the earnings of top models based on scenarios
Salesperson Ratings
Create a summary of salesperson sales stats with the help of range lookup.
Salesperson Ratings
Create a summary of salesperson sales stats with the help of range lookup.
Good Biscuit
Understanding formulas with "Sales" operations.
Good Biscuit
Understanding formulas with "Sales" operations.
International Tourist Data
Calculate which country recieves the most tourists in each continent.
International Tourist Data
Calculate which country recieves the most tourists in each continent.
New Text Functions
Combine text strings using TEXTJOIN() and CONCAT().
New Text Functions
Combine text strings using TEXTJOIN() and CONCAT().
Customer & Order Table
Getting special information from the table.
Customer & Order Table
Getting special information from the table.
Highest Paid Celebrities
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
Highest Paid Celebrities
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
Practice: Date Functions
Making more practice by using date functions.
Practice: Date Functions
Making more practice by using date functions.
Vacation Day Calculator
Calculate vacation days based on years worked and other conditions
Vacation Day Calculator
Calculate vacation days based on years worked and other conditions
GYM Complaints Sheet
Master date functions using the complaints data for a gym.
GYM Complaints Sheet
Master date functions using the complaints data for a gym.
Staff Data
Getting some information with VLOOKUP on "Employee Data"
Staff Data
Getting some information with VLOOKUP on "Employee Data"
Privileged Customers
Matching nested IF() and IFS() functions.
Privileged Customers
Matching nested IF() and IFS() functions.
Coffee Shop Price Table
Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...
Coffee Shop Price Table
Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...
Employee List
Lookup employee information from the employee list based on different parameters
Special Use of Lookups
Try using vertical lookup instead of if statements
Top Models
Calculate the earnings of top models based on scenarios
Practice: Date Functions
Making more practice by using date functions.
GYM Complaints Sheet
Master date functions using the complaints data for a gym.
Coffee Shop Price Table
Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...
Body Mass Index Calculation
Create a body mass index calculator using height and weight of a person
Salesperson Ratings
Create a summary of salesperson sales stats with the help of range lookup.
International Tourist Data
Calculate which country recieves the most tourists in each continent.
New Text Functions
Combine text strings using TEXTJOIN() and CONCAT().
Customer & Order Table
Getting special information from the table.
Highest Paid Celebrities
Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...
Vacation Day Calculator
Calculate vacation days based on years worked and other conditions
