Home > Excel Help Portal > Financial Analysis With Excel

# Financial Analysis With Excel

## The ExcelUser portal offers links to help pages created by top Excel web sites. This section discusses financial analysis in Microsoft Excel.

1. Guidelines for Selecting the Appropriate Picture Format This article discusses the following topics: The various picture file formats that you can insert into Microsoft Office programs How to select the best format for a particular purpose How to select the appropriate resolution and color depth for... KB#320314. Keywords: Third-Party, Ratio, Colors, Format, Arrays, Formulas, Printing, Files, Web

2.
3. Guidelines for Selecting the Appropriate Picture Format This article discusses the following topics: The various picture file formats that you can insert into Microsoft Office 2000 programs How to select the best format for a particular purpose How to select the appropriate picture resolution and... KB#272399. Keywords: Graphic, Third-Party, Ratio, Colors, Format, Arrays, Formulas, Printing, Files, Web

4.
5. Excel Statistical Functions: BINOMDIST This article describes the BINOMDIST function in Microsoft Office Excel 2003, illustrates how to use the function, and compares the results of the function for Excel 2003 with its results for earlier versions of... KB#827459. Keywords: Ratio, Statistics, Format, Formulas, BINOMDIST, COMBIN, SQRT

6.
7. How to manage Office XP Templates in Office Programs This step-by-step article describes the location of templates in Microsoft Office XP, how the Templates dialog box (click General Templates in the task pane) displays available templates, and the registry settings that control where to find... KB#290232. Keywords: Files, Registry, Templates

8.
9. Excel Statistical Functions: POISSON This article describes the POISSON function in Microsoft Excel, illustrates how to use the function, and compares the results of the function for Excel 2003 with the results of POISSON when it is used in earlier versions of... KB#828130. Keywords: Ratio, Statistics, Format, Errors, Formulas, EXP, NEGBINOMDIST, SQRT, FACT

10.
11. General Information about Microsoft Office Encryption This article describes changes in encryption file properties in Microsoft Office 2003 and Microsoft Office XP. Earlier versions of Office do not encrypt file properties. Office encrypts file properties by using supported algorithms. The... KB#290112. Keywords: Export, Password, Internet Explorer

12.
13. 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

14.
15. Running Subroutines and Macros from Visual Basic In Microsoft Excel, you can run Microsoft Visual Basic for Applications Sub procedures and Microsoft Excel version 4.0 macros from a Visual Basic procedure by using the Application.Run and Application.ExecuteExcel4Macro methods. You can also... KB#213837. Keywords: VBA, Macro, Web

16.
17. How to apply different passwords or permissions to separate ranges in worksheets in Excel This article shows you how to apply different passwords to protect specific ranges of a worksheet. If you use Microsoft Windows 2000, you can assign permissions rather than passwords to separate ranges of your worksheets. In Microsoft Excel 2002... KB#289270. Keywords: Errors, Password, Error Message

18.
19. How to Change Chart Type of a Series in Combination Chart If you create a combination chart of the Column-Area, Line-Column, or Line-Column on 2-Axes chart types, you may want to change the number of series plotted on each chart type. The Chart Wizard automatically takes half of the series (or one more... KB#192641. Keywords: Charts, SERIES, Format, Errors

20.
21. How to Display a Custom Office Assistant Balloon You can customize the Office Assistant to display messages in balloons with buttons or check boxes that you specify. At the bottom of the Office Assistant, you can display several types of buttons, such as: OK ,  Cancel ,   Retry , and so... KB#213731. Keywords: Sales, Arrays, Printing, VBA, Macro, Object, Web

22.
23. How to activate a Perpetual License in Office XP Programs This step-by-step article describes how to activate the perpetual license version of Microsoft Office XP. The same procedure can also be used for any stand-alone version of Microsoft Access 2002, Microsoft Excel 2002, Microsoft FrontPage... KB#293192. Keywords: Microsoft Access, Files

24.
25. How to Use STDDEV or STDDEVP with a PivotTable The PivotTable STDDEV or STDDEVP functions provide standard deviation statistics against data. STDDEV is best used when data is a sampling of the overall data. STDDEVP, on the other hand, is for use when the information included is all the... KB#152984. Keywords: Data Table, Years, Forecasting, Sales, Statistics, PivotTables, ROW, COLUMN

26.
27. How to Activate a Perpetual License in Office 2003 Programs This step-by-step article describes how to activate the perpetual license version of Microsoft Office 2003. The same procedure can also be used for any stand-alone version of Microsoft Office Access 2003, Microsoft Office Excel 2003, Microsoft... KB#828958. Keywords: Files, Web

28.
29. Find Command Doesn't Work Across Worksheets in Group When you use the Find dialog box to locate specific information, Microsoft Excel finds only the first occurrence of the value (even if you have selected multiple worksheets that contain this information). If the information is not located on... KB#124105. Keywords: VBA, Macro, Web, Window

30.
31. How to prevent Excel from Automatically Opening Files in the Startup Folder in Excel 2003 This step-by-step article describes how to prevent files from being opened automatically when you start Microsoft Office Excel 2003. back to the top How to prevent Excel from opening files When you start Excel 2003, all the files that are in... KB#826922. Keywords: Format, Errors, Startup, Error Message, Files, Toolbar

32.
33. How to specify Dynamic Web Query Parameters in Excel 2000 This step-by-step article shows you how to specify dynamic Web query parameters in Excel 2000. A Web query allows you to retrieve data stored on your intranet, the Internet, or the World Wide Web. A Web query can use static parameters,... KB#211926. Keywords: Query, Symbol, Web

34.
35. How to Delete Cells with a For Each...Next Loop Next loop in a different way from versions of Microsoft Excel earlier than Excel 97. This article describes the differences and provides a Visual Basic for Applications macro example... KB#213544. Keywords: VBA, Macro, Web

36.
37. How to Delete Cells with a For Each...Next Loop Next loop in a different way from versions of Microsoft Excel earlier than Excel 97. This article describes the differences and provides a Visual Basic for Applications macro example... KB#291300. Keywords: VBA, Macro, Web

38.
39. How to Delete Cells with a For Each...Next Loop Next loop in a different way from earlier versions of Microsoft Excel. This article describes the differences and provides a Visual Basic for Applications macro example that illustrates how to... KB#159915. Keywords: VBA, Macro, Web

40.
41. How to index Data in a PivotTable in Excel 2000 The Index function in a PivotTable calculates a weighted average by using the following formula: ((value in cell) x (Grand Total)) / ((Grand Row Total) x (Grand Column Total)) When you use PivotTables to compare the relative importance of your... KB#213922. Keywords: Sales, Format, PivotChart, PivotTables

42.
43. How to Dynamically Add and Run a VBA Macro from Visual Basic When Automating an Office product from Visual Basic, it may be useful to move part of the code into a Microsoft Visual Basic for Applications module that can run inside the process space of the server. This can boost overall execution speed for... KB#219905. Keywords: VBA, Macro, Object, VBE, Text Files

44.
45. Pictures in Earlier Office Documents Appear Flipped In Microsoft Office XP, when you open a document that was created in an earlier Microsoft Office 97 or Microsoft Office 2000 program, the images in the document may appear flipped horizontally, vertically, or in both... KB#312838. Keywords: Registry

46.
47. How to Get Prime Numbers or Factors A prime number is any integer that can be divided evenly only by itself and one. A factor of a number is an integer that can be evenly divided into that number. This article contains Microsoft Visual Basic for Applications macros for Excel that... KB#202782. Keywords: VBA, Macro, Web

48.
49. How to Copy One of Each Record Type to Another Worksheet Using Microsoft Visual Basic for Applications In Microsoft Excel 2000, you can use Microsoft Visual Basic to copy a single instance of a record type to another... KB#213292. Keywords: Clipboard, VBA, Macro, Web

50.
51. Macro Doesn't Function on Multiple Sheets in Group Mode In Microsoft Excel, when you use a Microsoft Visual Basic for Applications procedure to perform an action while worksheets are selected in group mode, the action performed may only be performed on one of the worksheets instead of on every worksheet... KB#213431. Keywords: Arrays, VBA, Macro, Object, Menu Command, Web, Window

52.
53. How to change the Chart Type of a Series in a Combination Chart in Excel 2000 In Microsoft Excel 2000, if you create a combination chart of the Column-Area, Line-Column, or Line-Column on 2-Axes chart types, you may want to change the number of series that are plotted on each chart type. The Chart Wizard automatically... KB#213881. Keywords: Charts, SERIES, Format, Errors, Error Message

54.
55. How to Create and Use OneInput Data Tables in Microsoft Excel This article describes how to create and use one-input tables in Microsoft Excel, which allow you to test how changes in one variable affect a... KB#282855. Keywords: Format, Arrays, Formulas

56.
57. How to use STDEV or STDEVP with a PivotTable in Excel 2000 This step-by-step article describes how to use the STDEV function and the STDEVP function with a PivotTable in Excel 2000. The PivotTable STDEV and STDEVP functions in Microsoft Excel calculate standard deviation based upon a set of data. You... KB#213914. Keywords: Years, Forecasting, Sales, PivotChart, PivotTables, ROW, COLUMN

58.
59. EnableEvents Property Does Not Work in Automation Server When Microsoft Excel 2000 is used as an Automation server during an Automation session, the EnableEvents property may not work as expected. Attempts by the client application to set this property to False through code in the client application... KB#211626. Keywords: VBA, Macro, Object, Toolbar, Web

60.
61. How to Share a Collection on a Network This article explains how to share Microsoft Clip Organizer clips among people who have access to the same network.NOTE: Sharing clips across the Internet or an intranet is not... KB#300859. Keywords: File Name, Files

62.
63. How to Get Prime Numbers or Factors A prime number is any integer that can be divided evenly only by itself and one. A factor of a number is an integer that can be evenly divided into that number. This article contains Microsoft Visual Basic for Applications macros for Excel that... KB#246802. Keywords: VBA, Macro, Web

64.
65. How To Convert a Single Column of Addresses to a CSV Text File This article describes how to convert a single column of addresses in a Microsoft Excel worksheet into a comma-separated value (CSV) file that you can import into another program (for example, Microsoft Access). Note For the address example in... KB#819964. Keywords: Format, File Name, Files

66.
67. How to retrieve the Names of Macros from an Excel Workbook by Using Visual Basic 6.0 This step-by-step article describes how to use Visual Basic 6.0 to retrieve the names of macros from an Excel workbook. Requirements The following items describe the recommended hardware, software, network infrastructure, skills and knowledge,... KB#315731. Keywords: Errors, Command Button, VBA, Macro, Object, Error Message, Web

68.
69. How to simulate a PivotTable with No Summarization in Excel 2000 This step-by-step article shows you how to use Microsoft Visual Basic for Applications code to simulate a PivotTable that does not summarize data. In Microsoft Excel, when you use the PivotTable command to create a table from a list, the data... KB#213799. Keywords: Format, PivotTables, VBA, Macro, Web

70.
71. Error Trying to Delete Image, Category in ClipArt Gallery IMPORTANT: This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. For information about how to do this, view the Restoring the Registry Help... KB#173411. Keywords: Errors, Registry, Web, Comments

72.
73. Visual Basic Macro for Validating Data upon Entry To automate a task or perform an operation when data is entered into a specific range in a Microsoft Excel worksheet, you can use the OnEntry and Intersect methods in a Visual Basic for Applications macro. For example, you can use this type of... KB#213373. Keywords: Sounds, VBA, Macro, OnEntry, Web

74.
75. How to use the Send To Command to Send Worksheet Selections as EMail in Excel This article describes how to use the Send To command to send worksheet selections as e-mail. back to the top Improvements and Requirements With Excel 2003, you can now send a message as a fax by using an Internet fax service. To turn on the Send... KB#826920. Keywords: Charts, Format, PivotTables, HTML

76.
77. How to change the Company Name and User Name in an Office 2003 Program This step-by-step article describes how to change the name of the company in Office 2003 after setup by modifying the Microsoft Windows registry. This article also explains how to change the user name information. Note In earlier versions of... KB#821550. Keywords: Setup, Registry, Web

78.
79. How to use TexttoSpeech in Excel 2002 This article describes how to use the buttons on the Text To Speech toolbar. This article also describes the default behavior of Text-to-Speech (TTS).Enable Text-to-Speech To turn on the Text-to-Speech (TTS) feature in Microsoft Excel, do one of... KB#288986. Keywords: Formulas, Speech, Toolbar

80.
81. How to Select Ranges Using Visual Basic for Applications (Novice Examples) In Microsoft Excel, you can select cells in a range either manually or by using some simple Microsoft Visual Basic for Applications code. This article provides examples you can use to select a range of... KB#291304. Keywords: VBA, Macro, Web, Discontiguous

82.
83. How to Temporarily Hide a UserForm In earlier versions of Microsoft Excel, if you use the Hide method to hide a custom dialog box, Microsoft Excel does not hide the dialog box until the macro that contains the Hide method is finished running. In Microsoft Excel 97, if you use the... KB#161536. Keywords: VBA, Macro, UserForm, Toolbar, Web

84.
85. How to Make Sample Macro Code Loop Through a List of Data on a Worksheet When you write a Microsoft Visual Basic for Applications (VBA) macro, you may have to loop through a list of data on a worksheet. There are several methods for performing this task. The More Information section of this article contains... KB#299036. Keywords: VBA, Macro, Web

86.
87. How to prevent Excel from Automatically Opening Files in the Startup Folder in Excel 2002 This step-by-step article describes how to prevent files from being opened automatically when you start Microsoft Excel. How to Prevent Excel from Opening Files When you start Excel, all files that are in the XLStart folder are automatically... KB#288866. Keywords: Startup, Files, Toolbar

88.
89. How to Simulate a PivotTable with No Summarization In Microsoft Excel, when you use the PivotTable command to create a table from a list, the data is always summarized according to the option that is selected in the Summarize By list of the PivotTable Field dialog box. Because this list box does... KB#149576. Keywords: Format, PivotTables, VBA, Macro, Web

90.
91. Excel functions for investment appraisal NPV and IRR are statistical tools for appraising projects and assisting in investment decision making. They measure cash flows over the period of a project and take account of the 'time value of money'. Monies spent or received at different times can not be directly compared. In general it is... Keywords: Cash Flow, Sales, Formulas, Links, NPV, IRR

92.
93. How to Set Print Area to Range with Defined Name In Microsoft Excel, if you have a macro that prints a range of cells on your worksheet, it may not print all of your data if you have inserted rows within the range specified in your macro. However, if rather than hard- coding a specific range... KB#141095. Keywords: Defined Name, Printing, VBA, Macro, Setup, Web, Window

94.
95. How to control the startup message about updating linked workbooks in Excel 2003 This step-by-step article describes how to control the startup message about updating linked workbooks in Microsoft Office Excel 2003. When you open a workbook that contains links to cells in other workbooks, you may receive the following... KB#826921. Keywords: Links, Startup

96.
97. How to Use a UserForm for Entering Data In Microsoft Excel, you can create a custom UserForm that provides a simple interface for entering data. This article includes steps for creating a custom UserForm and a sample Visual Basic for Applications macro that places the data you enter on... KB#161514. Keywords: VBA, Macro, Object, UserForm, Toolbar

98.
 Excel User's Home ExcelUser Blog Site Map Contact Excel for Business Excel Dashboards Excel Solutions Exploring Excel BI for Excel Business Tools Excel Catalog Affiliate Program Excel Help Portal

ExcelUser, Inc.
http://www.ExcelUser.com