General

I need an expense Db with categories for Schedule C
I used to use Quicken to run an expense calculation for my Schedule C (self-employed) tax return but it will not load onto my new computer. Is such a template available for Excel 2003? I can use Office 2007 on another computer if necessary. ... 22 Mar 2010 13:06

multiple correlations with one click?
I have a numerical data set with 11 columns and 1809 rows. I would like to simply obtain a table of correlations involving Col 1 with each remaining Col (Col 2 thru Col 11), then Col 2 with each remaining Col (3 thru 11), then Col 4 with each remaining Col (5 thru 11), and so on until the last correlation, i.e... 22 Mar 2010 11:53

Conditional Formatting and Formulas
Hi. I am using Excel 2003 to do some conditional formatting, but there are only three conditions to manipulate and I need four. I think though that I can comine two things together in a formula in one of the conditions - so that it would do the same formatting if either of two conditions were satisified - u... 22 Mar 2010 11:53

How do I enable drill down to refernce cells?
The <Ctl> <]> did not take me back to the formula cell. I am using Office 2007. Thanks in advance for any help. Stu "Mindy" wrote: Never mind. I found it. It's under Excel Options > Advanced. -- Thanks. ~ Mindy "Mindy" wrote: What about the same option in Excel 200... 22 Mar 2010 11:53

Can Excel be reset to the original settings?
We are having some problems at work where some of our users are going into the Excel options settings and changing them as they are experimenting. Is there anyway to reset the settings to the original settings? any help would be appreciated! Thanks! ... 24 Mar 2010 06:37

date formatting
I have an excel sheet which has a date in yyyy/mm/dd format saved on the internal network. other users who open the file do not see this date as the same format as the saved file. could anyone provide as to why this is happening and what can be done to correct it. thanks vandy ... 22 Mar 2010 13:06

import dynamic info from web Excel 2007
I am trying to import a table from a website into Excel that automatically refreshes and can be used in formulas. I was successful in doing this with a currency exchange website, but am having difficulty with this website in particular: http://www.cmegroup.com/trading/energy/crude-oil/light-sweet-crude.html ... 22 Mar 2010 11:53

I am trying to write a macro using If...Then
I am trying to write a macro that will look at the value in column G. If that value is blank or zero, then select the entire row and delete it. Then I want it to populate columns A with a number "111119" and column H with "TEXT" Here's what I tried, but it's not working. (There are other sorts, etc. that pre... 22 Mar 2010 11:53

Thought it was an "IF" formula, but haven't been able to figure it
I am looking for a formula (excel 2003) that gives me the following answer. (in box 14) If line 10 is more than line 13 enter the answer J31 (in box 15) If line 13 is more than line 10 enter the answer H32 8 175227.44 9 10 175225.44 11 175227.18 12a 296... 22 Mar 2010 13:06

Format Control Tab
In Excel 2000 there is no "Format Control Tab" only "Size, Protection, Properties and Web" tabs to choose from after clicking on "Control Properties" when attempting to format a SPIN BUTTON. How do I invoke this missing tab? ... 22 Mar 2010 11:53