Advanced Excel Archives - Page 2 of 3 - Excel TV

Category Archives for Advanced Excel

Handling Excel Rollover Popups

Various people have written to me asking what they should do about popups generated by the rollover method that don’t go away on their own. Essentially, the rollover method provides for an “on mouse over” style routine but not for a “on mouse out.” The “moat” method One method to address this is to create […]

Continue reading

A Dynamically Linked Checkbox Matrix with Microsoft Excel

Edit: sorry for some of the squashed images you see in this and other posts. I’m still working on my layout. In the meantime, click on an image to view it in full if you’re having trouble. Today, I want to show you what I liked to call a “ dynamically linked matrix.” I’ll post […]

Continue reading

The Excel Lab: Soundex Search

Every once in a while, I have a spreadsheet that sits in my ‘lab’ for way too long. At a certain point, I have to admit that I’m never going to finish it completely or do a full blog post on it. I’ve decided just to release one such spreadsheet as is. Perhaps you will […]

Continue reading

Two Great Applications of Rollovers

I want to highlight two applications of the rollover technique that are really quite phenomenal. Square Charts and Treemaps in Excel If you haven’t seen the work of the Frankens Team yet – you’re missing out. They’re a group of…geniuses, really…who investigate and push Excel’s limit. Very recently, they wrote on the development of square […]

Continue reading

CUBE: The Rollover Method Returns! Spin a cube in a 3d environment with your mouse!

Ok, so I know I promised no more updates, but this one is too cool. Basically, I combined Andy Pope’s 3d rotation tutorial with the rollover method. The result is a free-floating cube which you can rotate by passing your mouse over it. Here’s a choppy-ish video of what’s going on. I promise however that it […]

Continue reading

Interactive United States 2012 Presidential Scoreboard in Excel

Alright, here’s another map-based rollover. The instructions are pretty simple: click on a state to toggle through its party selection. Click on one of the three selections above to change scenarios. In the next month or so, I’ll be putting together a tutorial on this. But in the meantime, have some fun. Download. Ask questions […]

Continue reading

Recommendation: Excel School + Excel Hero Academy Bundle

Chandoo (of Chandoo.org) and Daniel Ferry (of ExcelHero.com) are kicking-off their new Excel School and Excel Hero Academy. If you really want to learn Excel—and I mean learn Excel—I recommend their new courses. It’s true; I’ve never taken a course from either of them. However, much of what you see on this website is a direct […]

Continue reading

The Excel Rollover Mini FAQ

As more people are use the rollover method (or “Interactive Hyperlinks” as Chandoo calls them), I thought it might be helpful to answer common questions I’ve seen popping up on forums. So, in no particular order, I present the Excel Rollover Mini FAQ! 1. Are there example articles and spreadsheets on how to use Excel […]

Continue reading

Interactive Map in Excel using Rollovers

Alright, so this seemed like the next logical step for the rollover method: This one is kinda complicated, I admit. Unfortunately, I didn’t really take the time to clean up the spreadsheet file for others to follow (I don’t really have the time these days). Sorry. But try to take it apart – and ask […]

Continue reading

Details on Demand: Bring up details on a graph with Excel rollovers

So, as usual, I’ve been experimenting more with the rollover technique. Last night, I started experimenting with adding the capability to rollover a point on a chart (instead of just a worksheet cell) to see if I could have a label appear – or just some event fire – upon the mouse entering a chart’s datapoint’s […]

Continue reading

Guest Post: Rollover for Months and Years

Reader Bert van Zandbergen sent me a cool modification to the instruction file in How to: highlighting cells using the rollover technique in Excel to include years and months – not just rows and columns. He writes: I am an enthousiast reader of the blog ‘Option Explicit’. I changed the formula (see below) and made a version for […]

Continue reading

Needs More Rollover: Quick Tip!

More people are interested in Excel mouse rollovers, which I think is great. I’m especially enthusiastic about Chandoo’s latest dashboard contest where I found out that several contestants used the technique! By the way, there are many great dashboards showcased in the contest. Take a look and make sure to vote! So here’s the tip. If […]

Continue reading

Interactive Periodic Table of Elements in Excel

I’ve been on a real rollover kick lately. I’m really trying to figure out if it can be useful. Earlier today I started making a Periodic Table of Elements using Excel. I employed the rollover technique to allow the user to gain information about an element simply by rolling over a cell. Well, for some reason, […]

Continue reading

Rollovers for Gantt Charts

Before we start, you might have noticed some renovations on this blog. Yeah, it was time for a change. I’m working this template out, so sorry if some of the formats seem off. Also, I have started a new facebook page. I’ll be keeping it updated with stories from my favorite blogs. Also, you can […]

Continue reading

Spreadsheet Guidelines and Best Practices

Today, I found this journal article, The role of OR [Operations Research] specialists in ‘do it yourself’ spreadsheet development, from the European Journal of Operational Research, by John S Edwards, Paul N Finlay, John M Wilson. The article outlines 20 Guidelines for Spreadsheet Development and 21 Best Practices Points, which I excerpt below. Guidelines for Spreadsheet […]

Continue reading
>