Category Archives for Tips
Why I don’t like RUN buttons
When I first started this blog, I thought to myself: VBA is wonderful and amazing—there’s nothing you can’t do with it. I still love VBA, don’t get me wrong, but my relationship with the scripting language has changed considerably over the last several years. On a recent Excel.TV episode, Rick rightly pointed out the irony […]
Continue readingExcel for Business Workshop in West Chester, Ohio
COURSE DESCRIPTION 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 […]
Continue readingHappy 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 […]
Continue readingGet 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 […]
Continue readingTake an extra 25% off Advanced Excel Essentials!
Until 12pm tonight PST, you can receive an additional 25 percent off Advanced Excel Essentials when your purchase the book on Amazon. Use BOOKDEAL25 at check out. (Make sure to purchase the November 5th edition. The lower cost book coming out in April is a glitch in my publisher’s system.) Click here to order your […]
Continue readingA method for quickly importing and working with CSV files (part 2)
This is part 2 in which I explain how I solved the problem. Make sure to read the previous blog posts. Taken together, these show I though through and ultimately solved the problem. Query Tables to the Rescue! To solve this problem, I stumbled on something I rarely use, and that’s our good ol’ friend […]
Continue readingA method for quickly importing and working with CSV files (part 1)
So many folks have asked me to write more on my coding style. So here it is: I’ve developed a two-parter blog post to present my thinking style and how I ultimately solved the problem. The Problem I have a client with several CSV files that must be checked and validated for certain data specifications. […]
Continue readingOn using complex IFs and Chapter 3 (now free!)
Hello everyone! I’m releasing chapter 3 from my new book, Advanced Excel Essentials, for free! Click here to download Chapter 3! Then buy it on Amazon today! So over at Excel.TV I wrote a blog post that’s an extension of chapter 3 of my book on using IF formulas. Sorry for the dear followers of this blog […]
Continue readingGet Chapter 1 of Advanced Excel Essentials for Free!
Download Chapter 1 of my new book and let me know what you think in the comments. Chapter 1 Download: 9781484207352_Ch01
Continue readingAdvanced Excel Essentials has been Published!
Take your Excel skills to the next level! Advanced Excel Essentials can be purchased through Amazon or through Apress’ website. The eBook will be available soon and can only be ordered on Apress’ website right now. If you’re looking to save a few dollars, Amazon is the way to go. If you use any […]
Continue readingBook Updates, Info Graphics with Excel, Excel Sumo, and more…
Updates First, the updates. Sorry dear readers I’ve been gone for so long. It’s been, well, two years since I started writing my book. I’m now 450+ pages with still a few more chapters to write. Here’s the thing, my book publisher would like me to finish my book–and rightly so! So that’s been taking […]
Continue readingUpcoming Live Workshops and Courses in Los Angeles and Cincinnati
I have several great training sessions and workshops coming up. If you’re interested in receiving training for your organization, let me know. Los Angeles, California, August 25-27th Free wine and beer will be served at both classes! Get the Picture: Intro to Data Visualization Tools With Microsoft Excel August 25th, 2014, 7-9pm Whether you’re an […]
Continue readingInteractive Spreadsheets for Decision Makers
In case you’ve missed it, my 70-minute long free webinar is available on YouTube. I’ll show you how to make three awesome decision tools in under an hour. Feel free to watch and share. And, remember: I can bring this and so much more to your organization! Send me a message at my consulting page […]
Continue readingMe vs Bill Jelen on the value of Option Explicit
Watch me argue it out with the wise and venerable (but ultimately incorrect) Bill “Mr. Excel” Jelen on the topic of using Option Explicit in your code. I argue for the affirmative (that you should use it) while Bill takes the status quo. Let me know your thoughts.
Continue readingGenerating random qualitative data in a pinch
There are plenty of terrific random data generators for Excel out there. But sometimes you just need some fake data qualitative data without the fuss. For instance, perhaps I want to generate a random list of data points with the values low, medium, or high. A simple method I recommend combines RANDBETWEEN with CHOOSE. Take […]
Continue reading