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

November 2011 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Excel as a project management tool

    It goes without saying that Microsoft Project is THE program to use if you need to manage large projects. But what if you manage smaller projects? Can you do that in Excel? Sure, but life will be easier if you start with a template that is specifically designed to facilitate project management. With that in mind, PowerPoint expert Glenna Shaw created a free project plan template for tracking projects in Excel. You can use this template to estimate time and costs, create a project schedule, manage...
    Filed under: ,

  • When a macro won't cut it, try a VBA script

    This post written by Daniel Ferry, an Excel MVP, chronicles how he and Beth Melton, a fellow MPV, designed a Gradebook template in Excel that makes teachers’ lives a whole lot easier. Several teachers, however, wanted to make the template even more useful. They asked us whether the template could batch print all student progress reports at once. To tackle this task, we knew recording a new macro wouldn’t cut it. I needed to write a VBA script. Here's how I did it. ...( read more Read...

  • Data’s got a brand new bag: PowerPivot for Excel (video)

    There's lots of data out there: LOTS. The digital universe is about eight hundred thousand petabytes (that's eight hundred million gigabytes). Your business is no doubt contriubting to that number and needs a way to work with it. PowerPivot is a free add-in for Excel that can link multiple spreadsheets or even link to databases. That means you can work with millions--emphases on the "s"--of lines of data. Excel also has another tool to help you slice through data, which I'll...

  • The Excel part of mail merge

    Hey, the holidays are fast approaching, which means you've got to get your cards signed, sealed, and delivered! This post goes out to those of you who keep your address list in Excel and need to figure out how to use it to create mailing labels in Word . Creating labels can be intimidating, mainly because there are a number of steps and you're typically working across different programs—in this case, Excel and Word. Read on to learn best practices for preparing your address list in...
    Filed under: , ,

  • Now where on the network did I save my workbook?

    If you commonly share workbooks that are saved on your network, consider adding the Document Location box to your Quick Access Toolbar. This box shows you exactly where your workbook is located. If you can see the path, you can easily paste it into an email message and send it to people. This is way better than sending around big file attachments! ...( read more ) Read More...
    Filed under: , ,

  • Poll your friends with Photo Vote

    What should I wear to the party next week? Which hair style suits me best? Your Facebook friends no doubt have strong opinions about these weighty matters, so why not create a quick poll and let the people decide? In this post, we'll introduce you to Photo Vote, a new app created by the Microsoft Office Labs team. With Photo Vote, you can create quick polls in Facebook, gather input from your friends, and then geek out on your results in Excel. ...( 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.