CARVIEW |
Earn Rewards, Reputation, and Badges
Redeem the reputation points you've earned from participating in O'Reilly Answers for O'Reilly books, videos, courses, and conferences.
Learn more »
Recommended for You
Topics: excel
excel Feed
excel Open Questions Feed
excel Email
Open Questions via Email

Please sign in or register to post.

Please sign in or register to post.
-
How to Summarize Data Using Sparklines in Excel 2010
By kbnotes: 18 April 2010 - 06:51 AM
Creating charts in Excel 2010 workbooks enables you to summarize your data visually, using legends, labels, and colors to highlight aspects of your data. It is possible to create very small charts to ...
-
-
Microsoft Office Web Apps: I’m Becoming a Believer
By kbnotes: 11 April 2010 - 09:36 AM
In a little over a month, Microsoft will release Office 2010 and SharePoint 2010. As a part of Office, Microsoft will offer a suite of Office Web Apps—Excel, PowerPoint, Word, and OneNote--that will...
-
Begining mySQL for every day work and linking in and out of MS Excel
Asked by komMWM : 11 March 2010 - 07:40 AM
Answered by KBenson: Mar 17 2010 11:30 AM
(Skip to the bottom if you are ONLY interesting in the MySQL portion of the question) There's a few basic questions that need to be answered before you can really decide where to start. These ar... full answer >
-
Problem while creating drop-down in excel through jxl if size exceeds 14
Asked by SURESH_VAVNI : 25 February 2010 - 10:55 PM
Tags:
-
Perl and Python manipulation of Excel files ( and Numbers too)
Asked by donfox : 31 January 2010 - 06:03 PM
Answered by adfm: Feb 05 2010 10:50 AM
If you are interested in comparing how others have accomplished manipulating an Excel spreadsheet using each language, then I would refer you to this article about reading and writing Excel files with... full answer >
-
How to use R inside Microsoft Excel
By adfm: 20 January 2010 - 11:25 AM
Excel can be a safe comfort zone for some users, but sometimes you need access to more robust tools like R. Thankfully there's RExcel to bridge the gap. In this excerpt from Joseph Adler's R in a N...
-
Can XML, XSLT and XSD do the following:
Asked by Boubou : 06 January 2010 - 08:52 AM
Answered by simonstl: Jan 08 2010 12:15 PM
I'm not completely clear on what the capabilities of your database extraction system are, or how complex your data is. If the data is strictly a table, then exporting as XML (with an XML Schema) ... full answer >
-
Sorting an Excel worksheet using VBScript
Asked by LawrenceMW : 12 December 2009 - 11:53 PM
Answered by CurtFrye: Dec 19 2009 05:06 PM
Hi Lawrence, If you can't get your VBA to work, I recommend recording a macro, sorting the range in descending order, and using that code. I put data in the range A1:A5 and recorded this macro: ... full answer >
-
How to use Excel to compare two versions of a legal contract
By michaelmilton: 03 December 2009 - 09:50 AM
I had a chance to use Excel for this purpose and thought you might want to see the technique. Be sure to watch it on full screen HD! Michael Milton is the author of Head First Data Analysis and...
![]() ©2009, O'Reilly Media, Inc. (707) 827-7000 / (800) 998-9938 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
About O'Reilly Academic Solutions Authors Contacts Customer Service Jobs Newsletters O'Reilly Labs Press Room Privacy Policy RSS Feeds Terms of Service User Groups Writing for O'Reilly |
Content Archive Business Technology Computer Technology Microsoft Mobile Network Operating System Digital Photography Programming Software Web Web Design |
More O'Reilly Sites O'Reilly Radar Ignite Tools of Change for Publishing Digital Media Inside iPhone makezine.com craftzine.com hackszine.com perl.com xml.com Partner Sites InsideRIA java.net O'Reilly Insights on Forbes.com |