Excel 10 Tutorial

How would you count someone’s age? Simple, by calculating the difference between two dates. There are certain situations where you need to get the number of years, number of months, number of days. There are different ways to get it but the best way to calculate difference between two dates in excel is to use the Dated If function . But the funny thing is that this is a hidden function in excel. You won’t be able to locate this function in the Formula Menu. Even if you write the function excel won’t show the parameter suggestions like it does for other functions. So, you need to understand and use the function on your own. Well, not exactly. I’ll be guiding you. So, let's have a look at the Function. This is how the Dated If Formula looks: = DatedIF(Start Date, End Date, "Unit") We have the Starting Date as the first argument. Here you can write the date or choose a date reference. This date can be written in text or formatted as a date. The End Date is the second...

  There are occasions when we need to consider combining multiple workbooks. You're working on a quarterly report, for example. You must consider the data from January, February, March, and April for the first quarter. If you keep data on a monthly basis, you'll need to marge those four files into a single workbook for a more accurate report. Of course, you could just open each workbook and copy the data to a new one. This could be done with four workbooks, but what about a hundred? Is it possible for you to manually combine those Excel files into one? That's completely ridiculous. You'll almost certainly need an automated solution for this. In this article, I'll teach you how to automatically merge numerous Excel spreadsheets into one. I'll be utilizing VBA for this, and you'll be able to combine multiple workbooks at once by simply hitting a button. You don't need to be a VBA expert to achieve this, so don't be concerned. This is something that...