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

September 2011 - The Excel Team Blog

The Excel Team Blog
  • Go beyond the basic chart type

    Excel comes with lots of predefined chart types, including column, line, pie, and so on. However, many of you ask how to make other kinds of charts, such as floating column charts, Gantt charts, combination charts, org charts, flow charts, hierarchy charts, histograms, or Pareto charts. While none of these are available as predefined chart types, don't worry. There are ways to create these in Excel. ...( read more ) Read More...
    Filed under: ,
  • Clean up imported or pasted data in Excel

    When you bring data from other sources into Excel, it may not look the way you'd like -- numbers might have come in as text so that you can't sum them, dates might not be dates at all...you get the idea. Here's how to clean things up so your spreadsheet looks and works right. ...( read more ) Read More...
  • Get data into Excel by importing it

    If you need to get existing data into Excel, I can guarantee you the last thing you'd ever want to do is retype it. And copying from another program or from the web and pasting directly into a cell in a workbook might leave you with nightmarish looking results. Luckily for you, there's a much better way to get that data into Excel. Importing! Read on to learn about the Excel Text Import Wizard. ...( read more ) Read More...
  • Track the Rugby World Cup in Excel

    This post is brought to you by Diego Oppenheimer a Program Manager on the Excel team. It’s finally here, the rugby world cup starts tonight and along with it an Excel template to keep track of every single try. The template is available for download HERE . Want to keep track of the world cup everywhere ? I will show you how to easily download the template and save it with your Windows Live account in the cloud to keep track of every score or to play around with possible outcomes. 1. Download...
  • Speed up data-entry tasks by using End Mode

    The other day, I was filling out a huge Excel table, and I found myself needing to enter the exact same information in multiple cells. To save time, I used something called End mode in combination with the arrow keys on my keyboard to quickly select all the cells I needed to change. Many of my own coworkers have never heard of End mode, so I thought you might not know about it either. It's a handy status bar option, and in my opinion it's often easier to use than fill down when you need to...
  • Tips for making your embedded Excel experience sparkle

    When we show people examples of beautiful, interactive embedded Excel workbooks built with the embedded Excel Web App, they often ask one of two things: 1) (Excited) “How do I do that?” 2) (Skeptical) “Can I really make my own workbooks look as good as these examples?” We love to hear that first question, because this summer we shipped a new in-app embedding experience that makes things as easy as “open up a public workbook in your Windows Live SkyDrive and click 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.