Results for:
MVP

• Using conditional formatting to highlight dates in Excel

  4 Apr 2013

  This tutorial on using conditional formatting to highlight dates is brought to us by MVP Frédéric Le Guen , with special acknowledgment and thanks to Ken Puls for assistance with translation from French to English. Date functions in Excel make it is possible to perform date calculations...
• VBA tip: Limit the number of times a file can be opened

  4 Jan 2012

  Today’s VBA power tip is brought to you by guest blogger Bob Umlas . Bob is a long-time Excel MVP and author of Excel Outside the Box , from which the text below is excerpted. In addition, Bob organized the Excel User Conference , which takes place this year on March 29-30, in Atlantic City, New...
• Remembering Nathan (Nate) Oliver

  7 Dec 2011

  This week, the Excel team here at Microsoft received the tragic news that Excel MVP Nathan Oliver passed away unexpectedly last weekend. 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...
• A capital idea: Changing case in Excel (video)

  10 Mar 2011

  People often ask how to change the case of text in Excel. This issue tends to crop up when you work with data from external sources. 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...
• Add Rank to PivotTable

  2 Nov 2010

  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...
• Summarize Spreadsheet Data With Excel's Array Formulas

  14 Oct 2010

  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...
• Extending Excel® to Build Models for You

  8 Oct 2010

    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...
• Use SUMPRODUCT to find the last item in an Excel list

  4 Aug 2010

  Today’s author is Charley Kyd, an Excel MVP, who describes how to use the SUMPRODUCT function to find the last sequential item in an Excel list. Charley has worked with spreadsheets in business since 1979, and has written books on spreadsheet use for McGraw-Hill and Microsoft Press. You can find...