Is there an excel version of writely.com? In other words, I need to find a free, collaborative, spreadsheet app hosted online. Does it (or something close to it) exist?
posted by limitedpie
on Oct 17, 2005 -
I'm looking for advice on teaching basic Excel skills to adults in a classroom setting. [more inside]
posted by jessamyn
on Oct 10, 2005 -
ExcelFilter: I know how to import a text file into Excel using the wizard for fixed column widths. Can I automate the process? [more inside]
posted by Lokheed
on Oct 5, 2005 -
Is there a quick way to create a mail merge directory in Word from an Excel spreadsheet, broken down by a specific field (department, category, etc.)? This seems like a Microsoft 101 question, but the built-in Help doesn't seem to address this specifically, and online help
from Word 2002 gets into code I can't even begin to understand. [more inside]
posted by pzarquon
on Sep 7, 2005 -
Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table? [more inside]
posted by clgregor
on Sep 2, 2005 -
I need help finding or creating a macro to transliterate Cyrillic characters to their Latin-alphabet, English-language "equivalents" without doing a massive find-and-replace by hand. [more inside]
posted by michaelkuznet
on Sep 1, 2005 -
Excel - I am interviewing a couple of people tomorrow for an admin job within my team. One of the things we want to check is their proficiency with Excel. Does anyone know of a site that has a downloadable Excel spreadsheet that we could give them as a test
posted by lloyder
on Aug 24, 2005 -
Is there a way to prevent a Pivot Table (in Excel) from displaying a row with all zeros? [more inside]
posted by grateful
on Aug 10, 2005 -
Timecode filter: how do I subtract a given number of frames from 400 timecodes in an Excel spreadsheet? [more inside]
posted by forallmankind
on Jul 5, 2005 -
Help me get a professional massage!
What is a "named range" in Excel and how do I create one? I cannot import an .xls file into her outlook contact folder until I address this issue. [more inside]
posted by sourwookie
on Jul 5, 2005 -
I have a number of Excel files with thousands of small bitmap images embedded. I need to extract these into individual files which a designer can put into Quark and match up with the original text. [more inside]
posted by skarmj
on Jul 5, 2005 -
I used to think I was good at Excel. I could add, subtract, multiply and even use PivotTables! But I have a big problem with Excel: Why does it jump to cell 65,000 occasionally when you try to copy and paste? [more inside]
posted by Happydaz
on Jul 4, 2005 -
I have a complicated Excel valuation spreadsheet. The "bottom line" is affected by about 20 variables. I'm comfortable fixing about 17 of them, but for the remaining three, I wish to output to a 4x30 matrix, consisting of parameters A, B, and C, and the bottom line value that corresponds to each of the three. As it stands now, I can plug and chug, but it's a bit unwieldy, and I may wish to make a bigger matrix soon (I'll keep the 4 parameters, but I may wish to go 4x100 or the like).
I can't reverse engineer the entire spreadsheet-- it would take forever. So, how do I build this matrix? [more inside]
posted by Kwantsar
on Jun 23, 2005 -
Suddenly, when I double click on an Excel document to open it, it won't open the document (specific details inside): can this be fixed without reinstalling Excel or Office? [more inside]
posted by anastasiav
on Jun 16, 2005 -
When I try running long complex macros in MS Word for OS X, created in Office for Mac OS 9.2, some of the macros are freezing/crashing. Perhaps even worse, the macros don't seem to be failing at the same point each time I try to run them. [more inside]
posted by ParisParamus
on Jun 15, 2005 -
Follow up Filter. Last week on AskMe I asked for help getting a formula
to calculate "future value" in excel. blue mustard came through with the perfect answer: "fv = pv (1+r)n + pmt ((1+r)n - (1+q)n) / (r-q)" Now, I need to have a formula I can plug into excel that solves for q in blue mustard's formula. [more inside]
posted by wtfwjd?
on Jun 9, 2005 -
Dear Excel Gods, please tell me there is an easy way to do this. I am so stuck! I am using FV (Future Value) to figure out the return of an investment. But, as it says in the excel help, "[FV] Returns the future value of an investment based on periodic, constant payments and a constant interest rate." The payment I am getting is not
constant, but rather itself grows by a constant interest rate each period. So what equation or formula do I need for that? [more inside]
posted by wtfwjd?
on Jun 2, 2005 -
Is there some way to link an Excel spreadsheet and Word document such that a portion of the Word document will update automatically from changes in the Excel file? [more inside]
posted by nelleish
on May 30, 2005 -
I'm working on my MA thesis and so have an enormous jumble of books, articles, and references kicking around. I am looking for an easy way to manage this. [more inside]
posted by synecdoche
on May 4, 2005 -
I dumped a week's worth (about 1400 rows) of successful connection data from my company's VPN concentrator logs into a .csv file containing the following columns (A through D): Date, Time, Username, Source IP. I am trying to filter the list in Excel so it only shows the most recent connection data per username, but I can't figure out how to accomplish this programmatically. [more inside]
posted by pmbuko
on Apr 27, 2005 -
I want to use Excel's mail merge feature to make students ID's. In order to do this, I must be able to insert photos into specific cells. When I insert a picture it just lays on top across whatever cell happen to be behind it.
Is there a way for me to get pictures into specific cells?
posted by leapingsheep
on Apr 24, 2005 -
I was hoping someone might have insight into why, when I filter row of text in Excel for Unique Values, i.e., no duplicates displayed, I still get some duplicate rows. Has anyone experienced this? Again, it's text that I'm working with; not numbers.
posted by ParisParamus
on Apr 6, 2005 -
Mathematical imbecile question: what's the simplest, most universal way to add a list of vectors? [more inside]
posted by Jimbob
on Feb 19, 2005 -
I am looking for software that will generate charts and graphs that isn't Excel. [MI] [more inside]
posted by donovan
on Feb 16, 2005 -
Excel Purgatory - Help!
How do I take an average of two individual data items within in a field in a Pivot Table? (More Inside) [more inside]
posted by JPD
on Feb 10, 2005 -
I need a simple hand held scanner that will scan text and allow the scanned text to be converted to something that can be imported into Excel or a database as text. Any suggestions? [more inside]
posted by spicynuts
on Feb 8, 2005 -
Embedding linked Excel 2003 worksheets in a Word 2003 document for portability is giving me pains! [mi!] [more inside]
posted by hominid211
on Feb 4, 2005 -
Excel formula question. Using Excel as an employee scheduler and need to help trying to create a formula for tracking. [more inside]
posted by cyniczny
on Feb 1, 2005 -
Is there a plug-in or macro for Excel v.X or Excel 2004 for Macintosh that adds PivotChart (from Excel 2003 for Windows) functionality or compatibility?
posted by AlexReynolds
on Jan 13, 2005 -
EXCEL FILTER: I have an entire column of 12 digit numbers with dashes (X-XXXX-XXXXX-X-X) and I need to delete the first five digits (and two dashes) so I can sort the numbers starting with the sixth digit. Is this possible? (more inside) [more inside]
posted by Slack-a-gogo
on Jan 7, 2005 -
I have an Excel document listing dates times and other information. I'd like to import this "calendar" to iCal but cannot figure out to get the information imported properly. I found this tool
, but couldn't get it to work. I also found this application, iCal Maker
but it doesn't seem to work either. Anyone have an idea on how to import a bunch of events listed in an Excel document to iCal? [More Inside] [more inside]
posted by pwb503
on Dec 19, 2004 -
How do I change the matrix of the legend in an Excel chart? I have 1x6, and I want 3x2.
posted by trharlan
on Nov 19, 2004 -
: I don't see an easy one-function way to get the initial letters of a text string in Excel. Is there such a beast? [=Text(MI)] [more inside]
posted by mwhybark
on Sep 29, 2004 -
Excel Question - Is there a way in Excel to evaluate whether a cell contains text that is in all caps as opposed to proper (first letter) caps. I know I can force cells into Upper or Proper, but I don't want to do that, i just want to flag and sort them.
posted by willnot
on Sep 23, 2004 -
How do I format cells in EXCEL to accept numeric values in the form: -26:32 (or +26:32 ... that is, mm.ss but including the pos/neg sign)? I'm trying to compile a simply list of Messier Objects (astronomy) and can't figure out how to include declinations.
posted by RavinDave
on Sep 14, 2004 -
I have a mountain of data to move from dozens of Excel spreadsheets into an Access database. The database is an existing one and sort-of documented. How do I go about doing this? I’m very comfortable with Excel, but not at all with Access---I’ve never used it before. How do I push Excel data into Access records? Are there any web resources I could use? Any books I should buy?
posted by bonehead
on Aug 19, 2004 -
I need to use Excel's FIND function to locate open-parentheses, but since parentheses are part of the syntax of the function itself, it's choking. How can I escape the character to make this work?
posted by scarabic
on Aug 6, 2004 -
Microsoft Excel 2000 v 9.0 - is there some way to stop excel from automatically turning email addresses into hyperlinks? Not just turning off the 'blue and underlined' format but actually not making them links. I've done it before in other versions of excel but I can't find a way to do it in this version. Thanks!
posted by anastasiav
on Jul 16, 2004 -
ExcelFilter: I've got a specific problem in mind [inside for the curious/helpful], but more importantly I'm looking for an advanced tutorial for excel. I'm looking to go from someone who is confident with excel to being a full-on pro. Books are ok, but I'd prefer internet (i.e. free) resources. I am using Office v.X for Mac, but I think most techniques will translate pretty well across platforms. I'm looking for things like recursive formulas, modeling theory, little-known tools/techniques, pivot tables, etc. [more inside]
posted by rorycberger
on Jul 15, 2004 -
I'm looking for a good, but very basic Excel tutorial. I'm somewhat familar with computers at large, but suddenly faced with an office productivity application my eyes are rolling up in my head and I'm drooling liberally. [more inside]
posted by elwoodwiles
on Jul 10, 2004 -
: I have an Excel spreadsheet where one column is filled with dates — but the dates aren't showing up properly in the spreadsheet. Instead of looking like a date, they are flat numbers (02/29/2004 is rendered "36584" in the display) — even though the proper date is revealed in the FORMULA BAR as I select each cell. I've set the text type to DATE in the FORMAT dialog... I've even tried setting the text type to PLAIN TEXT. No go. Strangely, the numbers increment with the date (03/07/2004 is "36591"), so I'm guessing there's some equation going on. Suggestions on getting the dates to render properly would be appreciated.
posted by silusGROK
on Jun 25, 2004 -
Is there a way to cut'n'paste charts from Excel into Word, without generating huge Word files? I've tried varieties of paste, 'paste special,' and so on, and I can't figure out why an Excel file of charts that's several hundred KB, always turns into a Word file that's at least several MB. I guess I'm missing something obvious, but have no idea what it is.
posted by carter
on Jun 24, 2004 -
I've recently realized that Crystal Ball
is incredibly powerful and cool. Unfortunately, it isn't available on a mac. Anybody know of equivalent software/plugins for the Mac version of Excel?
posted by rorycberger
on Jun 18, 2004 -
! How do I keep Excel from hotlinking URLs as I paste them into cells? I use spreadsheets to store, sort, and transform lots of URLs. But Excel seems to think that anything beginning with "http://" is something I want blue and underlined and hotlinked for easy clicking. It doesn't happen right away, only once I leave the cell does it become a hot link. I'd like Excel to just leave my text strings alone. I don't want to launch a browser window every time I click in a cell that contains a URL. And I'm tired of doing the right-click-remove-hyperlink thing every single time. Formatting the column as plain text before dropping in the URL *doesn't* work. As soon as you paste a URL into a cell, Excel wakes up, decides to "preserve the formatting" of your pasted text, and voila! A nice blue hot link. Is there a preference I can un-check for this?
Sorry if this is a stupid one. I can't find anything in the help documentation or via Google that solves my stupid problem.
posted by scarabic
on May 28, 2004 -