Home > Excel Help Portal > Excel Add-Ins

<<  (Page 2)  Previous              Next  (Page 2)  >>

Excel Add-Ins

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses add-ins available for
Microsoft Excel.

1. How to use Dates and Times in Excel This step-by-step article describes how to use the built-in date and time functions in Microsoft Excel to perform complex date and time calculations. Excel stores all dates as integers and all times as decimal fractions. With this system, Excel... KB#214094. Keywords: Analysis ToolPak, SERIES, Sorting, Dates, Days, Months, Networkdays, Years, Custom Number Formats, Formulas, Files, TODAY, NOW, DATEVALUE, TIMEVALUE

 
2. How to Use EXTRACT.EXE to Copy Files from DMF Disks Files on all but the first disk of the programs listed at the beginning of this article are combined in cabinet form, and as such cannot be copied individually to other disks or hard drives. This article explains how to use the Extract utility... KB#132913. Keywords: Solver, Symbol, Files

 
3. How to Use the EFFECT and NOMINAL Functions to Calculate Loan or Mortgage Interest with Intrayear Compounding The future value of a dollar amount, commonly called the compounded value, involves the application of compound interest to a present value amount. The result is a future dollar amount. Three types of compounding include: annual, intrayear,... KB#291106. Keywords: Add-In, Analysis ToolPak, Years, Format, EFFECT, NOMINAL, PMT

 
4. How to Use the Conditional Sum Wizard in Microsoft Excel This article shows you how to use the Conditional Sum Wizard in Microsoft Excel. The Conditional Sum Wizard helps you calculate the sums of values that meet specified conditions. It is included with Microsoft Excel versions 97 and later. The... KB#214249. Keywords: Add-In, Conditional Sum, Sales, Formulas, Files

 
5. Excel Statistical Functions: PEARSON This article describes the PEARSON function in Microsoft Excel. This article discusses how to use the function, and this article compares results of PEARSON in Excel 2003 with the results of PEARSON in earlier versions of... KB#828129. Keywords: Analysis ToolPak, Format, Arrays, Errors, Formulas, CORREL

 
6. Excel Statistical Functions: INTERCEPT This article discusses the INTERCEPT function in Microsoft Excel, illustrates how to use the function, and compares its results for Excel 2003 with its results in earlier versions of... KB#828234. Keywords: Analysis ToolPak, Plot, Linear Regression, Format, Arrays, Errors, Formulas, INTERCEPT, AVERAGE

 
7. Excel 2002 PostService Pack 2 Hotfix Package: September 19, 2003 This article describes the Microsoft Excel 2002 issues that are fixed in the Microsoft Excel 2002 Post-Service Pack 2 hotfix package that is dated September 19, 2003. back to the top Issues That Are Fixed in this Hotfix Package The following... KB#827978. Keywords: Add-In, Dates, Errors, Error Message, File Name, Files, Registry, Text Files, Web

 
8. Date Calculations This page was intended as a summary of calculations on my datetime page, but some of the formulas shown here differ, I think the nth weekday day of Month formulas are easier to follow... First Sunday of Mo....First Monday..,Keywords: Analysis ToolPak, Charts, Dates, Days, Holidays, Workday, Years, Borders, Format, Formulas, UDF, VBA, HTML, Web, Comments, WEEKDAY, DATEDIF, NOW, MOD, OFFSET, WEEKNUM, ROW

 
9. How to use Microsoft Map to Display Postal Code Centers in Excel 2000 This step-by-step article explains how to use Microsoft Map in Microsoft Excel 2000 to display postal code centers on inserted maps for the United States, Canada, or the United Kingdom. Postal Code Formats Microsoft Map can evaluate postal code... KB#213882. Keywords: Microsoft Map, Colors, Fonts, Format, Symbol, Object

 
10. Warning Message When You Start an Office Program with Adobe PDFMaker Addin When you start or quit one of the Microsoft Office XP programs listed at the beginning of this article, you may receive an error message that is similar to the following Microsoft program name has detected that your computer has a version of... KB#302596. Keywords: Add-In, Download, Third-Party, Errors, Error Message, File Name, Files, Templates, Web

 
11. Office 2000 Correct Flipped Pictures Addin When you open a file in Microsoft Word 2000, Microsoft PowerPoint 2000 or Microsoft Excel 2000, all your pictures appear the way that you want. However, when you open your file in an Office XP program or share your file with an Office XP user,... KB#823734. Keywords: Add-In, Download, OLE, Errors, Files, Registry, Links, Scenarios

 
12. Cannot Remove Entries from AddIns Dialog Box In Microsoft Excel version 5.0, when you choose Add-Ins from the Tools menu, you cannot remove an entry from the Add-Ins Available list in the Add-Ins dialog... KB#110076. Keywords: Add-In, Errors, Error Message, Files, Registry

 
13. How to Create a Map with Microsoft Data Map In Microsoft Excel, you can use Microsoft Map (Microsoft Data Map in Microsoft Excel 7.0) to graphically represent data that is associated with geographic regions. This article describes how to create a map on a worksheet in Microsoft... KB#147637. Keywords: Microsoft Map, Charts, Rank, Sales, Colors, Format, Styles, Symbol, Toolbar

 
14. How to Set the Mask and Picture Properties for Office XP CommandBars Microsoft Office XP introduces two new properties to the CommandBarButton object: the Mask and Picture properties. You can use these properties to place pictures on custom generated command bar controls. Note These properties are also available... KB#286460. Keywords: Add-In, ActiveX, OLE, Errors, Startup, VBA, Object, Web

 
15. Automation AddIn Function Binds to Excel BuiltIn Function with the Same Name When you create an Automation Add-in that is targeted for Microsoft Excel and you insert a function from your add-in into an Excel worksheet by using the Insert Function dialog box, Excel binds to the built-in function instead of your custom... KB#286305. Keywords: Add-In, DLL, Errors, Formulas, VBA

 
16. How to Create a Bell Curve Chart A bell curve is a plot of normal distribution of a given data set. This article describes how you can create a chart of a bell curve in Microsoft... KB#213930. Keywords: Analysis ToolPak, Charts, Histogram, Legend, Plot, SERIES, Format, Formulas, AVERAGE

 
17. How to use Excel Startup Folders in Excel 2002 This step-by-step article explains how to use the Microsoft Excel startup folders. Excel uses startup folders in two ways: The actual startup folder locations can vary depending on which version of Excel you use. For more details about Excel... KB#291218. Keywords: Add-In, Format, Errors, Startup, Macro, Error Message, Files, Save A File, Templates, Toolbar

 
18. How to Use Data Access Objects to Join Tables of Different Formats Microsoft Excel 2000 provides Data Access Objects (DAO) for Microsoft Visual Basic to allow you to access external databases. Microsoft Query and the Open Database Connectivity (ODBC) add-in (Xlodbc.xla) do not provide a direct means for you to... KB#213820. Keywords: Add-In, Query, DAO, Format, VBA, Macro, Object, Files, Web

 
19. Different Results from ACCRINT Function Between Excel 97 and Excel 2000 In Microsoft Excel 2000, the ACCRINT function returns a different result than in Microsoft Excel... KB#244023. Keywords: Analysis ToolPak, Dates, Formulas, File Name, Files, Web, ACCRINT

 
20. How to use Excel Startup Folders in Excel 2000 This step-by-step article describes how to use Microsoft Excel startup folders. Microsoft Excel uses startup folders in two ways: To load Excel files at startup -and- As a reference location for templates The actual startup folder locations can... KB#240150. Keywords: Add-In, Format, Errors, Startup, Macro, Error Message, Files, Save A File, Templates, Toolbar

 
21. How to Create an Excel Histogram by Using Automation and Analysis ToolPak This article provides a sample Visual Basic project that shows how to use the Analysis ToolPak (ATP) to generate a histogram. This article also illustrates basic techniques for implementing and using the Analysis ToolPak add-in library, and... KB#270844. Keywords: Add-In, Analysis ToolPak, Charts, Histogram, Command Button, Macro, Object, VBA, Templates, Web

 
22. Adobe Acrobat PDF and Excel Keywords: Add-In, Download, Export, Format, Errors, Speech, Startup, Printing, Error Message, Files, Templates, Toolbar, HTML, Web, Comments

 
23. How to calculate Compound Interest for an IntraYear Period in Excel 2000 The future value of a dollar amount, commonly called the compounded value, involves the application of compound interest to a present value amount. The result is a future dollar amount. Three types of compounding are annual , intra-year , and... KB#213907. Keywords: Add-In, Analysis ToolPak, Formulas, EFFECT

 
24. How to use the "Most Recently Used" Category in the Function Wizard in Excel 2000 This step-by-step article explains how to use the use the Most Recently Used category in the Function Wizard in Excel 2000. In the Microsoft Excel Function Wizard, the Most Recently Used Function list contains the last 10 functions that you used... KB#214300. Keywords: Add-In, Registry, Hyperlinks, AVERAGE, COUNT, MAX, SIN, PMT

 
25. How to Calculate Compound Interest for an IntraYear Period The future value of a dollar amount, commonly called the compounded value, involves the application of compound interest to a present value amount. The result is a future dollar amount. Three types of compounding include: annual, intrayear,... KB#162634. Keywords: Add-In, Analysis ToolPak, Years, Formulas, EFFECT

 
26. How to Use Excel Startup Folders Microsoft Excel uses startup folders in two ways: The actual startup folder locations can vary depending on what version of Excel you are using. For more details about Excel startup locations, please see the More Information section later in... KB#259926. Keywords: Add-In, Format, Errors, Startup, Macro, Error Message, Files, Save A File, Templates, Toolbar

 
27. How to use Excel Startup Folders in Excel 2003 This step-by-step article explains how to use the Microsoft Excel startup folders. Excel uses startup folders in two ways: To load Excel files at startup. -and- As a reference location for templates. The actual startup folder locations vary,... KB#822107. Keywords: Add-In, Format, Errors, Startup, Macro, Error Message, Files, Save A File, Templates

 
28. Enumerate Addins The following table was created using a macro at http://www.herber.de/mailing/020598v.txt showing how simple a conversion from Excel to HTML can be (safe and simple). Actually after an HTML editor reprocesses the HTML code, the code is no longer as simple. The macro which generated the Excel... Keywords: Add-In, Analysis ToolPak, Solver, Query, Fonts, Arrays, Links, VBA, Macro, AutoSave, Templates, HTML, Window

 
29. How to use the Histogram Addin in Excel 2000 This step-by-step article describes how to create a histogram with a chart from a sample set of data. The Analysis ToolPak that is included with Microsoft Excel includes a Histogram tool. Verify Installation of the Analysis ToolPak Before you use... KB#214269. Keywords: Add-In, Analysis ToolPak, Charts, Histogram, Setup

 
30. Inserting an Excel Worksheet Object May Fail Under Windows NT The insert object function of a container application may fail if the server application takes a long time to load. For example, if the autosave feature of Microsoft Excel is turned on and you attempt to insert an Excel Spreadsheet into a... KB#173191. Keywords: Add-In, OLE, Errors, Object, AutoSave, File Name, Web

 
31. How to Enable AutoSave Microsoft Excel includes an AutoSave feature that periodically saves your file as you work on it. AutoSave does not save data into a separate file; therefore, the AutoSave feature does not prevent file corruption. However, AutoSave protects your... KB#147778. Keywords: Add-In, Startup, Macro, AutoSave

 
32. How to Use the Histogram Addin The Analysis ToolPak that is included with Microsoft Excel includes a Histogram tool. This article describes how to create a histogram with a chart from a sample set of... KB#141684. Keywords: Add-In, Analysis ToolPak, Charts, Histogram

 
33. The /Automation CommandLine Switch Does Not Disable COM Addin Programs When you use the /automation command-line switch to start Excel, COM add-in programs load unexpectedly. (The /automation switch should disable all automatically opened files and auto-run... KB#320058. Keywords: Add-In, File Name, Files, Registry

 
34. Overview and History of Excel 2000 Updates This article is a comprehensive list of the service releases, service packs and updates for Microsoft Excel 2000, as of January 2003. How to Determine Which Version of Microsoft Office 2000 Is Installed To determine which version of each Office... KB#269356. Keywords: Add-In, Analysis ToolPak, Dates, Export, Macro, Text Files, HTML, Web

 
35. How to Calculate Interest Paid for Multiple Periods You can use the CUMIPMT worksheet function to return the cumulative interest paid on a loan between a start period and an end period. You can also use the IPMT worksheet function to return the interest payment for a single given period for... KB#71952. Keywords: Add-In, Analysis ToolPak, Months, Arrays, Formulas, CUMIPMT, ROW

 
36. Analysis ToolPak Functions Unexpectedly Return #NAME Error Value In Microsoft Excel, you may experience the following problems when you use a worksheet function that is included in the Analysis ToolPak add-in: You receive the #NAME error value. -or- The function you want to use is not available in the... KB#121730. Keywords: Add-In, Analysis ToolPak, Networkdays, Errors, Formulas, VBA, Setup, Setup Program, Toolbar, ACCRINT, ISEVEN, SERIESSUM, ACCRINTM, IMABS, ISODD, SQRTPI, BESSELI, IMAGINARY, LCM, TBILLEQ, BESSELJ, DELTA, IMARGUMENT, MDURATION, TBILLPRICE, BESSELK, DISC, IMCONJUGATE, MROUND, TBILLYIELD, BESSELY, DOLLARDE, IMCOS, MULTINOMIAL, WEEKNUM, DOLLARFR, IMDIV, IMEXP, NOMINAL, XIRR, EDATE, IMLN, XNPV, COMPLEX, EFFECT, YEARFRAC, CONVERT, EOMONTH, COUPDAYBS, ERF, IMPOWER, ODDFPRICE, YIELDDISC, COUPDAYS, ERFC, IMPRODUCT, ODDFYIELD, YIELDMAT, COUPDAYSNC, FACTDOUBLE, IMREAL, ODDLPRICE, COUPNCD, FVSCHEDULE, IMSIN, ODDLYIELD, COUPNUM, GCD, IMSQRT, COUPPCD, GESTEP, IMSUB, PRICEDISC, CUMIPMT, IMSUM, PRICEMAT, CUMPRINC, INTRATE, RECEIVED

 
37. How to Display Only Certain States/Nations in Microsoft Map In Microsoft Excel, you can use Microsoft Map (Microsoft Data Map in Microsoft Excel 7.0) to limit the states or countries shown on a map to a given list. When a map is drawn, the default is to include all the states or countries on the selected... KB#193468. Keywords: Microsoft Map, Colors, Format, Symbol

 
38. How to create Multiple Views and Create and Print a Report in Excel This step-by-step article describes how to create multiple views, how to create a report from those views, and how to print the report. A view is a picture of the worksheet that has specific characteristics associated with it, such as print... KB#291072. Keywords: Add-In, Printing, Web

 
39. How to count Unique Elements in a Cell Range in Excel This step-by-step article shows you how to use the FREQUENCY function in an array formula to count the unique elements in a cell range. Count Unique Number Elements The following formula counts the number of unique values found in the range A1:A10... KB#268001. Keywords: Conditional Sum, Arrays, Formulas, FREQUENCY

 
40. Cannot Delete Entries from AddIns Dialog Box When you click Add-Ins on the Tools menu, you may be unable to delete an item from the Add-Ins available list in the Add-Ins dialog... KB#211956. Keywords: Add-In, Third-Party, Registry, Window

 
41. How to Designate Custom Locations for Excel Addin Programs This article describes how to designate custom locations for Excel add-in... KB#810789. Keywords: Add-In, Registry

 
42. Issues Fixed in Excel 2002 by Office XP Service Pack 2 Microsoft has released Microsoft Office XP Service Pack 2 (SP-2). This article describes the issues that are fixed for Microsoft Excel 2002. about how to download and install the Office XP SP-2 325671 OFFXP: Overview of the Office XP Service Pack... KB#325668. Keywords: Add-In, Solver, Download, Borders, Errors, PivotTables, Printing, VBA, Files

 
43. Use Microsoft Small Business Financial Manager Every once in a while, something comes along which is so amazing, it warrants a spot in the tip of the week. I was amazed today to learn that the fine folks in Redmond had packaged an incredibly useful tool in Office 2000 Premium. The tool searched for and located my Quickbooks data. It imported... Keywords: Add-In, Charts, Dates, Ratio, VBA, Web

 
44. How to create Multiple Views, Create and Print a Report in Excel 2000 This step-by-step article shows you how to create multiple views of a worksheet as well create and print a report. A view is a picture of the worksheet that has specific characteristics associated with it, such as print settings and whether to... KB#214258. Keywords: Add-In, Printing, Setup

 
45. How to Set the Descriptive Name of an Addin File In Microsoft Excel, it is possible to create a descriptive name and descriptive text for an add-in file that is listed in the Add-Ins dialog... KB#120795. Keywords: Add-In, Analysis ToolPak, Query, Links, VBA, Files, Comments

 
46. How to Create Addin Application Name and Description In the versions of Microsoft Excel listed above, you can create an add-in application that contains any of the following elements: functions, custom dialog boxes, custom menus, toolbars, and procedures. To create a name and description for your... KB#108425. Keywords: Add-In, Comments

 
47. Example on Use of Solver The Solver add-in that ships with Microsoft Excel is used to find solutions to what-if scenarios based on adjustable cells and constraint cells. This article gives an example of how to set up a model on a worksheet and how to use Solver to find... KB#214263. Keywords: Add-In, Solver, Scenarios

 
48. How to Set the Descriptive Name of an Addin File In Microsoft Excel 2000, it is possible to create a descriptive name and descriptive text for an add-in file that is listed in the Add-Ins dialog... KB#214014. Keywords: Add-In, Analysis ToolPak, Query, VBA, Files

 
49. Inserting an Excel Worksheet Object May Not Work Under Windows NT Terminal Server The insert object function of a container program may not work if the server program takes a long time to load. For example, if the automatic save feature in Microsoft Excel is turned on and you attempt to insert an Excel spreadsheet into a... KB#245462. Keywords: Add-In, OLE, Errors, Object

 
50. Working with fractions Some types of data, such as stock market quotes, normally display as fractions, not decimals. To enter a fraction in Excel, type the whole number (or integer) followed by a space, and then type the fraction, using a slash (for example, 5/8). If you type only a fraction, Excel may interpret it as a... Keywords: Analysis ToolPak, Charts, Format, Formulas, Printing, DOLLARFR, DOLLARDE

 

<< (Page 2)  Previous              Next  (Page 2) >>