Home > Excel Help Portal > Financial Analysis With Excel

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

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.

201. Sample Macro to Insert/Delete Rows or Columns on Multiple Sheets
202. How to Determine the Number of Unique Items in a List
203. How to Use the Paste Options Button to Paste Data from Excel
204. "Runtime Error 1004" When You Attempt to Use Text to Speech in Macro
205. How to Determine If a Workbook or a Worksheet Is Protected
206. A description of the way that Excel saves files
207. Macro to Import a Text File into an Existing Worksheet
208. How to Use a Custom Dialog Box as a Startup Screen
209. How to Count Blank Cells in a Specified Range
210. How to Put Folder Contents into a Worksheet
211. How to Use Conditional Formatting to Shade Every Other Row
212. For Each Loop to Determine If an Excel Workbook Is Open
213. How to Determine If a Workbook or a Worksheet Is Protected
214. How to modify a Particular Time with the TIME and MOD Functions in Excel 2000
215. "SYLK: File Format Is Not Valid" Error Message When You Open File
216. Files Corrupted on Save: How to Troubleshoot Source of Problem
217. UserDefined Clip Art from Earlier Versions Is Unavailable
218. How to Use the INDIRECT Function to Create References
219. How to Programmatically Insert Blank Rows in a Worksheet
220. How to Parse Data Using the Text To Columns Command
221. How to Import Microsoft Excel File Into Microsoft Access
222. How to Close All Workbooks but One with Visual Basic Macro
223. When You Click a File Icon, Excel Starts but the File Does Not Open as Expected
224. How to display All Menu Commands in Office XP Programs
225. Selected Text in Combo Box from Forms Toolbar Overflows into Worksheet
226. How to Use the INDEX Function to Find Data in a Table
227. How to Programmatically Disable Keyboard Functionality
228. How to force Excel to Always Reference the Same Cell in Excel 2000
229. How to Create a Bullet List in Microsoft Excel
230. The font style of text that is contained in a Microsoft Excel Worksheet Object may change in Word or in PowerPoint
231. How to link to a Particular Worksheet from a Web Page in Excel 2000
232. Macro High Security Warning or User Defined Functions Display #Name?
233. How to Open from and Save to an FTP Site
234. Rich Text Formatting Is Lost When You Use Replace All
235. Borders Are Lost When You Print Inserted Excel Objects at Printer Resolution
236. How to Block Linked HTTP Images in Office XP Documents
237. How to use Advanced Filter to Exclude Records in Excel 2000
238. Custom Function Returns #VALUE! If Returning Array Larger Than 5,461 Elements
239. An Overview of Data Tables in Microsoft Excel
240. How to Determine How Many Pages Will Be Printed
241. Examples of Interest Calculations Outside the United States
242. "Open Clip In" Command Opens the File Instead of the "Open With" Dialog Box
243. How to Determine Which Version of Excel Wrote a Workbook
244. How to Close All Workbooks But One with a Visual Basic Macro
245. How to Avoid Saving Password in Text File When You Get External Data
246. #REF! Error Recalculating Worksheet with Defined Name
247. How to Manage Multiple Windows in Excel
248. How to Continue a Visual Basic Statement from One Line to the Next
249. Incorrect Attachment Name/Icon For Word/Excel Attachments
250. You Receive a "Cannot Open Protected File" Error Message When You Open a TabDelimited Text File

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