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 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 […]

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 […]

Find Age or Tenure using DATEDIF in Excel 2016. In this video, you will learn how to use DATEDIF function. This is a hidden gem inside Excel, for some odd reason this function does not show up when you start typing in any cell as other functions do. This function proves really handy and will […]

Calculate Expiry Date in Excel 2016 – EDATE. In today’s video, we will learn how to calculate the end date of a contract based on the start date and the length of the contract in the number of months. In this demonstration, we will be using an EDATE function in excel 2016. This function is […]

In this video, you will learn how to calculate the sum of time in Excel. We have demonstrated the different approach on how you can make sure that the calculation you do to perform the sum of time in Excel provides you with accurate numbers. With this video, you will be able to calculate and […]