Excel DATEVALUE AND TIMEVALUE

Excel DATEVALUE AND TIMEVALUE

Datevalue and timevalue functions are designed to convert a date that is stored in a text string to a serial number recognized by Excel as a date. The date value is a handy function used in moments where you have data containing dates in a text format. With the help of this function, you would […]

Workday and Workday.INTL

Excel Workday and Workdays INTL Functions

Workday and Workdays INTL Overview Excel WORKDAY Function and Excel WORKDAY.INTL Function. In this video, we will learn how to make use of Excel Workday function. We have two variations of this function where we can use this function with a standard weekend that is Saturday and Sunday. There is another variation where we can […]

Excel Networkdays and Excel Networkdays.INTL

Excel Networkdays and Excel Networkdays.INTL

How to make use of NETWORKDAYS function Overview In this video, you will learn about how to make use of NETWORKDAYS function, and you also learn how to use NETWORKDAYS.INTL excel function. By the end of this video, you will be able to use these functions with ease and should be able to calculate the […]

weeknum and isoweeknum funtions

Excel WeekNum and ISOWeekNum Functions

Excel WeekNum and ISOWeekNum Functions. In this video, we will learn about how to use WeekNum and ISOWeekNUm Excel Functions. These functions are designed to help you extract the number of a week from a given date. Using this week numbers you can organize your data more efficiently. These numbers would help you manage your […]

Excel Weekday Function

Excel Weekday Function

Excel 2016 Weekday Function. In this video, you will learn how to make use of weekday function. Weekday function is used to find the day of a particular date. This function can be used in a variety of ways when tracking the day for the date. While dealing with sales data, analytics data, research data […]

Generate Random Dates in Excel 2016

RandBetween – Generate Random Dates in Excel 2016

Did you ever struggle with Excel on how to generate Random numbers in Excel, or how to generate random dates in Excel? well, you have a treat here. In this video tutorial, you will learn how to make use of the randomBetween function to produce Random numbers. You will also see the usage of a […]