Pierre DeBois

Don't Toss Excel Out Just Yet

NO RATINGS
View Comments: Newest First | Oldest First | Threaded View
Pierre DeBois
User Rank
Blogger
Re: Long live Excel
Pierre DeBois   1/12/2012 10:12:31 AM
NO RATINGS
aaphril and Louis,

 

Thanks for the comments - it was probably a while before an Excel API could be considered.  Think about Microsoft and VBA as an example - they pulled VBA out of the Mac version for Excel, but placed it back again in the latest version. VBA is stilled used, but there were some limits in seeing its value.  Given that some businesses were storing data in Excel is revealing - it means that any sort of programming, VBA or API, was not given a due consideration.

Ariella
User Rank
Blogger
Re: Long live Excel
Ariella   1/12/2012 8:27:48 AM
NO RATINGS
@aaphil; @Louis Exactly!

Louis Watson
User Rank
Blogger
Re: Long live Excel
Louis Watson   1/12/2012 12:59:28 AM
NO RATINGS

No question Excel will continue to be vital to analyst of all skill sets and experience. As well it should be, it is a very powerful tool and still well worth learning.  

I agree with Ariella when she says that those who complain about Excel obviously don't know much about it.


aaphil
User Rank
Blogger
Re: Long live Excel
aaphil   1/11/2012 11:37:34 PM
NO RATINGS
Not to mention that many 'custom' solutions are built using the Excel API. So the native functionalities of the platform works for alot things, it's just a matter of knowing how to use it.

Shawn Hessinger
User Rank
Blogger
A question of flexibility
Shawn Hessinger   1/11/2012 10:19:24 PM
NO RATINGS
Pierre,

Excel remains a useful enough tool for working with data even if presentation and modeling tools change. In the end, I think it is a question of flexibility. If Excel remains easy to use in conjunction with other tools, I think it will remain an important tool in the foreseeable future.

Pierre DeBois
User Rank
Blogger
Re: Long live Excel
Pierre DeBois   1/11/2012 2:13:42 PM
NO RATINGS
Beth,

Per usual you get to core of it - cost can be a driver if something is familar and seems to be a nofix.  But what is slippery for many businesses is that they can become numbe to changes that could enhance a tool already used.  I mention Excel because it really was an eye openner as to how many analytic app for ti have been created, even for Excel for Mac.  And many small businesses are still learning how having familar software like accounting applications, project management applications, and email are on the cloud, so there is a convenience in delivering services not avialable before

Pierre DeBois
User Rank
Blogger
Re: Long live Excel
Pierre DeBois   1/11/2012 2:05:43 PM
NO RATINGS
Ariella,

Thanks for the post. Much of the difficult stems from using Excel as a data storage in some firms early on. I think most by know understand that there's Access. let along other databases that are better equipped for long-term data management.  But as I wrote, much of that overlook comes from misuse of what a spreadsheet can do.

Ariella
User Rank
Blogger
Re: Long live Excel
Ariella   1/11/2012 12:15:12 PM
NO RATINGS
On another board I participate in, I've seen many negative views of Excel. The posters indicate that the only way to go is to get custom software. But I question if they really know what Excel is capable of. Sure, if you buy the software specialized for your industry, it will seem to be the best choice, but many of the functions built into such programs are already available on Excel.

BethSchultz
User Rank
Blogger
Long live Excel
BethSchultz   1/11/2012 8:25:29 AM
NO RATINGS
Yesterday I posted a blog that talked, among other things, about the mainframe's lasting stature in the enterprise -- despite repeated doomsday predictions. Now I know Excel and mainframes are two highly different animals, but I think the point remains the same. I don't expect to see the end of the venerable spreadsheet any time soon in the enterprise. Yes, other business tools and more advanced analytics capabilities will supplement and complement Excel's use -- but from some folks, especially within companies creating a culture of data-driven decision-making, Excel will be a hanger-on. 

 

Information Resources
More Blogs from Pierre DeBois
The Solid conference on new technology highlighted not only the opportunities for the Internet of Things but how analytics pros have to be deeply involved in IoT initiatives.
Some organizations are making early progress in capturing information in the Dark Social world of apps.
Vetting referral traffic is becoming essential to ensure accuracy and, in some instances, security.
Mobile moves to the forefront in analytics and Google's search algorithm plans, and that means you have to think about how your website's architecture serving the needs of the mobile world. Take a peek at what Google plans for April.
Data scientists are discovering R programming as an augment in data visualization and analysis.
Radio Show
Radio Shows
UPCOMING
James M. Connolly
Hire and Manage a Great Analytics Team


9/1/2015   REGISTER   0
ARCHIVE
James M. Connolly
Use Mobile Analytics to See the Big Picture


8/26/2015  LISTEN   83
ARCHIVE
James M. Connolly
Survive the Digital Transformation


8/18/2015  LISTEN   85
ARCHIVE
James M. Connolly
Health Analytics: Find Data Beyond the Hospital Doors


7/28/2015  LISTEN   47
ARCHIVE
James M. Connolly
Finding Answers Through Prescriptive Analytics


7/21/2015  LISTEN   117
ARCHIVE
James M. Connolly
Visualization: How to Bring Data to Life


6/22/2015  LISTEN   55
ARCHIVE
James M. Connolly
Learn Why Analytics Are at Home in the Cloud


6/15/2015  LISTEN   26
ARCHIVE
James M. Connolly
Analytics: Your Defense Against Cyber Threats


5/27/2015  LISTEN   60
ARCHIVE
James M. Connolly
Big Data & Big Pharma: How Analytics Might Save Your Life


5/19/2015  LISTEN   37
ARCHIVE
James M. Connolly
Live Interviews From SAS Global Forum


4/28/2015  LISTEN   11
ARCHIVE
James M. Connolly
How to Hire Great Analytics Talent


4/23/2015  LISTEN   51
Information Resources
Follow us on Twitter
Follow us on Twitter
Quick Poll
Quick Poll
Like us on Facebook
Like us on Facebook
About Us  |  Contact Us  |  Help  |  Register  |  Twitter  |  Facebook  |  RSS