Lookup employee information from the employee list based on different parameters
Lookup employee information from the employee list based on different parameters
Calculate work days considering holidays, weekends and number of days worked
Calculate work days considering holidays, weekends and number of days worked
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
Making more practice by using text functions for date operations.
Making more practice by using text functions for date operations.
Making more practice by using workday function.
Making more practice by using workday function.
Making more practice by using TODAY() and NOW() functions
Making more practice by using TODAY() and NOW() functions
Making more practice by using date functions.
Making more practice by using date functions.
Making more practice by using date functions.
Making more practice by using date functions.
Calculate vacation days based on years worked and other conditions
Calculate vacation days based on years worked and other conditions
Master date functions using the complaints data for a gym.
Master date functions using the complaints data for a gym.
Getting some information with VLOOKUP on "Employee Data"
Getting some information with VLOOKUP on "Employee Data"
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.
Lookup employee information from the employee list based on different parameters
Calculate work days considering holidays, weekends and number of days worked
Creating a sample of time sheet with some date and time functions. You will be able to calculate total hours and overtim...
Making more practice by using text functions for date operations.
Making more practice by using workday function.
Making more practice by using TODAY() and NOW() functions
Making more practice by using date functions.
Making more practice by using date functions.
Master date functions using the complaints data for a gym.
Calculate vacation days based on years worked and other conditions
Cleaning up data using various text functions which were given below. You will also correct some datas in the table.