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

Blogs

  • Make Informed Decisions On The Go With Excel Mobile 2010

    In our previous post entitled “ Mobility in Office 2010 ” we briefly described the office applications available on your phone that would keep you productive on the go. In this post we will deep dive into Excel Mobile 2010, which supports over 100 of the formula functions available in Microsoft Excel 2010. In addition, its support for creating and displaying all of the common chart types brings the visual experience on the phone closer to that on the desktop. In this post, we will see how Excel Mobile...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Wed, Mar 31 2010
    Filed under:
  • More Excel 2010 Posts

    There’s some more Excel news, ads, and articles showing up.  Check out this post on the Office blog to see a couple of videos on the introduction of sparklines to Excel, one made by us and another by MrExcel … and since we’re on the topic, below is a couple of recent videos from MrExcel that feature sparklines:   Episode 1195 - Add shading to your sparklines to specify acceptable ranges. Episode 1194 – Add labels to your sparklines. Read More...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Mon, Mar 29 2010
    Filed under:
  • Information About ExcelKB: An Update

    Recently I announced that my English site ExcelKB will change its focus and therefore all my Excel related articles would be dropped. Soon after the announcement I was approached by an employee at Microsoft asking if I would be interested to have the articles published at MSDN. Actually, I accepted it immediately although it means limited rights to [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Mon, Mar 29 2010
    Filed under:
  • New Download Page for XL-Dennis Tools

    As a consequence of the reconstruction of ExcelKB my free tools needed a new place. I decided to add a new page to this blog enabling everyone to download the tools: Download XL-Dennis Tools Kind regards, Dennis Read More...
  • Copying Worksheets with VBA

    An Excel question via email I have one workbook, workbook1 where i have saved all the names of worksheets saved in my workbook. These are in range of B2:B20 Now I want to run a loop which will select the name from the range and copy all data from that worksheet to another workbook, workbook2 with [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Mar 25 2010
    Filed under:
  • Six

    In honor of DDoE’s sixth birthday, I thought I’d see how this blog is developing compared to other six-year-olds. From About.com: At mealtimes, the six-year old has a very good appetite - I’ve been starving this blog for years, so no match there. Very few six-year olds will nap - This blog just took a week [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Mar 24 2010
    Filed under:
  • Maxif and Minif with Multiple Variables

    In Maxif, Minif Functions, I discussed finding the maximum or minimum for a subset of data based on certain criteria. If you have more than one criterion, the formulas are roughly the same. In this example, I have three items in four different PriceZones. I want to find the most expensive and least expensive [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Mar 23 2010
  • Accessing your Office files from any computer with Windows Live SkyDrive

    Hello, my name is Rich Grutzmacher. I am a Program Manager on the User Experience team. As Clay wrote in his post , we created the Backstage view to provide a location for Office's OUT features (i.e., the things you do to the whole file, rather than the changes you make to the content within it). One of the new and exciting Backstage features in Office 2010 is the ability to save your files directly to Windows Live SkyDrive from within the Word, Excel, PowerPoint, and OneNote desktop applications...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Tue, Mar 23 2010
  • Preserve Size and Location of Windows Forms – Part II

    The first post in this mini series can be found here: Preserve Size and Location of Windows Forms – Part I Here I will discuss how we must do to preserve the size and location of Windows Forms that are part of managed COM Add-in and VSTO Add-ins. We can still use the approach that was discussed in [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Tue, Mar 23 2010
    Filed under:
  • More about collaborative editing in Excel Web App

    Thanks to Dan Parish for writing this blog post. In today’s post, I’m going to delve into some of the finer details of collaboration using Excel Web App. If you haven’t already read Collaborative Editing Using Excel Web App however, please start there. It goes over what is supported, how it works, our presence UI, as well as some interesting collaborative scenarios that this feature opens up. Today’s post is really a “Part II” to that post. Multiple Browser Windows Excel Web App allows you to collaborate...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Mon, Mar 22 2010
    Filed under: ,
  • The COM Shim Wizard for VS 2010 is available

    Misha Schneerson has now made the Shim Wizard for VS 2010 available for download. What should be noted is that the new version is not officially released by Microsoft and it’s not officially supported. For more information please see COM Shim Wizards for VS 2010. In view of the fact that VSTO is getting better and better for [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Sat, Mar 20 2010
  • Preserve Size and Location of Windows Forms – Part I

    Introduction To preserve size and location of Windows Forms are in many ways a common service towards the end users. In this first part I will take a closer look into how we can remember theses settings between the sessions for standalone applications in VB.NET. In the part two and last article I will discuss it [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Fri, Mar 19 2010
    Filed under:
  • PowerPivot – Part 4 of 4: A geographic visual display of 18 million US Census records

    Part 1: http://www.dailydoseofexcel.com/archives/2010/02/26/powerpivot-part-1-of-4/ Part 2: http://www.dailydoseofexcel.com/archives/2010/02/27/powerpivot-part-2-of-4-prepping-the-census-data/ Part 3: http://www.dailydoseofexcel.com/archives/2010/03/02/powerpivot-part-3-of-4-conditional-shape-colors/ In this tip I discuss integrating the result of a PowerPivot analysis of a large data set (18 million records) into a geographic map using a method I call “Conditional Color of Shapes.” For a version...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Mar 18 2010
    Filed under:
  • Change charts, represent +/-, and count the Mondays between 2 dates

    Bill Jelen has been running the MrExcel podcast for years now. For those that haven’t heard of it, it’s a frequently updated video podcast that teaches you Excel, showing everything from the basics of the fill handle to advanced tips around charting, and everything in between … including some recent tricks with linked pictures. Since there’s a lot of great information in his videos, we thought that a weekly (or so) wrap-up of his podcast would be a nice thing to add to the blog. If you have ideas...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Tue, Mar 16 2010
    Filed under:
  • Office 2010 Assessment & Planning

    Today, over on the Microsoft Assessment and Planning (MAP) Toolkit Team Blog we announced the availability of the Microsoft Assessment and Planning (MAP) Toolkit 5.0 Beta. The Microsoft Assessment and Planning (MAP) Toolkit is an assessment and planning tool targeted at IT Professionals to help them begin the deployment process. The tool inventories your current environment and assesses the readiness of those computers for migration to the new technology, in this case Office 2010. MAP is an agentless...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Tue, Mar 16 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.