I'll run through three logical functions (or groups of functions) that I find particularly helpful, and how you can also make the most of them in real-world scenarios.

Also, don’t worry about trying to remember all the options; Excel will provide drop-down lists with all the choices. Let’s work on a few examples using the AGGREGATE function. If you would like to ...