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

Browse by Tags

  • 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: , , , ,

  • VBA tip: Limit the number of times a file can be opened

    Suppose you want to send someone a demo workbook, but you don’t want that workbook to be used more than a certain number of times, perhaps because you want to be paid for your work. In today's VBA tip, Excel MVP Bob Umlas shows you how to limit the number of times a file can be used by using simple SaveSetting and GetSetting statements. ...( read more ) Read More...
    Filed under: , ,

  • Remembering Nathan (Nate) Oliver

    This week, the Excel team here at Microsoft received the tragic news that Excel MVP Nathan Oliver passed away unexpectedly. Nate was a vital member of the MVP community who loved sharing his vast knowledge of Excel with customers and fellow Excel enthusiasts. We’ll always be grateful to Nate for his countless contributions to various Excel forums and his insightful feedback to us about how to make Excel a better product. From the testimonials pouring in on the Microsoft MVP Facebook page, it’s...
    Filed under:

  • A capital idea: Changing case in Excel (video)

    Unlike Word, Excel doesn't have a Change Case button or keyboard shortcut for magically switching between uppercase, lowercase, and proper case. Now, that doesn't mean that you have to manually retype all your text. (In fact, the very thought of you doing that makes me weep.) Instead, you can use a function designed specifically for this job, or even a macro. Excel MVP Bill Jelen recently created a couple of videos that explain each of these techniques. ...( read more ) Read More...

  • Add Rank to PivotTable

      Today’s author is Mike Alexander, a Microsoft Excel MVP who shows us how to add a rank to a PivotTable in Excel 2003, 2007, and 2010. For more information, visit www.datapigtechnologies.com . Adding Rank in Excel 2003/2007 Step 1: Sort your pivot table on the data measure you are trying to rank. Step 2: Add a Calculated Field that will have the formula =1 . This will essentially assign a value of 1 to each row. Step 3: Right-click on your newly created calculated field and go into its Value...
    Filed under: ,

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

  • 10 Days for Office 2010 Series – Reviewing the Dow Jones Industrial in Excel 2010

    Today’s post was written by Excel MVP Nate Oliver. Excel 2010 presents traditional numerical analysts with new and old tools; today we’ll explore two of them. The difference is that the first shall be what we call qualitative, and the second, quantitative. As a real-world example, on a really hot day, qualitative could mean hot, while quantitative could mean 100F. We shall explore both, with Excel 2010, with respect to the Dow Jones Industrial Average (DJIA). Read more here... 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.