by Oz du Soleil | Feb 3, 2013 | Excel Geekdom, Spreadsheet Development
I’m going to clean up a mess I started. I’ve complained about Excel not being easy to integrate into the internet or replicate its complete functionality in the almighty cloud. As I research further it’s clear that bringing anything into the cloud is...
by Oz du Soleil | Jan 14, 2013 | Data Management, Excel Geekdom, Screencast, Tips
Tonight, I’m preparing to teach a workshop and need examples to show the students. Here’s your behind-the-scenes peek into using Excel to generate data to build useful examples. WHY GENERATE BOGUS DATA (AKA DUMMY DATA) SETS? Knowing how to generate random...
by Oz du Soleil | Oct 9, 2012 | Data Management, Excel Geekdom
UPDATE (2DEC13): ExcelWebApp continues to improve. They’ve added key validation features that didn’t exist when I originally published this blogpost in October 2012. See: App Development in Excel and Break-Even Calculator ♦♦♦ This was an unplanned blog...
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...