Category Archives: Tips

Get a free bonus video when you purchase Dashboards

Until the end of September, Chandoo and I will be offering a free, one-hour bonus video with all purchases of Dashboards for Excel.

Here’s how to qualify for this offer:

  • Purchase a copy of the book form Amazon (you can also buy it from a bookstore, but I’m not sure if they’ll be on shelves by the end of September)
  • Email a copy of the purchase receipt to
  • We will send a link to watch the bonus video (we plan for it to be available in first week of October or thereabouts).

Order your copy today! 

The easy way to copy and paste an entire worksheet.

Here’s a quick tip before I go. Chances are you already knew it. But I’m never surprised anymore by how much I learn from others even this late in the game. And in case you didn’t already know it, it will make your life easier.

So sometimes I want to copy an entire worksheet tab into a new workbook where it can exists on its own. Previously, I would start up a new workbook, press CTRL+A and copy everything over. This method has its faults: sometimes formats don’t copy over correctly, sometimes what’s being copied is just too large for the clipboard. Turns out, there’s an easier way.

You can right click the worksheet tab you’re interested in and selected Move or Copy….

This brings up the Move or Copy dialog box.


First, you’ll check “Create a copy” at the bottom of the dialog box. In the first dropdown, you’ll select “(new book)”. When you press OK, the entire worksheet will have been copied exactly as it appears into a new workbook. You can also copy the worksheet into an already open workbook by selecting the desired tab from the dropdown.

What a time saver! I wonder how I missed this all those years.

Dashboards for Excel… it’s finally finished!

It’s finally done! That’s right: the entire manuscript is done and in production. It’s going to the printers soon. My publisher hasn’t yet updated the Amazon page, but the planned release date is September 15th!

Now, as you might recall, we spun out eight chapters from Dashboards to become Advanced Excel Essentials. So if you already own Essentials, think of Dashboards as the expanded second edition. Where Essentials was about 200 some pages; Dashboards is about 550! So, as you might imagine, there’s considerably more in Dashboards. If you’re on the fence about which to order, Dashboards for Excel is going to give you more bang for the buck given Amazon’s current pricing (which might change).

Order your copy today! Thanks to the venerable Chandoo who contributed the chapters on Power BI tools. And thanks to everyone for being so supportive.


Long time no see

It’s been a long time since you last heard from me. Several things have happened in my life. Well, first, I had to get a job. My consulting business was doing well, and I was actually pretty good at it (at least, I thought so). But circumstances unforeseen changed what I had to do next; and lo, I had to get a job, you know, a real job. So now I’m working for EY (Ernst & Young before 2013) doing talent analytics.

Also, you know, at some point in time I’m required to finished Dashboards for Excel. So instead of writing for this blog, I’ve been working hard to finish what I started. It’s a long, long book now, but progress has been made and it’s almost complete. The manuscript is in and I’m now just answering editorial comments. I’m so close to finishing this book, I can taste it. And looking back over these three years, I’m surprised to even be able to say that. At several points in the writing process the task seemed so great I wouldn’t finish. But I am finishing now, and finally, I will have my life back. 🙂

There are more books I want to write. But if I tell you I’m thinking of writing another book at any point over the next year, please someone punch me right in the face.

You should expect me to start posting more regularly here soon.

Thank you all for your support of me and this blog, your patience, and your passion for Excel.

Advanced Excel for Business – less than two weeks left to sign up!

2015-02-16 15_39_12-Microsoft Excel - Book1

If you’re in the Ohio Miami Valley, then don’t miss my Advanced Excel for Business workshop! There are still spots available, so don’t miss out. Remember, aside from the awesome skills you’ll learn, you’ll also get a free copy of Advanced Excel Essentials and a catered lunch. What could be better?

Click here to sign up now! 

Corporate discounts are available. If you have questions, feel free to call me at 937-329-9612 or you can email me at jordan (at)

Looking forward to seeing you there.