Home > Excel Help Portal > Financial Analysis With Excel

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

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.

151. Office 2003 program is slow or may appear to stop responding (hang) when you open a file from a network location When you try to open a file from a network location in one of the Microsoft Office 2003 programs listed in the Applies To section of this article, the Office program may run very slowly or may appear to stop responding... KB#833041. Keywords: File Name, Registry

 
152. Macro to Delete Every Other Row This article contains a sample Microsoft Visual Basic for Applications macro that you can use to delete every other row in a selected range on a Microsoft Excel... KB#213610. Keywords: VBA, Macro, Web

 
153. How to sort More Than Three Columns in Excel 2000 Microsoft Excel limits you to a maximum of three columns or fields when you sort a list. If you want to sort a list of more than three fields, you must sort multiple times, with three or fewer fields at a time. Also, you must sort the fields in... KB#268007. Keywords: Sorting

 
154. How to Show Quotation Marks in Function Results and Macros When you type directly in a cell, you can type quotation marks and they appear in the cell both on the screen and when you print them. However, if you use the CONCATENATE() function or the concatenation operator (&), the quotation marks must... KB#141578. Keywords: Formulas, Printing, Macro, VBA, Web, CONCATENATE

 
155. Error Message When Opening a File by DoubleClicking the File Name When you double-click a Microsoft Excel file type (.xls), Excel starts as expected, but then you may receive an error message similar to the following: C:\ filename .xls' could not be found. Check the spelling of the file name, and verify that... KB#207574. Keywords: Errors, Error Message, Files, Registry

 
156. Error Message: Excel Caused an IPF in Module Excel.exe When you try to start Microsoft Excel 2000, you may receive an error message similar to the following: Excel caused an IPF in module excel.exe. Excel does not start. If you try to start Excel in safe mode by using the /s startup switch, Excel... KB#327761. Keywords: Errors, Startup, Corrupted, Error Message, File Name, Registry

 
157. How to Publish a Web Document to an FTP Site This article describes how to publish a Microsoft Office document to a Web server by using the File Transfer Protocol... KB#290298. Keywords: Format, Password, File Name, Files, Web

 
158. How to Programmatically Delete and Restore a Menu That Contains a Submenu This article describes how to programamtically delete and restore a menu that contains a submenu. If you use a Microsoft Visual Basic for Applications macro to delete a menu item that contains a submenu, and then you want to restore the menu item,... KB#213437. Keywords: VBA, Macro, Menu Command, Web

 
159. Automation Example with Microsoft Word and Microsoft Outlook It is possible to create a Visual Basic for Applications macro that uses data from a Microsoft Word document and a Microsoft Excel workbook to send messages from Microsoft Outlook. This article contains an example of one way that you can do... KB#213712. Keywords: VBA, Macro, Object, Web

 
160. Large Increase in Document File Size After Inserting JPEG In the programs listed at the beginning of this article, if you click the Insert menu, point to Picture, click From File, select a picture file, and click Insert, the following problems may... KB#186369. Keywords: Third-Party, Format, Files

 
161. 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 type of sheet in a workbook, but you must always leave at least one sheet... KB#213609. Keywords: Format, VBA, Macro, Object, Web

 
162. How to Delete a Collection of Code Objects from a VBAProject This article contains a sample Microsoft Visual Basic for Applications macro to loop through all the objects in a VBProject , and remove the objects contained in a specific collection. For example, you can remove all standard module sheets in... KB#260993. Keywords: Class, VBA, Macro, Object, VBE, Web

 
163. How to Make Spinner Whose Minimum Value Is Less Than Zero In the products listed at the beginning of this article, the spinner control that is on the Forms toolbar has a minimum value of zero. This article includes a Microsoft Excel Visual Basic for Applications macro example that demonstrates how you... KB#151324. Keywords: Format, VBA, Macro, Object, Toolbar, Web

 
164. How to Remove UserDefined Functions from Function Wizard When you create a custom function in Microsoft Excel using Visual Basic for Applications, it will be displayed in the Function Wizard under the User Defined Function category. You can prevent the custom function from being displayed in the... KB#142123. Keywords: VBA, Macro, User Defined Function, Web

 
165. How to Export a Money Report to an Excel Worksheet This article describes how to export a Microsoft Money report to a Microsoft Excel... KB#302382. Keywords: Export, Import Data, File Name, Text Files

 
166. Sample Macro to Add or Place Object in Relation to a Range When you add objects to a worksheet using a Microsoft Visual Basic for Applications procedure, you need to specify the coordinates of the new object, in points, relative to the upper-left corner of cell A1 on a worksheet as well as the height... KB#213607. Keywords: Outline, VBA, Macro, Object, Web

 
167. Types of Formatting and Features Preserved in Workbook Sent as Body of HTML Email Message Microsoft Excel has the ability to send a worksheet as the body of an HTML e-mail message. This article identifies the formatting and features that are and are not preserved when a message recipient opens a worksheet in... KB#291217. Keywords: Criteria, Format, Formulas, HTML

 
168. How to turn Off the Message for pdating Links in a Workbook in Excel This step-by-step article describes how to control the startup message about updating linked workbooks in Microsoft Excel. When you open a workbook that contains links to cells in other workbooks, you may receive the following message: This... KB#288851. Keywords: Links, Startup

 
169. How to Make Sure That Your Office Document Has a Valid Digital Signature This article describes how to: Make sure that a digitally signed Microsoft Office document has a valid digital signature. Make sure that a document was not tampered with after the document was originally digitally... KB#329228. Keywords: VBA, Web, IS

 
170. How to convert Excel column numbers into alphabetical characters This article discusses how to convert integers into alphabetical... KB#833402. Keywords: VBA, Web

 
171. How to Change an Existing Linked Excel Object After you use the Paste command in a Microsoft Word document to insert a link to a Microsoft Excel worksheet, there is no direct way to change the number of rows or columns being linked from... KB#211258. Keywords: Links

 
172. Embedded Excel Worksheets Shrink When You Edit Them In Microsoft PowerPoint, when you edit an embedded Microsoft Excel worksheet, the worksheet object resizes... KB#300523. Keywords: Object, Registry

 
173. Macro to Restore Tab Split Box to Default Position In Microsoft Excel 2000, 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#213505. Keywords: VBA, Macro, Web, Window

 
174. How to Create a Pie Of Pie Chart or a Bar Of Pie Chart This article describes how to create a Pie Of Pie chart or Bar Of Pie chart in Microsoft Excel... KB#192063. Keywords: Charts, Plot, SERIES, Format

 
175. Using Formulas Tutorial functions With SUMIF, you don't need ot set up a criteria range. If your sum criteria is simple, you can include it in the SUMIF statement. Comparative Ratio Analysis You can use Excel formulas to compare actual data to Robert Morris Associates annual statement studies. RMA comparative ratios are... Keywords: Criteria, Ratio, Ratio Analysis, RMA, Colors, Arrays, Formulas, VBA, Links, OFFSET, DAVERAGE, DCOUNT, COUNTIF

 
176. How to Determine If a Variable Is an Array You can use the IsArray function to test a variable that has been set in a Microsoft Visual Basic for Applications procedure to determine whether it is an... KB#151561. Keywords: Arrays, VBA, Macro, Web

 
177. How to Save Personal Macro Workbook When Excel Is Open When you make changes to your Personal Macro Workbook and then hide it again, you normally have to quit Microsoft Excel to save the changes you made. The sample Microsoft Visual Basic for Applications macro in the More Information section of... KB#141576. Keywords: Startup, VBA, Macro, Web

 
178. How to copy an Office File to a Disk This step-by step article describes how to copy a file from the My Documents folder on your computer hard disk to a 3.5-inch disk, and how to copy a file from a 3.5-inch disk to the My Documents... KB#812072. Keywords: Files

 
179. How to hide Records with Duplicate Cell Entries in Excel 2000 This step-by-step article shows you how to use the Advanced Filter feature to hide records with duplicate cell entries in Microsoft Excel 2000. In Excel 2000, you can hide rows that contain multiple records for an individual or company.... KB#214247. Keywords: Advanced Filter, Criteria

 
180. Sample Macro That Won't Allow User to Cancel Dialog Box In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro to display built-in dialog boxes, such as the Open or the Save As dialog box. After this type of dialog box is displayed, a user can cancel it by clicking Cancel... KB#213617. Keywords: VBA, Macro, Web

 
181. How to Force ReEntry of the Product Identification Code To troubleshoot activation or licensing issues, you may have to force the re-entry of your Office XP product identification code. This article describes how to force your computer to prompt you for your Office XP product identification code. NOTE... KB#325081. Keywords: Registry

 
182. How to Create an Index with Microsoft Query This article describes how to create indexes with Microsoft... KB#143348. Keywords: Query, Errors

 
183. How to Import Contacts from Excel 2000 If you have a list of contacts contained in a Microsoft Excel 2000 spreadsheet, it will not be readily accessible to Outlook 2000 or other programs that may access the Address Book. To overcome this obstacle, you can export and then import the... KB#295664. Keywords: Export, File Name

 
184. How to change the Assembly Name or the Assembly Namespace for Your Office Managed Code Extension This step-by-step article describes how to change the name of an assembly or how to change the namespace of an assembly for a managed code extension that you create with Microsoft Visual Studio Tools for the Microsoft Office System. To change the... KB#824003. Keywords: Errors, Error Message

 
185. How to Show Quotation Marks in Function Results and Macros When you type directly in a cell, you can type quotation marks and they appear in the cell both on the screen and when you print them. However, if you use the CONCATENATE() function or the concatenation operator (&), the quotation marks must... KB#213633. Keywords: Formulas, Printing, Macro, VBA, Web, CONCATENATE

 
186. Error Message When You Open an Excel 2000 File in the Exchange Public Folder When you open a Microsoft Excel 2000 file in an Exchange 2000 public folder and close the file without making a change, you may receive the following error message: Unable to save changes to the document. Your changes will be placed in the... KB#831229. Keywords: Errors, Error Message, Registry

 
187. How to Add a New Category to Function Category List To manually create a custom category for a user-defined function that you write in Microsoft Visual Basic for Applications, you must insert a Microsoft Excel 4.0 macro sheet before you create the... KB#137526. Keywords: Macro, Object, VBA

 
188. How to Sum and Format a Range of Hours, Minutes, or Seconds To automatically format times that when added together exceed 24 hours, 60 minutes, or 60 seconds, you can use the following custom number formats and the SUM function in Excel: Hours [h]:mm:ss Minutes [m]:ss Seconds ... KB#266691. Keywords: Custom Number Formats, Formulas

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

 
190. How to Hide Records with Duplicate Cell Entries This step-by-step article show you how to use the Advanced Filter feature to hide records with duplicate cell entries in Microsoft Excel. In Microsoft Excel, you can hide rows that contain multiple records for an individual or company.... KB#147640. Keywords: Advanced Filter, Criteria

 
191. Word Stops Responding When You Use "Open Clip In" to Open a WMF File When you right-click a Windows Metafile (WMF) in the Insert Clip Art task pane, and then click Open Clip In, Microsoft Word stops responding for a long time, and then the Word File Conversion dialog box... KB#285629. Keywords: Errors, Files, Web

 
192. How to Continue a Visual Basic Statement from One Line to the Next To make Microsoft Visual Basic for Applications procedures easier to read, you may want to continue a line of code from one line to the next. To write code in this way, use the line-continuation... KB#141513. Keywords: VBA, Web

 
193. Error Message When You Open an Excel 2002 File in the Exchange Public Folder When you open a Microsoft Excel 2002 file in a Microsoft Exchange 2000 public folder and close the file without making a change, you may receive the following error message: Unable to save changes to the document. Your changes will be placed in... KB#831111. Keywords: Errors, Error Message, Registry

 
194. "Insert Picture" Dialog Box Defaults to Thumbnails View When you try to insert a picture by using any of the programs listed at the beginning of this article, the Insert Picture dialog box always defaults to Thumbnails... KB#301459. Keywords: VBA, Macro, Web, T

 
195. How to Import Web Page Tables into Microsoft Excel You can import tables from Web pages into Microsoft Excel 97. This article discusses two methods you can use to accomplish this... KB#165499. Keywords: Clipboard, File Name, HTML, Internet Explorer, Web

 
196. How to Determine If a Variable Is an Array In Microsoft Excel, you can use the IsArray function to test a variable that has been set in a Microsoft Visual Basic for Applications procedure to determine whether it is an... KB#213282. Keywords: Arrays, VBA, Web

 
197. How to Programmatically Convert Column Position Numbers to Column Letters In Microsoft Excel you can create a Microsoft Visual Basic for Applications Sub procedure (macro) that uses the Column property to return the column position, and then converts the column position number to the column... KB#213264. Keywords: VBA, Macro, Web

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

 
199. How to Send a Range of Cells in EMail by Using VBA In Microsoft Excel, you can send a section of a workbook as an e-mail message. This article contains sample Microsoft Visual Basic for Applications (VBA) code that demonstrates how to automate sending a range of cells in an e-mail... KB#816644. Keywords: VBA, Web

 
200. Visual Basic Macro to Determine if Selected Cell Is in a Specified Defined Range You can use Microsoft Visual Basic for Applications to determine if the cell that you just selected is in a specified... KB#259137. Keywords: VBA, Macro, Web

 

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