post

Macros For Dummies

I’ve never made a secret of the fact that my spreadsheet skills are somewhere at the level of what I learned using Lotus 1-2-3ūüôā¬† so the recent addition of Macros and Pivot tables to Zoho Sheet was really not my piece of cake.¬† Not that I would not recognize the techological feat when both Google and Editgrid said they couldn’t / wouldn’t do it…

Now I have to admit I occasionally tinkered around with Excel macros: not that I know Visual Basic, all I ever did was record the sequence I needed, then tinker with the resulting VB code.¬† That’s the capability Zoho just announced today: with a few clicks record, edit, re-run your macros, in the original Zoho Sheet or in any others you have access to.¬† Finally, Macros For Dummies like me ūüôā Here’s a summary video:

To the best of my knowledge no other spreadsheet can do it (other than GrandDaddy Excel)

Reblog this post [with Zemanta]
post

Spreadsheet Macros and Pivot Tables: Google Says No. EditGrid Says No. Zoho Just Does It.

OK, OK, I admit, the title is a bit tongue-in-cheek… but real. Sophisticated Excel users have long complained that none of the online spreadsheets support Macros or Pivot Tables. The answer has so far been sorry, no can do…

Google hinted they would likely not do it, as reported by TechCrunch:

Will Google Spreadsheets ever have advanced features like pivot tables, macros or offline database integrations? (This was actually my question) Scott said they are constantly trying to find the balance between speed and utility. It will never be a heavy duty analytics program because that would be too heavy and bulky for the average user.

EditGrid’s David Lee also suggested Pivot Table are too difficult to do online. Well, maybe, but here they are both, in Zoho Sheet. Not that it comes a real surprise, in fact ever since the launch of Zoho DB pivot tables were just a matter of time, and Zoho has promised macros for some time, too.

I admit I probably don’t appreciate the importance of these two features, as I’ve said before, the level of my spreadsheet competency is probably stuck somewhere at Lotus 1-2-3. smile_wink. But even I used very limited Excel macros in the past, although typically be recording and editing afterward, rather than writing them in Visual Basic. Now Zoho Sheet can interpret VB directly, without using Microsoft’s back-end, and that means you can import your Excel spreadsheet, the macros no longer die. No other spreadsheet (other than Excel itself) supports VB macros.

Zoho launched a “marketplace” -sort of, being free – of VB macros at http://vbmacros.wiki.zoho.com/

As for pivot tables, they are an important analytical tool, but instead of reading me, why don’t you look at this demo video: