Excel Ultimate Lookup Guide Free Download Sorry about how late this post is. Some ...

Read More

Get file from Folder Get File From Folder is what Microsoft has named the ...

Read More

Introduction Welcome back to another episode of Excel.TV where Oz du Soleil shares his ...

Read More

Introduction I built a chart that let’s you highlight a series from a smaller ...

Read More

In this blog post, we’ll talk about how to create a relative file path. ...

Read More

Turn any image into an Excel file? Ever think about turning your face or ...

Read More

Excel.TV’s 50th Episode! It’s finally here! Roll out the red carpet, prep the T-shirt ...

Read More

How to Make Excel Faster Friday Fire is back with an all new episode ...

Read More

When I teach how to develop dashboards in Excel, I'm often asked if the ...

Read More

The 2016 Presidential Election Map is Now Available This was first created 4 years ...

Read More

Written by Bjoern Stiel APIs are the lifeblood of the internet, providing access to ...

Read More

Each month, we’ll introduce you to up-and-coming and new-to-the-scene Excel and data analysis blogs. ...

Read More

As we kickoff this new year of Excel.TV, we’re proud to pioneer the new ...

Read More

I recently contributed to the article on MRC’s Cup of Joe Blog called 7 harmful ...

Read More

EDIT: Unfortunately, the deal has ended. I’m writing this from my car on my ...

Read More

In a previous tip, I had complained about form control option buttons. I had ...

Read More

On your dashboards, reports, and charts it’s a good idea to alert the user ...

Read More

So let’s take a look at your standard form control option buttons. In the ...

Read More

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

Read More

At the PASS Business Analytics Conferences, I spoke about building better Excel models. Some ...

Read More

The theme colors for Excel 2013 are probably the best scheme to date. However, ...

Read More

When I first started this blog, I thought to myself: VBA is wonderful and ...

Read More

  I’m often asked this question, so I’ve decided to give my thoughts on ...

Read More

Today is the day of the final test for the sixteen competitors. Rick took ...

Read More

Hello everyone! I’m releasing chapter 3 from my new book, Advanced Excel Essentials, for free! ...

Read More

What a Great Time! In case you missed it, the Excel.TV team made a ...

Read More

Take your Excel skills to the next level!     Advanced Excel Essentials can be ...

Read More

I’m not always the biggest fan of info graphics. Many of the posters-sized info ...

Read More

In this episode, we interview the esteemed Ken Puls. Ken hails from Canada (the ...

Read More

The Most Interesting Spreadsheet Developer in the World This week we’re proud to interview ...

Read More

Table Master ExtraordinaireFor episode 11 we were joined by Excel MVP and Table aficionado, ...

Read More

The Chart Master Himself In episode 10, we welcome the Chartmaster, Jon Peltier. If ...

Read More

ModelOFF: The Largest Excel Modeling Competition in the World This is our ninth episode ...

Read More

Add-Ins are a great way to increase Excel’s firepower. Add-Ins not only add additional ...

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

In case you’ve missed it, my 70-minute long free webinar is available on YouTube. ...

Read More

Watch me argue it out with the wise and venerable (but ultimately incorrect) Bill ...

Read More

There are plenty of terrific random data generators for Excel out there. But sometimes ...

Read More

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

Read More

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

Read More

Wishing everyone a happy holiday and a terrific new year! Download file: Happy Holidays.xlsm ...

Read More

Based on the great reception Rob Collie has had in Cleveland, I am attempting ...

Read More

First of all, happy spreadsheet day! It was on this date today that VisiCalc ...

Read More

On October 1st, I was surprised to see I had been recognized by Microsoft ...

Read More

Pedro Wave made a few updates to the 3d Maze spreadsheet that I really love. ...

Read More

I’ve found a rather obnoxious bug in the version of Excel 2013 that comes ...

Read More

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

Read More

This is part of a series called “VBA4Play,” written in conjunction with Excel game ...

Read More

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

Read More

In my opinion, these are the two worst Excel errors ever: Code execution has ...

Read More

Here’s a fun little fortune cookie program. The fortunes are generated from a list ...

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

First, the updates. If you’re an avid follower or even a casual reader, you’ve ...

Read More

The other day, there was a discussion on one of the LinkedIn Excel Groups ...

Read More

A reader on one of the LinkedIn Excel Groups recently asked how to delete ...

Read More

Do you work with different series in your Excel charts? Here is what I would ...

Read More

Hello World! (Sorry, I could not resist J) I was recently asked by our ...

Read More

These last few months have been great to this humble blog – and to ...

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

When I’m all done with my Excel application, I’ll usually want to flip off ...

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

First, a big thank you to everyone following my blog. Here’s some stuff I’d ...

Read More

Reader, Bert van Zandbergen, from Beekbergen, The Netherlands (Holland) sent me his own cool ...

Read More

There are a lot of awful visualizations and info graphics floating around the internet. I’ve ...

Read More

Later this month, I’ll be attending the INFORMS Conference on Business Analytics and Operations Research in ...

Read More

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

Read More

Have you had a list of names but found your cell width too small ...

Read More

In the last post, A Dynamic Dashboard for Project Durations and Costs in Excel, we talked ...

Read More

Most importantly, use your wordsAn ideal Excel filename should be two or three succinct ...

Read More

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

Read More

So you’ve got a project that requires VBA – you’re ready and excited – and you ...

Read More

Anyone who has a made a dashboard in Excel before has probably experienced this ...

Read More

Now that I actually have some traffic to this blog, it’s probably time I ...

Read More

“Rollover B8 OV1” (like Rollover Beethoven…? get it?)Update 17 July 2011: This blog entry ...

Read More

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

Read More

Excel really doesn’t have an explicit “between function” to allow users, given a set ...

Read More