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

June 2009 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Quick PivotTables

    Sometime in the mid-1990s, a man named Lyle Lanley walked into Microsoft with an idea. Probably the greatest.... Oh, it's more of an Apple idea. "Just tell us the idea and we'll implement it", said Bill Gates. I'm on a quest to rid my life of wizards. The wizards that Microsoft seems [...] Read More...
    Filed under: , ,

  • Animate a greeting with Excel and VBA

    Inspired by Dick’s XL birthday, the upcoming birthday of my fiancee, and tinkering with iphone app development, I thought of an animated greeting in the form of a stadium wave (known to some as an audience wave)… See http://www.tushar-mehta.com/publish_train/xl_vba_cases/greeting_wave.html Read More...
    Filed under:

  • XL

    If I were Roman, that’s how old I would be today. Today I will be spending my birthday processing inventory transactions and answering the phone - great fun. Tomorrow, however, we’re having a little shindig in my honor with family, friends, and beer. Read More...
    Filed under:

  • Euler Problem 83

    Euler Problem 83 asks: NOTE: This problem is a significantly more challenging version of Problem 81. In the 5 by 5 matrix below, the minimal path sum from the top left to the bottom right, by moving left, right, up, and down, is indicated in red and is equal to 2297. 131 673 234 103 18 201 96 [...] Read More...
    Filed under:

  • Euler Problem 81

    Euler Problem 81 asks: In the 5 by 5 matrix below, the minimal path Min from the top left to the bottom right, by only moving to the right and down, is indicated in red and is equal to 2427. 131 673 234 103 18 201 96 [...] Read More...
    Filed under:

  • Look Up

    The last control on the right click menu is Look Up. That opens the Research task pane. I’d be interested to know if anyone actually uses this. I accidentally click on it several times a week, but I don’t actually use it. Anyone? Read More...
    Filed under:

  • Tip: Updates for Microsoft Office Excel 2007 Help

    Hi all Today I talked about the search results from the Excel 2007 help (Offline) with a fellow MVP. Our results where different, my results were correct and useful but his results on the same search topic were useless. The reason why we have different search results is because that I have installed the help update [...] Read More...
    Filed under:

  • Entering Dates Into Cells Part II

    I'm sure you all remember Entering Dates Into Cells from five years ago. It was a simpler time. Brittney Spears was telling us about her prerogative, the Olympics returned to Athens, and my date entering needs reflected the simplicity of the times. Now I need more. Here are some things I discovered about [...] Read More...
    Filed under:

  • Reading XML Files in VBA

    In Creating State Maps... I copied some data out of an XML file and graphed it into a state map. I wanted to try to read the XML file directly in VBA because I've never done it before. First, I set a reference to Microsoft XML v6. Six was the newest version [...] Read More...
    Filed under: ,

  • Euler Problem 123

    Euler Problem 123 asks: Let p(n) be the nth prime: 2, 3, 5, 7, 11, ..., and let r be the remainder when (p(n)-1)n + (p(n)+1)n is divided by p(n)2. For example, when n = 3, p(3) = 5, and 43 + 63 = 280. 280 mod 25 = 5. The least value of n for which [...] Read More...
    Filed under:

  • Hide or display Custom Ribbon Tabs, Groups or Controls with VBA code

    Hi all Today I upload a new page with examples to Hide or display Custom Tabs, Groups or Controls with VBA code Hide or Display Custom Ribbon Tab/Group/Control with getVisible http://www.rondebruin.nl/hidevisible.htm If you have suggestions to make the examples better please let me know. I am no expert but love to try new stuff like this. Regards Ron de Bruin http://www.rondebruin.nl/tips.htm Read More...
    Filed under:

  • Creating State Maps with XY Charts

    According to eggheadcafe, Excel doesn't have built-in maps anymore. I'm not a charting guy, as you know, so I didn't know that. I also didn't know that they ever did. But I wanted a map of the US with sales by region. That seems possible, but all I got this time [...] Read More...
    Filed under:

  • 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...
    Filed under:

  • Work Breakdown Structure Numbering in Excel

    I’ve never heard of Work Breakdown Structure (WBS) before, but I’ve definitely seen it. It’s that type of numbering I see in lawerly type documents. It looks like this: Jeremy has seen it before and wrote an Excel macro to number an Excel list based on indentation. It seemed to work well for me. [...] Read More...
    Filed under:

  • Professional Excel Development Book Winner

    Raymon was randomly selected from all of the entrants and he will be getting his copy of the book shortly. Thanks for all who entered. As for spreadsheet names: Bestspread - sounds like a margarine products Buckwheat - O Tay CalcEase - laxative? Calcium CalcXPress Cell U Like CellBoard Cirrus - in honor of cloud computing - clever Count Crunch DataHusker - my personal favorite DataMiner Dataplane EasySheet Ellexx Enumerate FigureItOut Formula FormulaGrid Formulator GNEWTON (Gnewton’s [...]...
    Filed under:
1 2 Next >
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.