Subtitles of the Movie

So that concludes our coverage of functions, so let's summarize what we have learned. We have looked first at the Excel built-in functions, and just those alone provide an incredible amount of power to do your job within Excel. But then moving on, we looked at how we can harness VBA's built-in functions as well. And then of course there's the user-defined functions, which we write in VBA code. Once we've done those, well in writing those, we can leverage off the built-in functions both available within Excel, and within VBA. And we have seen how we can reuse that code and to do things more efficiently. And then we have seen that once we've done that, we can leverage off those user-defined functions within our use of Excel. In fact, they really become indistinguishable from the built-in functions, those we have designed ourselves, and really add to the value of Excel. But it's important also when using these techniques, to test what you do very thoroughly. Because there's some subtle and some not so subtle differences between the Excel functions and VBA functions, and it's good to catch any mistakes that might otherwise creep into the results by (not) testing thoroughly.