I am looking for some good data visualisation books, tutorials and maybe software [more inside]
posted 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 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 on Apr 17, 2008 - 7 answers
MS Excel terror. Data saved but it is still gone. Where - if anywhere? [more inside]
posted on Jan 24, 2008 - 4 answers
Cleaning up imported data in excel using VBA. [more inside]
posted on Dec 21, 2007 - 1 answers
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 on Jul 2, 2007 - 10 answers
Your told you have a test in Excel regarding Data Manipulation, what do you revise? [more inside]
posted 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 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 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 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 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 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 on Apr 27, 2005 - 17 answers
