Excel filter-filter: How do I set up an easily adjustable filter for a 7000-odd row spreadsheet in Excel Mac 2004 or 2008? The data's not well organised and needs to be filtered over multiple columns. [more inside]
posted on Mar 20, 2008 - 5 answers

How do I add x and y axis labels to a chart in Excel 2008 for Macs? [more inside]
posted on Feb 15, 2008 - 2 answers

Probably ridiculously obvious Excel question: how do I set it so that a URL is never turned into a hyperlink? [more inside]
posted on Dec 19, 2007 - 7 answers

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 on Sep 1, 2005 - 5 answers

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 on Jan 13, 2005 - 2 answers

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.
posted on Jul 15, 2004 - 17 answers

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 on Jun 18, 2004 - 4 answers

Using Excel 2001 for Mac, is there any way to set up a column that can autocomplete using data from another column? If not, is there something that can handle this sort of thing?
posted on Apr 25, 2004 - 6 answers