Statistics question: is it possible to test sets of cumulative data for significant differences in rate? [more inside]
posted by rollick on Nov 4, 2009 - 9 answers

How to merge data from two excel sheets into one? [more inside]
posted by willy_dilly on Oct 9, 2009 - 6 answers

What are some affordable alternatives to Tableau for data visualization, plotting, etc? [more inside]
posted by ttyn on Jul 29, 2009 - 4 answers

Excel - Pivoting With Dates [more inside]
posted by SirStan on Mar 25, 2009 - 3 answers

Excel charting help: Help me analyze sales stats based on salesperson tenure. [more inside]
posted by samuelad on Mar 7, 2009 - 6 answers

How to make clever visualizations from Excel or CSV data? Any free, flexible information-graphic scripting software out there? [more inside]
posted by anthill on Feb 23, 2009 - 10 answers

Automation Filter: How can I automate the insertion of data from a spreadsheet into a Word report template? [more inside]
posted by McBearclaw on Jan 6, 2009 - 8 answers

Am I distorting my data, and not showing the true picture? [more inside]
posted by matholio on Nov 18, 2008 - 9 answers

How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column? [more inside]
posted by niles on Oct 20, 2008 - 7 answers

My friend works in database applications each day to create in house reports. He's bored and wants to go it alone. [more inside]
posted by simplesharps on Sep 3, 2008 - 0 answers

Excel/Graphing - Time vs. usage (y/n) graph [more inside]
posted by SirStan on Aug 25, 2008 - 6 answers

I am looking for some good data visualisation books, tutorials and maybe software [more inside]
posted by tseo on May 29, 2008 - 9 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

Any Excel gurus in the room? I have an Excel spreadsheet with over 800 rows of data. Each row begins with a number (like 0001), and some have letters after the numbers (like 0001a). The Sort function doesn’t sort the way I’d like it to. [more inside]
posted by Milkman Dan on Apr 17, 2008 - 7 answers

MS Excel terror. Data saved but it is still gone. Where - if anywhere? [more inside]
posted by ollsen on Jan 24, 2008 - 4 answers

Cleaning up imported data in excel using VBA. [more inside]
posted by corpse on Dec 21, 2007 - 1 answer

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]
posted by beammeup4 on Jul 2, 2007 - 10 answers

Your told you have a test in Excel regarding Data Manipulation, what do you revise? [more inside]
posted by informity on Feb 13, 2007 - 11 answers

In MS Excel, how do I remove duplicates, clean up a document and merge two files together? [more inside]
posted by perpetualstroll on Feb 7, 2007 - 6 answers

I have a large excel spreadsheet that contains various html tags, mainly bold and anchor tags (in upper case and lower case). How can i automagically remove them? [more inside]
posted by anonaccount on Oct 27, 2006 - 9 answers

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

Excel experts? Between two Excel files, anyone know how I can reassign the data source file when I'm working on my Mac with files emailed to me by my boss, created on his PC? [more inside]
posted by seaward on Nov 9, 2005 - 3 answers

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

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