IntroductionI wanted to let you know about a really cool new add in for ...
- Home
- |
- Category: zAdvanced Excel
Introduction I built a chart that let’s you highlight a series from a smaller ...
No matter where you fall on the political spectrum, you’ll love the chart I’ve ...
CORRECTION Several people pushed back on the video I release this morning and I ...
In this article, we’ll talk about how to complete random shuffling with only formulas. ...
This is part 2 in which I explain how I solved the problem. Make ...
So many folks have asked me to write more on my coding style. So ...
Written by Bjoern Stiel Add-Ins are a great way to increase Excel’s firepower. Add-Ins not ...
In the first part of my manifesto, I outlined why I think we should ...
Most of us code using the Hungarian notation style when writing VBA code. Basically, ...
That’s right, if you’re in the San Francisco bay area, don’t miss an exciting ...
There are many great articles and tutorials on how to build interactive data displays ...
Disclaimer: The following tutorial requires Conditional Formatting which is a feature of Excel 2010 ...
Various people have written to me asking what they should do about popups generated ...
Edit: sorry for some of the squashed images you see in this and other ...
I want to highlight two applications of the rollover technique that are really quite ...
Ok, so I know I promised no more updates, but this one is too ...
Alright, here’s another map-based rollover. The instructions are pretty simple: click on a state ...
Chandoo (of Chandoo.org) and Daniel Ferry (of ExcelHero.com) are kicking-off their new Excel School ...
As more people are use the rollover method (or “Interactive Hyperlinks” as Chandoo calls ...
Alright, so this seemed like the next logical step for the rollover method: This ...
So, as usual, I’ve been experimenting more with the rollover technique. Last night, I started ...
Reader Bert van Zandbergen sent me a cool modification to the instruction file in How ...
More people are interested in Excel mouse rollovers, which I think is great. I’m ...
I’ve been on a real rollover kick lately. I’m really trying to figure out if ...
Before we start, you might have noticed some renovations on this blog. Yeah, it ...
Today, I found this journal article, The role of OR [Operations Research] specialists in ...
Wow, it’s been a while since my last article. I’ve actually been pretty busy ...
This article describes what I like to call “Easy One Way Sensitivity Analysis” in ...
So I’ve created a spreadsheet program that will import a selected bitmap and use ...
This is a long overdue article, my apologies. The basis of the article surrounds ...
“Rollover B8 OV1” (like Rollover Beethoven…? get it?)Update 17 July 2011: This blog entry ...
Sometimes, you’ll want to programmatically take advantage of Windows outside the capabilities readily available ...