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

May 2012 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Our eight best Excel tutorials on charts

    Excel spreadsheets are all about numbers. But tons of numbers are often not the most effective way to communicate what you want. That's where charts come in handy. Charts can display numeric data in a graphical format, making it easy to understand large quantities of data and the relationships among data. If you want to learn about Excel charts, you've come to the right place. We've pulled together out best tutorials and articles to get you started. ...( read more ) Read More...

  • What's the dif? Gridlines vs borders in spreadsheets

    A lot of you want to know the difference between gridlines and borders. Gridlines help you work in a spreadsheet, and borders help you highlight important information in one for your audience. Gridlines appear automatically so you can see how your data is organized into rows and columns; borders need to be added by you so you can highlight certain cells. This post describes how to work with both of them. ...( read more ) Read More...

  • Split and recombine data in URLs

    Issue: I have a list of URLs with their corresponding page views. The URLs include a section of the site and the date when the page was published. I'd like to calculate the total number of page views by site section and the total number of page views by publication date. I want to reduce the time it would take to manually enter this data into new columns. To save time, I plan on using the Text to Columns wizard and Concatenate function rather than a complex formula. Once you learn the steps,...

  • Quick Trick: Resizing column widths in pivot tables

    Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way. In this first one, she shows us how to change the default width of a column in a pivot table. Knowing this is especially helpful when you're working with data that that makes a row really long. ...( read more ) Read More...
    Filed under: ,

  • Updated! Try it for free: Count values that meet a condition with the COUNTIF function

    Update: See near the bottom of this post for the latest Office how-tos on embedding Excel and PowerPoint files on web pages. You probably know how to use the COUNT function to count cells that contain a value. But what if you want to count only the cells that meet a condition, such as being greater than or equal to a number or date you specify, or that matches text? That's where the COUNTIF function comes in really handy. Keep reading to learn more, and try out this great function for free using...
    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.