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

Blogs

  • Grid Computing + Excel = Amazing !

    Check out this video on the collaboration between the Microsoft High Performance Computing team and Excel: http://www.facebook.com/video/video.php?v=477293906954 Read More...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Mon, Oct 18 2010
    Filed under:
  • Populate TreeView Controls with Tables from SQL Server & Access Database by using ADOX

    This is the third article on how to populate a TreeView Control with Tables, Views and Columns from a SQL Server database respectively from an Access database. The previously blog entries on this subject is: Populate TreeView Control with Tables and Columns from MS Access Database Populate TreeView Control with Tables, Views and Columns from [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Fri, Oct 15 2010
  • 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...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Thu, Oct 14 2010
    Filed under: , ,
  • 33 Miners

    The CNN banner said “21st Miner Rescued.” To be on topic, I wondered how Excel might automate that. You need a simple algorithm that checks the count mod 10 and the count mod 100. If i mod 10 = 1 and i mod 100 11 then the appropriate suffix for i [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Oct 14 2010
    Filed under:
  • Subjective Sorting

    I have a list of objects. Oh, I don’t know, let’s say it’s the top 5 grossing movies from 1988. I want to rank these movies by how much I like them. To do this, I want to compare only two movies at a time until they’re in the proper order. Any comparison [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Oct 14 2010
    Filed under:
  • LiveKd for Virtual Machine Debugging

    When Dave Solomon and I were writing the 3 rd edition of the Windows Internals book series Inside Windows 2000 back in 1999, we pondered if there was a way to enable kernel debuggers like Windbg and Kd (part of the free Debugging Tools for Windows package...( read more ) Read More...
    Posted to Office 2010 Team Blog by Mark's Blog on Thu, Oct 14 2010
  • Chat about Office 2010 and Windows 7 on Oct 14th with MVPs

    This is a first time event for me so I have no idea of what to expect. I volunteered and Microsoft took me up on my offer to be one of the Excel panelists. The blurb from Microsoft: Would you like to learn more about the cool new features in Office 2010 and Windows 7 and [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Oct 13 2010
    Filed under: ,
  • Pulling RSS data into Excel (or: Using Excel to Search Craigslist) - Part 1

      This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. OK, so I'm going to talk a bit about a relatively unknown feature in Excel: XML data import. It was introduced in Excel 2003, but we've done a pretty good job hiding it since Excel 2007 by putting it on the Developer tab of the Ribbon. I'm going to make the topic even a bit more geeky by using it in conjunction with VBA. In exchange, I'm going to produce, at the end, a nice little solution...
  • TableMaker 2.0

    Dick very recently put up a function that takes an Excel range and whips up some HTML to create a table. I loved that idea, and I asked if I could flesh it out. With Dick’s green light, I created a Sub() that captures each cell’s font family, font style, and font color, [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Oct 8 2010
    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...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Fri, Oct 8 2010
    Filed under: ,
  • Failed Charting

    I wanted to make a chart that told the following story: Although the top athletes make a lot of money and those are the athletes you see on TV, if you care about how much money you make, you’ll have better odds becoming an accountant. To tell this story, I thought I would show the average [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Oct 8 2010
    Filed under:
  • MVP 2010

    According to Microsoft, I’m awesome. Who am I to disagree? I’ve actually been an MVP for a few years, but the stackable acrylic award only started last year. I’m not sure when I was first awarded, but it was around the same time as Debra and Jon, so maybe they remember. There was a time [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Oct 7 2010
    Filed under:
  • VLOOKUP: No more #N/A

      Today’s blog post is brought to you by Anneliese Wirth, who writes about Excel for Office.com.   To grow your skills with Excel, it’s helpful to familiarize yourself with a core set of functions, or predefined formulas that are built into Excel. One of my all-time favorites is VLOOKUP. If you’re new to VLOOKUP, we have a free, entry-level training course available on Office.com that can get you started. If you’re familiar with VLOOKUP, you’ve no doubt seen this before: #N/A errors really...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Wed, Oct 6 2010
    Filed under: ,
  • Excel Converts to Date When Opening CSV

    This is an age old problem that I’ve mostly ignored. When you have something in a CSV that could be a date, like 2-1 could be February 1st, Excel “helpfully” converts it into a date. This problem isn’t unique to Comma Separated Values (CSV) files. Excel will convert 2-1 entered into a [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Oct 6 2010
    Filed under:
  • Top 5 Ways PowerPivot Helps Excel Pros

      This blog post is brought to you by Rob Collie CTO at PivotStream. Former co-founder of the PowerPivot team and Lead PM for Excel at Microsoft, broad-spectrum geek and cruncher of sports stats.   Hello Excel Pros! I’d like to start by saying this: You are my kind of people. I’ve met hundreds of you over the years that I worked on Excel (and other teams) at Microsoft, and I meet more of you all the time today. I like to think of myself as one of you, in fact. I know the “secret,” that...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Fri, Oct 1 2010
« 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.