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

Browse by Tags

  • Web Apps

    I came across a couple of interesting web applications recently. The first is AccountingASAP.com. Offering free invoicing is a great way to get their name out there and encourage users to check out their for-pay stuff. It reminds me a little of the free version vs. pro version model, but there are differences. [...] Read More...
  • Friday Link Dump

    Cloud Excel Excel Web App 2010 Overview Editing in Excel Web App – Part I I haven’t used the web app yet, so take my comments in that light. Fidelity appears to be the word of the hour. Clearly MS thinks it’s important, but I’m not so sure. I don’t expect my bank’s website [...] Read More...
  • Methods in Excel Podcast #3

    I recently did an interview with Ross at MIE. Check it out. I’m able to subscribe to MIE podcasts via iTunes now. So if that’s your preferred method, have at it. Read More...
  • 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...
  • 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...
  • 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...
  • Bacon Bits Blog

    Welcome to 2002, Mike! In another five years you’ll be on Facebook and Twitter. I kid because I love. Mike Alexander of DataPig Technologies has started Bacon Bits, “Delicious pieces of Excel and Access training”. It promises to be the feel-good Excel blog of the year. Check it out. Subscribed! Read More...
  • Finding External Links in Data Validation

    I kept getting the Edit Links message when I opened this on particular file, but I could never find the link. It wasn't in any formulas or range names. I ended up copying each cell to a new worksheet and seeing when that new worksheet got the link. Fortunately it was about [...] Read More...
  • External Links

    Ron sez: What happens often is that one person will have one of these spreadsheets open and the other spreadsheets linked to the subject spreadsheet closed and decide to insert a column that throws off the references of the closed linked spreadsheets. If the person knew which spreadsheets were linked to it, the person could open [...] Read More...
  • VBA WTF

    Enterprise Level Access - The Daily WTF A pretty good DWTF featuring VBA. Check it out. Read More...
  • 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...
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.