5 Reasons For Building Apps in Excel
Yes yes! This is the spicy part of Excel, right here. Somebody's out there in the world with an idea or a need for an app that will make them richer, more accurate, happier, smarter or all of those. In many instances an app is as close as a search in Bing, Yahoo! or...
Seeing Data Can Be More Helpful Than The Calculations
Today we see how data visualization eased a real-life crisis. No fancy Excel tricks, but the thought process behind the analysis called for a simple line graph that told the whole story and eased the crisis.
Real Data Management Is Managing People Who Don’t Like The Results
Once again, let's get out of the spreadsheet and discuss other things that we need to manage this world with reliable data. Today, we look at what it takes to fully own a data-driven role. Many of us are shocked when we take on a new position and discover how...
REDUX: Excel for Musicians
Today we have some fun and will revisit Excel for Musicians. No complicated techie tips today. More interesting however, is a simple data management exercise that will even appeal to non-musicians. Whenever we take on something new, it often helps to break it down...
Microsoft & The Tower of Babel
The Tower of Babel (Genesis 11:1-9) The whole world had one language and common speech. As people migrated eastward, they settled in the land of Shinar. People there sought to make bricks and mortar to build a city with a tower that reaches into the heavens, to make a...
If Office 365 (Excel 2013) Was A Car It’d Be A Terrafugia
Microsoft asked “if Office 365 was a car, what would it be?” No! Let’s just look at Excel 2013. It’s not a car at all! It’s a freaky mash-up like a Terrafugia. Excel 2013 had 4 wheels, wings, and rotor blades. Excel 2013 is like a Centaur, half man, half horse, lewd and lascivious.
High=100, Low=1, Chart = WTF?
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 jump right...
ExcelWebApp & Sriracha Smackdown Round 2
Rachel Esralew and I are leading Sriracha Smackdown Round II: The True Sensation. This will be a Google Hangout where many of us will sample and rate the joyful joy of various brands of sriracha. ♦♦ One night I stumbled across Rachel's...
Wear Your Underwear Over Your Pants! Create Excel Data Models
WARNING: Excel 2013 Content Ahead Chandoo, the Excel Master of Excel Masters and is a blessing for many of us in the Excel world. His humor and Excel knowledge keep us Excel geeks on top of our game. Today, I borrow from both his humor and his reminder of an Excel...
Excel Tip of the Month: Close the Frikken Spreadsheet
Let's add this to an earlier post about the 6 Quiet Habits for Working with Excel & Data. In that post I listed several best practices that won't ever end up in a "Make Excel Your Friend" manual. Yet, they are just as helpful as a nested IF statement. Here is #7:...
The Full Contact Sport of Parsing Data in Excel
I'm getting ready to teach a 2-session workshop on parsing data in Excel. As with other courses, before I teach them for the first time, I have to clarify the mindset to decide who would get the most from the course. Scrubbing data, reorganizing columns, peeling part...
One Thing I Can’t Teach About Excel: A.D.D.
Thanks to Susan Murphy of SuzeMuse for the encouragement to share this blogpost with you. Her blogpost What's Holding You Back From Telling Your Story has reminded me to just be a human being and write. Sometimes, I read so much about "how to blog" and "how to _____"...