Microsoft Excel is a spreadsheet application. It isn't appropriate on this site to ask direct Excel questions, but some questions for online spreadsheet apps will refer to it.
2
votes
1answer
864 views
How do you insert an Excel sheet as part of a new mail message?
How do you insert an Excel sheet as part of a new mail message? I tried inserting a MS Excel document directly / via a Microsoft document. But when I copied into a new Gmail message, the formatting ...
0
votes
1answer
57 views
Excel to Google Spreadsheet problem
I emailed an Excel spreadsheet as an attachment to my Gmail account.
I then chose open as a Google Spreadsheet.
When I opened the Google Spreadsheet, it was missing some formulas and had changed some ...
2
votes
3answers
2k views
Are Excel formulas and Google Spreadsheet formulas the same?
I want to be sure all my Google Spreadsheet work can be converted OK to Excel. How many of the Excel formulas match the formulas of Google spreadsheets?
3
votes
3answers
419 views
Google Spreadsheets equivalent of Excel CLEAN() formula
I've created an Excel file where a non-technical co-worker of mine organizes a bunch of data into rows and columns.
I then have formulas concatenate across those rows and columns and add some HTML ...
23
votes
8answers
7k views
What limitations does Google Spreadsheets have in relation to Microsoft Excel
Office licenses are expensive. What features of Microsoft Office are missing from Google Spreadsheets that would be of value in ordinary personal or business use?
0
votes
2answers
222 views
embed google / microsoft excel spreadsheet
I'm searching for few hours for a web app which allows me to create a spreadsheet and embed in to my webpage.
I've looked through Microsof Excel Webapp and Google spreadsheets but none of them allow ...
0
votes
0answers
679 views
Is it possible to sync a GCal calendar with an Excel/CSV file and/or Google Spreadsheet?
I keep track of the concerts I'm attending with a spreadsheet, which I primarily edit in Google Drive and sync to my computer using Syncplicity. What I would like to do is sync this spreadsheet, in ...
0
votes
0answers
143 views
Using an Excel file in a web application
I currently am using a macro-enabled Excel sheet that gives me an output based on several input fields with client specific information. I want to automate the process of entering the input values, by ...
9
votes
3answers
2k views
How do I Export Data to Excel
I am using Trello as the Scrum tool of choice but need a way of exporting data to populate my burn down charts.
We are using Google Chrome but have data security concerns, so exporting to Excel is ...
0
votes
0answers
168 views
Converting and Excel to Google Spreadsheet
I am trying to convert an Excel Spreadsheet to a Google Spreadsheet, but after it is converted, the document is smaller in size. How can it get it to be the exact size that I uploaded?
6
votes
1answer
8k views
How to easily select multiple cells in Google Spreadsheets?
How do I select multiple cells in Google Spreadsheets (non related cells, other cells between them)? In MS Excel I just press Ctrl and click on all the cells, in Google Spreadsheets it doesn't work. ...
1
vote
0answers
117 views
Google Docs capabilities
We've created a commission calculator to help our resellers work out what commissions they will receive on a deal.
We built it in Excel 2010 but want to move it to a web based platform that will ...
5
votes
5answers
225 views
Replacement for Excel [closed]
We have a small team of 20 people who use basic spreadsheet functions to share daily reports between us for our clients. We'd like to switch to a web-based product vs using Excel.
What do you ...
1
vote
2answers
461 views
How to write a logical function that checks several columns and rows
I have three columns in my Google Spreadsheet:
C (Dialog) - D (Declined) - E(Answered)
All the columns are dates. Example:
C D E
14/02/2012
28/02/2012
...
1
vote
3answers
430 views
formatting excel sheet to organize data properly
I have an excel sheet which has approximately 2000 Rows.
The columns are First Name ,Second Name, email 1, email 2
I want to be able to use all these contacts in one go in gmail in following format
...
2
votes
2answers
674 views
How to count how many cells in a column are below a certain date, AND check if other cells in the current row are empty?
I need to count how many cells in a specific column are below a certain date. Also, at the same time, the counter should only be increased, if some other cells next to each cell being counted are ...
6
votes
0answers
770 views
How do I get my data out of Trello? [duplicate]
Possible Duplicate:
Is it possible to export my data from Trello, to back it up?
Is there a way (or is it planned) to export Boards, Lists or specific cards to an external downloadable file ...
2
votes
1answer
1k views
What is the equivalent key in Google Docs Spreadsheet to Excel's F2 for editing a cell?
In Excel
When you want to edit the highlighted cell, and you don't want to move back to the previous cell when pressing the <- key, you press F2.
Pressing F2 ensures that when you're editing the ...
2
votes
3answers
698 views
How exactly does sharing work in Google Docs?
I have an Excel spreadsheet I made to track my own scores for an XBox game I play (TrialsHD, if you are curious). I've made it available to other players so they can track their own scores, but it ...
1
vote
1answer
2k views
Is there a way to search and replace a regular expression in Google Docs spreadsheets?
The problem is that I entered a lot of formulas like =round(x+y) into a Google Docs spreadsheet. Now I need them exported to MS Excel and the latter only accepts =round(x+y,0) as a valid format. ...
1
vote
2answers
593 views
open source analogs of google doc
I am looking for open source analogs of google docs that could work with word and excel.
Or maybe some script that can convert .doc to html and than back to .doc
0
votes
1answer
866 views
Embedding an excel like spreadsheet with formula calculations?
I wish to create an Excel-like spreadsheet which gets a few simple inputs (let's say 3 cells with the input of a number), where then a fourth cell will calculate the sum of the square of the three ...
1
vote
0answers
46 views
Web App for Deduplicating 2 CSVs
I'm looking for a web service that will allow me to deduplicate 2 CSVs.
I'm looking for a web service that allows me to upload 2 CSVs, specify which column in each should be the basis for the ...
2
votes
1answer
385 views
Graphs with Google Spreadsheets - collapse data into one 'category'
I have a set of data which is similar to the following:
Groceries 5.00
Groceries 14.75
Groceries 6.37
Dinner Out 43.50
Dinner Out 15.00
I'd like to be able to use this data to ...
