Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

March 2010 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • More Excel 2010 Posts

    There’s some more Excel news, ads, and articles showing up.  Check out this post on the Office blog to see a couple of videos on the introduction of sparklines to Excel, one made by us and another by MrExcel … and since we’re on the topic, below is a couple of recent videos from MrExcel that feature sparklines:   Episode 1195 - Add shading to your sparklines to specify acceptable ranges. Episode 1194 – Add labels to your sparklines. Read More...
    Filed under:

  • More about collaborative editing in Excel Web App

    Thanks to Dan Parish for writing this blog post. In today’s post, I’m going to delve into some of the finer details of collaboration using Excel Web App. If you haven’t already read Collaborative Editing Using Excel Web App however, please start there. It goes over what is supported, how it works, our presence UI, as well as some interesting collaborative scenarios that this feature opens up. Today’s post is really a “Part II” to that post. Multiple Browser Windows Excel Web App allows you to collaborate...
    Filed under: ,

  • Change charts, represent +/-, and count the Mondays between 2 dates

    Bill Jelen has been running the MrExcel podcast for years now. For those that haven’t heard of it, it’s a frequently updated video podcast that teaches you Excel, showing everything from the basics of the fill handle to advanced tips around charting, and everything in between … including some recent tricks with linked pictures. Since there’s a lot of great information in his videos, we thought that a weekly (or so) wrap-up of his podcast would be a nice thing to add to the blog. If you have ideas...
    Filed under:

  • Hover Charts

    Thanks to Dan Battagin for writing this blog post. OK, so I'm sure everyone knows about the Freeze Panes feature in Excel - it's been around forever, and it's pretty useful in certain circumstances where you want to keep a row (or more) of data at the top of the sheet, or column on the side of the sheet - especially for filtering. Of course, we've made it a little less necessary in the 2007 and 2010 releases, since table headers (2007) and now table filters (2010) automatically camp...

  • PowerPivot Alpha Geek Challenge

    There was a recent contest with PowerPivot, see the details of the contest here: http://wildfireapp.com/website/6/contests/19877?order=recency&view_entries=1   There were some great PowerPivot reports submitted, including some from our MVPs: Bill Jelen created a “Tag Cloud & SmartArt Updated Via PowerPivot!” report:   Tushar Mehta created a “Visualize US population trends over the last 150 years” report: Check out all of the entries here: http://wildfireapp.com/website/6/contests...
    Filed under: ,
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.