A Data Science Central Community
Listed on my personal website www.markmcilroy.com is my book titled 'A guide to writing Excel formulas and VBA macros'. The book is available for free download in PDF format. It is also available in print from Amazon.com.
Excel is widely used for all forms of data analysis once the bulk of the data has been processed and summarised using a tool such as SAS, SQL, etc.
While this book is relatively small it includes an overview of key…Continue
Added by Mark McIlroy on November 18, 2016 at 11:00pm — No Comments
Generally, Java programmers use poi or other open source packages to read and compute Excel data. These open source packages support low-level programming, which increases the overall learning cost and complicates the operation. But with the help of esProc, Java can avoid these problems.…Continue
Added by Jessica May on October 8, 2014 at 12:26am — No Comments
I have a 5-20K USD budget to get a tool (w/wo dedicated hardware), including training for 2 people, to prepare (clean, merge, etc...) and summarize (samples, grouping/aggregations, etc) large data sets (over 5GBs, over 4 million rows).
I need an efficient solution (fast data processing and fast to learn), and definitely easy to use. I would have done it with excel if excel could handle such large data files.
After preparing and summarizing the data, I'll use excel pivot tables…Continue
Excel® is the most widely-used spreadsheet tool. The nontechnical persons like to use it for computation and analysis. But they usually find the formulas and functions available in Excel® are rather poor and the VBA® is just double Dutch to them for further analysis. Thus, a huge volume of data with valuable information has been wasted in vain.
Hereby introduce a better solution to realize the utmost value of Excel® by taking the esProc advantages of powerful computation ability,…Continue
Added by Ben Hinchliffe on June 18, 2009 at 2:55pm — No Comments