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

Blogs

  • The Garage Series for Office 365: What’s new in the world of apps for Office?

    This week hosts Jeremy Chapman and Richard diZerega explore what’s new in the new world of apps for Office. They look at the top 5 new features including amazing content apps for PowerPoint, Excel APIs for formatting, content apps for Access, mail APIs for body and attachments and compose mail apps. Watch as Richard masterfully demonstrates all of this along the way. Last week we caught up with Jeremy Thake… Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, Jul 23 2014
  • Broken Arrow

    Dick et al tell me that my over-use of the arrow anti-patten is broken… …to the point that my Ifs are well out of sight of my EndIfs. So much so, that I’ve got into the habit of appending my closing IF statements with an apostrophe and then adding the text of the matching opening […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jul 23 2014
    Filed under:
  • Updating the For Next AutoHotkey in the VBE

    Last month I posted about some AHK scripts I was starting to use to make the VBE a little less gross every day. There were some awesome comments. I took Hubisan’s comment and ran with it through a few iterations. First, let’s go to the video. I use a program called CamStudio. For some reason […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jul 14 2014
    Filed under:
  • Join us for Tuesday’s webinar: Understanding the Excel Data Model

    The Excel Data Model is revolutionizing how you can work with data in Excel. In this webinar, we’ll show you why. Join us on Tuesday when guest host Owen Duncan will teach us how Excel Data Models provide lightning fast data analysis and visualizations. What you will learn at Tuesday’s webinar What an Excel Data Model is How to get data into a Data Model How to create relationships between… Read More...
    Posted to The Excel Team Blog by Office Blogs on Mon, Jul 14 2014
  • What caused that PivotTableUpdate? Episode IV

    So if you’ve been merrily following along, then you’ll know that we’ve got a function that picks up which PivotField just got filtered in a PivotTable, with a couple of exceptions: If users change the PivotFilter list, but leave the same count of things visible, or If any stinky PageField filters read ‘Multiple Items’ both […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jul 10 2014
    Filed under:
  • Pre-Order 101 Ready-To-Use Excel Formulas

    The venerable Mike Alexander and I wrote a book last Spring and now you can pre-order it at Amazon (ships next month). 101 Ready-To-Use Excel Formulas This book is not a list of worksheet functions and a description of their arguments. It contains fully formed formulas that solve real world problems. For example, there’s a […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jul 9 2014
    Filed under:
  • What caused that PivotTableUpdate? Part Tres.

    Okay, so: In Part One, we considered the problem of determining what actually triggered a PivotTableUpdate (or it’s equally gormless twin, the PivotTableChangeSync event) In Part Two we worked out that we could tell via the contents of the Undo Stack whether the update was caused by filtering, a refresh, a structure change, or other […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jul 9 2014
    Filed under:
  • Do you use LinkedIn?

    Why not? You could be getting helpful notifications like this one: Now, what kind of skills can I endorse former Brazilian football manager Luiz for? Oh I know! Ball skills… Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Jul 8 2014
    Filed under:
  • What caused that PivotTableUpdate? Part Two.

    In Part One, we considered the problem of determining what actually triggered a PivotTableUpdate (or it’s equally gormless twin, the PivotTableChangeSync event), with a view to identifying when a specific PivotField is filtered. Today we’re going to take a look at how we can find out more about what triggered those events. And what better […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Jul 8 2014
    Filed under:
  • What caused that PivotTableUpdate? Part One.

    Over at MSDN, ToWIZ writes: I’m looking for a detailed guide that would help users understand the details of PivotTable events and their functioning. The documentation has only one sentence for each event. Surely Microsoft doesn’t consider this to be a detailed guide? Apparently so. Microsoft: The PivotTableUpdate event occurs after a PivotTable report is […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jul 7 2014
    Filed under:
  • Adding a New Worksheet to the End of the Workbook

    I can think of five ways to add a new worksheet to a workbook. There may be more, but I can only think of five. Alt + i + w – this is the way I do it now. I’m trying to get away from the 2003 keyboard shortcuts, but this one remains. Alt + […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jul 3 2014
    Filed under:
  • Converting Numbers to Words Part V

    See Converting Numbers to Words Part IV No need to bite this one off in small chunks. Just need to make sure the triplets processing works at the next level. Sub TEST_Millions()         Debug.Assert NumbersToWords(1000000) = "one million"     Debug.Assert NumbersToWords(1000001) = "one million one"     Debug.Assert NumbersToWords(20000000) = "twenty […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jul 2 2014
    Filed under:
  • Converting Numbers to Words Part IV

    See Converting Numbers to Words Part III On to the thousands: Sub TEST_Thousands()         Debug.Assert NumbersToWords(1000) = "one thousand"     Debug.Assert NumbersToWords(1001) = "one thousand one"     Debug.Assert NumbersToWords(1099) = "one thousand ninety-nine"     Debug.Assert NumbersToWords(1200) = "one thousand two hundred"     Debug.Assert NumbersToWords(1310) = "one thousand three […]...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Jul 1 2014
    Filed under:
  • Converting Numbers to Words Part III

    See Converting Numbers to Words Part II My tests work from 0-99. The next test will test numbers between 100-199. Sub TEST_OneHundred()     Debug.Assert NumbersToWords(100) = "one hundred"     Debug.Assert NumbersToWords(110) = "one hundred ten"     Debug.Assert NumbersToWords(119) = "one hundred nineteen"     Debug.Assert NumbersToWords(120) = "one hundred twenty"     […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jun 30 2014
    Filed under:
  • Converting Numbers To Words Part II

    See Converting Numbers To Words Part I. The next test will test 20-99. I think in real TDD, you’re supposed to write tests that test just one thing. But I’m not doing real TDD, so I’m testing in groups. Sub TEST_Tens()     Debug.Assert NumbersToWords(20) = "twenty"     Debug.Assert NumbersToWords(21) = "twenty-one"     […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jun 27 2014
    Filed under:
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.