Home > Excel Help Portal > Financial Analysis With Excel

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

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.

101. How to remove Password Protection from Worksheets, Workbooks, and Shared Workbooks in Excel 2000 This article describes how to remove protection from Excel worksheets and workbooks and how to return a protected, shared workbook to unrestricted use. If you are not sure whether you need to remove protection from a workbook or a worksheet to... KB#263564. Keywords: Password

 
102. How to Use the Imp Operator for Binary Comparison The Microsoft Visual Basic for Applications Imp operator is used to perform a logical implication on two expressions. If you are using the Imp operator with two numeric expressions as arguments, Microsoft Excel performs a bit-wise comparison... KB#213706. Keywords: VBA, Macro, Web

 
103. How to use the Microsoft Office Application Recovery Tool in Office Programs This step-by-step article describes how to use the Microsoft Office Application Recovery tool. This tool provides you with a way to potentially recover data from an Office program that stops responding (hangs). If an Office program stops... KB#294933. Keywords: Errors, Application Recovery

 
104. Limits of PivotTables in Microsoft Excel 2002 This article discusses some of the limitations of PivotTables in Microsoft... KB#291061. Keywords: Errors, PivotTables, Error Message

 
105. How to Use Microsoft Excel Data Source for Word Mail Merge This article describes three methods to attach a Microsoft Excel data source to a Word mail merge main... KB#155179. Keywords: DDE, Files

 
106. How to use the GetPivotData Worksheet Function in Excel 2000 This step-by-step article shows you how to use the GETPIVOTDATA function to retrieve data from a PivotTable. Microsoft Excel 2000 has a new worksheet function, GETPIVOTDATA, that allows you to work with PivotTable data outside of a... KB#211949. Keywords: Sales, PivotChart, PivotTables, GETPIVOTDATA, ROW, COLUMN

 
107. How to Calculate Compound Interest Compound interest is the amount that a dollar invested now will be worth in a given number of periods at a given compounded interest rate per period. Although Microsoft Excel does not include a function for determining compound interest, you can... KB#141695. Keywords: Formulas, VBA, Macro, Web, PV, N, T

 
108. How to Create and Use TwoInput Data Tables in Microsoft Excel This article describes how to create and use two-input tables, which allow you to test how changes in two variables affect one... KB#282856. Keywords: Format, Formulas

 
109. How to Programmatically Turn Off the Clipboard Warning Message When you close a Microsoft Excel workbook, there is no setting to prevent you from receiving a warning message that prompts you to save or delete information from the Clipboard. This article explains why this warning message occurs and how to... KB#287392. Keywords: Borders, Clipboard, Macro, Object, VBA, Web

 
110. How to Suppress "Save Changes?" Prompt 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#213428. Keywords: VBA, Macro, Web

 
111. How to view the Error Signature from Office Application Error Reporting If Program Quits Unexpectedly If a Microsoft Office XP program experiences a serious error and quits, your computer records an error signature that describes the error that occurred. This article explains how to view these error signatures. The error signature... KB#289508. Keywords: Errors

 
112. Euro Currency Character Is Not Displayed Correctly The euro currency character is not displayed as expected on your worksheet. It appears as a vertical bar or a pipe character instead of the euro... KB#217124. Keywords: Ratio, Fonts, Format, Links, Registry, Web

 
113. How to Remove Leading Space for Values Converted to Strings The Microsoft Visual Basic for Applications Str() function returns the string representation of a numeric value represented as (n). Positive numbers and zeros are converted to a string with a leading space character. This article discusses... KB#290359. Keywords: Sales, Macro, VBA, Web

 
114. ShowDataForm Method Fails If Data Can't Be Found In Microsoft Excel, when you use the Visual Basic ShowDataForm method, you may receive the following error message: Run-time error '1004': ShowDataForm method of Worksheet class... KB#110462. Keywords: Errors, Defined Name, Class, VBA, Web

 
115. How to Display Data as Percentage of Total in Pivot Table In Microsoft Excel, you can display data in a PivotTable as a percentage of the data's total using the % Of Row and % Of Column calculation... KB#106359. Keywords: Sales, PivotTables

 
116. How to Insert Scanned Images in Microsoft Office 2003 Programs In the programs that are listed in the Applies to section of this article, you can use a scanner to insert images in a document. This article describes two methods that you can use to insert images in a document, and when to use each method. back... KB#827100. Keywords: Camera, Printing, Web

 
117. How to display Data as Percentage of the Total in a PivotTable in Excel 2000 This step-by-step article shows you how to display data as percentage of the total in a PivotTable in Microsoft Excel 2000. In Excel 2000, you can use the using the % of row and % of column calculation types to display data in a PivotTable as... KB#214057. Keywords: Sales, PivotChart, PivotTables

 
118. How to Use the DataEntryMode Property This article contains information about using the DataEntryMode property in Microsoft Excel and includes a sample Microsoft Visual Basic for Applications... KB#162715. Keywords: VBA, Macro, Web

 
119. How to Display the Open and Save As Dialog Boxes This article describes how to programmatically display the Open or the Save As dialog boxes in Microsoft Excel. Note that the Open and Close methods do not display these dialog... KB#213371. Keywords: VBA, Macro, File Name, Web

 
120. Macro to Restore Tab Split Box to Default Position In Microsoft Excel, it is possible to adjust the space allocated for displaying sheet tabs and the horizontal scroll bar by moving the tab split box. The tab split box is located between the sheet tabs and the horizontal scroll bar. This... KB#106009. Keywords: VBA, Macro, Web, Window

 
121. Error Message: ORA00923:FROM Keyword Not Found Where Expected In Microsoft Query, when you use an alias in a query to an Oracle database, and you employ an aggregate, the query does not succeed, and you receive the following error message: ORA-00923:FROM keyword not found where... KB#259347. Keywords: Query, Errors, Registry

 
122. How to create a Column Chart with Two YAxes in Excel 2000 This step-by-step article shows you how to create a chart with two y-axes, so that both axes can be clearly seen. In general, a combination or overlay chart must have a second y-axis. However, Microsoft Excel 2000 places the column series that... KB#214011. Keywords: Charts, Plot, SERIES, Sales, Format, Toolbar

 
123. Macro That Changes Cell Dimensions on Multiple Sheets Doesn't Run As Expected If you record a macro that changes column widths, changes row heights, or hides and unhides rows or columns while multiple sheets are selected, the macro may not run as expected. In such a case, when you run the macro, only the active sheet in... KB#213823. Keywords: Format, Arrays, VBA, Macro, Web, Window

 
124. How to Programmatically Select Every Nth Row in a Range In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro to select every nth row in a currently selected contiguous range on a worksheet. This article describes a sample macro that performs this... KB#213438. Keywords: VBA, Macro, Web

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

 
126. How to Run a Macro When Certain Cells Change In Microsoft Excel, you can create a macro that is called only when a value is entered into a cell in a particular sheet or in any sheet that is currently open. Note, however, that you should not call macros unnecessarily because they slow down... KB#213612. Keywords: VBA, Macro, Web

 
127. How to Control the Appearance of the Mouse Pointer While a Macro Runs In Microsoft Excel 2000, you can use the Microsoft Visual Basic for Applications Cursor property to control the appearance of the mouse pointer while a macro is running. In versions of Excel earlier than 7.0, you do not have the ability to change... KB#213424. Keywords: VBA, Macro, Web

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

 
129. Cannot Select Named Range from Excel During Mail Merge When you perform a mail merge using a Microsoft Excel 97 worksheet as your data source using the Microsoft Excel Worksheet via Converter (*.xls; *.xlw) option, you will only be able to select the entire worksheet and not a named range from... KB#183417. Keywords: DDE, Format, Files

 
130. Cannot Select Named Range from Excel During Mail Merge When you perform a mail merge using a Microsoft Excel worksheet as your data source and using the Microsoft Excel Worksheet via Converter (*.xls; *.xlw) option, you can select only the entire worksheet and not a named range from... KB#211283. Keywords: DDE, Format, Files

 
131. How to Create Unique Random Integers Between Two Numbers In Microsoft Excel, you can create a Microsoft Visual Basic Sub procedure (macro) to create a list of unique (non-repeating) random integers between two other numbers. This articles describes a sample macro that prompts the user for a starting... KB#213290. Keywords: VBA, Macro, Web

 
132. How to determine Office Document and Managed Code Extension Paths at Run Time This article describes how to programmatically determine the path of a Microsoft Office Word document or a Microsoft Office Excel workbook, and the path of the associated Microsoft .NET Framework assembly (managed code... KB#824000. Keywords: VBA

 
133. How to insert a Picture into the Header or the Footer in Excel 2003 This article describes how to insert a picture into the header or the footer of an Excel 2003 worksheet. back to the top How to Insert a Picture in the Header or the Footer In Excel 2003, a new permits you to insert pictures into the header or... KB#826918. Keywords: Graphic, Ratio, Format

 
134. How to Use the GetPivotData Worksheet Function Microsoft Excel 97 has a new worksheet function, GetPivotData, that allows you to work with PivotTable data outside of a PivotTable. This article contains an example that uses the GetPivotTable function to retrieve data from a... KB#161538. Keywords: Sales, PivotTables, GETPIVOTDATA, ROW, COLUMN

 
135. Macro to Loop Through All Worksheets in a Workbook This article contains a Microsoft Visual Basic for Applications macro ( Sub procedure) that loops through all the worksheets in the active workbook. This macro also displays the name of each... KB#213621. Keywords: VBA, Macro, Object, Web

 
136. Changed Macro Behavior with Excel Files When you click a control on a worksheet that is assigned to a macro, you receive the following message: The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to... KB#262876. Keywords: Macro, Templates, Toolbar

 
137. How to use the INDEX and LINEST Functions to Solve for New XValues in Excel 2000 This step-by-step article explains how to determine values for a set of unknown x-values when you are given a set of known x-values and known y-values. Solve the Linear Equation To determine new x-values for a given set of data, you must solve... KB#214251. Keywords: Format, Arrays, Formulas, INDEX, LINEST

 
138. How to Determine the Key Pressed Along with Mouse Button Visual Basic for Applications in Microsoft Excel 97 incorporates many more events for activating macros. Some of the new events include MouseDown, MouseUp, KeyDown, and KeyUp. One of the Arguments returned by these particular events, Shift,... KB#161903. Keywords: VBA, Macro, UserForm, Web

 
139. How to Lock Individual Cells in a Worksheet This article describes how to lock individual cells in a Microsoft Excel worksheet. The procedure to use depends on whether you want the majority of the cells on the worksheet to remain locked or unlocked. NOTE : If you lock a cell and protect... KB#214081. Keywords: Format, Password

 
140. Cannot Follow Hyperlink to Office Document When you click a hyperlink in a Microsoft Word document or a Microsoft Excel worksheet, either the hyperlink does not go to the correct destination, or nothing... KB#280680. Keywords: DDE, Errors, Registry, Hyperlinks

 
141. Creating Macros for Different Language Versions In Microsoft Excel 2000, you can determine the country code that corresponds to the version of Excel that you are running. These country codes can be helpful in creating custom... KB#213833. Keywords: VBA, Macro, Web

 
142. How to Create Yes and No Buttons for a Custom Message Box By default, the MsgBox function in a Microsoft Visual Basic for Applications procedure contains a single OK button. However, you can display other buttons in the message box. This article provides a sample Visual Basic macro that displays a... KB#142142. Keywords: VBA, Macro, Web

 
143. BUG: Excel Does Not Shut Down After Calling the Quit Method When Automating from JScript When automating Microsoft Excel from Microsoft JScript, Excel stays in memory after calling the Quit method until you close Internet Explorer or navigate to another... KB#266088. Keywords: Internet Explorer, Web

 
144. How to Modify the Number of Undo Levels By default Microsoft Excel keeps track of 16 undo levels, which provide an undo history for most actions you perform in Microsoft Excel. You can change the number of undo levels by adding an entry in the Microsoft Windows registry.... KB#211922. Keywords: Macro, VBA, Registry

 
145. How to use the "Send To" Menu Command to Send Worksheets and Workbooks as EMail in Excel The Send To menu command has been improved in Microsoft Excel 2002. This article discusses how to use this command to send worksheet selections as e-mail.Improvements and Requirements With Excel 2002, you can now send a selection from a worksheet,... KB#289272. Keywords: Charts, Format, PivotTables, Menu Command, HTML

 
146. How to Change the Alternate Startup Folder (Directory) The following example explains how to change the alternate startup folder (directory) without having to start Microsoft... KB#153543. Keywords: Startup, Files, Registry

 
147. How to Use an Excel RTD Server with DCOM Excel 2002 provides a new worksheet function, RTD, that allows you to call a Component Object Model (COM) Automation server for the purpose of retrieving data in real time. This RealTimeData (RTD) server can exist as an ActiveX dynamic-link... KB#285888. Keywords: ActiveX, Formulas, Object, Registry, RTD

 
148. How to save addresses that are contained in a Word mail merged label document in Excel This article describes how to save addresses that are contained in a Microsoft Word mail merged label document to a Microsoft Excel... KB#832286. Keywords: Gridlines, File Name, Files

 
149. How to Create and Use an Auto_Close Procedure An Auto_Close procedure is an automatic procedure stored in a workbook that runs automatically when the workbook is closed. You can place automatic procedures in any Microsoft Visual Basic for Applications module in the workbook. A... KB#141563. Keywords: VBA, Macro, Web

 
150. How to Programmatically Copy All Range Names In Microsoft Excel, you can create a Microsoft Visual Basic for Applications Sub procedure (macro) that you can use to copy all the range names from the active workbook to another... KB#213389. Keywords: Defined Name, VBA, Macro, File Name, Web

 

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