Home > Excel Help Portal > Financial Analysis With Excel

<<  (Page 1)  Previous              Next  (Page 3)  >>

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.

51. Unexpected Behavior with Numbers Formatted as Text When you attempt to change the number format of a cell, the number format may not change as you... KB#181226. Keywords: Format, VBA, Macro, Web

 
52. How to Determine If a File Is ReadOnly This article describes how to determine if a file has an attribute of read- only, and how to determine if a file is opened as read-only using Microsoft Visual Basic for Applications... KB#153058. Keywords: VBA, Macro, Web

 
53. How to Use the FREQUENCY Function The FREQUENCY function returns a frequency distribution as a vertical array. For a given set of values and a given set of bins (or intervals), a frequency distribution counts the number of values that occur in each interval. The FREQUENCY... KB#100122. Keywords: Arrays, Formulas, FREQUENCY

 
54. Branching to Other Sections of Code with GoTo and Call In Microsoft Excel versions 5.0 and later, you can use the GoTo and Call statements to branch to other sections of a Microsoft Visual Basic for Applications procedure. NOTE : In earlier versions of Excel, you can do this with the GOTO() and... KB#213486. Keywords: VBA, Web

 
55. Limits of PivotTables in Microsoft Excel 2000 This article discusses some of the limitations of PivotTables in Microsoft... KB#211517. Keywords: Errors, PivotTables

 
56. How to use Speech Recognition to Select Cells, Rows, and Columns in Excel This step-by-step article explains how to use speech recognition in conjunction with the keyboard to select a range of cells, rows, and columns. This article shows you how to: Enable Speech Recognition To perform the tasks listed later in... KB#288981. Keywords: Speech, Printing

 
57. 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#126313. Keywords: Arrays, VBA, Object, Menu Command, Web, Window

 
58. How to Use a Toolbar Settings File from a Network Share This article contains information about using a Microsoft Excel toolbar settings file that is stored on a shared location on a... KB#161235. Keywords: Registry, Toolbar

 
59. How to Change the Company Name and User Name After Setup In earlier versions of Office, if you want to change the company name displayed in the Office splash screens and About program name on the Help menu (where program name is the program you are using), you uninstall Office, run Setup again, and enter... KB#233499. Keywords: Setup, Registry

 
60. Unexpected Behavior or Error Messages When You Start or Work with an Excel File or Object You may experience one or more of the following unexpected behaviors when you try to start or work with a file or object in Excel: You receive an error message similar to one of the following when you try to start Excel: File format is not valid... KB#327764. Keywords: DLL, Format, Errors, Object, Error Message, Files, Registry

 
61. How to Avoid "Save Changes?" When You Close a Workbook In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro that suppresses the Save Changes? prompt when you close a workbook. You can do this either by specifying the state of the workbook's Saved property or by... KB#129153. Keywords: VBA, Macro, Web

 
62. How to Display a Custom Function in Step 2 of the Function Wizard In Microsoft Excel 2000, you can create a custom Microsoft Visual Basic for Applications function to perform calculations. By default, this custom function appears in the Function Wizard under the function category called User Defined. You can... KB#213183. Keywords: Formulas, VBA, Macro, Web

 
63. Macro to Check for Page Breaks on a Worksheet In Microsoft Excel 2000, you can check for an automatic or manual page break in the current cell by using the PageBreak property in a Microsoft Visual Basic for Applications... KB#213831. Keywords: VBA, Macro, Web

 
64. Macro Code to Check Whether a File Is Already Open When you use a file that is shared over a network, you may frequently find it useful to know if another user has the file open. The following Microsoft Visual Basic for Applications procedure is an example of a method for determining whether... KB#213383. Keywords: Errors, VBA, Macro, Web

 
65. Defined Names Are Case Sensitive When you run a Visual Basic for Applications macro in Microsoft Excel, and your macro code reads the Name property of an item in the Names collection, the result may be slightly different than the result you receive in versions of Excel earlier... KB#213533. Keywords: Arrays, Defined Name, VBA, Macro, Web

 
66. Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High When you try to open a workbook, you receive the following error message: This workbook cannot be opened under High Security Level because it contains a type of macro (Microsoft Excel 4.0 macro) that cannot be disabled or signed. To open... KB#820739. Keywords: Errors, Macro, VBA, Registry

 
67. Visual Basic Example Using If and Case Statements Then...Else statement or a Select Case statement. The If...Then...Else statement executes a group of statements based on... KB#141691. Keywords: VBA, Macro, Web

 
68. Controlling How and When the Office Assistant Appears When you run any of the programs included with Microsoft Office 2000 and you use a lower screen resolution (640 x 480 for example), or if you have many windows open, or if your screen is very cluttered, you may find that the Office Assistant is... KB#199766. Keywords: Sounds, Startup

 
69. How to Programmatically Subtract or Sum Two Ranges of Data In Microsoft Excel 2000, you can use a Microsoft Visual Basic for Applications macro to programmatically subtract or sum two ranges of data. You can do this in the same workbook, or from more than one workbook, using defined... KB#213337. Keywords: VBA, Macro, Object, Web

 
70. How to Minimize Metadata in Microsoft Office Documents Whenever you create, open, or save a document in any of the programs listed at the beginning of this article, the document may contain information that you may not want to share with others if you distribute the document electronically.... KB#223396. Keywords: OLE, Printing, Files

 
71. How to correct rounding errors in floatingpoint arithmetic Many combinations of arithmetic operations on floating-point numbers in Microsoft Excel and Microsoft Works may produce results that appear to be incorrect by very small amounts. For example, the equation 1*(.5-.4-.1) may be evaluated to the... KB#214118. Keywords: Format, Errors, Formulas, ROUND

 
72. How to Automate Smart Tags by Using Visual Basic for Applications In Microsoft Excel, you can use smart tags to quickly take actions on data entered in a workbook. This article contains sample Microsoft Visual Basic for Applications (VBA) code that demonstrates how to automate smart... KB#293808. Keywords: VBA, Smart Tag, Web

 
73. How to set a Print Area by Using a Defined Name in Excel 2000 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 insert rows in that range. However, you can create a print macro that automatically adjusts when you insert rows. To... KB#213648. Keywords: Defined Name, Printing, VBA, Macro, Setup, Web, Window

 
74. How to Programmatically Increment a Date With a Spinner In Microsoft Excel, you can use a spinner control to change values on a worksheet or in a Microsoft Visual Basic for Applications procedure. To use the spinner to increment and decrement a value over a wide range, you must set and use the spinner... KB#213464. Keywords: VBA, Macro, Web

 
75. How to Determine If a File Is ReadOnly This article describes how to programmatically determine whether a Microsoft Excel file has an attribute of read-only, and how to determine whether a file is opened as... KB#213266. Keywords: VBA, Macro, File Name, Web

 
76. Graphics in Header or Footer Extend into Data Area of Worksheet Graphics placed in the header or footer intrude into the data area of the... KB#288966. Keywords: Ratio, Format, Page Setup, Printing

 
77. How to clear the Most Recently Used Files List in an Office 2003 Program by Modifying the Windows Registry You can edit a single registry entry to clear the most recently used files list that appears in most Microsoft Office 2003 programs. Many Office 2003 programs maintain a list of the most recently used (MRU) files and display that list on the File... KB#826208. Keywords: File Name, Files, Registry, Hyperlinks

 
78. How to Hide Sheets and Use xlVeryHidden Constant in a Macro In Microsoft Excel, you can hide sheets in a workbook so that a user cannot see them. You can hide any sheet type in a workbook, but you must always leave at least one sheet... KB#142530. Keywords: Format, VBA, Macro, Object, Templates, Web

 
79. Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High When you attempt to open your file, you receive the following error message: This workbook contains a type of macro (Microsoft Excel version 4.0 macro) that cannot be disabled or signed. Therefore, this workbook cannot be opened under High... KB#291206. Keywords: Errors, Macro, VBA, Registry

 
80. Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High When you attempt to open your file, you receive the following error message: This workbook contains a type of macro (Microsoft Excel version 4.0 macro) that cannot be disabled or signed. Therefore, this workbook cannot be opened under High... KB#230889. Keywords: Errors, Macro, VBA, Registry

 
81. How to Perform a CaseSensitive Lookup You can use LOOKUP functions in Microsoft Excel 97 and later to compare values to find an exact match, but the match is not case-sensitive. However, you can combine the LOOKUP functions with other built-in functions to perform a case-sensitive... KB#214264. Keywords: Formulas, LOOKUP, EXACT, HLOOKUP, VLOOKUP

 
82. How to Compare Data in Two Columns for Duplicates This article describes two methods for comparing two columns of data to find duplicate entries between the two... KB#139882. Keywords: Errors, Formulas, VBA, Macro, Web

 
83. How to Create PivotTable from Word This article includes a sample Microsoft Visual Basic for Applications macro. The macro uses Automation to build a PivotTable in Microsoft Excel 97 and returns the data back to Microsoft... KB#170745. Keywords: Sales, Format, Errors, PivotTables, VBA, Macro, Object, Web

 
84. How to Create PivotTable from Word This article includes a sample Microsoft Visual Basic for Applications macro. The macro uses Automation to build a PivotTable in Microsoft Excel and returns the data back to Microsoft... KB#213697. Keywords: Sales, Format, Errors, PivotTables, VBA, Macro, Object, Web

 
85. Using a Worksheet Function in a Visual Basic Macro You can call a built-in Microsoft Excel worksheet function directly from a Microsoft Visual Basic for Applications macro. This article describes how to use a built-in worksheet function in a... KB#161120. Keywords: Errors, Macro, Object, VBA, Web, ACOS

 
86. How to Set the Default Command Button on a UserForm On a UserForm, you can designate only one command button object as the default command button. Because only one command button can be the default, if you set the default property for any command button to True , the default properties for all... KB#213743. Keywords: Combo Box, Command Button, VBA, Object, UserForm, Web

 
87. How to use an Excel Data Source for Mail Merge in Word 2000 This article explains three ways to attach a Microsoft Excel data source to a Microsoft Word mail-merge main document. After you perform step 1 in the Mail Merge Helper, use one of the following methods in step 2 in the Mail Merge Helper to attach... KB#212314. Keywords: DDE, Files

 
88. How to Sum Ranges Using Visual Basic for Applications In Microsoft Excel, you can use a Microsoft Visual Basic for Applications macro to sum or subtract two ranges of data and to then place the result into a third range without using formulas in the cells. You can do this in the same workbook or... KB#148317. Keywords: Formulas, VBA, Macro, Object, Web

 
89. Sample Macros that Customize and Control Shortcut Menus This article features sample Microsoft Visual Basic for Applications macros that customize and control shortcut menus using the Commandbar object. IMPORTANT : Some of the examples in this article use the ID number for a particular control. To... KB#213209. Keywords: Formulas, PivotTables, VBA, Macro, Object, Web

 
90. How to clear the Most Recently Used Files List in an Office XP Program by Modifying the Windows Registry You can edit a single registry entry to clear the most recently used files list that appears in most Office XP programs. Many Office XP programs maintain a list of the most recently used (MRU) files and display that list on the File menu of... KB#312968. Keywords: File Name, Files, Registry, Hyperlinks

 
91. How to Display a UserForm Whose Name Is in a Variable In Microsoft Excel 97, it is possible for a Visual Basic for Applications macro to display a UserForm whose name is stored in a variable. This article explains how this may be... KB#157609. Keywords: Errors, VBA, Macro, Object, UserForm, Error Message, Web

 
92. How to Compute the Periodic Annual Interest Rate in Microsoft Excel The RATE() function in Microsoft Excel returns the periodic interest rate necessary for an investment to grow to a specific value over a specified number of compounding periods. However, the RATE() function assumes a known periodic payment amount.... KB#110854. Keywords: Years, Formulas, VBA, Web, RATE, FV, PV, N

 
93. Cannot Start Excel and Open a Workbook by DoubleClicking the .xls File When you double-click an Excel workbook (.xls) file to open it, you may receive the following error message: Cannot find the file path (or one of its components). Make sure the path and file name are correct and that all required libraries... KB#323216. Keywords: Errors, Error Message, File Name, Registry

 
94. How to Display a UserForm Whose Name Is in a Variable In Microsoft Excel 2000, it is possible for a Visual Basic for Applications macro to display a UserForm whose name is stored in a variable. This article explains how to do... KB#213574. Keywords: Errors, VBA, Macro, Object, UserForm, Error Message, Web

 
95. 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

 
96. Sample Macro Code to Change Case of Text This article contains three sample Microsoft Visual Basic for Applications macros (Sub procedures) that you can use to change the letters in a text string to all uppercase, all lowercase, or title case (the first letter in each word is... KB#141094. Keywords: VBA, Macro, Web

 
97. How to Drag Data from Microsoft Excel to a Microsoft Access Database This article shows you how to use the drag-and-drop method to copy data from a Microsoft Excel worksheet to a table in a Microsoft Access... KB#208640. Keywords: Microsoft Access

 
98. How to Solve for New XValues Using INDEX and LINEST This article contains information about how to determine values for a set of unknown x-values when you are given a set of known x-values and known... KB#147266. Keywords: Format, Arrays, Formulas, INDEX, LINEST

 
99. How to Compare Data in Two Columns for Duplicates This article describes two methods you can use to compare data in two Microsoft Excel worksheet columns and find duplicate... KB#213367. Keywords: Errors, Formulas, VBA, Macro, Web

 
100. How to insert a Picture into the Header or Footer in Microsoft Excel 2002 This article explains how to insert a picture into the header or footer of a Microsoft Excel 2002 worksheet.Insert Picture into Header New functionality in Excel 2002 provides the ability to add pictures to the header or footer areas of a... KB#288964. Keywords: Ratio, Format, Page Setup, Printing

 

<< (Page 1)  Previous              Next  (Page 3) >>