Modular Spreadsheet Development
Chandoo recently posted about Modular Spreadsheet Development (MDS). Like it was for him, this is a new concept for me but it made sense. The idea of Modular Spreadsheet Development is efficiency. If you're developing certain spreadsheet elements over and over again,...
IgniteChicago: The Power of Data
On 2APR14 I had the honor of Presenting at IgniteChicago and sharing the story about my first effort doing anything real with Excel. That 1 task lead to nearly daily use of Excel for the next 15 years. When I heard about IgniteChicago, I immediately submitted a...
5 Lessons From Stand-Up & Improv For Excel Trainers
September 2013 I started taking Improv and Stand-Up classes at Second City Training Center where famous alumni include: Joan Rivers, Alan Arkin, Tina Fey, Tim Meadows, Amy Sedaris, Cecily Strong, Amy Poehler, and Stephen Colbert. No. This isn't the start of a...
Excel On The Come-up in 2014
It's been a while since I've blogged. There's a lot going on, and it's all about Excel y'all! 2014: Excel is on the come-up Many of us in the Excel community are taking different approaches to get the word out about Excel's newest features and elbowing our way into...
3 Reasons To Use VBA: It Tames Beasts!
A while ago I wrote a blogpost that attracted some hostility. One commenter even called it "stupid." 6 Reasons Not To Use VBA (Or Be Careful) was meant to be a fun warning and an invitation to BE CAREFUL. Ah! But a few folks took it as a swearing off of VBA coding,...
Robust Tasks In Excel Using Dependent Droplists, Tables & A Little VBA
Q: Why does a knight have a lance, armor and a solid horse? A: All of those pieces make it a helluva lot easier to succeed inside the reality of knocking another person off of their horse. The task of unhorsing is fairly simple in concept. But problems arise quickly...
Use Excel to Randomize Lunch: Haggis, Anyone?
Today, we look at a basic need and take it a few steps further. The result is a mini app for randomizing meals. We won't get into the dirty how-to of formulas. Instead, we'll think through what's needed to make something really work for a repeated task. ...
Where are Excel & Google Spreadsheet Headed? Part 6 of 6
Here we are at the final day of a 6-day tour that started with a question: where are Excel and Google spreadsheet headed? We've gone on a fascinating journey across a vivid landscape in this world of spreadsheets, particularly Excel, the #1 BI tool around the world....
Where are Excel & Google Spreadsheet Headed? Part 5 of 6
We're almost at the end, good people. Part 1: The Introduction Part 2: Bill Jelen & Hiran de Silva Part 3: Craig Hatmaker & Rob Collie 1 Part 4: Craig Hatmaker & Rob Collie 2 Part 5: Jordan Goldmeier & Carl Arriaza Part 6: Szilvia Juhasz & Closing...
Where are Excel & Google Spreadsheet Headed? Part 4 of 6
Part 1: The Introduction Part 2: Bill Jelen & Hiran de Silva Part 3: Craig Hatmaker & Rob Collie 1 Part 4: Craig Hatmaker & Rob Collie 2 Part 5: Jordan Goldmeier & Carl Arriaza Part 6: Szilvia Juhasz & Closing Comments The conversation continues...
Where are Excel & Google Spreadsheet Headed? Part 3 of 6
Continuing the conversation Part 1: The Introduction Part 2: Bill Jelen & Hiran de Silva Part 3: Craig Hatmaker & Rob Collie 1 Part 4: Craig Hatmaker & Rob Collie 2 Part 5: Jordan Goldmeier & Carl Arriaza Part 6: Szilvia Juhasz & Closing Comments...
Where are Excel & Google Spreadsheet Headed? Part 2 of 6
Part 1: The Introduction Part 2: Bill Jelen & Hiran de Silva Part 3: Craig Hatmaker & Rob Collie 1 Part 4: Craig Hatmaker & Rob Collie 2 Part 5: Jordan Goldmeier & Carl Arriaza Part 6: Szilvia Juhasz & Closing Comments Yesterday, I introduced a...