by Oz du Soleil | Jul 30, 2015 | Excel Geekdom, Spreadsheet Development, Tips
Months ago, my friend Michael asked, “is Excel for the common man?” That question has stirred my attention and imagination like I’ve just turned 21 years old again. Excel can be used for so many things and it’s been fun to come up with uses for...
by Oz du Soleil | Nov 10, 2014 | Excel Geekdom, Tips
The anti-VLOOKUP people are at it again, and let’s blame Sumit Bansal at TrumpExcel.com (of course, I’m joking). VLOOKUP Vs. INDEX/MATCH – The Debate Ends Here! is a blogpost that’s quite thoughtful in how it addresses something in the Excel...
by Oz du Soleil | Oct 22, 2014 | Excel Geekdom, Tips
“Teach me Excel” is a tough request to satisfy because it’s so vague, and the person making the request doesn’t realize the bottomless possibilities within Excel. When the open-ended requests “teach me Excel” come to me,...
by Oz du Soleil | Mar 24, 2014 | Tips
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...
by Oz du Soleil | Mar 3, 2014 | Data Integrity, Spreadsheet Development, Tips
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...
by Oz du Soleil | Jul 16, 2013 | Tips
If you make a lot of charts, here’s a too often unused feature in Excel: Logarithmic Scale. Thanks to fellow Excel Badass Blogger Michael Rempel for this tip! In the video below, I take the tip further to include a secondary axis and and area graph. Let’s...
