Can anyone suggest somewhere I can learn more about how to use Pivot Tables other than within Help?

Hi I have excel 2007, and the datasystem here only accepts excel 2.1 format files. How can i convert or save in excel 2.1 format? I'd really appreciate any...

Hi Paul, Copy, paste special, transpose If this was helpful please click yes. thanks "Paul" wrote: I forgot how to do it. I have a set of numbers say 10...

I downloaded a calendar template from Microsoft. How do they work? How do you find them when you open Excel? Do you have to delete all information(month,day,...

I wish to freeze panes in excel 2007 however, the option is not highlighted i.e. I click on it but nothing appears. Help! -- JB

I have results of a 5 point lickert scale that I want to chart out using only 3 groupings how can i make a pie chart? thnx

hi Im performing Logical boolean operations using MS Excel. The only problem is that its displaying result set as "TRUE/FALSE" and I want to have the result...

I want to alternate colors between successive rows. One blue one white, the next one blue and the next white and so on to the end of my worksheet. It there...

Hello, I placed a inquiry for help on spliting a cell, I did get notification that it was answered yet I can't find the answer. Question was if I have a...

I am using Excel 2003. I have a spreadsheet in which two columns are locked and password protected. What I would like to do is display a message whenever...

I have data in columns A:C and would like to sum (Add) the data in A if a specific criteria in C is met...please assist with a formulae A B ...

I am using the sum feature on a large spreadsheet where one total might not be complete and yields a #VALUE!. Is there a way to make this appear 0. I am...

i AM TRYING TO CREATE A CUSTOM BUTTON IN EXCELTO ADD TO MY TOOL BAR TO WHICH I WOULD LIKE TO ASSIGN A MACRO. IT USED TO BE POSSIBLE IN WINDOWS XP. HOW DO YOU...

how do i suck a fat chode? srsly

I saw alot of excel wher some celles do not move and other move up and down so can any body help me to know how to make it

Hi, I have some data that needs to be reformatted. (see below) The data has 4 columns, Col A ("Position"), Col B ("Assay") and Col C ("Alpha"), Col D ("Sample...

Can I combine Sumif and If function? I have a data spreadsheet with the following columns: DATE column, $$ column, STATE column. Is there a formula that I...

I am trying to automate a spreadsheet. The basic formula is this... Any suggestions or corrections would be appreciated. =if(Logical_test, lookup_array,...

When you do not have information for a cell how do you get it to leave the cell blank or return a zero as opposed to the #N/A

I thought someone might learn something from my post: http://michiel.wordpress.com/2009/04/05/10-worst-microsoft-excel-practices/ Michiel