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

March 2008 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Can You Believe

    That I started this blog four years ago. I can’t. It seems more like six and a half. Here’s some stats: That’s about 26 posts per month and about 8 comments per day. I’m no Nick Hodge, but hey. As is my wont, I’ll be having an anniversary give-away. I just like [...] Read More...
    Filed under:

  • Excel and Music

    Finally, a legitimate use for Excel Excel & Music I get all of them except the “Milkshake” one. Read More...
    Filed under:

  • Limits

    I recently ran into a problem with an application I developed over a year ago. I had pre-formatted 100 rows in a template, some just formatting, some conditional formatting. “We’ll never need 100 rows”, I said. One hundred ninety-six rows later and I feel like the Patent Commissioner who said everything has [...] Read More...
    Filed under:

  • 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...

  • External Data Worksheets

    Someone sent me an email last week suggesting I have a Wishlist category where we could discuss features we hope MS will someday incorporate into Excel. I think that’s a fine idea. If you like, send me an email with your wish. If I find it sufficiently interesting, I’ll post it for [...] Read More...
    Filed under:

  • Random Sorts

    Red wants to have a kind-of lottery for his students. He will award them prizes based on a random drawing, but wants to weight each student based on the number of assignments turned in. Normally, I would accomplish this by typing the name of each student in column A one time for every [...] Read More...

  • Excel User Conference Download

    Download Presenter Notes and Sample Files If you didn’t attend, these files will be of limited value. But there they are if you want them. As I mentioned at the conference, I will be reformatting my laptop hard drive this weekend. My folder problem that I’ve been blaming on Groove, isn’t Groove’s fault (I think), [...] Read More...
    Filed under:

  • Conduct in Reserve

    I’m back in the good ol’ USA after traveling for 22 hours. I’m expecting a jet-lag hangover tomorrow. Today I had a 3.5 hour nap, so I’m still up at 11:30 writing a blog post. Here are some thoughts about my trip. I got more out of the conference than the delegates. [...] Read More...
    Filed under:

  • G’day

    Here’s something you may not have known about Australia: They haven’t heard of free internet yet. This post is costs $2. You’ll have to wait until I’m stateside to hear about all the $7 beers I’ve been drinking. Update That strike through costs another $1 and this update another $1 still. What am [...] Read More...
    Filed under:

  • Australian Tips

    I’m giving a 90-minute presentation next week entitled Tips & Tricks. I’m not much of a tips guy as I prefer deeper discussions. However, tips presentations simply can’t beat because they allow me to combine disparate items. Nobody would care if I jumped from keyboard navigation to array formulas in a tips [...] Read More...
    Filed under:
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.