Page 1 of 14PREVNEXT

Find functions and enter arguments

Treasure-trove of hundreds of functions
Learn how to find Microsoft® Excel functions by using the Insert Function dialog box. Get to know function arguments and the ways to learn more about them.

About this course

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.

Goals

After completing this course you will be able to:

  • Search for, find, and use a function by means of the Insert Function dialog box.
  • Enter function arguments by using the Function Arguments dialog box.
  • Get information from function tips as you type function arguments directly into a worksheet.
  • Open Help topics from a dialog box or from the function tips.

Before you begin

You should complete the course Audio course: Get to know Excel: Enter formulas, or you should already be familiar with Excel formulas, functions, cell references, and function arguments.


Excel has a treasure-trove of hundreds of functions. These prewritten formulas make it easy to do complex procedures with numbers, dates, times, text, and more. Simple enough, but with so many to choose from, how do you find the function you need?

In this course you'll learn how to find a function, and then you'll learn how to get help to enter arguments, information that tells functions what to work with.

To learn more about this course, you can read the overview in the center of this page or the detailed table of contents in the left column.

Click the Next button to start the first lesson.

Page 1 of 14PREVNEXT