For a project, I'm trying to collect uses of Excel that do not include any formulas or other use of math. What are some common documents that people use the format of Excel to create in an office setting? [more inside]
posted by sweetkid on Oct 26, 2012 - 68 answers

I need to quickly figure the 9th and 20th business days of each month for the rest of 2012 and all of 2013. Preferably not in a manual fashion. [more inside]
posted by reenum on Sep 14, 2012 - 6 answers

Excel skills required for a particular job… I'm not sure what they are asking for. [more inside]
posted by anonymous on Dec 6, 2011 - 9 answers

Which programming languages are best suited to creating a timetabling application? [more inside]
posted by bister on Jun 26, 2011 - 16 answers

Help with Excel 2003... More inside: [more inside]
posted by Mastercheddaar on Mar 9, 2010 - 7 answers

How do I create an inventory database using Excel? [more inside]
posted by Seeba on Jul 14, 2009 - 10 answers

Can I download only OpenOffice Writer? [more inside]
posted by ptsampras14 on Jun 18, 2009 - 4 answers

Spreadsheet question: Display Greater Value? I know this is one of those "you-either-know-it-or-you-don't" situations, and I just don't know. [more inside]
posted by guptaxpn on Feb 5, 2009 - 6 answers

I'm using Microsoft Excel 2003 at work and I need to make a chart where the category (x) axis is the y axis; is there any way of doing this? [more inside]
posted by Rustbeard on Apr 30, 2008 - 5 answers

I've got two columns in MS Excel. They each share 200 numbers. However, one of the columns has an additional 700 numbers. I want the column with 900 sorted in ascending order, with like numbers from the column of 200 beside those in the column of 900. How do I do that?
posted by panoptican on Feb 8, 2006 - 18 answers

Microsoft Excel. Is it possible to insert some "alarm" function that will notify me if I insert duplicate text in later cells? [more inside]
posted by Amizu on Dec 7, 2005 - 4 answers

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 - 5 answers

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 - 0 answers

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 - 10 answers