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

Blogs

  • T Accounts

    I’ve made an Excel template for filling out T accounts. For you non-accounting folks, a T account is a method to trace accounting transactions through the accounts on the general ledger. Hey, wake up! This post isn’t finished yet! I’ve made a T account template at least three times in my Excel career. They never […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Jun 13 2014
    Filed under:
  • FastExcel V3 Released – At Last!

    As some of you may know I have been working on developing Version 3 of my FastExcel product for more years than I care to remember. First there was the VB6 blind alley, then 64-bit and multi-threaded calculation and that ribbon thing, then I detoured into learning C++ and XLLs, then there was the inevitable […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jun 12 2014
    Filed under: , ,
  • Tiered Commissions and Counting Zeros

    I was writing some formulas for a tiered commission calculation recently that I thought I should post. But beyond just what the formulas do, it reminded me that I’ve never shared my ‘counting zeros’ opinion, so I’m wrapping that in with this post too. You have a commission structure where you pay your salesmen 5% […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Jun 12 2014
  • AutoHotkey in the VBE

    I downloaded AutoHotkey recently for something not Excel related. Well, it was kind of Excel related so I guess I’ll tell the story. I’ve been using the Save As feature of my Kwik Open add-in and really enjoying the lack of folder navigation. But it has sewn the seeds of discontent. When I’m doing a […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jun 9 2014
  • Excel Function Bible released

    Hi all Together with Norman Harker I add this page to my website : Excel Function Bible The Excel Function Bible is aimed at providing meaningful and practical help in finding and implementing the 468 Excel functions. It replaces and adds significantly to the help users can call for whilst building or using Excel workbooks. To […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jun 2 2014
    Filed under:
  • 2048… Excel Style!

    Occasionally on the blog we like to feature the many creative and unexpected ways in which people are using Excel to solve all sorts of problems, for both work and play. For those of you who are fans of the hit mobile phone game 2048, some ingenious Excel users have created versions of the game inside of Excel! Read More...
    Posted to The Excel Team Blog by Office Blogs on Tue, May 27 2014
  • Avoiding Date Conversion When Pasting an HTML Table

    From Get Data From a Website…, MD comments: However, the info in the table I copy is formatted ## / ## whereby # represents a number. So when it tries to paste 10 / 10 in the worksheet for example, it auto-changes to 10/okt in my sheet. This is a common problem that’s hard to […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, May 23 2014
  • NOT learning from my Errors

    I was writing some formulas today that need to return TRUE if a search term appears in a cell, and FALSE otherwise. For instance, I wanted to know if FOO appeared in FOOBAR or not. Originally I was using FIND, along these lines: =NOT(ISERROR(FIND(“FOO”,”FOOBAR”))) =TRUE But then had some issues with case that screwed things […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, May 23 2014
    Filed under:
  • Learning from my Errors

    There’s an annoying bug in VBA whereby if you’re trying to change the .visible status of a PivotItem, and if the PivotField had a number format set to General, and if you live in New Zealand, then you’re out of luck: If you live in the US however, you’ll be fine. No error for you. […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, May 21 2014
  • Wonky Keyboard Shortcut

    Check out the keyboard shortcut for the Reapply button. I don’t think I’ve ever used that button. If I need it, I think I’ll just use the mouse. Even I have limits. Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, May 17 2014
    Filed under:
  • Free ApressOpen eBook: Office 365

    I’m still alive although it was quite a long time ago I published any article here. But now that I’m back I hope I will speed things up so You will see more activity of my blog. Apress have a series of books that are made available for free. The series is named ApressOpen eBooks […] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Tue, May 13 2014
  • Find Your Dropbox Folder in VBA

    Here’s a function to get the location of the Dropbox folder: Public Function DropBox() As String         Dim DropboxHostFile As String     Dim DropboxHostFileNumber As Long     Dim Base64EncodedPath As String     Dim TempXMLDocument As MSXML2.DOMDocument60     Dim Base64XMLNode As MSXML2.IXMLDOMElement         DropboxHostFile = Environ("appdata") […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, May 5 2014
  • Visualizing Podcasts

    I like podcasts. I listen to them almost every minute I’m behind the wheel. They’re mostly technology related, so if my wife’s in the car sometimes I have to turn on music or switch to Unprofessional or Roderick on the Line (a couple of great podcasts that are a little less techy). As I was […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, May 2 2014
    Filed under:
  • Pop quiz

    Question One You want to calculate a running (i.e. cumulative) total of the Data column. Which of these formulas should you put in B2 and drag down, and why? =SUM(A$2:A2) =SUM(A2,B1) Question Two You want to calculate a running (i.e. cumulative) total of the Data column, and subtract 1 from it. Which of these formulas […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Apr 30 2014
    Filed under:
  • Copy Selection Sum to Clipboard

    Last month I posted some metrics on the keyboard shortcuts I use. One of the pieces of code that I could not link to (because I’ve never posted it) is CopySum. I don’t remember what prompted me to write this little procedure, but it has been surprisingly useful. It sums the selected cells and puts […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Apr 30 2014
    Filed under: ,
< Previous 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.