PivotTable this video

Steve Gillmor calls Office 2007 “Office Dead.” Oh, yeah Steve? Take this video of Excel 2007′s business intelligence features, er PivotTables, and stick it into your browser. Excel 2007 does stuff in minutes that used to take hours to do. You know, for a “dead” product I sure am having fun using all these “dead” new features! And I hear this video only shows a small fraction of what is great about Office 2007.

110 thoughts on “PivotTable this video

  1. ok, I’ll play village idiot, but where does one actually set up Pivot tables in 2007?

    I’m surfing all over the place and watching video’s and most start off with it already in place.

    I can’t see where in the top ribbon to access it. You’d think it would either be under Data or Review tabs.

    cheers
    tom

  2. ok, I’ll play village idiot, but where does one actually set up Pivot tables in 2007?

    I’m surfing all over the place and watching video’s and most start off with it already in place.

    I can’t see where in the top ribbon to access it. You’d think it would either be under Data or Review tabs.

    cheers
    tom

  3. Here’s the thing: use SPSS. No more terrrrrible pivot tables. AND you can do statistical analysis! And, of course, the REAL geeks use SAS.

    Excel should be limited to data layouts with pretty colors. All my powerpoint charts start in Excel. If you don’t know better, you use Excel.

    Here’s an example, we have Outlook, but management keeps schedules in Excel. And that’s your problem right there. You’re waaaay past the stage where features matter in Office.

  4. Here’s the thing: use SPSS. No more terrrrrible pivot tables. AND you can do statistical analysis! And, of course, the REAL geeks use SAS.

    Excel should be limited to data layouts with pretty colors. All my powerpoint charts start in Excel. If you don’t know better, you use Excel.

    Here’s an example, we have Outlook, but management keeps schedules in Excel. And that’s your problem right there. You’re waaaay past the stage where features matter in Office.

  5. Richard:

    I think the real PITA is figuring out what insane way it wants the data formatted in the spreadsheet in the fist place before you can slice and dice it. I know that the layout I’ve already built has never been acceptable to the PivotTable function. I suppose you have to know from the beginning you need a pivot table and lay your data out to suit the tool, but that seems kinda bass ackwards in the 21st century, doesn’t it?

    What would *really* be nice is a real multidimensional capability, like what used to exist in Lotus Improv and Informix WingZ, but with a better UI than either had. MS is actually pretty good at some UI stuff – I know it’s a hard problem to properly represent 3 or more dimensions on a 2D screen, but it’s possible if you think outside the box, and is the sort of thing we’re *willing* to pay MS for. (Although a different beast for sure, 3D CAD UIs are an interesting study here: Look at SketchUp for an example of really outside-the-box thinking in dealing with real 3D in a 2D interface environement. It’s the first significant advancement in geometry creation since Ashlar invented snap-to drawing assistants, and by far the easiest I’ve seen in real 3D. There may well be some lessons there for dealing with multi-dimensional data as well…)

  6. Richard:

    I think the real PITA is figuring out what insane way it wants the data formatted in the spreadsheet in the fist place before you can slice and dice it. I know that the layout I’ve already built has never been acceptable to the PivotTable function. I suppose you have to know from the beginning you need a pivot table and lay your data out to suit the tool, but that seems kinda bass ackwards in the 21st century, doesn’t it?

    What would *really* be nice is a real multidimensional capability, like what used to exist in Lotus Improv and Informix WingZ, but with a better UI than either had. MS is actually pretty good at some UI stuff – I know it’s a hard problem to properly represent 3 or more dimensions on a 2D screen, but it’s possible if you think outside the box, and is the sort of thing we’re *willing* to pay MS for. (Although a different beast for sure, 3D CAD UIs are an interesting study here: Look at SketchUp for an example of really outside-the-box thinking in dealing with real 3D in a 2D interface environement. It’s the first significant advancement in geometry creation since Ashlar invented snap-to drawing assistants, and by far the easiest I’ve seen in real 3D. There may well be some lessons there for dealing with multi-dimensional data as well…)

  7. MUI language files. Multinational companies have been entitled to these files so that their users can change the language of menus and help files as they move around their offices round the world. Why haven’t these files been made available to smaller companies, startups and individuals who also move around the world. It may not be the case in the US, but in Europe it’s not unusual that all members of the same family don’t speak the same language, or rather have a different mother tongue in which it is a lot easier to refer to in the help files. These MUI files exist. Why are they not released?
    Has this issue been discussed within Microsoft prior to the launch of Office 2007 and Vista?

  8. MUI language files. Multinational companies have been entitled to these files so that their users can change the language of menus and help files as they move around their offices round the world. Why haven’t these files been made available to smaller companies, startups and individuals who also move around the world. It may not be the case in the US, but in Europe it’s not unusual that all members of the same family don’t speak the same language, or rather have a different mother tongue in which it is a lot easier to refer to in the help files. These MUI files exist. Why are they not released?
    Has this issue been discussed within Microsoft prior to the launch of Office 2007 and Vista?

  9. Office 12 will be a success, Microsoft must be licking their lips in anticipation. Proof? If Google Desktop Search is any indication of user stupidity.

    How many idiots have installed this crap on their computers? This evil app came preinstalled on my Dell the other day, just say NO!

    Link: http://www.computerworld.com/securitytopics/security/story/0,10801,108845,00.html

    Google Desktop 3 is the latest version of Google Inc.’s desktop search application. The software’s “search across computers” feature allows users to search for information stored on other PCs and servers. To do this, Google stores an index of files contained on a PC running the software for 30 days, promising that the information is encrypted and accessible to a limited number of Google employees, according to Gartner.


    Love that part about being stored for 30 days, long enough for the government to subpoeana them? To de-crypt the contents of your hardrive. I can see a whole new class of spyware coming soon. Any hacker worth his salt will be creating their own versions of desktop search, this makes user acceptance so easy. How hard would it be to create your own version of Google Desktop search? Brand it the same, hell name it the same, but send the information to your own servers? This stuff is getting outta control.

  10. Office 12 will be a success, Microsoft must be licking their lips in anticipation. Proof? If Google Desktop Search is any indication of user stupidity.

    How many idiots have installed this crap on their computers? This evil app came preinstalled on my Dell the other day, just say NO!

    Link: http://www.computerworld.com/securitytopics/security/story/0,10801,108845,00.html

    Google Desktop 3 is the latest version of Google Inc.’s desktop search application. The software’s “search across computers” feature allows users to search for information stored on other PCs and servers. To do this, Google stores an index of files contained on a PC running the software for 30 days, promising that the information is encrypted and accessible to a limited number of Google employees, according to Gartner.


    Love that part about being stored for 30 days, long enough for the government to subpoeana them? To de-crypt the contents of your hardrive. I can see a whole new class of spyware coming soon. Any hacker worth his salt will be creating their own versions of desktop search, this makes user acceptance so easy. How hard would it be to create your own version of Google Desktop search? Brand it the same, hell name it the same, but send the information to your own servers? This stuff is getting outta control.

Comments are closed.