Home > Excel Help Portal > Financial Analysis With Excel

<<  (Page 1)  Previous              Next  (Page 3)  >>

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.

51. Unexpected Behavior with Numbers Formatted as Text
52. How to Determine If a File Is ReadOnly
53. How to Use the FREQUENCY Function
54. Branching to Other Sections of Code with GoTo and Call
55. Limits of PivotTables in Microsoft Excel 2000
56. How to use Speech Recognition to Select Cells, Rows, and Columns in Excel
57. Macro Doesn't Function on Multiple Sheets in Group Mode
58. How to Use a Toolbar Settings File from a Network Share
59. How to Change the Company Name and User Name After Setup
60. Unexpected Behavior or Error Messages When You Start or Work with an Excel File or Object
61. How to Avoid "Save Changes?" When You Close a Workbook
62. How to Display a Custom Function in Step 2 of the Function Wizard
63. Macro to Check for Page Breaks on a Worksheet
64. Macro Code to Check Whether a File Is Already Open
65. Defined Names Are Case Sensitive
66. Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High
67. Visual Basic Example Using If and Case Statements
68. Controlling How and When the Office Assistant Appears
69. How to Programmatically Subtract or Sum Two Ranges of Data
70. How to Minimize Metadata in Microsoft Office Documents
71. How to correct rounding errors in floatingpoint arithmetic
72. How to Automate Smart Tags by Using Visual Basic for Applications
73. How to set a Print Area by Using a Defined Name in Excel 2000
74. How to Programmatically Increment a Date With a Spinner
75. How to Determine If a File Is ReadOnly
76. Graphics in Header or Footer Extend into Data Area of Worksheet
77. How to clear the Most Recently Used Files List in an Office 2003 Program by Modifying the Windows Registry
78. How to Hide Sheets and Use xlVeryHidden Constant in a Macro
79. Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High
80. Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High
81. How to Perform a CaseSensitive Lookup
82. How to Compare Data in Two Columns for Duplicates
83. How to Create PivotTable from Word
84. How to Create PivotTable from Word
85. Using a Worksheet Function in a Visual Basic Macro
86. How to Set the Default Command Button on a UserForm
87. How to use an Excel Data Source for Mail Merge in Word 2000
88. How to Sum Ranges Using Visual Basic for Applications
89. Sample Macros that Customize and Control Shortcut Menus
90. How to clear the Most Recently Used Files List in an Office XP Program by Modifying the Windows Registry
91. How to Display a UserForm Whose Name Is in a Variable
92. How to Compute the Periodic Annual Interest Rate in Microsoft Excel
93. Cannot Start Excel and Open a Workbook by DoubleClicking the .xls File
94. How to Display a UserForm Whose Name Is in a Variable
95. How to use the "Most Recently Used" Category in the Function Wizard in Excel 2000
96. Sample Macro Code to Change Case of Text
97. How to Drag Data from Microsoft Excel to a Microsoft Access Database
98. How to Solve for New XValues Using INDEX and LINEST
99. How to Compare Data in Two Columns for Duplicates
100. How to insert a Picture into the Header or Footer in Microsoft Excel 2002

<< (Page 1)  Previous              Next  (Page 3) >>