Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 Find functions and enter arguments 
 
  Overview  
 Show/Hide lesson sections Use the Insert Function dialog box
 Show/Hide lesson sections Use function tips
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Bookmark and ShareShare
Overview
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.

  • Length: 20–30 minutes
  

Next

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.
 
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.
COURSE TEXT

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.

 
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.

  Go to previous page (disabled)    Next Go to next page
advertisement