Home > Excel Help Portal > Financial Analysis With Excel

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

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.

251. How to Find and Replace Tildes and Wildcard Characters Microsoft Excel uses the tilde (~) as a marker to indicate that the next character is a literal. When you click Find or Replace on the Edit menu to replace or search for a tilde (~), an asterisk (*), or a question mark (?), you must precede... KB#214138. Keywords: Wildcard

 
252. How to preserve Formulas If You Save a Document As a Text File in Excel 2000 In Microsoft Excel, you may occasionally want to save a document as a text file; for example, to fix corruption in the file. Although an Excel file is saved as a text file, only the active sheet and the displayed values are saved. All formulas on... KB#213913. Keywords: Formulas, Text Files

 
253. How to make Paste Options Disappear After You Paste in Excel 2002 After you perform a copy and paste operation in Microsoft Excel, the Paste Options are displayed near the paste destination. This step-by-step article explains how to make the Paste Options disappear or prevent them from appearing. Make Paste... KB#289577. Keywords: Clipboard

 
254. How to Change the Case of Text This article describes how to use worksheet functions to change the case of... KB#263580. Keywords: Formulas, LOWER

 
255. How to Assign a Macro to an Option Button In Microsoft Excel, you can assign a macro to a custom option button so that when the option button is selected, the macro is... KB#141689. Keywords: Outline, Macro, Toolbar

 
256. How to specify Trusted Sources for Digital Certificates in Excel 2002, PowerPoint 2002, and Word 2002 If you open a document that contains a digitally signed macro, you are prompted to select whether to trust the source if the following conditions are true: The digital certificate has not previously been trusted. -and- The security for your program... KB#308983. Keywords: Macro, Files, Templates

 
257. How to Use Advanced Filter to Exclude Records You can use the ISNA and MATCH worksheet functions exclude records in an Excel database that do not match another list. To create exclusion criteria, use the following formula... KB#183512. Keywords: Advanced Filter, Criteria, Formulas, MATCH

 
258. Cannot Use Pound Character in File Name for a Hyperlink When you create a hyperlink to another file, the file name that appears in the hyperlink text may appear to be different than the actual file name. For example, a hyperlink to a file with the following file name: C:\My Documents\Book#One.xls... KB#202261. Keywords: Errors, File Name, Hyperlinks, Web

 
259. How to use Wildcard Characters in Microsoft Excel 2000 Parameter Queries This article describes various wildcard characters that you can use in parameter queries in Microsoft Query. A parameter query, when you run it, prompts for values (criteria) to use to select the records for the result set so that the same query... KB#211459. Keywords: Criteria, Query, Wildcard

 
260. How to convert Dates in Imported Files from yy/mm/dd to mm/dd/yy Format in Excel 2000 This step-by-step article describes how to convert dates in imported files from yy/mm/dd to mm/dd/yy format in Excel 2000. Files imported from mainframe computers and other computer systems may contain dates in the format yy/mm/dd. These date... KB#214031. Keywords: Dates, Format, Formulas, Files, DATEVALUE

 
261. "Do You Want to Save the Changes You Made to { ?" in French Excel 2000 When you close a workbook in the French version of Excel 2000, you receive the following message: Do you want to save the changes you made to { ? Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel. The... KB#269679. Keywords: Formulas, Files

 
262. How to Return a Day of the Week for a Date That Is Contained in a Cell in Excel This article describes how to return a day of the week for a date that is contained in a cell in Microsoft... KB#827327. Keywords: Dates, Format

 
263. Cannot Save Excel File That You Open in Microsoft Internet Explorer When you open a Microsoft Excel file from a server and you click Save As on the File menu, you are prompted for your Microsoft Windows NT credentials. If you click Cancel, the credentials dialog box closes, but the local Save As dialog box is... KB#321778. Keywords: Registry, Links

 
264. How to Delete and Restore a Menu That Has a Submenu In a Visual Basic for Applications macro, if you delete a menu item that has a submenu and you want to restore it, use the Addmenu command, not the Add command. Addmenu adds a new menu (or submenu), while Add adds a new menu... KB#125423. Keywords: VBA, Web

 
265. 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#213810. Keywords: Printing, VBA, Macro, Web

 
266. Cannot Use Keyboard Shortcuts to Select Ranges in RefEdit Control When you use a RefEdit control in a user form, you cannot use keyboard shortcuts, such as CTRL+SHIFT+END, to enter a range in the RefEdit... KB#291110. Keywords: Registry

 
267. How to add a Digital Signature to a Custom Macro Project in an Office Program This article describes how to add a digital signature to your macro project. You digitally sign a file or a macro project, so that users who run the macro can be assured of the identity of the creator of the macro and that the macro has not... KB#307731. Keywords: Macro, VBA

 
268. How to Link to a Particular Worksheet from a Web Page This article explains how to create a link from a Web page to a particular worksheet, range, or defined name in a Microsoft Excel... KB#172503. Keywords: Defined Name, Links, Web

 
269. How to turn AutoComplete On or Off in Excel 2000 This step-by-step article describes how to turn the AutoComplete feature on or off. (The AutoComplete feature automatically completes entries in columns.) This information is also covered in more detail in Microsoft Excel 2000 Help. For... KB#263552. Keywords: Patterns

 
270. Diagonal Border Disappears with Rotated Text In Microsoft Excel, when you use rotated text (any angle between 90 and -90 degrees) and a diagonal border in the same cell, the diagonal border may... KB#212129. Keywords: Borders, Format, Outline

 
271. How to Display All Menu Commands When you first start a Microsoft Office program, the menus and toolbars display basic commands and buttons. As you work with an Office program, the commands and buttons that you use most often are stored as personalized settings and displayed on... KB#213398. Keywords: Toolbar

 
272. How to Automate Excel 2000 Subtotals Function in Visual FoxPro Microsoft Excel provides a useful function called Subtotals, which you may automate with Microsoft Visual FoxPro. The Subtotals function allows you to choose groups and columns to subtotal. The following example shows how to automate the Excel... KB#265731. Keywords: OLE, Arrays, Object

 
273. How to Compute the Average Growth Rate of an Investment The average growth rate is a calculation used by financial investors to determine the best investment over time given present value, future value, and number of periods per year of an investment. This calculation can also be referred to as... KB#123198. Keywords: Formulas, FV, PV, N

 
274. How to calculate the Number of Months Between Two Dates in Excel 2000 This step-by-step article shows you how to calculate the number of months between any two dates. To calculate the number of months between any two dates, use one of the following methods. Note that both methods use the following information: EDate... KB#214134. Keywords: Dates, Days, Months, Formulas

 
275. UserDefined Function to Place Sheet Name in a Cell To display the name of a worksheet in a cell, create a user-defined function similar to the sample functions in the More Information section of this... KB#213475. Keywords: VBA, Macro, File Name, Web

 
276. How to Copy Column Widths In Microsoft Excel, you can copy the column width when you copy data from one range of cells to another by selecting the entire column when you copy it. You can also copy column widths separately from your... KB#61269. Keywords: Column Width

 
277. 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#214261. Keywords: Parse

 
278. How to Use a Visual Basic Macro to Open and Retrieve a File on the Internet In Microsoft Excel 2000, you can use a Microsoft Visual Basic for Applications macro to open and retrieve files that are located on computers on the Internet or an... KB#213245. Keywords: VBA, Macro, Files, Web, Window

 
279. How to Access Smart Tag Menus from the Keyboard This article describes how you can use your computer keyboard to access smart tag menus, instead of using your... KB#301403. Keywords: Smart Tag

 
280. How to add a Series to an XY (Scatter) Chart with a Second XAxis in Excel 2000 When you add a second series to an XY (scatter) chart, the new values are added with respect to the same x-axis values as the first series. This step-by-step article explains how to add a second series to an XY (scatter) chart that uses a second... KB#214292. Keywords: Charts, SERIES, Format

 
281. How to Remove Smart Tags from a Workbook This article explains how to remove smart tags from a... KB#288958. Keywords: AutoCorrect, Smart Tag

 
282. How to Force MS Excel to Always Reference the Same Cell To continually reference the same cell in a formula in Microsoft Excel, use the INDIRECT... KB#51918. Keywords: Formulas, INDIRECT

 
283. How to display or Hide the Ask a Question Box in Microsoft Office This step-by-step article describes how to display or hide the Ask a Question box in Microsoft Office XP programs. The Ask a Question box is a new feature of Office XP that allows quicker access to Help topics. This box is located in the... KB#283633. Keywords: Ask a Question box, Toolbar

 
284. Size of TIFF Picture Is Incorrect When Inserted When you insert a tagged image file format (TIFF) picture into a document in any of the programs listed above, the picture is larger than it should be. If you examine the original size and scaling information (On the Format menu, click Picture,... KB#144930. Keywords: Ratio, Format

 
285. Error Message: This Operation Is Attempting to Change a Filtered Range on Your Worksheet and Cannot Be Completed When you try to create a list from a filtered range of cells in Excel 2003, you receive the following error message: This operation is attempting to change a filtered range on your worksheet and cannot be completed. To complete this... KB#818244. Keywords: Query, Errors, Error Message

 
286. How to Compare Two Cells Ignoring Leading and Trailing Spaces By using the TRIM worksheet function in Microsoft Visual Basic for Applications, you can compare the contents of two cells in such a manner that leading and trailing spaces are... KB#142588. Keywords: VBA, Macro, Web, TRIM

 
287. Dragging a Drawing Object into Clip Gallery Creates a GIF Graphic This article describes how to create new .gif files in Clip Gallery by dragging vector-based images, AutoShapes, or groups of AutoShapes from PowerPoint, Word, or Excel into Clip Gallery. Note that if you drag these objects from Microsoft... KB#218541. Keywords: AutoShapes, Object, Files

 
288. Can't Drag and Drop Movies/Sounds to Excel or Word When you attempt to use a drag and drop operation to move a movie or sound object from Microsoft PowerPoint to Microsoft Word or Microsoft Excel, a picture image appears in place of the object. This behavior does not occur when you use the drag... KB#198340. Keywords: OLE, Sounds, Object

 
289. How to Format Cell Data When You Are Creating an Excel File With an Active Server Pages Page This article demonstrates how to format a field to preserve the leading digits (such as the 000 in 0001112) or a specific formula when you create an Excel file with an Active Server Pages (ASP)... KB#260239. Keywords: Format, Formulas, Internet Explorer

 
290. How to use Draw Border Tools and Draw Border Grid Tools to Apply and Remove Cell Borders in Excel This step-by-step article shows an example of how you can use the new Draw Border tools and Draw Border Grid tools in Microsoft Excel 2002. Excel 2002 provides a new approach to adding or removing borders around and between cells. Instead of... KB#288852. Keywords: Borders, Colors, Format, Styles, Toolbar

 
291. How to use Shared Workbooks with Different Versions of Excel, Including Excel 2000 This step-by-step article explains how to share a Microsoft Excel workbook with other users. If you want several users to work in the same Excel workbook simultaneously, you can save the workbook as a shared workbook. Users can then enter data,... KB#269860. Keywords: Format, Errors

 
292. Cannot Suspend Computer with Windows 2000 Offline Files Open When you edit a document that was made available offline using Windows 2000, you cannot suspend the computer and may receive the following error message: Windows cannot go on standby because Microsoft Office documents or application components... KB#257456. Keywords: Errors, Files

 
293. Mailto Hyperlink in Office Docs Opens Two New Mail Messages When you click a MailTo hyperlink in a Microsoft Office document, two e-mail message windows... KB#197097. Keywords: Registry, Hyperlinks

 
294. Example on Use of Solver The Solver add-in that ships with Microsoft Excel is used to find solutions to what-if scenarios based on adjustable cells and constraint cells. This article gives an example of how to set up a model on a worksheet and how to use Solver to find... KB#214263. Keywords: Add-In, Solver, Scenarios

 
295. How to Preserve Formulas When Saving as a Text File In Microsoft Excel, it is sometimes necessary to save your document as a text file to fix corruption in the... KB#153490. Keywords: Formulas, Text Files

 
296. How to Use Wildcards in Parameter Queries This article includes examples that show you how to use wildcards in parameter queries in Microsoft... KB#164117. Keywords: Criteria, Query, Wildcard

 
297. How to use Custom Toolbars from Excel 5.0 in Excel 2000 This step-by-step article shows you how to use custom toolbars from Microsoft Excel 5.0 in Microsoft Excel 2000. When you upgrade Excel 5.0 to Excel 2000, built-in toolbars that you customize in Excel 5.0 and custom toolbars you create in Excel 5.0... KB#211963. Keywords: Toolbar

 
298. How to use RAND() to Generate Randomly Distributed Integers in Excel 2000 This step-by-step article describes how you can use the RAND function to generate randomly sorted, uniformly distributed integers in Microsoft Excel 2000. Excel does not include a built-in method for generating sets of randomly sorted,... KB#214090. Keywords: Sorting, RAND

 
299. The 'Mail Recipient (as Attachment)' Option Is Missing Even when Microsoft Outlook is set as your default e-mail program, one or more of the following syptoms may occur: The menu item Mail Recipient (As Attachment) is missing on the File, Send To menu of Office 2000 programs. The menu item... KB#249786. Keywords: API

 
300. How to create a Single Stacked Column Chart or Single Bar Chart in Excel 2000 This step-by-step article explains how to create a single stacked column chart and a single bar chart in Microsoft Excel 2000. these kinds of charts. Create Stacked Column Chart To create a single stacked column chart, follow these steps: Start... KB#213929. Keywords: Bar Chart, Charts, Legend, SERIES

 

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