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

March 2011 - The Excel Team Blog

The Excel Team Blog
  • Staying on budget might be easier than you think

    Ask most of your friends how they're doing, and they'll probably tell you how hectic their lives are. You may feel that way too. Sometimes just thinking about balancing work and family can be exhausting. A lot of you use and love Excel at work. It makes tasks faster, it keeps you organized, and it adds insight into all that data that surrounds you. You may already be taking advantage of those same Excel benefits at home too. After all, as many of us know, sometimes keeping a handle on data...
  • IF and only IF (video)

    This post is all about IF--not the poem by Rudyard Kipling, or the 1971 hit song by Bread, but the function . The IF function is used in many Office programs, but most of us know it from Microsoft Excel: IF(logical_test, [value_if_true], [value_if_false]) IF is one of the most searched-for words on Office.com, so we thought we’d compile some of our resources on IF so you can find them more easily. ...( read more ) Read More...
  • PivotTables can save the day in a budget crisis

    <div><img alt="DCSIMG" id="DCSIMG" width="1" height="1" src="http://m.webtrends.com/dcsygm2gb10000kf9xm7kfvub_9p1t/njs.gif?dcsuri=/nojavascript&WT.js=No" mce_src="http://m.webtrends.com/dcsygm2gb10000kf9xm7kfvub_9p1t/njs.gif?dcsuri=/nojavascript&WT.js=No"/></div> "); // --> This “Office Show” episode...
  • You asked about pivot table (video)

    So many Office customers ask about "pivot table" that we've gathered the best answers in this blog post. Most likely, you are looking for information about how to create a PivotTable report that can help summarize and analyze your data. Or you already have your data in a PivotTable report and are looking for information about how to pivot it. ...( read more ) Read More...
  • America's Debt: Get the Facts !

    The United States has a massive debt problem. Politicians have talked about why the country is in this position and what could be done about it. Tyler Chessman, the author of "Understanding the U.S. Debt," used data to get to the bottom of the issue. As a data expert, not an economist, Tyler analyzed data sets from several government sources using PowerPivot for Excel 2010 to determine where the problems lie. ...( read more ) Read More...
  • Try it for free: Count values that meet a condition with the COUNTIF function

    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 the embedded worksheet in this post. ...( read more ) Read More...
  • A capital idea: Changing case in Excel (video)

    Unlike Word, Excel doesn't have a Change Case button or keyboard shortcut for magically switching between uppercase, lowercase, and proper case. Now, that doesn't mean that you have to manually retype all your text. (In fact, the very thought of you doing that makes me weep.) Instead, you can use a function designed specifically for this job, or even a macro. Excel MVP Bill Jelen recently created a couple of videos that explain each of these techniques. ...( read more ) Read More...
  • Count your values with the COUNT function

    The process of manually counting values in Excel is time-consuming and error-prone, especially when you have a lot of data. Fortunately, there are a few automated ways to count values. From the questions we get from our customers about counting, it's clear that not everyone knows how to go about it. There are different methods, depending on what you want to count. ...( read more ) Read More...
  • New Excel 2010 resource center for IT professionals on TechNet!

    Are you an IT Pro who works with Excel 2010? If so, be sure to check out the new 2010 resources page on TechNet. This page is full of information for the IT Pro, including links to online articles, whitepapers, blogs, and videos. The resources on this page cover everything from migration and compatibility information to overviews of Excel Services and Excel Web App. ...( read more ) Read More...
  • Format column sparkline charts using the data axis and cell merging

    Sparkline charts are great, but there may be times they need a little visual massaging to maximize their usefulness. Consider this scenario: You have a system for which you want to track downtime over the course of a year and (fortunately) it had downtime events in only four of twelve months. Here's how to use and format sparkline charts to show this data effectively. ...( 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.