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

August 2012 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Introduction to the Data Model and Relationships in Excel 2013

    This post is brought to you by Diego Oppenheimer a Program Manager on the Excel team. I am very happy to be writing this blog post today. Not just because I will be showing you another way Excel can make your data analysis easier but also because I will be introducing the new Data Model and Relationships features that will hopefully change the way you use Excel for data analysis forever. ...( read more ) Read More...

  • Select multiple names from a dropdown List

    Our guest blogger and Excel MVP award winner, Debra Dagleish, makes it easy to create an Excel dropdown list that lets you select multiple names in one cell. The magic to her method is adding a few lines of VBA code--a trick just about anyone can learn, even if you don't know programming. ...( read more ) Read More...

  • Plug into your data: Connecting Excel to an Access database

    Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But first you need to create the connection. ...( read more ) Read More...
    Filed under: , ,

  • Flash Fill:

    This post is brought to you by Chad Rothschiller a Program Manager on the Excel team. Today I’m proud to be writing about a new feature in Excel 2013 called Flash Fill that makes all of those tasks very simple for even the most novice user. Several years ago, I wrote a blog post demonstrating how to do string manipulations like the above examples. The problem is that the solutions relied heavily on using formulas, which can feel quite complex and intimidating for people not as familiar with...
    Filed under: , ,

  • The Excel Button - Bringing Excel Everywhere

    As Dan mentioned in his blog post, there’s data all over the web , and with the Excel Button we are giving you a way to get deeper insights with nothing more than the click of a familiar looking button. In this post, I’ll go a little deeper into the hows and whys of this new awesome feature. What is it? The Excel Button, also known as the Excel Interactive View, is like the Facebook like button for data on the web. When you find an Excel Button, click it and you’ll see the simple...
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.