From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using other common functions

Using other common functions

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using other common functions

- Built into Excel is a huge library of over 450 functions. We're looking at a worksheet called Functions in our workbook 03 - Creating Formulas and Functions. If you go to the Formulas tab in the ribbon and slide over one of the entries here you can see, there are different kinds of functions and as we slide over this one or that one we can see a pop-up tip reminding us or explaining to us what it does and there's a lot of them as I suggested, Math & Trig. Now, with the wrong mindset here you could easily get overwhelmed. Here's one on inverse hyperbolic cosines you think you'll need that one? I kind of doubt it, unless you're in the scientific arena and of course there are some valuable tools and functions in here. If you work in finance, there certainly are some financial functions here, quite a few of them about 50 of them or so out here. A capsule description of a function, what is it? It's a shortcut for a formula. Now, each one has to be taken on its own merits and you'll see…

Contents