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
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
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
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.
Practice: VLOOKUP-IV
Making more practice by using lookup functions.
Practice: VLOOKUP-IV
Making more practice by using lookup functions.
Customer & Order Table
Getting special information from the table.
Customer & Order Table
Getting special information from the table.
Practice: VLOOKUP-II
Making more practice by using lookup functions.
Practice: VLOOKUP-II
Making more practice by using lookup functions.
Good Biscuit
Understanding formulas with "Sales" operations.
Good Biscuit
Understanding formulas with "Sales" operations.
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...
iPhone vs Samsung
Checking formulas results with Iphone-Samsung sales.
iPhone vs Samsung
Checking formulas results with Iphone-Samsung sales.
Electronic Sales
Using formulas for "Electronic Sales" operations.
Electronic Sales
Using formulas for "Electronic Sales" operations.
Practice: VLOOKUP-I
Making more practice by using lookup functions.
Practice: VLOOKUP-I
Making more practice by using lookup functions.
Staff Data
Getting some information with VLOOKUP on "Employee Data"
Staff Data
Getting some information with VLOOKUP on "Employee Data"
Practice: VLOOKUP-III
Making more practice by using lookup functions.
Practice: VLOOKUP-III
Making more practice by using lookup 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() ...
Practice: VLOOKUP-V
Making more practice by using lookup functions.
Practice: VLOOKUP-V
Making more practice by using lookup functions.
Special Use of Lookups
Try using vertical lookup instead of if statements
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
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.
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...
iPhone vs Samsung
Checking formulas results with Iphone-Samsung sales.
Practice: VLOOKUP-III
Making more practice by using lookup functions.
