In case you’ve missed it, my 70-minute long free webinar is available on YouTube. ...
- Home
- |
- Category: Excel Tips & Tricks
Watch me argue it out with the wise and venerable (but ultimately incorrect) Bill ...
There are plenty of terrific random data generators for Excel out there. But sometimes ...
Most of us code using the Hungarian notation style when writing VBA code. Basically, ...
There are many great articles and tutorials on how to build interactive data displays ...
I had a lot of fun putting together my recent list of Top Excel ...
I went to ALL the Excel Discussion Groups on the internet and asked all ...
Based on the great reception Rob Collie has had in Cleveland, I am attempting ...
First of all, happy spreadsheet day! It was on this date today that VisiCalc ...
Dude… Like a REALLLL Video Game in Excel??? Like… Free, Right? Yeah… That’s what ...
Pedro Wave made a few updates to the 3d Maze spreadsheet that I really love. ...
I’ve found a rather obnoxious bug in the version of Excel 2013 that comes ...
Disclaimer: The following tutorial requires Conditional Formatting which is a feature of Excel 2010 ...
This is part of a series called “VBA4Play,” written in conjunction with Excel game ...
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 ...
In my opinion, these are the two worst Excel errors ever: Code execution has ...
You were handed a spreadsheet of exported data from some legacy system. The data ...
Here’s a fun little fortune cookie program. The fortunes are generated from a list ...
I want to highlight two applications of the rollover technique that are really quite ...
First, the updates. If you’re an avid follower or even a casual reader, you’ve ...
Excel data validation not only includes controlling a specific cell, but it also allows ...
Data validation, when used within the Excel framework, is basically a control function. In ...
A reader on one of the LinkedIn Excel Groups recently asked how to delete ...
Do you work with different series in your Excel charts? Here is what I would ...
Form controls are great for reporting information about groups of items, like a list ...
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 ...
You probably noticed a “bug” while playing around with my Interactive Periodic Table of ...
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 ...
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 ...
In my last post I used my patented rollover technique to create an effect similar ...
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 ...
Later this month, I’ll be attending the INFORMS Conference on Business Analytics and Operations Research in ...
Anyone who has used a Form Control Label likely knows its limitations: you can’t ...
So I’ve created a spreadsheet program that will import a selected bitmap and use ...
Have you had a list of names but found your cell width too small ...
Most importantly, use your wordsAn ideal Excel filename should be two or three succinct ...
This is a long overdue article, my apologies. The basis of the article surrounds ...
Anyone who has a made a dashboard in Excel before has probably experienced this ...
Now that I actually have some traffic to this blog, it’s probably time I ...
“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 ...