Join 3,512 readers in helping fund MetaFilter (Hide)

22 posts tagged with excel and software. (View popular tags)
Displaying 1 through 22 of 22. Subscribe:

iPad iDiot

Help me turn my iPad into a work productivity tool. [more inside]
posted by sardonyx on Feb 17, 2014 - 10 answers

What are the best ways to increase Excel skills?

What are the best free and paid resources or training courses for Excel? [more inside]
posted by ramenopres on Jul 1, 2012 - 7 answers

Please help me create a calender on Microsoft Excel using dates in the spreadsheet from another tab.

Please help me create a calender on Microsoft Excel as I can't find any help online. [more inside]
posted by sockpim on Jun 25, 2012 - 3 answers

How do I create an amortization table where my payments change every period?

Is it possible to create an amortization schedule in Excel when the payment amount, the principal amount, and the interest amount each year is unique? [more inside]
posted by lea724 on Mar 29, 2012 - 16 answers

I don't think Fortran and punchcards cut it anymore...

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

Copy & pasting from Excel into Word

Is there a way to insert into a text string in Excel a "hard enter" so that when a series of rows of text are copied into Word that it automatically incorporates paragraph breaks between them? [more inside]
posted by notcostello on Jun 29, 2010 - 5 answers

Word I find software that can get to the root of this problem?

How do I obtain a list of all words associated with a list of word roots / stems? [more inside]
posted by hooves on May 13, 2010 - 6 answers

Printing an Excel file

Excel filter: How do I print a specific column on every printed page without having to physically insert the column to the beginning of every page? [more inside]
posted by jujube on Apr 22, 2009 - 3 answers

Why is Excel so incredibly slow on my Mac?

Why is Excel so incredibly slow on my Mac? [more inside]
posted by kdern on Apr 9, 2009 - 7 answers

In need of *easy* method for tracking multiple sources of income.

I want to simply my recording-keeping. Seeking an *easy* method for tracking multiple sources of income. [more inside]
posted by mintchip on Jan 2, 2008 - 8 answers

Champagne scheduling app on a beer budget.

OfficeApp Filter: How can I seamlessly convert lists of project assignment names and deadlines to a calendar view that can be shared? Or can I? [more inside]
posted by Marnie on Aug 22, 2006 - 4 answers

Understanding external references in Microsoft Excel?

It's very clear in Microsoft Excel how to calculate formulas using external references, but what isn't clear is how, in several worksheets, to have the same data in certain columns. How do I do this? [more inside]
posted by arimathea on Aug 8, 2006 - 9 answers

Visual data organization.

I would like to make a chart like this to track my daily computer usage. Any ideas on how I could do this? Any free software you can recommend? Any way of doing it with Excel? [more inside]
posted by bubukaba on Jun 1, 2006 - 6 answers

Can I get a hybrid text file/spread sheet?

I'd like a word processor that mimics Excel sheets. [more inside]
posted by oddman on Apr 14, 2006 - 10 answers

MS Excel Sorting

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

Chart and graph software (not Excel)

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

Can Excel talk to iCal?

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

Why does pasting excel charts into word cause the word file to become gigantic?

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

Crystal Ball software for the Mac?

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

Excel Hotlinking

Yo, skryche! 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 - 8 answers

Excel Spreadsheet Updating

Excel query. I have two Excel spreadsheets that I want to have automativally update each other. But, the format that they are in is generally incompatible. These are used as scheduling documents for the place where I work.

One spreadsheet is very wide. It lists each individual person at the top and their personal schedule below it. It lists breaks using "ONE" as the first half of a 30 minute block, "TWO" as the second half of a 30 minute block, and "LONG" as the entire 30 minute block.

The other spreadsheet is much less wide. It has 7 days listed and three columns. One is for "LONG" one is for "ONE" and the third is for "TWO." In each column, each person's name is entered in the appropriate block as defined in the first spreadsheet.

Can I get those two to talk to each other? Can I tell the first spreadsheet that if the word "TWO" is in a certain field to put the name of that person in another field on another spreadsheet?
posted by ajpresto on May 11, 2004 - 1 answer

Excel File Naming Question

MS Excel appends a 1 to the name of every file I open. How do I get rid of this? [more inside] [more inside]
posted by trillion on Feb 20, 2004 - 9 answers

Page: 1