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

Blogs

  • Short DOS Path

    Remember DOS? Back in the day, we had to limit our file names to eight characters plus a three digit extension (8.3) and we liked it. Today I needed to add Google Chrome to my startup batch file. Normally I can convert long Windows paths to short DOS paths in my head, [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Dec 3 2009
    Filed under:
  • Benford’s Law

    J-Walk posted about Benford’s law and I thought I’d test it out. I found an Excel file with a lot of numbers, namely a price list. In a new workbook, I put the following code: Sub MakeNumbers()         Dim wb As Workbook     Dim ws As Worksheet     Dim rCell As Range   [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Dec 2 2009
    Filed under:
  • ExcelUser Sale

    ExcelUser.com is having a Half Off Sale through this Friday. From now through midnight Pacific Standard Time (GMT -8), December 4, I’m offering a 50% discount on four of my most-useful dashboard products, and six free bonuses… For those of you not running an ad blocker, you probably noticed that ExcelUser.com runs an ad at [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Dec 2 2009
    Filed under:
  • How to Get Office for Free

    How do you get Microsoft Office for free for Macs and PCs? is written by fellow MVP Jim Gordon. He’s a Mac guy, but I still like him. Strategy #5 Ask for Microsoft Office for your birthday or a holiday, such as Christmas. Hey, you never know! Good stuff. Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Dec 1 2009
    Filed under:
  • Introducing the JavaScript Object Model for Excel Services in SharePoint 2010

    Thanks to Christian Stich , a consultant working on Excel Services projects, for putting together this series on the Excel Services JavaScript Object Model. Excel Services 2010 has added two entirely new programming APIs: The REST API which I covered in an earlier series of posts and the JavaScript Object Model (JSOM) which I will discuss in this post. The JavaScript Object Model (JSOM) enables a whole new set of solutions using Excel Services. With the JSOM it is possible to detect and react to...
    Posted to The Excel Team Blog by Microsoft Excel on Tue, Dec 1 2009
  • Getting Started in VBA

    My off-the-cuff recruit a new VBA programmer week comment got a modest amount of traction around the ‘tubes. Yet, I didn’t want to wait a whole year to provide these links. From msdn’s Getting Started with VBA… series. Are you facing a repetitive clean up of fifty tables in Word 2010? Do you want [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Nov 30 2009
    Filed under:
  • More About Background Removal in Office 2010

    Hi, I’m Tucker Hatfield, a PM on the Office Graphics team, and a while back I posted an introduction to Background Removal ( The Magic of Background Removal ). In this post I’ll build on what I showed you last time by giving an example of how to make more detailed background removal and how to do some interesting things with the results. As I showed before, in many cases you’ll find you can effectively remove a background with nothing more than a very little adjustment of the marquee, but other times...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Mon, Nov 30 2009
  • Methods in Excel Podcast

    Go check out the first Methods in Excel Podcast hosted by Ross McLean. The first guest is Simon Murphy of Codematic. I’m slotted for a future show, so I’m looking forward to that. Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Nov 24 2009
    Filed under:
  • Create conditional drop-down lists

    Today’s author is Reinout Dorreboom from the Netherlands, a Technical Consultant at Getronics, where he has worked with Office applications for many years, and where his Microsoft Certified Training skills enabled him to help other people get up to speed with Excel. In Excel 2007 (and earlier), it’s possible to create a drop-down list. By using the INDIRECT function, you can then create additional drop-down lists that are conditional to the first drop-down list. In this example we’ll create the following...
    Posted to The Excel Team Blog by Microsoft Excel on Tue, Nov 24 2009
    Filed under:
  • Uncovering Publish to Excel Services in Excel 2010

    Thanks to Amy Lin for putting together this post. In Excel 2007, we introduced the ability to publish workbooks to SharePoint. This feature enabled users to upload Excel workbooks (or specific workbook items) on to their SharePoint sites for people to view and interact with using Excel Services. In Excel 2010, this feature has all the same functionality but the entry point has changed. For the Technical Preview/Beta users, the entry point will look different since these changes will be reflected...
    Posted to The Excel Team Blog by Microsoft Excel on Tue, Nov 24 2009
  • Collaboration Without Compromise

    Lots of the talk around Office documents these days seems to be about “Collaboration”. “Team work”. “Sharing”. And yet, you don’t get an A on your term paper because four people were on your team. And you don’t get promoted because your business plan involved 30 different reviewers. No doubt, it almost always takes a group of people to get the job done these days, but the job is still about the output. Unfortunately these days we have to choose between simple collaboration and rich, polished output...
  • Changing names of some files in a directory

    This started off by helping myself to Dick’s code in ‘Removing Spaces from File Names’ (http://www.dailydoseofexcel.com/archives/2009/11/12/removing-spaces-from-file-names/) but quickly evolved to meet my own needs. First, was the requirement to replace a certain text string by another. I added 3 parameters to the subroutine (Dirname, ReplaceWhat, and ReplaceBy). Also evident was that some files had [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Nov 21 2009
    Filed under: ,
  • Office Web Apps

    I’m trying to be the last blog on earth to announce the Office 2010 Beta. Included in 2010 are Office Web Apps. With Microsoft Office Web Apps, you can access documents from virtually anywhere. Whether you’re editing a document from home or collaborating with someone around the world, Office Web Apps help you work the [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Nov 20 2009
    Filed under:
  • Mobility in Office 2010

    Microsoft Office 2010 provides you powerful new ways to deliver your best work - whether you’re at work or at home, whether you are travelling in a cab or on a flight, whether you are working on a PC, browser or phone. By offering more ways to access your files from virtually anywhere, Office 2010 puts you in control. As part of Wednesday’s Office 2010 Beta Announcement we announced the availability of the Office Mobile 2010 Beta -- today’s post describes some of the exciting work we’ve done related...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Thu, Nov 19 2009
  • Open XML: One Year In

    As you’ve probably heard, this is a big week for Microsoft’s Business Division. Earlier this week we announced the public availability of Microsoft Office 2010 Beta. Have you ever wanted to co-author a document with your team in Word? Have you ever wanted to analyze tons of data at once in Excel? Have you ever wanted to push the limits of multimedia in your PowerPoint presentations? If so, check out the Beta . It’s also a big week for the standards community, especially for those of us working in...
    Posted to Office 2010 Team Blog by Microsoft Office 2010 Engineering on Thu, Nov 19 2009
« 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.