Subscribe to DSC Newsletter

All Blog Posts Tagged 'Excel' (5)

Free book on Excel formulas and VBA macros

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

A use case to read and analyze Excel data in Java

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

Help Needed! Getting a user-friendly tool (or system) to prepare large data sets for analysis...

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

Added by Ahmed on October 22, 2013 at 2:16pm — 13 Comments

Realize the utmost value of Excel for Users

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 Daisy Ding on July 8, 2012 at 11:30pm — 4 Comments

Inference for R version 3.5: Inference in PowerPoint Makes its Debut

I am happy to announce the release of Inference for R version 3.5. This is a significant release for Inference that includes several major features requested by users:



• Inference in PowerPoint: Embed and run R code in PowerPoint presentations just as you can in Word and Excel.



• Run-in-Place: Execute R code inside of an Excel, Word, or PowerPoint document and see the code results immediately in the same document – “preview” how your document will execute without having to… Continue

Added by Ben Hinchliffe on June 18, 2009 at 2:55pm — No Comments

Monthly Archives

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

On Data Science Central

© 2019   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service