How Function Works in Excel - Understanding Function Library, Arguments and Volatile Result

In this Excel tutorial, we'll explore how to use functions from the Function Library, understand what function arguments are, and see how the Function Arguments dialog box works. You'll learn about volatile functions like TODAY(), how to work with functions that require arguments like YEAR() and DAYS(), and how to create powerful nested functions using real-world examples. I'll also show you how to edit formulas safely and how nesting functions. 00:00 Inserting Functions with Function Library 01:36 Volatile Result 02:17 Understanding Arguments 03:32 Writing Functions Directly into Cells 03:57 Editing Functions 04:43 Nesting Functions 05:30 Understanding Common Errors