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.
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
Staff Data
Getting some information with VLOOKUP on "Employee Data"
Staff Data
Getting some information with VLOOKUP on "Employee Data"
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.
Vacation Day Calculator
Calculate vacation days based on years worked and other conditions
Badly Formatted Data
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
