Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » All Tags » Templates (RSS)

Browse by Tags

  • Simplify management of an Excel Power View template by using a VSTO add-in

    Templates are one of the cornerstones in modern professional Excel development. By using one or more templates, we can provide a structural approach for end users to acquire, store and present data. From a development point of view, we can simplify the maintenance. In this tutorial, Excel MVP Dennis Wallentin shows how to simplify management of a Power View template by using a VSTO add-in. ...( read more ) Read More...

  • Generate invoice numbers in Excel

    If you need a way to create invoices in Excel, feel free to use one of the many invoice templates on Office.com. While these templates are a great starting point, they won't automatically generate unique invoice numbers for you—you need a macro for that. Fortunately, Excel MVP Bill Jelen created a short video that shows you how to create just such a macro. Enjoy! ...( read more ) Read More...
    Filed under: , , , ,

  • 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...

  • Easy budget management with Excel

    In post #8 in the Ten Days of Office series, we're celebrating the one-year anniversary of the release of Office 2010 by providing you with tips and tricks to get the most from your Office experience. In today's economy, smart money management is a necessary skill. Whether managing the family budget , planning college expenses , or budgeting for your upcoming wedding , Microsoft Excel can help you track the latest numbers, even while on the go with Excel Mobile 2010 on your Windows Phone...

  • 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...
    Filed under: ,

  • Wedding budget planner template: From good to great in under 5 minutes (video)

    Planning a wedding can be really fun or really stressful. OK, to be honest, it's usually a little of both. Figuring out where to seat Aunt Mildred at the reception and how to convince all your bridesmaids that yellow taffeta really does look pretty can be hard enough. Now imagine trying to coordinate and keep track of your expenses and overall wedding budget. While it can't really help you with the yellow taffeta problem, Excel can help you keep your budget on track. As part of the 5-minute...
    Filed under:

  • Use Excel to track your projects

    Troy Chollar is a designer and the owner of TLC Creative Services, Inc ., a multimedia and graphic design firm located in San Diego, CA. Troy is also a Microsoft Most Valuable Professional (MVP) for Microsoft PowerPoint. Read this post to see how Troy set up one example of a worksheet that tracks multiple design elements in a project that's spread among three designers, and download his template. ...( read more ) Read More...
    Filed under:

  • Business expenses and invoice templates: From good to great in under 5 minutes (video)

    Last week, I showed you some easy ways to make your budget in Excel even better in just a few quick steps. This week, I want to share some tips for improving your business expense sheets and invoice templates, all in under 5 minutes. Check out these videos and helpful templates to get started. ...( read more ) Read More...
    Filed under:

  • College student and household budgets: From good to great in under 5 minutes (video)

    If you're like me, and you're still trying to get started on your New Year's resolutions, hope is not lost. If you made a resolution around getting your budget set up or organizing your monthly financial expenses, you're in luck. There are some great Excel templates and videos available to show you how to turn your monthly budget spreadsheet into a work of art, all in under 5 minutes! And if you don't already have a budget spreadsheet, there are even some great templates to get...
    Filed under: , ,

  • 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...
    Filed under: ,

  • Free Excel templates save time for busy parents, students, and teachers

      This week’s post is written by Amy Miller. Amy is a writer for Office.com.     For many of us, our kids are now back in school, and the reality of packed lunches, homework assignments, and hectic schedules are a new reality. If you’re a teacher, your life just got extra busy too. Juggling your own life, along with that of your children, can be a daunting task. And keeping a classroom of kids (or, shudder , teenagers) running smoothly is time consuming. Luckily, Excel is here to Help...
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.