When making a gradebook, I need to find a procedure to use the homework
averages and the test grade averages to determine whether or not the homework
is helping the test grades? How would I go about this?
 Thank you for ANY advice!

Excel 2007 has a feature which enables you to create a PDF document from the
spreadsheet. Is there an add-in available for Excel 2003 that does the same
thing?
I am aware of PDF writer applications which work by sending the printed

First I am a newbie to this community but I am by no means a newbie to
Excel. I have a need where I work to match two different columns of data as
follows. Anyone that can help will be my savior.
Problem to solve:

Hello - I am constantly changing the format of my cells (when they are
the number format) to include the comma separator and to use zero
decimal places.
Is there a way to change the settings so that by default the values

I want to use a conditional formatting statement on a cell to be true if
four other conditions are true.
I set the conditional formatting to apply if the value of the test cell = 1
Then I'd like to set an IF statement to produce a value 1 for that cell if

I am trying to put together a spreadsheet where I get a 26 week average on
the first 26 items in the column. When I insert a cell in the column the
formula expands to 27 items. How do I lock the formula on 26 items/

In cell A2 I input a year (2008, 2009 ect) in cell A11 I need a formula
which will return a value which represents the first day of January of the
year displayed in cell A2.

I have a Macro that sorts data then gives me a print preview to confirm I
agree with results, IE manually resolve ties, not common. In order to print
from that view I need to exit preview - click on excel button - select
print -  select print type - agree to printer,nr, etc - ...

I have a Pivot table with sub totals in rows.
Is there a way to get a grand total in the same row outside the pivot table
in the first column to the right of the pivot able

Is there a directory or registry that lists Excel consultants by
geographic location? I would like to locate one in my area in the US.

just upgraded from 2002 to 2007 and now when I double-click shortcuts to my
excel-documents they will not show in 2007. Excel 2007 opens but with an
empty workspace, only when I click the upper-left "Office button" does it
show. Why?? If I open the same document using the "Open" ...

I just got myself a wide format printer/cutter and would like a Excel
document to quote on Jobs
Not being all that great with excel and its formulas, I thought I would ask
if anyone would mind sharing their excel skills with me.

I have a very simple spreadsheet that has a column of serial numbers
and next to it a column with a yes/no tracking whether a serial number
has been registered or not.  I want my sales team calling into an
account once 50% of the serials are registered so I created a pivot

I have 11 cells with $2500.00, If I select them the footer bar showes
the right answer ($27500) but the cell showes $37500.  If I set a cell
equal to the sum cell times 1.0 it gives $37500.  So my confidence is
pretty low in the over all spread sheet.  Any work arounds for this??

I usually use the Filter function when dealing with data in Excel.
But I cannot figure out why SOMETIMES the hidden data (i.e. after being
filtered) is also afected by changes to filtered data. For example, if I use
Filter to find blanks cells and then delete the filtered rows ...