2009
10.15
10.15
Advanced Excel Training Guide
learn all about excel with us
2009
10.14
10.14
gwennie101 asked:
I need an easier way to explain this to people who have never used Microsoft Excel 2007. Your help is greatly appreciated.
Kristin
I need an easier way to explain this to people who have never used Microsoft Excel 2007. Your help is greatly appreciated.
Kristin
2009
10.09
10.09
Gabho asked:
Some information in Internet is displayed as a table. I like to capture those tables directly into Excel (no copy-paste please). I can program in Excel if necessary. Thank you.
Theresa
Some information in Internet is displayed as a table. I like to capture those tables directly into Excel (no copy-paste please). I can program in Excel if necessary. Thank you.
Theresa
2009
09.04
09.04
Quaim asked:
I am working on a huge 35-40 MB Excel file with thousands of records and complex formulas. The system computes and subsequently hangs after every small operation. How can I get away with this? My machine is new and it is Centrino, 80GB. I have disabled the ‘Automatic Calculation’ option in the Tools menue to avoid frequent computations but it does not help much.
Hector
I am working on a huge 35-40 MB Excel file with thousands of records and complex formulas. The system computes and subsequently hangs after every small operation. How can I get away with this? My machine is new and it is Centrino, 80GB. I have disabled the ‘Automatic Calculation’ option in the Tools menue to avoid frequent computations but it does not help much.
Hector
2009
07.27
07.27
katy c asked:
I am subtotaling a spreadsheet in excel. Most of the balances are zero, but I am only concerned with the balances that are not. I need to keep the detail. What is the easiest, least manual way to seperate those subtotals with balances from those with zeros?
Jo
I am subtotaling a spreadsheet in excel. Most of the balances are zero, but I am only concerned with the balances that are not. I need to keep the detail. What is the easiest, least manual way to seperate those subtotals with balances from those with zeros?
Jo
2009
07.22
07.22
unitedsways asked:
I want to make a home budget spreadsheet on excel and be able to download my transaction history from my bank. So far, I’ve been entering transactions by hand and that’s gotten too tiresome. My bank offers transaction historys in the downloadable formats - *qif, *csv, quicken, and microsoft money. I want to be able to just download the transaction history and input them into excel budget spreadsheet with minimal hassle. Anybody know how? Thanks.
Dora
I want to make a home budget spreadsheet on excel and be able to download my transaction history from my bank. So far, I’ve been entering transactions by hand and that’s gotten too tiresome. My bank offers transaction historys in the downloadable formats - *qif, *csv, quicken, and microsoft money. I want to be able to just download the transaction history and input them into excel budget spreadsheet with minimal hassle. Anybody know how? Thanks.
Dora
2009
07.21
07.21
D_Icon asked:
I have an Excel spreadsheet, version 2003. I have a column of data in column Q. I want to see if any of the cell values in column match the cell values in column H. If it does, I want Excel to return the location of that cell.
I have an Excel spreadsheet, version 2003. I have a column of data in column Q. I want to see if any of the cell values in column match the cell values in column H. If it does, I want Excel to return the location of that cell.
Anyone know how to do this?
Hector
2009
07.18
07.18
Nicole R asked:
How do you feel about utilizing Excel to keep a list? Which features are good for lists?
Debra
How do you feel about utilizing Excel to keep a list? Which features are good for lists?
Debra
2009
07.14
07.14
SayWhat? asked:
I have all the information for my property owner association on an Excel file. I just bought a new database to store all the information on (called Data Village). How do I export the Excel file to the new database?
Crystal
I have all the information for my property owner association on an Excel file. I just bought a new database to store all the information on (called Data Village). How do I export the Excel file to the new database?
Crystal
2009
07.02
07.02
Adam A asked:
I need excel to output every possible sample of size n from a small population.
Eg from a population of three discrete numbers x, y and z there are 9 possible samples of size 2 (with replacement). I have tried the sampling tool in excel but this only draws random observation it does not give groups of possible samples. Any help on this would be much appreciated as i have spent a long time on this!!!
Thanks
Kristen
I need excel to output every possible sample of size n from a small population.
Eg from a population of three discrete numbers x, y and z there are 9 possible samples of size 2 (with replacement). I have tried the sampling tool in excel but this only draws random observation it does not give groups of possible samples. Any help on this would be much appreciated as i have spent a long time on this!!!
Thanks
Kristen