Use formulas and functions

Locate functions

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Excel groups functions into many categories and you can use help to understand what each function does.

Find functions and categories of functions
  1. Select Formulas.

  2. The Function library group displays categories of functions that are available.
    Function library group

  3. If the function you are looking for is unlikely to be in the categories listed, select More Functions.

Use help to get more information about functions
  1. Select Formulas.

  2. Select a category of function, and then hover the mouse cursor over the function.

  3. Select Tell me more.

Want more?

Discover more courses like this at LinkedIn Learning

Create a formula by using a function

Excel functions (by category)

Tracking down functions, by going to the Formulas tab and clicking on the various categories, sometimes helpful, sometimes not as helpful as we would want.

When you have that extra minute or so, click Logical for example, you might or might not, have seen some of these functions.

How about Text, sometimes just the very name, the word, suggests something.

LOWER, how about lower case, that could be handy at times.

PROPER, maybe, text strings to proper case, first letter upper case, that could be interesting too.

Date & Time functions, as you slide over these.

Now again, who really has the time to explore all these, probably nobody.

But, on the other hand, when you have that extra moment, extra minute, occasionally just seeing some of these might pique your interest a little bit, or maybe you've heard about certain functions.

And again, don't just look at the major ones that we see here, also go over to More Functions and there are some more over there too.

If you're an engineer, you're probably aware that Excel has a lot of capability, and here are some Engineering functions, and there are certainly some other kinds out here as well too.

So, this give us entry into some of the many different functions that we might consider using, it doesn't always give us all the information we need, notice here too when you click one of these, I'll just pick one at random out of Statistical, perhaps you've heard of something called CONFIDENCE or CONFIDENCE NORM, well what does that mean?

And down here you'll see a choice, as we do on all these, Tell me more, and it'll bring up a dialog box, taking us into the Help system.

And, sometimes it takes us right back to another list, how about functions by category, and we might have to track it down that way.

Or else type in the name, maybe we've heard about PMT, let's type in PMT, and Enter, and see where that takes us.

And it takes us to this PMT function, and we've got a Help screen here, with a convenient Print button here if we wish, can make the dialog box wider, and so on.

So at different times and at different levels of using certain functions, you need the on-screen Help, you can certainly see it here, and lots of examples.

Learning doesn't stop here. Discover more expert led tutorials at LinkedIn Learning. Start your free trial today, at linkedin.com/learning.

Enjoy one month of free access to LinkedIn Learning

Learn from recognized industry experts, and get the business, tech, and creative skills that are most in demand.

Benefits
  • Get unlimited access to over 4,000 video courses.

  • Receive personal recommendations based on your LinkedIn profile.

  • Stream courses from your computer or mobile device.

  • Take courses for every level – beginner to advanced.

  • Practice while you learn with quizzes, exercise files, and coding windows.

  • Choose a plan for yourself or your entire team.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×