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 27, 2012 | Excel Geekdom
Brace yourself. I haven’t presented myself like this before. What’s Got My Hackles Up? Over the past few months I’ve mentioned Excel in certain situations and it’s been met with contempt and borderline hostility. This started with a conference...
by Oz du Soleil | Sep 25, 2012 | Data Integrity, Data Management
Today, 25 September, is my birthday and this reminds me of something: Data Collection Efforts That Invite Crap Data Crap data leads to questionable analysis, bad business decisions, and even contempt of your own customers because they’re the ones who fed you...
by Oz du Soleil | Sep 23, 2012 | Excel Management
QUESTION Keely is trying to merge 2 lists and the Excel date format is different between the 2 lists. List 1: Date and Time in one cell 3/14/2011 11:20 AM List 2: Date only 3/14/2011 What’s the deal? ANSWER We can solve this formatting...
