Macros, Pivot Tables & More in Zoho Sheet
Raju Vegesna April 28, 2008 09: 44 am
Our Zoho Sheet team just rolled out a milestone update to our spreadsheet application with a cluster of new features. There are more than 15 new features added to this update, but two key features really stand out for businesses - Macros & Pivot Tables.
This video gives you a quick introduction to these key features.
Macros:
Zoho Sheet now supports Visual Basic Macros - the ones you use in MS Excel. This is an important milestone for Zoho Sheet as it becomes the only Spreadsheet application that supports VB Macros apart from Microsoft Excel. We now understand Visual Basic and can execute Visual Basic code at the backend (no, we don’t run any MS stuff back there). This capability opens up new set of possibilities.
In the current version, Zoho Sheet lets you import your existing speadsheets with Excel macros or create new ones. We support a broad set of functions and we do plan to extend the list further. We also plan to add Record & Play for Macros going forward.
We are also launching a Wiki (http://vbmacros.wiki.zoho.com/) which is kind of a free marketplace for Macros. You can browse for sample Macros or share your Macros with others.
Pivot Tables & Charts:
As you may know, Zoho DB supports Pivot tables. This functionality is now extended to Zoho Sheet allowing you to create Pivot tables & Pivot charts on your structured data or from a range of spreadsheet data.
This unique integration between Zoho Sheet & Zoho DB brings in some new capabilities to Zoho Sheet. You can now import upto 100,000 rows of structured data to Zoho Sheet from a CSV file. Pivot tables and pivot charts can be created by simple drag and drop interface. 
Pivot Tables & Macros are just two of the key functionalities added in this update. Complete list is available here.
As you may have noticed, we are adding more depth to our existing applications apart from adding new apps. We believe in feature-rich business applications and you’ll see us improving and integrating our apps further.
As always, we can’t wait to hear your feedback on this new update.
Popularity: 24% [?]
Help others find this article:
[…] Related posts: TechCrunch, Mashable!, Webware, Zoho Blogs. […]
Great work guys. Keep the momentum high.
http://feedshub.blogspot.com/2008/04/online-office-vs-offline-office-zoho.html
Wow! Macros! I wouldn’t have expected you to roll out an advanced feature like that for quite a while yet. I’ve very excited to play with this now.
[…] More details at Zoho blog […]
[…] Fanno cose che talora stupiscono davvero. Ieri sera, ad esempio, mi sono accorto dell’introduzione di una serie di novità davvero stupefacenti: nel loro foglio elettronico (zoho sheet) adesso è supportato il motore delle […]
[…] thought about a runtime for VBA implemented in .Net… Zoho Sheet now has support for VB macros (via TechCrunch). Since this runtime is implemented in Java, I can’t imagine they support […]
Ok, that’s it, your software is now officially more powerful than my beloved Excel. I’ve never understood pivot tables until this video broadcast. I will now have all of my data in tabular format, please and thank you!
ZOHO - you rock. My business will be using your productivity suite to get things done.
Josh
Josh, thank you. I believe we can actually provide even richer functionality than the desktop, while actually being easier to use. After all, a site like Amazon packs just so much functionality yet all available in a very accessible way. That is what is coming to web based applications.
[…] they ofttimes demand the special tools. But Zoho is apace dynamical that. The consort fresh announced an overhaul to Zoho Sheets with hold for noesis individual features same parader tables and Visual Basic […]
[…] they often lack the specialized tools. But Zoho is quickly changing that. The company recently announced an overhaul to Zoho Sheets with support for power user features like pivot tables and Visual Basic […]
auto insurance washington…
auto insurance washington…
auto insurance settlements…
auto insurance settlements…