Excel Functions

Here, we will learn how to use the Excel text functions: CLEAN and TRIM. Later, we will also learn how to clean data.

Here, we will learn how to use the Excel date and time functions: DATEVALUE and TIMEVALUE. Later, we will also learn how to preserve both date and time.

Here, we will learn how to use the Excel time functions: TIME, HOUR, MINUTE and SECOND. Later, we will also learn how to create a new time.

Here, we will learn how to use the Excel date functions: WORKDAY, WORKDAY.INTL, NETWORKDAYS and NETWORKDAYS.INTL. Later, we will also learn how to calculate workdays in a year.

Here, we will learn how to use the Excel date functions: DAYS and DAYS360. Later, we will also learn how to calculate difference in days.