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

Blogs

  • Offloading UDF’s to a Windows HPC Cluster

    Thanks to Gabhan Berry for putting together this series on high performance computing. In my previous post I discussed how we have enabled workbooks to be calculated on a Windows HPC cluster. In this post, I’ll describe the other piece of HPC integration we have developed in Excel 2010: offloading the calculation of UDFs to a Windows HPC cluster. Overview User defined functions are one of the most popular pieces of Excel extensibility. UDFs enable customers to create their own worksheet functions...
  • Fix for Message Size Issue in Outlook 2010 Beta

    Recently, we posted information on the Outlook blog about a bug in the Microsoft Office 2010 Beta that increases the message size of some e-mails messages sent from the Microsoft Outlook 2010 Beta. The Office team has been hard at work building a fix for this issue, which is available immediately. Download Outlook 2010 Beta fix for 32-bit Office 2010 Download Outlook 2010 Beta fix for 64-bit Office 2010 This fix prevents future messages from consuming unnecessary space, but doesn’t resize existing...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Thu, Feb 11 2010
    Filed under: ,
  • Formula Tips

    Al sent me a formula to revise. Before: =IF($B11<>0,IF(OR(ISNUMBER(FIND("-",J11))=TRUE,ISNUMBER(FIND(" ",J11))=TRUE,ISNUMBER(FIND("_",J11))=TRUE), IF(ISNUMBER(FIND("-",J11))=TRUE,TRIM(SUBSTITUTE(J11,"-","")),IF(ISNUMBER(FIND(" ",J11))=TRUE,TRIM(SUBSTITUTE(J11,"  ","")),IF(ISNUMBER(FIND("_",J11))=TRUE,TRIM(SUBSTITUTE(J11,"_","")),TRIM(J11)))),TRIM(J11)),"") After: =IF($B1<>0...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Feb 10 2010
  • How does usage data improve the Office User Experience?

    Hello, my name is Tim Briggs – I am a user experience (UX) Researcher in the Office Design Group (ODG). Usage data is one of the important feedback mechanisms we look at to understand how Office is being used in the real world. Answering questions like “how frequently is a command used?” and “how many files contain this feature?” are critical parts of our entire engineering process. Today, I’d like to give you a better sense of how we collect, interpret, and design based on usage data. To get the...
  • VBA Assessment

    Patrick O’Beirne sent me a link to Alex Palfi’s VBA Assessment. I assumed I would ace it, but I got 7 wrong. That’s 80%. I knew I was in trouble when I read the first question. The following figure illustrates a help system in Excel. The user can click on a tab [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Feb 9 2010
    Filed under:
  • Calculating Excel Models on an HPC Cluster

    Thanks to Gabhan Berry for putting together this series on high performance computing. In a previous post , I introduced the work we have done with the Windows HPC team to enable customers to calculate Excel models on a Windows HPC cluster. In this follow up post, I go a little deeper into how we can harness the utility and power of Excel 2010 and Windows HPC to solve complex modeling problems. Modeling Complex Systems using Excel 2010 and Windows HPC Mathematically modeling complex problems is far...
  • List Custom Lists

    DataPig posted about Custom Lists in Excel and his inability to delete them. I agree on all points; I’ve never needed Sun-Sat and we should be able to delete them if we want. Here’s a macro to list all the Custom Lists to the Immediate Window. Sub FindCustomListNumber()         Dim i As Long, j [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Feb 8 2010
    Filed under: ,
  • Google Chrome

    This week I made the switch from Firefox to Google Chrome. The latest stable release of Chrome supports “extensions” so all those pesky annoyances that kept me away from Chrome in the past can be fixed. My only complaint with Firefox is that I have to restart it a couple of times a [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Feb 5 2010
    Filed under:
  • Excel 2010 and High Performance Computing

    Thanks to Gabhan Berry for putting together this series on high performance computing. In this post, I introduce the work we’ve done with the Windows HPC team to integrate Excel 2010 with cluster computing. This is a high level overview and I’ll follow up with the technical details in later posts. High Level Overview of Excel 2010 and Cluster Computing High Performance Computing (HPC) is a branch of technical computing that uses supercomputers and cluster computing to solve computationally intensive...
  • Data Excecution Prevention in Office 2010

    Hello, my name is Vikas Malhotra, and I am a security Program Manager in the Office Trustworthy Computer Team (TWC). In this post I will be covering some security changes we made around Data Execution Prevention or DEP for short. DEP is one of the many new defense in depth protection layers we have added in Office 2010. I will begin by telling you what DEP is all about and how it can affect you both as an IT professional and as a developer. What is DEP? DEP is a security feature that was introduced...
  • ISO Year

    Ron de Bruin has an ISO Date page for computing ISO Week numbers, start dates, and end dates. I needed to compute the ISO year, which should just be the YEAR() function wrapped around the end date formula. But I was getting strange results for the first three days of January this year, [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Feb 4 2010
    Filed under:
  • Management Features of PowerPivot for SharePoint

    Thanks to John Hancock from the PowerPivot team for putting together this post. Previous articles have covered some of the features of PowerPivot for Excel, and shown how PowerPivot helps users build really powerful BI applications right in Excel. We have described some of the PowerPivot for SharePoint features on this blog as well as the PowerPivot blog , so for this article I will be focusing on the features that we provide to help IT to manage and understand the self-service BI activity. Self...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Mon, Feb 1 2010
  • Office 2010 Improvements for Cropping Pictures

    Hi, again, I’m Tucker Hatfield, a Program Manager on the Office Graphics team with another post on improvements for using pictures in documents in Office 2010. This time we’re looking at the improvements to cropping pictures in Word, PowerPoint, Excel, and Outlook. When planning our new features for this version of Office, we did a lot of research to find out more about the common tasks people do with pictures in Office. Cropping was overwhelmingly the most-used bit of editing used on pictures, so...
    Filed under: ,
  • Perfect Training

    Have you even attended a really good training session? What about it made it good? I’d like to develop some training sessions. I get a lot out of preparing and presenting (and I hope the attendees get something too). Rather than developing training that looks like every other session I’ve attended, I thought it [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jan 29 2010
    Filed under:
  • Check out the InfoPath "5 for forms" Video Demo Series

    The InfoPath team has a great series of posts on the InfoPath team blog . If you would like to meet the people behind the product and learn about new InfoPath 2010 features, then check out our "5 for forms" video demo series. Each week a member of the product team demos a cool, new InfoPath 2010 feature or scenario in less than 5 minutes. In this series, discover how easy it is to build powerful applications on SharePoint , using InfoPath and InfoPath Forms Services 2010 - no code required...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Fri, Jan 29 2010
    Filed under:
« First ... < Previous 63 64 65 66 67 Next > ... Last »
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.