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

June 2010 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • The analytics of the World Cup in Excel with PowerPivot

    This post is brought to you by Bruno Aziza, WW Strategy Lead for Microsoft Business Intelligence. The Soccer World Cup is watched by billions around the world and many have tried to use models, from macro-economic to financial ones, to predict the outcome of the world cup. Our team and partners have put together a set of tools and videos to help you experience a more “analytical” world cup. See our intro video here ! · Start by enrolling in the World Cup Challenge to win prizes...

  • Excel 2010 Games: Missile Command and Tower Defense

    Thanks to Mauricio Acevedo, Nathan Shomber, Karen Cheng, and Manpratap Suri for putting together this blog post. It's official, Office 2010 is out! To celebrate, we've created two games that are playable in Excel for you to download. Missile Command Tower Defense To play, you'll need - · Download games here · To install Excel 2010, hot off the press last week. You can get a free trial here . The games use features that are new to Excel 2010, so they won't work in older...

  • New Visualization Types in Excel

      This post is brought to you by Scott Ruble , Senior Program Manager in Excel.     Over the last year, we’ve written a number of articles on the new capabilities of Excel 2010 . Several of these were related to new charting features in Office 2010. Here is a quick list of them. · More Charting Enhancements in Excel 2010 · Improvements to Chart Performance · Chart Object Model in Word & PowerPoint These improvements were well received; however, we understand there is a pent up...

  • Importing Text Files in an Excel Sheet

    Today’s author is Jan Karel Pieterse, an Excel MVP, who describes the process of importing text in great detail. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ . In this article, I'll explain how to ease importing of .txt, .prn and/or .csv files into an existing sheet in Excel. Introduction If you've ever tried to open a text file, you have probably used the Text import wizard. If you have ever opened a CSV file, you have probably noted you can't...
    Filed under:

  • Solutions to Three Common Problems when Using VLOOKUP()

    Today’s author is Greg Truby, an Excel MVP, who addresses some common issues you may encounter when you use the VLOOKUP function. This article assumes a basic familiarity with the VLOOKUP() function, one of the easiest ways to lookup up a key value in one worksheet or block of data and return a related piece of information from a second worksheet or block of data.   When using VLOOKUP() we frequently find ourselves facing three common problems: ·         We...
    Filed under:

  • [Deadline Extended] Excel 2010 Developer Challenge - Soccer Edition

    We had some issues with our entry submission e-mail so we are extending the challenge end date to July 5 th , 2010: o If you already submitted your entry but have not received a confirmation e-mail, please re-submit your entry to emanb@microsoft.com before July 5 th , 2010. o If you are new to this challenge , this is a unique opportunity for you to join. If you’re into developing Excel-based applications, then participate in the Excel 2010 Developer Challenge- Soccer Edition! We’re looking...

  • Office Web Apps Now Available on Windows Live

    We are excited to announce that today Office Web Apps are available on Windows Live. The initial release is available to Windows Live customers in the USA, Canada, Great Britain and Ireland with support for English, Spanish (USA) and French (Canada). More languages and locales will be added over the coming months. This release includes Word, PowerPoint, Excel and OneNote. The ability to edit Word documents and open OneNote notebooks is included. Not only do we want you to try these web apps, we also...

  • Running a SQL Stored Procedure from Excel (No VBA)

    Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. For more useful articles and videos, visit www.datapigtechnologies.com . We all know we can use MS Query to get data from a SQL server. Typically though, we pull from a Table or a View. Well in some organizations, the IT department wants all interaction with the server to be done through Stored Procedure. This adds a level of risk management and makes the DBAs feel better. So today...
    Filed under:

  • Excel Team Favorite Keyboard Shortcuts – Part 3

    Today’s post is brought to you by Chad Rothschiller a Program Manager on the Excel team. In Part 3 of my series on Excel shortcuts, I’m going to focus on a few miscellaneous shortcuts that help out with daily tasks. F4 – Repeat Use F4 to repeat the last thing you did, a great shortcut especially if the action just took several clicks. For example: · Inserting cells to the right · Applying complex formatting to a cell (could also use the format painter) · Inserting more rows or columns (after the...
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.