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

August 2011 - The Excel Team Blog

The Excel Team Blog
  • Line or scatter chart?

    Ah, the great questions of life: Paper or plastic? Line chart or scatter chart? Choosing the wrong chart type for your data can easily happen when it comes to line and scatter charts. They look very similar, especially when a scatter chart is displayed with connecting lines, but there is a big difference in the way each of these chart types plots data along the horizontal and vertical axes. Let Excel writer Frederique be your guide as to which type of chart to use and when. ...( read more ) Read...
    Filed under:
  • Why not use Excel as your calculator?

    By now, you've gotten used to using digital calculators, such as the one in Windows or in your phone, and you know their limitations. Say you want to calculate mortgage interest or your grade point average. This is where it's time to make the move to Excel and see how it's a vast improvement over a simple calculator. ...( read more ) Read More...
    Filed under: ,
  • Making sense of dollar signs in Excel

    We've noticed some of you searching for help using "$" — a dollar sign. In Excel, a dollar sign can denote a currency format, but it has another common use: indicating absolute cell references in formulas. In this post, we'll talk a bit about both uses of the dollar sign. ...( read more ) Read More...
  • Apollo 11 & Excel – How did we do that?

    A couple of weeks ago, as part of our Watch History Reimagined series, we posted a video to show you how Excel might've helped the team at NASA work through some of the tensest moments in American history. Some of you asked us how we created certain visualizations that appear in the video. In today's post, we point you to the source workbook and data used to make the video and show you how to recreate a couple of the chart and slicer effects. Enjoy! ...( read more ) Read More...
  • How to do percentages in Excel

    Are you confused by how Excel handles percentage formatting, or by percentages in general? It's okay, you're not alone. In this post, find out more about how Excel displays percentages, and learn basic techniques for calculating percent decrease, percent increase, and percent change. ...( read more ) Read More...
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.