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

Blogs

  • Excel Team Favorite Keyboard Shortcuts – Part 1 of 3

    In this series of posts I’ve decided to walk through some of my favorite Excel keyboard shortcuts and a few other little tricks I’ve learned along the way that helps me work faster. In fact, when visiting some analysts in financial services, I learned that when they get trained on Excel, the instructor actually unplugs the mouse from the classroom computers in order to really drive home the efficiencies that can be gained from keyboard shortcuts. But when I say these are my favorites what I really...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Tue, May 18 2010
    Filed under:
  • Announcing the Microsoft Business Intelligence Indexing Connector

    Or what I like to call BISearch in 13 languages and available immediately! As many of you know, we acquired FAST and have been hard at work integrating the technology with SharePoint.  One of those integrations was using FAST’s great ability to help users find their BI reports locked away in Excel and SQL Server Reporting Services.  With this new Indexing connector, users have a dedicated Report tab where they can find the reports they are looking for, use refiners to further narrow their...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Mon, May 17 2010
  • Soccer World Cup Developer’s Challenge

    Some people think football is a matter of life and death...I can assure them it is much more serious than that.  Bill Shankley, 'The Sunday Times' (London) , October 4, 1981 + = " border="0" alt="clip_image001 " src="http://blogs.msdn.com/blogfiles/excel/WindowsLiveWriter/MICROSOFTEXCEL2010DeveloperChallengeSocc_AB96/clip_image0016.jpg" width="114" height="101" />+ " border="0" alt="clip_image001 " src="http://blogs.msdn.com/blogfiles/excel/WindowsLiveWriter/MICROSOFTEXCEL2010DeveloperChallengeSocc_AB96...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Sun, May 16 2010
  • Next Week: TechNet Updates & Disabled Comments

    Hello blog readers! Next week the TechNet blog servers will be upgraded to support new features such as invisible captcha (you won’t need to enter numbers before commenting), a new excerpt view for easier browsing of blog posts, and easier sharing of posts on your favorite social sites like Facebook, Windows Live, or Twitter. As part of the upgrade process we will be disabling comments from Sunday, May 16 at 8:30pm PST to Monday, May 24 th , at 12pm PST . We apologize for the inconvenience but are...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Fri, May 14 2010
  • Upgrading to SharePoint 2010

    Now that I have managed to get a new MSDN subscription I’m about to upgrade my physical testserver with Windows 2008 R2 Server, SQL Server 2008 and SharePoint 2010. Despite all the good installation wizards included in the softwares it requires more knowledge and understanding then just click on the right buttons so to speak. [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Fri, May 14 2010
  • Understanding Software Assurance

    Most large organizations have Software Assurance (SA) as part of their licensing agreement and there are many benefits that are included that go unused every agreement period. We have found that many of the people who would use the benefits don’t know that their organization has them. Those who do know about Software Assurance associate the program with getting the next version of software at no additional cost, however there are other benefits that can save you money from your budget on training...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Thu, May 13 2010
    Filed under:
  • Omaha CPA Who Knows Excel

    I was reading Gobán Saor’s essay about learning software: At a minimum, everybody should be taught the basics and the possibilities of spreadsheets. At a minimum, I thought, accounting degrees should have a class dedicated to spreadsheets. And who better to teach it than me? What if my Alma mater decides to create such a [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, May 13 2010
    Filed under:
  • Performance of linked pictures

    I frequently use the camera tool to create pictures linked to cell ranges. For example to be able to have different column widths beneath each other on one sheet. They have one major drawback however: they can slowdown VBA performance (when updating cells) enormously (update time may go up from .2 secs to as much as 8 [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, May 12 2010
    Filed under: , ,
  • What’s up with the Business Launch? A conversation with the engineering leader behind Office

    We’re excited to announce that Office 2010 is available to business customers starting today! In addition to our virtual launch events , you can find more information below from a conversation that Takeshi Numoto had with Antoine Leblond , the engineering leader behind Office 2010. In it, he shares some of his insights into Office 2010 from an engineering perspective. T: We’ve been talking about Office 2010 for over a year. Why are businesses going to tune into our “launch” on May 12? A: Candidly...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Tue, May 11 2010
    Filed under:
  • PowerPivotPro – Excel, SharePoint, and PowerPivot

    An interesting post on PowerPivotPro about Automating a report using Excel, SharePoint, and PowerPivot: “Let’s say you don’t have much need for handling large data volumes, your organization isn’t large enough to worry about spreadsheet robustness/business intelligence/one version of the truth, and you haven’t yet seen what DAX can do for you in pivots. Or maybe you get some of that, but don’t really understand this whole SharePoint thing. If you are in either of those boats, here’s an example from...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Tue, May 11 2010
    Filed under:
  • How the SDL helped improve Security in Office 2010

    Hello, my name is Didier and I am a Security Program Manager in the Microsoft Security Engineering Center. We focus on helping teams like Office go beyond the minimum requirements of the Security Development Lifecycle (SDL). For Office 2010, I worked closely with members of the Office TWC team. The Microsoft SDL is a security assurance process that is focused on software development. As a company-wide initiative and a mandatory policy since 2004, the SDL has played a critical role in embedding security...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Tue, May 11 2010
    Filed under:
  • Find and Replace Hyperlinks

    Sub FindReplaceHLinks(sFind As String, sReplace As String, _     Optional lStart As Long = 1, Optional lCount As Long = -1)         Dim rCell As Range     Dim hl As Hyperlink         For Each rCell In ActiveSheet.UsedRange.Cells         If rCell.Hyperlinks.Count > 0 Then             For [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, May 10 2010
    Filed under: ,
  • Excellent Learning Tool for Open XML SDK 2.0

    For some weeks ago Microsoft announced that they had launched the final version of Open XML SDK 2.0 for Microsoft Office. With this SDK we can create and manipulate Excel workbooks in code without involving Excel and also without having Excel installed. What comes as a bonus with SDK 2.0 is the Open XML SDK 2.0 Productivity Tool [...] Read More...
  • SmartArt Diagram Improvements

    In Office 2007 we introduced SmartArt diagrams, a tool designed to simplify the process of creating quality graphical layouts. The goal of every SmartArt diagram is to enhance the aesthetic appeal of your document and to use a graphic to convey a message. SmartArt diagrams adjust the size of all of your shapes and text for you as you add or remove content. You may also resize your entire graphic and all of the contents will be resized accordingly. In the Excel, Outlook, PowerPoint, and Word 2010...
  • GoodTodo

    I’ve been using the Getting Things Done and 43 Folders method to organize my life for a almost a decade now. It’s definitely a system that works for me. I’ve tried in the past to rid myself of the paper aspect of this method and make it electronic without success. A few [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, May 5 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.