Paste Function Button

Thanks for joining us this week to continue our discussion on Excel Functions. This week we are reviewing the Paste Function button.

The Paste Function button is really the easiest way to enter unfamiliar formulas into a cell. All you need to do is answer some basic questions and the Wizard puts the values in the correct parts of the function. This is a great tool to use for basic formula calculations.

To use the Paste Function button in Excel 2007:

• Enter a brief description of what you want to do, and then click on the "Go" button to the right of the description box. This will narrow down the possibilities allowing you to find the specific function you want.
• A drop down box of functions will display for you to make your selection
• You can also select a category of functions or the name of the function itself
  
• Click OK when done
• A window will pop up for you to enter the values for each argument in the function by either typing in the appropriate cell addresses or by using the mouse to click on the cells
  
• Press OK to display the results of the function

You can also type the function directly into the cell you want the results to appear. You can type in all lowercase or uppercase. (Tip: you will need some experience in using the formula to write the formula correctly and avoid calculation errors.)

• Click th ecell you want the function in
• Type "=" to begin the formula
• Type the function name in either uppercase or lowercase
• Open parenthesis "("
• Enter the appropriate arguments using the keyboard or mouse
• When the argument is complete, close parenthesis")"
• Press Enter to display the results of the function

We hope you have found these tips helpful. If you need additional help writing formulas or need any other Excel expertise please contact us! We can help you become more proficient in Excel and all other Microsoft Office applications. We specialize in virtual training for small or large groups. We would be happy to talk to you about all your training needs!


If you found this helpful and you want more great tips sign up for our free report on "Top 10 VA Skills Most Requested by Employers" at http://www.buildyourvaskills.com
or sign up for our Super Summer School Series to learn more skills to build your Virtual Assisting business. Plus, just announced this week, our Inner Circle program!

Visit our main website at www.pcstraining.net for a full range of our services.

Susan Snyder
Practical Computing Solutions, LLC