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

Hour 14. Working Smarter > Using Excel Add-ins

Using Excel Add-ins

From time to time, you might have noticed the Add-Ins item on the Tools menu and wondered what that option does. Excel add-ins are worksheet tools that bring more power to your desktop. Table 14.2 lists the Excel add-ins and explains what they do.

Table 14.2. Excel's Add-ins
Add-inWhat It Does
Analysis ToolPakGives you several worksheet functions and macro functions for financial and scientific data analysis for use in a workbook, the Function Wizard, and the Tools menu.
Analysis ToolPak VBAProvides developers with Analysis ToolPak syntax tools and functions for financial, statistical, and engineering analysis.
Conditional Sum WizardAssists you with summing data in lists.
Euro Currency ToolsLets you format values as euros and provides the EUROCONVERT worksheet function for converting currencies.
Internet Assistant VBAAllows developers to publish Excel data to the Web by using Excel 97 Internet Assistant syntax.
Lookup WizardAllows you to create formulas to find data in Excel tables.
Solver Add-inLets you determine answers to complex what-if questions or equations by analyzing cells and determining the optimum value adjustments to arrive at a desired result.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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