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

October 2010 - The Excel Team Blog

The Excel Team Blog
  • Q & A: Things you really want to know about Excel IF function

      Today’s post is brought to you by Frederique Klitgaard. Frederique is a writer on Office.com   To follow up on my previous post about the IF function , in which I showed you a very simple application of this formula, I want to address some questions about the use of this function that come up regularly. As pointed out to me, the grading example isn’t the best one for the IF function, but I think it still helps illustrate the answers to the following questions. You asked: Can the formula...
  • Pulling RSS data into Excel (or: Using Excel to Search Craigslist) - Part 2

    This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. You'll remember last time that we'd built a spreadsheet that searched Craigslist via the RSS feed that's available for search results, and pulled the information into Excel using the little-used XML Map feature. Today, we'll continue on where we left off, adding the ability to search multiple sites, and adding a little progress indicator in case the search takes a long time. Oh, and at the end...
  • Create a bulleted list in a cell

    Today’s blog post is brought to you by Gary Willoughby. Gary is a writer on Office.com who has created and edited content about Excel, Access, and Project. For those of you who like bulleted lists and are frustrated that you can’t insert one in a cell, there is a way to insert bullet points in a cell to emulate such a thing. Just keep in mind that this isn’t a true list, so you can’t generate more bulleted lines by inserting a new line – you have to insert a bullet character on each line. That said...
  • Grid Computing + Excel = Amazing !

    Check out this video on the collaboration between the Microsoft High Performance Computing team and Excel: http://www.facebook.com/video/video.php?v=477293906954 Read More...
  • Summarize Spreadsheet Data With Excel's Array Formulas

      Today’s author is Charley Kyd, an Excel MVP, who has worked with spreadsheets in business since 1979, and has written books on spreadsheet use for McGraw-Hill and Microsoft Press. In 1990, he also created the first-ever Excel dashboard. You can find more useful tips and posts from Charley and other Excel MVPs at his website, ExcelUser.com   Subtotals can reveal very useful management information. For example, managers might be interested to learn that sales increased by 10% last month...
  • Pulling RSS data into Excel (or: Using Excel to Search Craigslist) - Part 1

      This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. OK, so I'm going to talk a bit about a relatively unknown feature in Excel: XML data import. It was introduced in Excel 2003, but we've done a pretty good job hiding it since Excel 2007 by putting it on the Developer tab of the Ribbon. I'm going to make the topic even a bit more geeky by using it in conjunction with VBA. In exchange, I'm going to produce, at the end, a nice little solution...
  • Extending Excel® to Build Models for You

      Today’s author is Richard Petti President and Co-founder of Modelsheet. For more info http://www.modelsheetsoft.com . Microsoft has enhanced Excel® in many ways to help build spreadsheets easily and reliably. Every one of us has made spreadsheets for a wide range of applications ranging from sales forecasting, to a scorecards for fantasy football. In order to build our model, we first conceptualize what we need, familiarize ourselves with the necessary algorithms and methods, and then build...
  • VLOOKUP: No more #N/A

      Today’s blog post is brought to you by Anneliese Wirth, who writes about Excel for Office.com.   To grow your skills with Excel, it’s helpful to familiarize yourself with a core set of functions, or predefined formulas that are built into Excel. One of my all-time favorites is VLOOKUP. If you’re new to VLOOKUP, we have a free, entry-level training course available on Office.com that can get you started. If you’re familiar with VLOOKUP, you’ve no doubt seen this before: #N/A errors really...
  • Top 5 Ways PowerPivot Helps Excel Pros

      This blog post is brought to you by Rob Collie CTO at PivotStream. Former co-founder of the PowerPivot team and Lead PM for Excel at Microsoft, broad-spectrum geek and cruncher of sports stats.   Hello Excel Pros! I’d like to start by saying this: You are my kind of people. I’ve met hundreds of you over the years that I worked on Excel (and other teams) at Microsoft, and I meet more of you all the time today. I like to think of myself as one of you, in fact. I know the “secret,” that...
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.