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
Project Work Days
Calculate work days considering holidays, weekends and number of days worked
Project Work Days
Calculate work days considering holidays, weekends and number of days worked
Practice: IF Functions 3 - Other Functions and If
Making more practice by using IF() function.
Practice: IF Functions 3 - Other Functions and If
Making more practice by using IF() function.
Customer & Order Table
Getting special information from the table.
Customer & Order Table
Getting special information from the table.
Practice: Date Functions
Making more practice by using date functions.
Practice: Date Functions
Making more practice by using date functions.
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.
Badly Formatted Data
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
Badly Formatted Data
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
Employee List
Lookup employee information from the employee list based on different parameters
Project Work Days
Calculate work days considering holidays, weekends and number of days worked
Practice: Date Functions
Making more practice by using date functions.
GYM Complaints Sheet
Master date functions using the complaints data for a gym.
Customer & Order Table
Getting special information from the table.
Badly Formatted Data
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
