I am an information worker. A big part of my job is to provide our staff and team members with useful information so that they can perform better in their jobs roles. In addition to this, as the Controller of
I was playing a version of 21 with my daughter this weekend, and mentioned Blackjack to her. After a few questions, I thought it might be entertaining to build a version of Blackjack for her to play so I did.
I was working on a little application which has a spin button on the worksheet. That spin button is linked to a cell and works just fine for my purposes. After a while though, it became apparent that I needed
I had an email exchange with Charley Kyd tonight, and I was bemoaning the fact that I couldn't link my Excel chart titles to a range. I could have sworn you could do this, but not working with charts a
Background I've been pretty up front with the productivity gains that I saw when I embraced VBA years ago. In fact, the old About Me page on my website spells it out pretty clearly: In the fall of 2002, the
Tonight we picked up an iPod Touch from our local Save-On Foods with some reward points that we'd been accumulating. This is pretty cool for a variety of reasons, including the fact that now my kid will try and scoop
I have a financial model that I set up using a grouping in some key places so that I could collapse sections of the model when I didn't want to look at them. As I was handing off the model
Today I realized that one of my GETPIVOTDATA formulas was returning an error, since there wasn't any result in the Pivot Table it was checking for data. Unfortunately, during the design of the spreadsheet I never wrapped the function with
I know it's been forever since I've blogged here, and I'm sorry to have to revive this with a rant, but... I was writing an article up for how to customize the Office Ribbon in Excel 2010, and thought I'd
Tonight I discovered that my site had been hacked... as it turns out I was running an old version of WordPress and there was some injection code fed into a security vulnerability. I've upgraded to the latest version, which has
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
