You are not limited to the Built-In Functions that are provided in Excel. You can also invent your own functions by writing Excel macros to perform specific tasks.
You can even add your own macros to the Excel function menu, so that they are available to you in the same way as Excel's built-in functions.
A macro is a piece of computer code, that is written for Excel, using the Visual Basic for Applications (VBA) programming language. The basics of the VBA programming language are covered in the Excel VBA Tutorial pages of this site. However, it is recommended that you read the following sections on Excel Macro Security settings and the Visual Basic Editor, before you begin to write VBA code.