Pierre DeBois

Don't Toss Excel Out Just Yet

NO RATINGS
View Comments: Newest First | Oldest First | Threaded View
Zimana
User Rank
Blogger
Re: Long live Excel
Zimana   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!

louisw900
User Rank
Blogger
Re: Long live Excel
louisw900   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.

Zimana
User Rank
Blogger
Re: Long live Excel
Zimana   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

Zimana
User Rank
Blogger
Re: Long live Excel
Zimana   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 struggle to learn how customers engage with IoT devices as part of customer experience is real. Here is how marketers can approach strategies with analytics reporting that monitors related traffic in real time.
The rise of services based on artificial intelligence is adding more variety and reporting challenges in analytics. Here are tips for marketers to look for in managing AI influenced metrics and reports.
Is an emphasis on encouraging managers to understanding technology masking a need to understand a management framework that mesh digital and real-world concerns?
With more ways to engage customers there are more ways to cross legal boundaries. A look at how marketers can avoid pitfalls.
O’Reilly Media’s OSCON featured how open source is influencing business operations at every level. Analytics practitioners looking to manage advance tactics should pay attention to the lessons learned.
Radio Show
A2 Conversations
UPCOMING
James M. Connolly
Retail Analytics: See Where Style Meets Statistics


12/6/2016   REGISTER   0
ARCHIVE
James M. Connolly
Why the IoT Matters to Your Business


11/29/2016  LISTEN   45
ARCHIVE
James M. Connolly
Will Data and Humans Become Friends in 2017?


11/22/2016  LISTEN   40
ARCHIVE
James M. Connolly
We Can Build Smarter Cities


10/20/2016  LISTEN   31
ARCHIVE
James M. Connolly
Visualization: Let Your Data Speak


10/13/2016  LISTEN   70
ARCHIVE
James M. Connolly
How Colleges and Tech Are Grooming Analytics Talent


9/7/2016  LISTEN   56
ARCHIVE
James M. Connolly
How Machine Learning Takes Handwriting Recognition to New Levels


8/25/2016  LISTEN   40
ARCHIVE
AllAnalytics
A Look at Tomorrow's Data Scientist


8/9/2016  LISTEN   83
ARCHIVE
James M. Connolly
Analytics and the Making of a President


7/21/2016  LISTEN   76
ARCHIVE
James M. Connolly
Analytics: Where We've Been, Where We're Going


7/12/2016  LISTEN   48
ARCHIVE
James M. Connolly
How Predictive Analytics Can Take Your Company to the Next Level


6/28/2016  LISTEN   22
Information Resources
Quick Poll
Quick Poll
About Us  |  Contact Us  |  Help  |  Register  |  Twitter  |  Facebook  |  RSS