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

May 2011 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Portable Formulas: A PowerPivot Benefit You’ll Never Believe You Lived Without, Part Two

    Hello again, I’m back for part two. If you missed part one, I highly recommend reading it first , because this won’t make much sense on its own. Same Examples, This Time WITH PowerPivot OK, now we’re going to replay part one, but this time we are going to use PowerPivot. Let’s start with a basic PivotTable that looks like one of our first steps in part one. You check four checkboxes, and here’s what you’ve got: No Formulas Needed So Far… Just Four Clicks...

  • Where to begin: PowerPivot for Excel

    By now, you've probably read about PowerPivot in one or more of our many blog posts on this subject (such as Introducing PowerPivot , Using PowerPivot with Excel 2010 , or Supercharge your budget sheets with PowerPivot for Excel 2010 ), and you totally get the picture of how powerful this feature is. Its ability to process massive amounts of data from various data sources so that you can analyze it right in Excel 2010 is truly promising! But how exactly do you get started with it? Keep reading...
    Filed under:

  • Avoid losing the state of the global IRibbonUI ribbon object

    Excel MVP Ron de Bruin provides a solution for a common problem that occurs when you use RibbonX and VBA to customize the ribbon. You can find more tips and links to Excel add-ins at Ron's website: http://www.rondebruin.nl/ There is a common problem when you are working with the ribbon by using RibbonX and VBA. The ribbon object (which is initialized when Excel loads your file) can lose its reference to the ribbon, which means your code can no longer tell Excel to update your ribbon customizations...
    Filed under: ,

  • Make your data pop with conditional formatting

    You've got your numbers wrangled and organized just right, but they still don't jump out at the people who look at your worksheet. You want to give them the big picture at a quick glance. This is where conditional formatting can come to your rescue. The embedded worksheet in this post will show you three great examples of conditional formatting. Keep reading to learn more! ...( read more ) Read More...

  • Take the first step in growing your Excel skills

    It's hard to find time to learn new skills. We're all busy, and as much as we might want to become more proficient in something, we seldom have the extra time required to learn. That's one of the reasons I'm excited about the new video series, called the Excel skills builder. In a nut shell, the skills builder is a video series, comprised of short (typically under 5 minutes each) videos that give you an overview of a task or feature in Excel. The videos are grouped so that you can...
    Filed under: ,

  • Visualize this: Take our PowerPivot Quiz and Win an Xbox 360

    What kind of PowerPivot nerd are you? A Numbers Ninja? A Data Mining Wizard? Find out by taking our Nerdtastic PowerPivot Quiz on Facebook. Besides learning if you're the nerdiest PowerPivot user of them all, you'll automatically be entered to win an Xbox 360 + Kinect just for participating. So head on over to the PowerPivot Facebook page , take the Nerdtastic Quiz, and have your inner nerd revealed for a chance to win. ...( read more ) Read More...

  • Rockin' out with PivotTables

    We recently discovered this music video by youarentbenjamin on YouTube titled "PivotTables Make Everything Just Right." The video gives some serious love to PivotTables . Props for the creativity, and here's hoping they got an A+ for their group project! ...( read more ) Read More...

  • Portable formulas: A PowerPivot benefit you’ll never believe you lived without

    How much time do you spend in Excel doing basically the same thing over and over again, like calculating "growth versus prior year?" My bet is you spend a lot of time doing that sort of thing. Maybe even the majority of your time. The reason for that is that Excel formulas are not "portable." What do I mean by that? There are two ways in which Excel formulas are not portable...keep reading to find out more... ...( read more ) Read More...

  • Learn the ins and outs of dates and formulas in this free training course

    Have you ever wanted to subtract one date from another? Or find out how many workdays until vacation? Or maybe you need to figure out a project end date. You can do all of this and more by using date functions in Excel formulas. As long as you type a date in a format that Excel recognizes: 8/22/2011, 22-August-2011, or August 22, 2011, for example, Excel will interpret the date as a serial number, and you can use formulas to find important dates. For example, you can then use formulas to subtract...
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.