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
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
Social Media Statistics
Create some statistics to better understand the social media adoption
Social Media Statistics
Create some statistics to better understand the social media adoption
Good Biscuit
Understanding formulas with "Sales" operations.
Good Biscuit
Understanding formulas with "Sales" operations.
Weekly Timesheet
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
Weekly Timesheet
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
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...
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
Privileged Customers
Matching nested IF() and IFS() functions.
Privileged Customers
Matching nested IF() and IFS() functions.
Special Use of Lookups
Try using vertical lookup instead of if statements
Top Models
Calculate the earnings of top models based on scenarios
Employee List
Lookup employee information from the employee list based on different parameters
Social Media Statistics
Create some statistics to better understand the social media adoption
Weekly Timesheet
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
Body Mass Index Calculation
Create a body mass index calculator using height and weight of a person
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
