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

Blogs

  • Microsoft sponsors the Financial Modeling World Championships for Excel power users

    ModelOff, the Financial Modeling World Championships for Excel, is a fun and educational international competition for students and professionals. This year, Microsoft continues the tradition of sponsoring this exciting event. The post Microsoft sponsors the Financial Modeling World Championships for Excel power users appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Oct 23 2014
  • Putting together an Excel VBA course

    Hi everyone! I’m putting together an advanced VBA course and I am looking for feedback, as I plan to make this a top-notch training. If you have a couple of minutes to spare (or perhaps are interested in attending an advanced VBA training in The Netherlands), please fill out my survey Thank you in advance! […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Oct 23 2014
    Filed under: , ,
  • Autohotkey for WordPress Blogs

    I’ve added some autohotkey dealies for when I’m writing blog posts. If you’re blog isn’t about Excel and/or doesn’t use the CodeColorer plugin, they won’t be of much use to you. ; ; AutoHotkey Version: 1.x ; Language: English ; Platform: Win9x/NT ; Author: A.N.Other ; ; Script Function: ; Template script (you can customize […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Oct 21 2014
    Filed under:
  • An Even More Better AutoFilter

    You knew I wasn’t going to let this go, didn’t you? I started with snb’s rewrite. I really don’t want to use the SelectionChange event. It runs whenever you move around the spreadsheet and that’s just wasteful. I like how snb did the heavy lifting on SheetActivate, then only burns processors when you change a […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Oct 20 2014
    Filed under:
  • A Better AutoFilter

    Jeff recently wrote about how you can type your filter criterion in a Pivot Table’s page field and it will filter it automagically. That’s awesome. I want the same thing when I filter Tables, so I started doing some experiments. To filter a table, you select the header, press Alt+{DOWN}, e to get to the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Oct 16 2014
    Filed under:
  • Introducing Microsoft Ignite

    This morning on The Official Microsoft Blog, we revealed more details about our unified enterprise technology conference in May—Microsoft Ignite. The post Introducing Microsoft Ignite appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Thu, Oct 16 2014
  • A Daily Overdose of Arrays

    snb, who wrote the detailed piece on dictionaries, has applied the same rigor to arrays. I knew there would be something in there that I didn’t know (there was plenty). Under the section about identifying the existence of an item in an array, you can use a defined name: 6.2.2.3 The Excel-object ‘Names’ Assign the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Oct 15 2014
    Filed under:
  • Back in the Saddle

    And we’re back. Leave your comments admonishing my server maintenance skills here. I promise I will never try to do the right thing again. KNOW YOUR LIMITS! That’s my new mantra. Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Oct 14 2014
    Filed under:
  • PinkyPivotPimping

    Well here’s something that I probably learned once, but have subsequently forgotten and then rediscovered: You can filter a PivotTable Page Field just by typing the PivotItem that you want to filter it on. So if I start with a PivotTable like this:       And say I don’t like the look of the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Oct 10 2014
    Filed under:
  • Two Times Table

    So if you’ve played around with Tables a fair bit, then you probably would have noticed that you can merrily insert a row in the worksheet that intersects one table:       …but if you try the same thing on a row that intersects more than one table, the Insert, Delete, and Clear Contents […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Oct 9 2014
    Filed under:
  • 6 cool ways to use Custom Maps

    If you haven’t noticed, Power Map got a whole lot richer in September with the introduction of a new feature called Custom Maps. This feature allows you to create amazing 3-D visualizations that showcase your data on top of any map image … literally. To prove this point, we’d like to show you six different ways that you can use Custom Maps to visualize your data in new and creative… The post 6 cool ways to use Custom Maps appeared first on Office Blogs . Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, Oct 8 2014
  • Celebrating my MVP award: Discount offer

    Hi everyone! Every quarter Microsoft announces who are the lucky ones to receive their Most Valuable Professional Award. An MVP award lasts a year, so for a quarter of the MVPs, October 1st is an important day. I got re-awarded! And to celebrate that I am offering a 3 day 50 percent discount on my […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Oct 7 2014
  • MLB Runs By Inning

    There is an office pool for the MLB post season that goes like this: Each participant is assigned a half inning per game in the ALCS, NLCS, and World Series. A participant may get the top of the 1st in one game and the bottom of the 6th in another game. There are 20 participants […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Oct 3 2014
    Filed under:
  • Pimpin’ My Site

    When Doug posted about Data Comparison Tricks, I saw Dick tell him to “pimp his site” in the comments. Having a vivid imagination, this is what went through my head. Anyway, that’s what I’ll now proceed to do. (Having obtained Dick’s permission first of course!) Here’s some stuff I’ve been working on recently. A multi-field […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Oct 3 2014
    Filed under: , , , ,
  • Data Comparison Tricks

    Hey Dick, thanks for having me over. Wow, it’s even nicer in here than I imagined. Look at all those posts! Hey, is that an Office XP beer stein… where’d you get that? Gosh, do you really wear all these baseball caps? Okay, well great to be here. I hope I don’t blow it. I’m […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Sep 22 2014
1 2 3 4 5 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.