• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Using Excel's Built-In Funct... > Working with Excel's Most Useful Fun...

Working with Excel's Most Useful Functions

In this section, I show you examples of the functions in Table 11.1 (with the exception of the SUM function which you learned about in Chapter 10), with suggestions for using them in real-life worksheet situations. This short list of functions contains just a few of the hundreds of functions available in Excel. If you explore the list of functions in the Paste Function dialog box, you'll find functions that calculate sine, cosine, tangent, the actual value of pi, and functions for a lot of accounting and engineering equations, logarithms, and binomials.

If you want to use complex engineering and financial functions, you'll need to install the Analysis Toolpak. Click Tools,Add-Ins, mark the Analysis Toolpak check box, and click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint