Category Archives: Tips

Excel for Business Workshop in West Chester, Ohio


Have you mastered VLOOKUP and INDEX? Have you not met a Pivot Table you couldn’t best? Then this is the class for you.

With this advanced course, I’ll teach you powerful techniques to take your skills to the next level. This is a full-day hands-on workshop, where we’ll use Excel’s features and functions in novel and innovative ways to create products that rival the large, business intelligence vendors. I’ll show you how to create data visualizations and interactivity not thought possible with Excel. And I’ll show you how to make them fast and efficient, so you can use model results without waiting.


  • Create fast and efficient spreadsheet models.
  • Use Excel’s boolean functions to select, filter, and aggregate data on the fly.
  • Avoid common spreadsheet development pitfalls
  • Apply techniques in your dashboard, decision model, and data visualization tools


All attendees will receive an absotlutely free copy of my book, Advanced Excel Essentials


  • Following along on your laptop is encouraged but necessary. If you want to follow along, you’ll need Excel 2007 or above installed on a Windows laptop.
  • This course qualifies for CPE credits. You will receive a certificate upon completion.
  • Group discounts are available, please call 937-329-9612 to inquire.


The cost of the class is $197 per person. This workshop has a limited number of seats which fill up quickly, so you should sign up as soon as possible. Until the end of January, use discount code EARLYBIRD to receive a 35% discount.


You may receive a 50% refund if you cancel a week before the event. Beyond that, refunds will be issued at our sole discretion. If inclimate weather causes the event to be canceled by the venue, we will let you know as soon as possible and change the event date.


Contact Jordan Goldmeier by calling 937-329-9612 or by email

Until the end of January, use discount code EARLYBIRD to receive a 35% discount.

Happy Holidays 2014

Hello everyone. I’m a little late getting out my holiday card. Unfortunately, it’s not as polished as last year’s, which had falling snow. So, I’m sending you this card, which isn’t perfect. Just pretend it’s something your kid made with glued macaroni.

Move your mouse around like a flashlight to reveal a hidden message. See below:


If you look at the backend pieces, you’ll see some extra fat that could have been trimmed. But, for now, I’m happy with it!

Keep on calculat’n’, friends.

Download the Holiday Card!

(It’s hosted on Google Drive so you might have to hit a ‘Download’ button.)

Get Advanced Excel Essentials for $9.99!

I wish this deal were available a few days ago.

Apress’ parent company, Springer, currently has a coupon to receive $30 off any of their books, including Advanced Excel Essentials.

Here’s what you do:

1. Go here to my Advanced Excel Essentials book page. Then click “Get it now.”

2. Use the coupon code HLDY14A to take $30 off the regular price. That’s all. Shipping is free.

Obviously, you can use this code for any of the other books in their library. I’m not affiliated with the coupon, so I won’t get a kick back every time you use it (in fact, I’ll make pennies in royalties from the lowered price!) nor can I really troubleshoot if it doesn’t work. I will say that it’s worked for my friend’s who’ve tried it, so why not give it a try yourself?