Excel Tips
Adding Every Other Cell in a Column »
January 24, 2002
Is there a quick way of adding every other cell?
Convert Seconds to Time Format »
January 23, 2002
How can I format a cell that has data in seconds to show it as hours:minutes:seconds?
January 22, 2002
When I call Help without using the assistant (F1) Excel resizes itself to allow the Help window and the spreadsheet to be visible at the same time. Is there anything to prevent this?
January 21, 2002
How to fill a column with the last date of the month, starting with the last date of one particular month.
Finding the Average Between Two Data Sets »
January 19, 2002
I'm trying to calculate the median of salaries with a particular job code within a large set of data... something like a Sumif function but to calculate the median.
Rounding Numbers to Nearest Number »
January 18, 2002
Is there anyway in Excel that I can round numbers to nearest number?
January 17, 2002
How can I have VLOOKUP return a 0 or a empty string instead of #N/A?
Tabbing Through Specific Cells »
January 16, 2002
How to move from cell to another (and skip some cells) by pressing the tab key or some other key.