News for hackers. Stuff that matters.

A comment on Ask HN: Excel experts – Formula IDE in Excel (MVP screenshot) – is it useful?.

Re:Ask HN: Excel experts – Formula IDE in Excel (MVP screens... by philbroberts on Wednesday July 29, 2015 @10:53AM (#9969009)
Have you checked out PowerPivot? I've been developing in Excel for 15 years and created many a convoluted formula along the way. Two years ago I moved all Excel development to Powerpivot and I hardly write any formulas in "regular" Excel anymore. PowerPivot provides more of a formula IDE (along with DAX Studio), along with a ton of other functionality. I think it's clear that's the direction sophisticated Excel development is going.
[ Parent | on HN ]
Re:Ask HN: Excel experts – Formula IDE in Excel (MVP screens... by damian_r on Wednesday July 29, 2015 @03:54PM (#9971170)
I haven't seen that. I tried installing it on my Excel but it looks like kind of pro version is needed for PowerPivot. I'll try to find some more information on it. Thanks!
[ Parent | on HN ]