Published On Apr 4, 2019
In this video we’ll learn about the 4 best kept secrets of Excel.
We’ll start with the NetWorkDays function in in Excel, which serves to obtain the working days between 2 dates. We will also see NetWorkDays.int in Excel, which serves to obtain the working days between 2 dates where the weekend changes and there are holidays.
We will then go to the Prediction function, which serves to identify the future using Excel.
Next, we will learn about how to use an approximate vlookup to replace the nested if. We will see how it must be done to avoid using nested if with approximate match with SearchV.
We will finish with the wonderful DSUM in Excel, which serves as a compliment or replacement to sumif.
It is an excellent tool to make sums with filters and to be able to modify those filters directly in the Excel sheet.
Here is the file
https://s3.amazonaws.com/a2excel.com/...