Home > Excel Help Portal > Financial Analysis With Excel

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

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.

301. How to Enter a Second Line in a Message Box In a Microsoft Visual Basic for Applications macro (Sub procedure), to display more than one line of text in a message box, use the line feed character (character code 13) as in the following sample... KB#124213. Keywords: VBA, Macro, Web

 
302. How to Remove Gridlines from a Section of a Worksheet This article describes how to hide the gridlines on a section of a worksheet in Microsoft... KB#189883. Keywords: Borders, Colors, Format, Gridlines, Outline, Patterns, Styles

 
303. Support WebCast: General Corrupt File recovery techniques in Microsoft Excel 97, Microsoft Excel 2000, and Microsoft Excel 2002 Session Summary During this session, we will discuss how to use the corrupted file recovery features in Microsoft Excel. We will cover both the automatic functionality and the manual methods to invoke file recovery, how Excel displays the results... KB#325496. Keywords: Corrupted

 
304. How to Return the First or Last Match in an Array You can use the LOOKUP() function to search for a value within an array of sorted data and return the corresponding value contained in that position within another array. If the lookup value is repeated within the array, it returns the last... KB#214069. Keywords: Arrays, LOOKUP, VLOOKUP, HLOOKUP, INDEX, MATCH

 
305. Updating Link Removes Formatting from Microsoft Excel Table In Microsoft Word, if you insert a link to a Microsoft Excel worksheet as Formatted Text (RTF) and then apply formatting (such as bold or italic formatting) to the linked table, the formatting may be lost when the link is... KB#220526. Keywords: Format, Links

 
306. How to Enter a Second Line in a Message Box In a Microsoft Visual Basic for Applications macro, to display more than one line of text in a message box, use the line feed character (character code 13), as in the following sample... KB#213444. Keywords: VBA, Macro, Web

 
307. How to Extract an Exact Match of Text from a Database In Microsoft Excel, to filter records in a list by using the Advanced Filter command, the text to be matched must be preceded by an equal () sign in the criteria range. Use the following format in the appropriate criteria cell ' text string... KB#214100. Keywords: Advanced Filter, Criteria, Sorting, Sales, Format, MONTH

 
308. How to Reverse the Axis on a Bar Chart When you create a bar chart with the ChartWizard, the category labels are arranged from bottom (the first label) to top (the last label) instead of from top to bottom as expected. This order of arrangement occurs because labels are plotted from... KB#141103. Keywords: Bar Chart, Charts, Format

 
309. How to Remove Duplicate Records or Create List of Unique Records When Microsoft Excel imports or combines many records, it may create duplicates. This article describes how to create a compiled list of unique... KB#262277. Keywords: Advanced Filter, Criteria, Sorting

 
310. How to rename a Chart by Using the Name Box in Excel 2000 This article tells how to rename an embedded chart in Microsoft Excel 2000. In versions of Excel earlier than Microsoft Excel 97, you can rename an embedded chart by clicking the chart one time, clicking the Name box, and then entering the new... KB#212121. Keywords: Charts, SERIES, Format

 
311. Frequently Asked Questions About the Find and Replace Feature in Excel 2002 In Microsoft Excel 2002, the Find and Replace dialog boxes of earlier versions have been replaced by a single dialog box. The default tab selection depends on which of the two commands is used to open the dialog box. You can switch between finding... KB#293450. Keywords: Format, Errors, Error Message

 
312. How to Create a Dynamic Named Range on a Worksheet in Excel In Microsoft Excel, you may have a named range that must be extended to include new information. This article describes a method to create a dynamic defined name. Note The method in this article assumes that there are no more than 200 rows of... KB#830287. Keywords: Sales, Formulas, Defined Name, OFFSET, RAND, COUNT, COUNTA

 
313. Ejecting CDROM Causes Microsoft Excel to Close When you press the eject button on your CD-ROM drive, Microsoft Excel 97 may close unexpectedly. NOTE: This behavior occurs regardless of whether there is a compact disc in the CD-ROM... KB#167136. Keywords: Setup, CD-ROM

 
314. Excel Caused an Invalid Page Fault in MSO9.DLL When Saving File When you attempt to save a file in Microsoft Excel, you may receive an error message similar to either of the following: EXCEL caused an invalid page fault in module MSO9.DLL at 0137:3092fdcd. -or- EXCEL caused an invalid page fault in... KB#248167. Keywords: Format, Errors, Error Message, File Name, Save A File

 
315. Clip Organizer Cannot Read Design Gallery CIL Files When you are prompted to select a program to open a downloaded Clip Gallery Package file (CIL) from the Microsoft Office Online Clip Art Web site and you select Clip Organizer, a new instance of Clip Organizer runs. It behaves as though it is... KB#297224. Keywords: Download, Format, Files, Web

 
316. How to use SUM Function on Only Odd or Even Rows in Excel 2000 This step-by-step article explains how to use the SUM function on only the odd rows or the even rows in a range. When you use any of the worksheet functions in Excel, and you have a range argument that includes either hidden rows or columns, the... KB#213961. Keywords: Arrays, Formulas

 
317. How to Find Secant, Cosecant, or Cotangent of an Angle Microsoft Excel has built-in functions for a large number of trigonometric functions, but does not include all such functions. However, those not included may be derived from existing functions by using a formula in Microsoft Excel. Some... KB#188075. Keywords: Formulas, PI

 
318. How to View Sample Chart with the Keyboard When you use the keyboard shortcut, ALT+V, to view a sample chart in step 1 of the Chart Wizard, a sample of the chart does not... KB#157354. Keywords: Charts

 
319. "Compile Error in Hidden Module: RegistrationDB" Error Starting Excel When you start or quit Microsoft Excel, you receive an error message similar to the following: Compile error in hidden module:... KB#291214. Keywords: Third-Party, Errors, Error Message

 
320. MS03050: Vulnerability in Microsoft Word and Microsoft Excel Could Allow Arbitrary Code to Run Microsoft has released security bulletin MS03-050. The security bulletin contains all the relevant information about the security patch, including file manifest information and deployment... KB#831527. Keywords: Web

 
321. How to Use Custom Toolbars in Excel5.xlb When you upgrade Microsoft Excel 5.0 to Microsoft Excel 97, any built-in toolbar you customize or custom toolbar you create in Microsoft Excel 5.0 does not appear in Microsoft Excel... KB#161322. Keywords: Toolbar

 
322. Outlook Does Not Display a Complete HTML Message or Excel Form If Internet Explorer 6.0 Is Installed Outlook 2000 may not display a complete HTML message or a message that contains an embedded Microsoft Excel form if Microsoft Internet Explorer 6.0 is installed on the computer on which Outlook 2000 is... KB#318256. Keywords: HTML, Internet Explorer

 
323. How to Create a Formula to Correctly Evaluate Blank Cells In Microsoft Excel, when you use a formula that tests for a zero value, you may see unexpected results if the cell is blank. Microsoft Excel interprets a blank cell as zero, and not as empty or blank. Therefore, any cells that are blank are... KB#214244. Keywords: Formulas

 
324. PivotTable of OLAP Data Does Not Display Data Correctly When you create a PivotTable in the Japanese version of Microsoft Excel, the invalid value 1.7977E+308 is displayed in calculations of Online Analytical Processing (OLAP) cube fields, even if the server returns correct... KB#271900. Keywords: Errors, PivotTables, Internet Explorer, Web

 
325. How to Sum Either Odd or Even Rows Only When you use any of the worksheet functions in Microsoft Excel, and you have a range argument that includes either hidden rows or columns, the cells in these hidden areas are still used by the function. For example, if you have the following in... KB#136738. Keywords: Arrays, Formulas

 
326. How to Use the OFFSET Function This article describes how to use the OFFSET function to return the value of a cell that is a specified number of rows and columns away from a cell or range of cells that you referenced in an adjacent... KB#324991. Keywords: Formulas, OFFSET

 
327. How to control the size of a UserForm in Excel Excel does not provide a method to Maximize or to Minimize a... KB#827710. Keywords: Macro, UserForm

 
328. Custom Toolbar Is Lost When Workbook Is Sent as Attachment When you open a Microsoft Excel 2000 workbook that has an attached toolbar, the toolbar may not be... KB#250793. Keywords: Macro, Toolbar

 
329. How to use the Keyboard to Change the Active Cell in Excel 2000 This step-by-step article describes how to use the keyboard to change the active cell in an Excel worksheet. Press CTRL+PERIOD This method is an undocumented navigation keystroke. To do this, follow these steps: Select a range of cells.... KB#200724. Keywords: RIGHT, LEFT

 
330. "Cannot Quit EXCEL.EXE" and Can't Log Off from Windows NT If Excel File Open in Internet Explorer If you open a Microsoft Excel workbook as an active document (in-place) within Microsoft Internet Explorer, and then attempt to log off from Windows NT, you cannot log off and Excel returns the following error message: Cannot quit EXCEL.EXE.... KB#235520. Keywords: Errors, Hyperlinks, Internet Explorer

 
331. Wrong Workbook Is Printed or Previewed When you print a workbook or or use the Print Preview command to preview a workbook, the wrong workbook is printed or... KB#236408. Keywords: Add-In, Printing, Object

 
332. Lines in a Graph Are Missing When Inserted into an Office Document When you insert a graph into one of the programs listed in the Applies to section of this article, some of the lines in the graph are... KB#249079. Keywords: Colors, Format

 
333. Font Size and Displayed Rows and Columns May Change When You Edit Embedded Excel Object in PowerPoint If you are working in a PowerPoint presentation that contains a Microsoft Excel worksheet object, the number of rows and columns displayed and the size of the fonts may change when you edit the... KB#252382. Keywords: Fonts, Object

 
334. How to Calculate the Number of Months Between Two Given Dates This article contains information about calculating the number of months between any two given... KB#67093. Keywords: Dates, Days, Months, Years, Formulas, NOW

 
335. Valid Geographic Names for Microsoft Map In Microsoft Excel 2000, you can use Microsoft Map to graphically represent data associated with a geographic area. For Microsoft Map to recognize a territory, such as a country or province, the name must be a valid name or... KB#214385. Keywords: Microsoft Map

 
336. Error Message: No RETURN() or HALT() Function Found on Macro Sheet When you switch between two workbooks several times, you receive the following error message: No RETURN() or HALT()function found on macro... KB#316399. Keywords: Errors, Macro, AutoSave, File Name, Files

 
337. How to Find the Percentage of Change Between Values In Microsoft Excel, there is no built-in function to calculate the percentage of change from one value to another. However, you can use the following formula to calculate the percentage change ( new_value - original_value )/ABS(original_value)... KB#214078. Keywords: Sales, Format, Formulas

 
338. "Unable to Load the Excel Template" Error Message When You Run the Import Flowchart Data Wizard In the products listed at the beginning of this article, if you have Microsoft Excel 95 installed and you start the Import Flowchart Data Wizard, you receive the following error message: Unable to load the Excel template. Make sure the following... KB#265122. Keywords: Format, Errors, Error Message, Templates

 
339. An Excel formula to calculate weighted averages To calculate a general indicator of a selection of values you could calculate the arithmetic mean - generally known as the average. If measuring the average price of foodstuffs you could take a list of products available and then calculate the average. E.g. Bread (60) + Milk (30) + Beef (300) +... Keywords: Sales, Arrays, Formulas

 
340. Invalid Page Fault Changing PivotTable Data Source When you use the PivotTable Wizard to change the location of the source data for your PivotTable, Microsoft Excel stops responding and you receive an error message similar to the following: This program has performed an illegal operation and will... KB#248225. Keywords: Errors, PivotTables, Error Message

 
341. How to display More Digits in Trendline Equation Coefficients in Excel When you add a trendline to a chart, and then display the equation and R-squared value for the trendline, the equation shows only the first five digits of each coefficient. For some purposes, this may not be a sufficient number of significant... KB#282135. Keywords: Charts

 
342. How to use Only Selected Parts of AutoFormat in Excel 2000 This step-by-step article describes how to use only selected parts of an AutoFormat. You can also find this information in more detail in Microsoft Excel 2000 Help. For more information, please see the REFERENCES section later in this article.... KB#263557. Keywords: AutoFormat

 
343. "Compile Error in Hidden Module: RegistrationDB" Error Starting Excel When you start or quit Microsoft Excel, you receive an error message similar to the following: Compile error in hidden module:... KB#235326. Keywords: Third-Party, Errors, Error Message

 
344. EUROCONVERT Function Is Lost When You Save Excel Data to a Web Page In Microsoft Excel, when you publish or save your Excel data as a Web page, and the data contains the EUROCONVERT function, only the value of the... KB#235113. Keywords: Web, EUROCONVERT

 
345. File That Contains PivotTable Grows Each Time It Is Saved When you save, close, and reopen an Excel file that contains a PivotTable, the file may increase in size even if there are no changes to the data in the file. This problem occurs whether or not you save the pivot data with the file, and whether or... KB#316446. Keywords: PivotTables, File Name

 
346. Links to Closed Workbook with Defined Names Update Slowly When you choose to update external links to a closed Microsoft Excel workbook, it takes longer than it did in earlier versions of... KB#248173. Keywords: Links, Files

 
347. The FORECAST, STEYX, SLOPE and INTERCEPT functions cause different results in Excel 2003 than in earlier versions of Excel When you use the FORECAST, STEYX, SLOPE or INTERCEPT functions in a Microsoft Office Excel 2003 worksheet, you may receive different results than you did when you used these functions in earlier versions of Microsoft... KB#834521. Keywords: INTERCEPT

 
348. "Syntax Error (Missing Operator)..." Error Performing Query with a Date When you enter a date in the Criteria pane of your query, you receive an error message similar to the following Syntax error (missing operator) in query expression '( Table Name . Fieldname ts '100-11-16 00:00:00'})'. where Table Name is the name... KB#248222. Keywords: Criteria, Query, Errors, Error Message

 
349. How to Force the Clipboard Toolbar to Remain Docked The Clipboard toolbar typically floats in front of Office programs. This article explains how you can set the Clipboard toolbar to always be... KB#277686. Keywords: Clipboard, Toolbar

 
350. Excel Chart Does Not Refresh Properly After Update When you update a link to a Microsoft Excel chart, the chart may not be redrawn... KB#151047. Keywords: Charts, Links

 

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