Hot answers tagged excel
10
Google Docs
Upload your existing files.
Google Docs accepts most popular file formats, including DOC, XLS, ODT, ODS, RTF, CSV, PPT, etc. So go ahead and upload your existing files.
Familiar desktop feel makes editing a breeze.
Just click the toolbar buttons to bold, underline, indent, change font or number format, change cell background color ...
9
Google Spreadsheets doesn't have Pivot Tables built in. For any serious data analysis that could be a real deal breaker.
However, it does appear that there are apps in the marketplace that add this functionality in, for example:
http://www.google.com/enterprise/marketplace/viewListing?productListingId=3466+14613093613005114004
8
I find the inability of Google spreadsheets to select noncontiguous rows or columns a serious limitation, particularly when formatting a spreadsheet. Keyboard shortcuts that will work on one platform but not another seriously hinders my use of Google docs in general. (That said, I use Google Documents a lot and wish I could use it for more.)
5
If you're just looking for rows/columns to insert data, then Google Spreadsheets are the way to go. Two really cool applications for Google Spreadsheets is using it to create a live Feedback form for any website (if you know how to edit HTML, then you can even take the attributes from the Google Form and use your own website's HTML and CSS to format the ...
5
Besides what's already been said:
Lack of text-to-column parsing.
That is, if I have a raw string like
Blah|2|4|5|www.google.com
Foo|2|1|1.2|www.twitter.com
It's trivial to have Excel quickly do a text-to-columns on that, using | as a delimiter. Making data formatting as simple as possible is crucial to people who need to create or interact with data ...
3
I am pretty sure that Google Docs does not quite do what you would like.
One neat feature in Docs for a spreadsheet is that you could make a form onto your sheet, and give people the form, where they enter their information, and select their name from a list, so you could sort on their data.
3
Per the official list of keyboard shortcuts, F2 is the only key responsible for editing a cell. I've just tried it in 3 browsers (Chrome 16, Firefox 9, and IE 9) and it doesn't function the same way as it does in Excel.
Your solutions are 1) pressing F2 before entering any data, 2) pressing Backspace to remove the characters you've typed after the error, or ...
3
There is a free application known as TrelloExcel out there. I've been using it for about a week or two now - https://github.com/dillenmeister/TrelloExcel
It will very nicely export/import data, but it doesn't seem to handle updating existing items. For what you need it for, I think it will work to get you the task name, description, and due date (but no ...
2
Logical operators such as OR return single values in array formulas, try instead:
=ARRAYFORMULA(SUM(IF(IF($C$4:$C$4000 <= H55; 1; 0)+IF($C$4:$C$4000 <> ""; 1; 0)+IF(($D$4:$D$4000 = "")+($D$4:$D$4000 > H55);1;0)+IF(($E$4:$E$4000 = "")+( $E$4:$E$4000 > H55);1;0)=4; 1; 0)))
2
This is a bit off topic because it doesn't answer the question of Excel exporting, but it does address the side of good solutions for burndown charts. We use Trello Burndown from Blue Line Game Studios. It does a pretty good job and everyone can update their piece so it's not dependent on sharing an excel spreadsheet. You can find that at ...
2
I think you can do what you describe with Forms & Spreadsheet in Google Docs.
Step 1: In Google Docs, select Create New > Form
Step 2: Create questions in "Edit Form" window.
Each question will be represented as a column in the spreadsheet that is being created in the background. (I assume you'll want "Name" and "Latest Score", so I'll use that ...
1
If you want to make sure that MS Excel 2010 files are properly converted and still work in Google Spreadsheets, then don't use the following formula's:
AMORDEGRC
AMORLINC
AREAS
ASC
AVERAGEIF
AVERAGEIFS
BAHTTEXT
BESSELI
BESSELJ
BESSELK
BESSELY
BETADIST
BETAINV
CALL
CELL
CHIDIST
CHIINV
CHITEST
CLEAN
COMPLEX
CONVERT
COUNTIFS
CUBEKPIMEMBER
CUBEMEMBER
...
1
There is no current functionality to do this (I'm not on the Beta, so I cannot test the Bulk Export functionality currently on offer, although it doesn't look like its what you need).
However, there is a card on the Ideas stack (sort of a feature request list), entitled CSV or Other Export. This looks like more what you want - however it's not implemented ...
1
The way you've stated it, that this is not a FORMATTING problem: you need to use a FORMULA to combine the data you have into a new data-value, in a new cell.
The nice thing about using a spreadsheet for this is that it's dynamic: if your source data changes, your derived data changes at the same time.
However as others have stated, the gmail ...
1
You don't have to create in one go the whole string because some clients have limitations regarding the number of recipients. You can simply create the desired format for each row and then select the ones that you want and paste them in client's field for BCC. You don't have to worry about the fact that you're copying cells instead of the string, because ...
1
You can find them using find and replace if you go to view -> all formulas (ctrl+') and then do you "round( " find this will at least cut down on the manual labor of it all
I couldnt find a way (using find and replace to search for wild card value though
EDIT:
Try out the script below
REF: ...
1
You can look at Wikicalc, an open source Wiki-Spreadsheet
http://www.softwaregarden.com/products/wikicalc/
And if you are not so fixed on using a spreadsheet-like user interface, why not a "standard" html form, with javascript to do the calculation ?
1
In Excel you would use a Pivot Table and in Google Spreadsheets you would need to use a Gadget. I tried it with the "Table by Google" gadget and it was straightforward though, I've used pivot tables before so it was very familiar.
Here is a more complicated example using a gadget I couldn't find.
1
Google spreadsheets formatting is limited compared to the newer versions of Excel (2007+). I have found it much easier to create usable spreadsheets with a decent UI using Excel than Google Spreadsheets - everything I do with the latter looks like Excel 2003!
Google spreadsheets does web interaction much better than Excel (retrieving info from the web such ...
1
I can't speak to a specific limitation but Google Spreadsheets do things differently than MS Excel. For instance if you need to program in excel you will use VBA. If you are going to program in Google Spreadsheets you will need to use javascript.
I am pretty sure that you will not get to keep your macro's when you import a spreadsheet from Excel into ...
Only top voted, non community-wiki answers of a minimum length are eligible
