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

May 2010 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Track the Soccer World Cup scores with Excel®

    This blog post is brought to you by Diego Oppenheimer a Program Manager on the Excel team. As we approached the 2010 World Cup in South Africa, and continuing on a theme from a couple of weeks ago , I set off to create an Excel template that was as automated as possible; with not a single line of VBA code but with conditional formatting , formulas , and the camera tool feature; I wanted to create the ultimate couch companion for the hours I have planned to spend in front of the TV waking up at 4...

  • Excel Team Favorite Keyboard Shortcuts – Part 2 of 3

    This post is brought to you by Chad Rothschiller a Program Manager on the Excel Team and is Part 2 of his ongoing series on the Excel Team’s Favorite Keyboard Shortcuts. In Part 2 of this series on Excel shortcuts, I’m going to focus on a few shortcuts that help out with the absolute essence of Excel: Formulas.   F2 – Edit Mode For starters, pressing F2 is a convenient way to start editing a formula in a cell: it places the cursor at the end of the formula so you can make quick additions. Before...

  • 10 Days for Office 2010 Series – Reviewing the Dow Jones Industrial in Excel 2010

    Today’s post was written by Excel MVP Nate Oliver. Excel 2010 presents traditional numerical analysts with new and old tools; today we’ll explore two of them. The difference is that the first shall be what we call qualitative, and the second, quantitative. As a real-world example, on a really hot day, qualitative could mean hot, while quantitative could mean 100F. We shall explore both, with Excel 2010, with respect to the Dow Jones Industrial Average (DJIA). Read more here... Read More...

  • Excel Team Favorite Keyboard Shortcuts – Part 2

      This post is brought to you by Chad Rothschiller a Program Manager on the Excel Team and is Part 2 of his ongoing series on the Excel Team’s Favorite Keyboard Shortcuts.   In Part 2 of this series on Excel shortcuts, I’m going to focus on a few shortcuts that help out with the absolute essence of Excel: Formulas. F2 – Edit Mode For starters, pressing F2 is a convenient way to start editing a formula in a cell: it places the cursor at the end of the formula so you can make quick additions...

  • Excel Team Favorite Keyboard Shortcuts – Part 1 of 3

    In this series of posts I’ve decided to walk through some of my favorite Excel keyboard shortcuts and a few other little tricks I’ve learned along the way that helps me work faster. In fact, when visiting some analysts in financial services, I learned that when they get trained on Excel, the instructor actually unplugs the mouse from the classroom computers in order to really drive home the efficiencies that can be gained from keyboard shortcuts. But when I say these are my favorites what I really...
    Filed under:

  • Announcing the Microsoft Business Intelligence Indexing Connector

    Or what I like to call BISearch in 13 languages and available immediately! As many of you know, we acquired FAST and have been hard at work integrating the technology with SharePoint.  One of those integrations was using FAST’s great ability to help users find their BI reports locked away in Excel and SQL Server Reporting Services.  With this new Indexing connector, users have a dedicated Report tab where they can find the reports they are looking for, use refiners to further narrow their...

  • Soccer World Cup Developer’s Challenge

    Some people think football is a matter of life and death...I can assure them it is much more serious than that.  Bill Shankley, 'The Sunday Times' (London) , October 4, 1981 + = " border="0" alt="clip_image001 " src="http://blogs.msdn.com/blogfiles/excel/WindowsLiveWriter/MICROSOFTEXCEL2010DeveloperChallengeSocc_AB96/clip_image0016.jpg" width="114" height="101" />+ " border="0" alt="clip_image001 " src="http://blogs.msdn.com/blogfiles/excel/WindowsLiveWriter/MICROSOFTEXCEL2010DeveloperChallengeSocc_AB96...

  • PowerPivotPro – Excel, SharePoint, and PowerPivot

    An interesting post on PowerPivotPro about Automating a report using Excel, SharePoint, and PowerPivot: “Let’s say you don’t have much need for handling large data volumes, your organization isn’t large enough to worry about spreadsheet robustness/business intelligence/one version of the truth, and you haven’t yet seen what DAX can do for you in pivots. Or maybe you get some of that, but don’t really understand this whole SharePoint thing. If you are in either of those boats, here’s an example from...
    Filed under:

  • Microsoft Excel 2010 Developer Challenge - Soccer Edition

    Some people think football is a matter of life and death...I can assure them it is much more serious than that.  Bill Shankley, 'The Sunday Times' (London) , October 4, 1981 + = " border="0" alt="clip_image001 " src="http://blogs.msdn.com/blogfiles/excel/WindowsLiveWriter/MICROSOFTEXCEL2010DeveloperChallengeSocc_AB96/clip_image001%5B6%5D_thumb.jpg" width="91" height="81" /> + " border="0" alt="clip_image001 " src="http://blogs.msdn.com/blogfiles/excel/WindowsLiveWriter/MICROSOFTEXCEL2010DeveloperChallengeSocc_AB96...
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.