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

Browse by Tags

  • Testing VBA Code

    For years I’ve wanted to make my testing easier and more automatic. My procrastination may have paid off. Version Control for Excel Workbooks Read More...
  • Data Visualization? Sir, Yes Sir!

    Did you ever want to join the army but don’t like all the physical activity? And instead of shooting people you’d rather create charts and dashboards in Excel? If so, you should go to the Excel Dashboard and Visualization Bootcamp. This 3-day boot camp is designed for Excel users who need to more effectively [...] Read More...
  • Free Excel Stuff

    Giveaway of the Day I like the comments from the OpenOffice users. Jeez, does everything have to be open-source? Read More...
  • Andrew’s Excel Tips

    Just a quick post to let everyone kind enough to visit - my site address has now changed to www.andrewsexceltips.net (formerly www.andrewsexceltips.com). I’ve been blogging for over 4 years now, and although I don’t post as often as I used to, I’m still cooking up new stuff to add. Thanks to Dick and my other great Excel [...] Read More...
  • Peltier Loves Pie

    I’m testing out widgenie (beta) and want to see how an embedded chart looks. I chose a pie chart because I’ve been reading lately how we all know pie charts are bad. Anyway, this took about 10 seconds to create with Debra’s sample data. var myLogiWidget477e7c06_b129_47f5_b60b_617dfb112792 = new rdLogiWidget; [...] Read More...
  • Excel Links

    First, from the double trademark infringement department, there’s Excel®RainMain®, who says: Whether it’s your homework, day job, or just a new idea, let the Excel Rain Man make your life easier! Submit a Request, inquiries are free! (see How it Works for further details) Pay for homework service? For a fee, I’ll read your lit homework [...] Read More...
  • Excel Blog Happenings

    The Contextures Blog has moved off of the wordpress.com domain and onto the contextures.com domain. Check it out if you haven’t, update your feeds if you have. PTS Blog is holding a contest for physics and engineering spreadsheet models. Since I’ve mentioned it on my blog, I get to submit six entries. I’m [...] Read More...
  • Excel and Music

    Finally, a legitimate use for Excel Excel & Music I get all of them except the “Milkshake” one. Read More...
  • Two popular tools updated.

    Hi All, As many of you know I give away a number of tools for Excel through my site www.jkp-ads.com. Today I have updated the two most popular downloads: Name Manager (which I created together with Charles Williams, www.decisionmodels.com): Most important change: the unused names filter now includes objects in its search, as well as VBA code. It [...] Read More...
  • Presidents Day Chart Sale

    Worst. Blog title. Ever. Jon Peltier of Peltier Technical Services (and world renowned charting expert) has started the PTS blog to: …show off some of the projects I’ve worked on, share some Excel and Charting tips and techniques, show how to make some tricky charts that people ask about in forums and newsgroups, and talk about the [...] Read More...
  • MSDN Primers

    MSDN has some nice articles on the basics The Application Object The Range Object Read More...
  • G’Day Excel

    Hey, if you’re within 5,000 miles of Sydney, Australia next month, be sure to sign up for the Excel User Conference. Australian Excel User Conference I’ll be presenting some of the sessions and I’m pretty excited about that. I’m less excited about spending 18 hours in coach, but at least I’ll finish that book I started [...] Read More...
  • Some Links

    The blist beta opened this week and I got an invite. I think I signed up for it last November. I really like the things that I can put in fields, such as images, lists, URLs, and even other tables. There are three things that weren’t immediately discoverable by me: I [...] Read More...
  • Hash and Stack in VBA

    These are a couple of links that I want to keep handy. They describe creating a stack and a hash table in VBA. Hash and Stack VBA Modules Hash and Stack in VBA for centralised configuration and error handling Read More...
  • Excel User Group Site

    Fellow MVP Nick Hodge has a new Excel site at ExcelUserGroup.org. Whenever Nick does something, it’s always first class. Check it out. Look how skinny he is.
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.