Home > Excel Help Portal > Financial Analysis With Excel

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

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.

201. Sample Macro to Insert/Delete Rows or Columns on Multiple Sheets This article contains a sample Microsoft Visual Basic for Applications macro ( Sub procedure) that you can use to insert or delete rows or columns in multiple worksheets in Microsoft... KB#291305. Keywords: VBA, Macro, Object, Web, Window

 
202. How to Determine the Number of Unique Items in a List The purpose of this article is to describe how to determine the number of unique items contained in a list in Microsoft Office Excel... KB#823573. Keywords: Arrays, Formulas

 
203. How to Use the Paste Options Button to Paste Data from Excel This article explains how to use the Paste Options button to paste data from... KB#284751. Keywords: Fonts, Format, Styles, Clipboard, Links

 
204. "Runtime Error 1004" When You Attempt to Use Text to Speech in Macro When you attempt to use the Text to Speech feature in a macro, you receive an error message similar to the following: Run-time error '1004': Application-defined or object-defined... KB#277808. Keywords: Errors, Speech, VBA, Macro, Object, Error Message, Web

 
205. How to Determine If a Workbook or a Worksheet Is Protected This article provides Visual Basic for Applications sample macros that determine whether a workbook or a worksheet is... KB#161245. Keywords: VBA, Web

 
206. A description of the way that Excel saves files Describes the process Excel uses when you save a... KB#814068. Keywords: Errors, Error Message, File Name, Files, Save A File

 
207. Macro to Import a Text File into an Existing Worksheet Microsoft Excel 2000 does not provide a direct means for importing a text file into an existing worksheet. Generally, this is done by opening the text file into its own workbook and then copying the data from the new workbook to the... KB#213816. Keywords: VBA, Macro, Object, Text Files, Web

 
208. How to Use a Custom Dialog Box as a Startup Screen In Microsoft Excel, it is possible to use a custom dialog box and a Visual Basic, Applications Edition, procedure together to create a startup (or splash)... KB#136222. Keywords: Startup, VBA, Macro

 
209. How to Count Blank Cells in a Specified Range In Microsoft Excel, you can use a Microsoft Visual Basic for Applications macro (Sub procedure) to count the blank cells in a specified range. NOTE: You can also use the COUNTBLANK worksheet function to return the number of blank cells in a... KB#139573. Keywords: VBA, Macro, Object, Web, COUNTBLANK

 
210. How to Put Folder Contents into a Worksheet This article describes how to a create a Microsoft Visual Basic for Applications macro that prints the contents of a folder (directory) to a range of cells in a... KB#213343. Keywords: Printing, VBA, Macro, Files, Web

 
211. How to Use Conditional Formatting to Shade Every Other Row It is often easier to read lists of data if alternate rows are shaded. This article shows you how to use conditional formatting to shade alternate... KB#268568. Keywords: Format, Patterns, Formulas, MOD

 
212. For Each Loop to Determine If an Excel Workbook Is Open Microsoft Excel does not include a Microsoft Visual Basic for Applications function to determine whether a workbook is already open. The following sample user-defined function loops through all of the opened workbooks in memory to determine whether... KB#213299. Keywords: VBA, Web

 
213. How to Determine If a Workbook or a Worksheet Is Protected This article provides Visual Basic for Applications sample macros that determine whether a workbook or a worksheet is... KB#213761. Keywords: VBA, Web

 
214. How to modify a Particular Time with the TIME and MOD Functions in Excel 2000 This step-by-step article shows you how to add and subtract any number of hours, minutes, or seconds from a specific time of day. In Microsoft Excel 2000, time values are represented with serial numbers that range from 0 (12:00:00 A.M.) to... KB#214095. Keywords: Dates, Formulas, TIME, MOD

 
215. "SYLK: File Format Is Not Valid" Error Message When You Open File When you try to open a text file or a comma-separated variable (CSV) file, you may receive the following error message: SYLK: File format is not... KB#323626. Keywords: Format, Errors, Error Message, Text Files

 
216. Files Corrupted on Save: How to Troubleshoot Source of Problem Files that you save to a floppy disk or to a network drive may intermittently become corrupted or... KB#213951. Keywords: Startup, Corrupted, Files

 
217. UserDefined Clip Art from Earlier Versions Is Unavailable When you open Microsoft Clip Organizer for the first time, you cannot locate custom clip art that you imported into earlier versions of Microsoft Clip Gallery. You cannot find these clips either by browsing or by keyword... KB#281858. Keywords: Search

 
218. How to Use the INDIRECT Function to Create References In Microsoft Excel, the INDIRECT worksheet function returns the contents of the specified reference and displays its contents. You can use the INDIRECT worksheet function to create linked references to other workbooks. You can reference each... KB#213933. Keywords: Errors, Formulas, INDIRECT

 
219. How to Programmatically Insert Blank Rows in a Worksheet In Microsoft Excel 2000, you can use a Microsoft Visual Basic for Applications macro to programmatically insert a blank row between every row of data on your worksheet. The example in this article contains a sample macro that performs this... KB#213318. Keywords: VBA, Macro, Web

 
220. How to Parse Data Using the Text To Columns Command This article contains information about how to parse data in Microsoft Excel by using the Text To Columns... KB#142149. Keywords: Parse

 
221. How to Import Microsoft Excel File Into Microsoft Access This article explains how to import a Microsoft Excel file into Microsoft Access version 2.0 or 7.0. Microsoft Access can import files from Microsoft Excel version 2.0 through version 7.0. However, Microsoft Access cannot import Microsoft Excel... KB#141228. Keywords: Microsoft Access, Format, Files

 
222. How to Close All Workbooks but One with Visual Basic Macro This article explains how to create a Microsoft Visual Basic for Applications macro (Sub procedure) that closes all other workbooks when you open a particular... KB#147742. Keywords: Errors, VBA, Macro, Object, Web

 
223. When You Click a File Icon, Excel Starts but the File Does Not Open as Expected When you double-click the icon for a Microsoft Excel (.xls) file (or right-click the icon, and then click Open ), Excel starts but the file does not open as expected. However, you are able to open the workbook when you click Open on the File menu... KB#304424. Keywords: Errors, Error Message, File Name, Registry

 
224. How to display All Menu Commands in Office XP Programs This step-by-step article describes how to display all menu commands in a Microsoft Office XP program. When you first start an Office program, the menus and toolbars display basic commands and buttons. As you work with an Office program, the... KB#290374. Keywords: Toolbar

 
225. Selected Text in Combo Box from Forms Toolbar Overflows into Worksheet Characters that do not fit into the space in a combo box may be displayed to the right of the combo box in the underlying... KB#231088. Keywords: Combo Box, Toolbar

 
226. How to Use the INDEX Function to Find Data in a Table This article describes how to use the INDEX function to find data in a table at the intersection of a specific row and column. There are two forms of the INDEX function, Array and Reference . The primary differences between the two forms are... KB#324988. Keywords: Arrays, Formulas, INDEX

 
227. How to Programmatically Disable Keyboard Functionality In Microsoft Excel, you can programmatically disable all of the keys on the computer keyboard by setting the Microsoft Visual Basic for Applications DataEntryMode property to xlOff . A sample Visual Basic macro that you can use to turn off... KB#213509. Keywords: VBA, Macro, Web

 
228. How to force Excel to Always Reference the Same Cell in Excel 2000 This step-by-step article shows you how to use the INDIRECT function to continually reference the same cell in a formula in Microsoft Excel 2000. How to Use the Indirect Function To anchor a reference while you insert or delete rows, columns,... KB#214143. Keywords: Formulas, INDIRECT

 
229. How to Create a Bullet List in Microsoft Excel Microsoft Excel does not have a built-in function to add a bullet item to entries in a worksheet. However, you can add bullets to text, or you can create a custom text format that includes bullets, so that you can format the cells and add text... KB#323567. Keywords: Bullet, Custom Number Formats, Fonts, Symbol

 
230. The font style of text that is contained in a Microsoft Excel Worksheet Object may change in Word or in PowerPoint After you edit a Microsoft Excel Worksheet Object in Microsoft Word or Microsoft PowerPoint, the font (or font style) that is contained in the object may change or may appear... KB#834009. Keywords: Fonts, Styles, Object, Registry

 
231. How to link to a Particular Worksheet from a Web Page in Excel 2000 This step-by-step article explains how to create a link from a Web page to a particular worksheet, range, or defined name in a Microsoft Excel 2000 workbook. Normally, when you create a link from a Web page to a Microsoft Excel workbook, the path... KB#211693. Keywords: Defined Name, Links, Web

 
232. Macro High Security Warning or User Defined Functions Display #Name? When you start Microsoft Excel or open a workbook, you may receive the following or similar error message: Macros in this workbook are disabled because the security level is high, and the macros have not been digitally signed or verified as safe.... KB#277608. Keywords: Errors, Macro, VBA

 
233. How to Open from and Save to an FTP Site This article describes how to open and save documents directly from or to a File Transfer Protocol (FTP) Web site using Microsoft Office... KB#212491. Keywords: Password, Files, Web

 
234. Rich Text Formatting Is Lost When You Use Replace All If you use the commands in the Replace dialog box to find and replace text in a worksheet, some cells may lose their text... KB#177194. Keywords: Fonts, Format, Styles, Formulas, Toolbar

 
235. Borders Are Lost When You Print Inserted Excel Objects at Printer Resolution When you print a slide in Microsoft PowerPoint, borders around the far right column of embedded Microsoft Excel objects may not print... KB#316070. Keywords: Borders, Printing, File Name, Files

 
236. How to Block Linked HTTP Images in Office XP Documents You can configure Microsoft Office to block linked Hypertext Transfer Protocol (HTTP) images that are placed in Office documents as an added security feature in Microsoft Office XP. This article describes how to configure Office XP to block... KB#327635. Keywords: Download, Registry

 
237. How to use Advanced Filter to Exclude Records in Excel 2000 This step-by-step article explains how to use the ISNA and MATCH worksheet functions to exclude records in a Microsoft Excel database that do not match another list. How to Create Exclusion Criteria To create exclusion criteria, use the... KB#214324. Keywords: Advanced Filter, Criteria, Formulas, MATCH

 
238. Custom Function Returns #VALUE! If Returning Array Larger Than 5,461 Elements When you calculate your workbook, some cells may contain a #VALUE!... KB#250828. Keywords: Arrays, Errors, Registry

 
239. An Overview of Data Tables in Microsoft Excel You can use data tables (on the Data menu, click Table ) to see how different input values affect the results of a formula. By doing so, you can test different input values for a formula, without having to retype or copy the formula for each... KB#282852. Keywords: Format, Formulas

 
240. How to Determine How Many Pages Will Be Printed Microsoft Visual Basic for Applications does not provide a method to determine the total number of pages that will print in a worksheet. However, you can use the ExecuteExcel4Macro method to use the GET.DOCUMENT(50) macro sheet function to return... KB#139405. Keywords: Printing, VBA, Macro, Web

 
241. Examples of Interest Calculations Outside the United States Microsoft financial functions presume customary financial practices in the United States. Other countries have different laws about quoting and computing interest. This article provides examples that demonstrate how to compensate for these... KB#294396. Keywords: Months, NOMINAL, FREQUENCY

 
242. "Open Clip In" Command Opens the File Instead of the "Open With" Dialog Box In Microsoft Clip Organizer, when you click the drop-down arrow to the right of the clip, and then click Open Clip In on the Properties menu, the clip opens in whichever program that is associated with the clip file type. It does not display the... KB#285628. Keywords: Errors, Error Message, Files

 
243. How to Determine Which Version of Excel Wrote a Workbook This article demonstrates how to determine the version of Microsoft Excel that wrote a given... KB#225029. Keywords: OLE

 
244. How to Close All Workbooks But One with a Visual Basic Macro This article explains how to create a Microsoft Visual Basic for Applications macro (Sub procedure) that closes all other workbooks when you open a particular... KB#213806. Keywords: Errors, VBA, Macro, Object, Web

 
245. How to Avoid Saving Password in Text File When You Get External Data When you use a new database query to retrieve data from external sources into Microsoft Excel, you are asked to save the password twice. If you select either of the following check boxes Save my UserID and Password in the data source definition... KB#253300. Keywords: Query, Password, Registry, Text Files

 
246. #REF! Error Recalculating Worksheet with Defined Name When your worksheet is recalculated, some cells may display the #REF! error... KB#221058. Keywords: Errors, Formulas, Links, Defined Name, File Name

 
247. How to Manage Multiple Windows in Excel In Microsoft Excel, you can open multiple windows into a workbook (document). By doing so, you can gain access to different areas of your workbook... KB#254791. Keywords: Window

 
248. 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#213640. Keywords: VBA, Web

 
249. Incorrect Attachment Name/Icon For Word/Excel Attachments In the Adding Attachments to a Message topic under Programming Tasks in the CDO (1.2x) help file, it is stated that for CdoFileData and CdoOle type of attachments, ReadFromFile method and for CdoFileLink type of attachments, Source method of... KB#198897. Keywords: Errors, VBA, Object

 
250. You Receive a "Cannot Open Protected File" Error Message When You Open a TabDelimited Text File If you try to open a tab-delimited text file that begins with the letter C in Microsoft Excel 2002, you may receive the following error message: Cannot open protected... KB#831959. Keywords: Errors, Error Message, Registry, Text Files

 

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