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

November 2010 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Switching to Excel 2010? Start here…

    There are lots of great reasons to step up to Excel 2010 from an earlier version. Some of the new features— sparklines , slicers , PowerPivot —were enough for me to take the plunge personally. If you’ve recently upgraded to Excel 2010, or are just about to do so, I want you to know that we have resources available that can help you through the transition. If you’re upgrading from Excel 2007, it won’t take you long to figure out Excel 2010. For the highlights, I’d recommend scanning the What’s New...

  • New Excel Developer Roadmap on MSDN

    This blog post is brought to you by Allison Bokone a technical writer for Excel. With the wide variety of solutions available for automating, customizing, and extending Excel, it can be hard to determine which technology to use. And even if you know which solution you want, it can be hard to find all of the related documentation you need to get the job done. That’s why we’ve created the Excel Developer Roadmap . The Excel Developer Roadmap gives you an overview of the available Excel...

  • Sparklines: tiny charts show the big picture

      Today’s blog post is brought to you by Judi Hurlock, who writes Excel online training for Office.com.   I write free training courses for Office.com. My job is to learn new features, and the tried and true, and to pass that learning on to you. Recently I heard about a new feature in Excel 2010 called sparklines. I couldn’t tell just by the name what the feature was. But when I found out that a sparkline is a tiny chart, the proverbial light bulb turned on, and I realized this was something...
    Filed under: ,

  • Add Rank to PivotTable

      Today’s author is Mike Alexander, a Microsoft Excel MVP who shows us how to add a rank to a PivotTable in Excel 2003, 2007, and 2010. For more information, visit www.datapigtechnologies.com . Adding Rank in Excel 2003/2007 Step 1: Sort your pivot table on the data measure you are trying to rank. Step 2: Add a Calculated Field that will have the formula =1 . This will essentially assign a value of 1 to each row. Step 3: Right-click on your newly created calculated field and go into its Value...
    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.