Excel 2003 Solution Center

how-to articles - Excel 2003

• Methods for transferring data to Excel from Visual Basic
  This article discusses numerous methods for transferring data to Microsoft Excel from your Microsoft Visual Basic application. This article also presents the advantages and the disadvantages for each method so that you can choose the solution that...
• How to dynamically add and run a VBA macro from Visual Basic
  Demonstrates how to dynamically add a VBA module to a running Office application from Visual Basic, and then call the macro to fill a worksheet in-process.
• Description of the way that Excel saves files
  Describes the process that Excel uses when you save a file. Explains how Excel uses the temporary file to makes sure that the original file is not damaged so that you can save your files.
• How to calculate compound interest for an intra-year period in Excel
  Provides formula and examples to show you how to calculate future value of intra-year compound interest and interest rates for intra-year compounding.
• How to use the INDIRECT function to create references in Excel
  Describes how to use the INDIRECT function to create references in Excel.
• How to control and understand settings in the Format Cells dialog box in Excel
  Explains that you can modify the majority of these settings in the Format Cells dialog box to change the way that your data is presented.
• How to change the case of text in Excel
  Describes how to use worksheet functions to modify the case of text in Excel. Provides an example.
• How to sum and format a range of hours, minutes, or seconds in Excel
  Describes how to sum and format a range of hours, minutes, or seconds in Excel.
• When to use a SUM(IF()) array formula
  You can use the SUMIF() worksheet function in Microsoft Excel for either of the following situations: When you want to return a sum for a single criteria (for example, a single IF condition) When you want to use multiple criteria and return the sum to...
• How to convert text to numbers in Excel 2002 and in Excel 2003
  Describes how to convert cells that contain text to cells that contain numbers. This article describes some methods that assume that you have already changed any cell number formatting in the cells to General.
• How to change the color palette for workbooks in Excel
  Describes the steps that you use to change the color palette in Excel. You can use custom colors to modify the colors for many workbook elements.
• How to select cells/ranges by using Visual Basic procedures in Excel
  Describes how to use VBA macros or procedures to select cells, ranges, and named ranges in Excel. Includes some sample code.
• How to use macro examples to delete duplicate items in a list in Excel
  Describes how to create a macro to delete duplicate items in a list in Excel. Provides macro examples to show how to accomplish this task.
• Some Excel features are unavailable if you disable Visual Basic for Applications and run Excel
  Explains that several Excel features are unavailable when Visual Basic for Applications (VBA) is not enabled in Excel 2002, in Excel 2003, and in Excel 2007.
• Method to determine whether a year is a leap year
  Describes how to determine whether the year in a date that is used in an Excel document is a leap year.
• Description of link management and storage in Excel
  In Microsoft Excel, you can link a cell in a workbook to another workbook using a formula that references the external workbook. When this link is created, it may use a relative path. With a relative link, you can move the workbooks without breaking...
• XL: 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 =( - )/ABS(original_value) where represents the value that...
• How to find data in an Excel table
  This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result. Create the Sample Worksheet This article uses a sample...
• How to calculate the number of months between two dates in Excel
  Provides a step-by-step guide to show you how to calculate the number of months between any two dates.
• Floating-point arithmetic may give inaccurate results in Excel
  Discusses that floating-point arithmetic may give inaccurate results in Excel.
• How to use the INDEX and MATCH worksheet functions with multiple criteria in Excel
  Describes how to use the INDEX and MATCH worksheet functions in Excel to find a value based on multiple criteria. This article also provides some examples to show how to perform this task.
• Excel statistical functions: TREND
  Describes the TREND function in Excel 2003 and in later versions of Excel, illustrates how the function is used, and compares the results of the function in later versions of Excel with results of TREND in earlier versions of Microsoft Excel.
• Description of how Excel determines the current mode of calculation
  Discusses how Excel determines the calculation mode. You can change the caculation mode in the Tools menu. You can press SHIFT+F9 to recaculate the active sheet and press F9 to recaculate all open documents.
• Description and examples of data validation in Excel
  Explains that data validation is a feature that is available in Excel 2002 and in Excel 2000. Provides some methods for and examples of how to use the data validation feature.
• How to use a macro to add labels to data points in an xy scatter chart or in a bubble chart in Excel
  Explains how to create and use a VBA macro to attach text labels to data points in an xy scatter chart. You can use the same code for a bubble chart.