In this article, we’ll talk about how to complete random shuffling with only formulas. ...

Read More

Written by Bjoern Stiel Add-Ins are a great way to increase Excel’s firepower. Add-Ins not ...

Read More

In the first part of my manifesto, I outlined why I think we should ...

Read More

A little while ago, I made a blog post on why I think we ...

Read More

Most of us code using the Hungarian notation style when writing VBA code. Basically, ...

Read More

That’s right, if you’re in the San Francisco bay area, don’t miss an exciting ...

Read More

There are many great articles and tutorials on how to build interactive data displays ...

Read More

Disclaimer: The following tutorial requires Conditional Formatting which is a feature of Excel 2010 ...

Read More

Various people have written to me asking what they should do about popups generated ...

Read More

Every once in a while, I have a spreadsheet that sits in my ‘lab’ ...

Read More

I want to highlight two applications of the rollover technique that are really quite ...

Read More

Alright, here’s another map-based rollover. The instructions are pretty simple: click on a state ...

Read More

Chandoo (of Chandoo.org) and Daniel Ferry (of ExcelHero.com) are kicking-off their new Excel School ...

Read More

As more people are use the rollover method (or “Interactive Hyperlinks” as Chandoo calls ...

Read More

Alright, so this seemed like the next logical step for the rollover method: This ...

Read More

So, as usual, I’ve been experimenting more with the rollover technique. Last night, I started ...

Read More

Reader Bert van Zandbergen sent me a cool modification to the instruction file in How ...

Read More

More people are interested in Excel mouse rollovers, which I think is great. I’m ...

Read More

Before we start, you might have noticed some renovations on this blog. Yeah, it ...

Read More

Today, I found this journal article, The role of OR [Operations Research] specialists in ...

Read More

So I’ve created a spreadsheet program that will import a selected bitmap and use ...

Read More

This is a long overdue article, my apologies. The basis of the article surrounds ...

Read More

Sometimes, you’ll want to programmatically take advantage of Windows outside the capabilities readily available ...

Read More