Home > Excel Help Portal > Financial Analysis With Excel

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

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.

351. 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#213813. Keywords: Macro, VBA

 
352. Filename Is Not Valid" When You Quit Microsoft Excel When you quit Microsoft Excel, you may receive the Filename is not valid error message, if both of the following conditions are true: You have logged on to the computer with a user name that exceeds eight characters. -and- You have disabled the... KB#133707 ". Keywords: Errors, Error Message, Toolbar

 
353. Embedded Excel Chart Resizes in Word When Scrolling to Different Page If you are working in a Microsoft Word 2000 document that contains an embedded Excel chart object, the size of the chart may... KB#257713. Keywords: Charts, Printing, Object

 
354. Solver Limits for Constraints and Adjustable Cells The maximum number of adjustable cells and constraints that a Solver model can use are listed in the following table. Microsoft Excel Adjustable cells Constraints version --------------------------------------------------- 3.x 200 299 4.x 200 500... KB#75714. Keywords: Solver, Errors

 
355. How to turn Off Function Argument ToolTips in Excel 2002 In Microsoft Excel, you can complete functions with the aid of the ToolTip feature, which displays ToolTips by default when you begin to type a formula in the formula bar. These ToolTips also make it easier to obtain additional help for a... KB#289146. Keywords: Formulas

 
356. How to change the Voice That Is Used for Text to Speech in Excel Microsoft Excel 2002 offers two different voices that you can use with the Text to Speech feature. This article describes how to change the Text to Speech voice. Change the Voice You can choose either LH Michael or LH Michelle as the voice to... KB#289845. Keywords: Speech

 
357. How to Change the Voice That Is Used for the Text to Speech Feature in Office 2003 Microsoft Office 2003 offers several different computer generated voices that you can use with the Text to Speech feature. This article describes how to change the voice of the Text to Speech... KB#826207. Keywords: Speech

 
358. Excel 95 Auto_xxxx Defined Name Values Change When Imported into Excel 97 or 2000 In the versions of Microsoft Excel listed at the beginning of this article, when you import a Microsoft Excel 95 workbook that contains a defined name, the reference for that name may change. For example, if the defined name 'AAA' in the Excel... KB#265311. Keywords: Defined Name

 
359. Help using Excel spreadsheet financial functions The following example shows the results of various financial calculations based upon both Annual and Monthly values. Note that the cells C4:D8 have all been given names ending with '_A' (annual) or '_M' (monthly). The names have been used in the formulae rather than the cell references. Business... Keywords: Analysis ToolPak, Months, Years, Formulas, FV, IPMT, PPMT

 
360. Justify Command Does Not Insert Spaces Between Text from Each Cell When you select text in separate cells, if there is not a space between the last word in a cell, and the first word in the following selected cell(s), the space is not inserted when you use the Justify command (on the Edit menu, point to Fill... KB#252730. Keywords: Search

 
361. Valid Geographic Names for Microsoft Map In Microsoft Excel, you can use Microsoft Map (Microsoft Data Map in Microsoft Excel 7.0) to graphically represent data associated with a geographic area. In order for Microsoft Map to recognize a territory, such as a country or province, the... KB#168691. Keywords: Microsoft Map

 
362. Excel Worksheet Changes Font When Copied to PowerPoint Slide When you paste cells or a chart that you copied from Microsoft Excel 2000 into a Microsoft PowerPoint slide, the correct font is not displayed. The Times New Roman font is displayed instead of the font that you selected in Excel. This problem may... KB#248208. Keywords: Charts, Fonts, Object

 
363. Embedded Excel Chart Resizes in Word if Zoom is Set to 20% or Less In Microsoft Word 2000, when you work with an embedded Excel chart object, the size of the chart may... KB#257622. Keywords: Charts, Printing, Object

 
364. How to include Both Value Labels and Percentage Labels on a Pie Chart in Excel 2000 In Microsoft Excel, you can add value labels or percentage labels, but not both, to a pie chart. This article explains how to manually add value labels to a pie chart that uses percentage labels. Add Value Labels to a Pie Chart That Uses... KB#279199. Keywords: Charts, Formulas

 
365. Lines Drawn Incorrectly on Imported Graphics When you insert a graphic file into a Microsoft Office program, the graphic may not be displayed properly. Specifically, dashed or dotted lines in the graphic may not be drawn... KB#151068. Keywords: Graphic

 
366. How to Change the Depth of a 3D Surface Chart This article explains how to change the chart depth of a 3-D surface chart in Microsoft Excel 97 for... KB#168253. Keywords: Charts, Legend, SERIES, Format

 
367. How to hide Gridlines in a Selected Area of a Worksheet in Excel 2000 This article describes how to hide the gridlines in a selected area of a worksheet in Excel 2000. Hide Gridlines To hide gridlines in a selected area of a worksheet, follow these steps: Select the range of cells for which you want to hide... KB#213884. Keywords: Borders, Colors, Format, Gridlines, Outline, Patterns

 
368. How to Add a Command to a New Toolbar In the programs listed at the beginning of this article, the steps for creating a new toolbar may differ from steps that you use in earlier versions of these programs. This article lists the steps to use when you want to add a command to a new... KB#200522. Keywords: Toolbar

 
369. Crash When Closing Excel After Closing Workbook with Circular References When you attempt to close Microsoft Excel after closing a workbook with circular references, you may receive one of the following error messages: Windows 95/98 EXCEL caused an invalid page fault in module EXCEL.EXE at 0167:303c4b08 Windows NT... KB#249076. Keywords: Errors, Circular References

 
370. How to Rename a Chart Using Name Box In earlier versions of Microsoft Excel, you can rename an embedded chart by clicking the chart once, clicking the Name box, and then entering the new name for the chart. This process changed slightly in Microsoft Excel 97 because clicking a chart... KB#169882. Keywords: Charts, SERIES, Colors

 
371. You Receive a "Microsoft Excel Cannot Open or Save Any More Documents" Error Message When You Open or Save an Excel File Through a Terminal Services Session When you try to open or save a Microsoft Excel file through a Terminal Services session, you may receive the following error message: Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk... KB#830065. Keywords: Errors, Error Message, Terminal Services

 
372. Memory Leak When Excel Calculates UserDefined Functions Microsoft Excel may leak memory when a custom function, also known as a... KB#265023. Keywords: UDF

 
373. Cannot Expand PivotTable If Data Is Not Saved with Table You can only expand a PivotTable when the Save data with table layout check box is... KB#283838. Keywords: PivotTables, File Name, Files

 
374. Charts Lose Axis Labels, Axis Scaling After You Copy Worksheet When you copy a worksheet, some of the charts on the resulting worksheet may exhibit on or more of the following problems: The axis titles are missing. The scale on the x-axis or y-axis is no longer... KB#248202. Keywords: Charts

 
375. Excel Stops Responding When You Click Help Topic In Microsoft Excel Help, when you search on the keyword VBA, and then click the Help topic Get Visual Basic Help in Microsoft Excel , Excel may stop... KB#248867. Keywords: VBA

 
376. Error 1004 Opening Buy vs. Lease Analysis Report When you open your workbook, you receive the following error message: Error: 1004 Description: Method 'Range' of object '_Worksheet' failed Source: Localizationinit Module: modMain Procedure:... KB#251139. Keywords: Errors, Object, Web

 
377. Dashed Series Lines Appear Solid in Excel 2000 When you open a file in Microsoft Excel 2000, some of the charts are displayed differently than they were in earlier versions of Excel. Data series that were displayed as a dashed line in earlier versions of Excel now appear solid. The data series... KB#248223. Keywords: Charts, SERIES

 
378. Templates Do Not Appear in New Dialog Box When you try to create a new document, you may be unable to view all templates from the New dialog box (on the File menu) if the following conditions are true: The templates exist in subdirectories under the main template directory. The... KB#262633. Keywords: Templates

 
379. Defined Name No Longer Present When You Open Workbook When you open your workbook, some of the names that you had previously defined are... KB#248165. Keywords: Defined Name, Links, Web

 
380. Limitations of the Break Links Command Microsoft Excel 2002 includes a new feature that allows you to break external links within a workbook; however, the Break Links command cannot break the following types of... KB#291984. Keywords: Links, Defined Name

 
381. How to use Keyboard Shortcuts to Select Border Styles in Excel This step-by-step article describes keyboard shortcuts that you can use to access the border styles buttons on the Border tab of the Format Cells dialog box. Keyboard Shortcuts for Border Styles Microsoft Excel includes keyboard shortcuts to... KB#277581. Keywords: Borders, Format, Styles

 
382. Frequently Asked Questions About Web Publishing in Excel 2002 You can save a Microsoft Excel 2002 workbook, or part of the workbook (such as a single item on a worksheet), as a Web page and make it available on an HTTP site, an FTP site, a Web server, or a network server for users to view or interact with.... KB#293416. Keywords: Web

 
383. STOP 0x1e Error Message Appears When You Try to Print from Excel or Word Using HP LaserJet 8100 PCL6 Printer Driver When you try to print from Microsoft Excel or Microsoft Word in landscape mode from a Microsoft Windows NT 4.0-based computer, using the Hewlett-Packard (HP) LaserJet 8100 PCL6 printer driver, you may receive a STOP 0x1e error... KB#255238. Keywords: Third-Party, Errors, Printing, Error Message, Web

 
384. How to use Small Business Financial Manager in Excel 2002 The Microsoft Small Business Financial Manager (SBFM) is not included with Microsoft Office XP Small Business Edition. However, with Microsoft Excel 2002, you can use the SBFM that is included with the Microsoft Office 2000 Small Business Tools.... KB#292187. Keywords: Download, Web

 
385. File Name Does Not Appear in the Recently Used File List on the File Menu In Excel 2000, any file whose path, including its file name, contains more than 127 characters does not appear in the recently used file list on the File... KB#326959. Keywords: File Name

 
386. SHIFT+SPACEBAR Keyboard Shortcut Does Not Work with Hangul Input Mode on Windows 2000 If you install Global IME (Korean) on a Windows 2000-based computer, and you then set the input mode as Hangul input, the SHIFT+SPACEBAR keyboard shortcut does not... KB#317385. Keywords: File Name

 
387. How to Reverse the Order of Words in a Text String This article explains how to reverse the order of words in a comma-separated text string by using the FIND, LEFT, LEN, and RIGHT functions in... KB#75513. Keywords: Formulas, RIGHT

 
388. Forecasting Techniques Example of applying Excel's forecasting features to the process of forecasting sales. This method provides the user with a method of eliminating seasonal trend and the R^2 statistic to compare the fit of various shape curves to the adjusted data. You can use Excel's built-in forecasting features to... Keywords: Charts, Plot, SERIES, Time Series, Download, Forecasting, Sales, Format, Formulas

 
389. Macro Virus Warning Does Not Appear When Opening SYLK File That Contains XLM Code When you open a workbook that contains macros, you may not be warned that the workbook contains... KB#241901. Keywords: Download, Format, Macro, Links

 
390. No Error Message Returned to VBA on Failed Save During a file save operation in Microsoft Excel, if a second program locks the file, a temporary file with an eight-character hexadecimal name is created, which contains the saved data, and the original file is deleted. No error message is... KB#269521. Keywords: Errors, VBA, Error Message

 
391. Changes Aren't Saved When Altering or Resetting Toolbars Using Automation When you alter toolbars using Automation, changes are not saved when you close and then restart Microsoft... KB#249066. Keywords: Toolbar

 
392. German Reports in Microsoft Excel Format Contain Incorrect Dates In the German version of Report Writer, all reports that are saved in Microsoft Excel format contain a wrong date for Datum der analyse, Erstes Datum analysiert, and Letztes Datum... KB#226500. Keywords: Format

 
393. How to Select Cells in Excel by Using OLE Automation This article shows by example how to use OLE Automation programmatically to create a Microsoft Excel worksheet, and select a range of... KB#139051. Keywords: OLE, Object

 
394. Advanced Formulas Tutorial Using a List Box to Change Data Displayed on a Worksheet Learn to use a List Box to update values displayed on your worksheet. Use the OFFSET function to return values from a table. Select an item in the List Box and see values for that item appear on a worksheet. IRR, XIRR, NPV, XNPV Functions You... Keywords: Add-In, AutoFilter, Criteria, Sorting, Sales, Arrays, Formulas, PivotTables, Iteration, VBA, Circular References, Auditing, OFFSET, XNPV, IRR, XIRR

 
395. Excel 2000 Chart Object Becomes Picture In Word 7.0, when you open a Word 2000 document that contains a Microsoft Excel 2000 chart object, and you double-click the Excel chart object, the Word picture editor is opened instead of... KB#212228. Keywords: Charts, Object

 
396. Converting Hours in Decimal Form to HH:MM:SS Format This article shows you how to convert hours displayed in decimal form to a time format such as hh:mm:ss (for example, converting 2.1 to... KB#214125. Keywords: Format, Formulas

 
397. JPEG Picture with Border Is Saved as GIF When Using Save as Web Page When you use Save as Web Page for a slide that contains a JPEG picture with a border, the picture is saved in GIF format rather than JPEG... KB#249057. Keywords: Borders, Format, Web

 
398. How to calculate the nth Root of a Number in Excel 2000 This step-by-step article shows you how to find the nth root of a number in Microsoft Excel 2000. To find the nth root of a number, raise that number to the power of 1/n. For example, to find the cube root of 8 in a cell, type the following:... KB#271143. Keywords: Formulas

 
399. Labels on XY Scatter Graphs Disappear in Print Preview When you view an XY scatter graph with smooth lines and labels that has been rotated to less than -6 degrees or more than 6 degrees in print preview, the horizontal (X) axis labels... KB#262113. Keywords: Printing

 
400. Cell Formulas Change When You Copy a Worksheet with an Embedded Chart When you copy a worksheet from one workbook to another, the formulas that already exist in the destination workbook... KB#265018. Keywords: Charts, Formulas

 

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