by Oz du Soleil | Aug 27, 2013 | Spreadsheet Development
BFTBY: Blogging From The Backyard This weekend a friend asked me to take a look at her spreadsheet for a bit of manicure and polish. When I received the document, it was beautiful. So, the polish that I had was easy to apply. I can’t share the data with you...
by Oz du Soleil | Jul 10, 2013 | Case Studies, Data Management, Excel Geekdom
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...
by Oz du Soleil | Oct 2, 2012 | Data Management, Excel Geekdom
When Mr. Excel, Bill Jelen, is excited about something it’s time to pay attention. Excel Interactive View is part of Office 15 and is creating a lot of excitement because it allows users to analyze and manipulate data on a web page. Simply mind-blowing. Check...
by Oz du Soleil | Oct 2, 2012 | Excel Geekdom, Spreadsheet Development
Live Data For Your Exploration of Excel Interactive View Hop in and Let’s Go! The table below is random Data for 66 people whom I created with a Data Generator to display Excel Interactive View (click here for Excel Interactive View Part 1). With Excel...
by Oz du Soleil | Sep 19, 2012 | How Tos and Q&As
THREE people in the past 24 hours have had DROPDOWN DRAMA! But there are easy solutions. We just need to relax. QUESTION Cheryl maintains clean data, by using dropdown lists to control data entry. But there’s a problem she describes: “Oh! I hate it when I...