by Oz du Soleil | Nov 13, 2015 | Excel Geekdom
Last week I participated in my first Microsoft MVP Summit and it was a great experience. Several thousand MVPs are invited–each Microsoft product has its own MVP program. Word. Xbox, SQL Server, PowerPoint, Project … everythign! There are approximately 100...
by Oz du Soleil | Oct 13, 2015 | Excel Geekdom
My friend Mo works in the areas of branding and marketing. He text messaged me over the weekend, but I didn’t see it until about 5 hours after he’d sent the message. He was asking if I had a second to go over some Excel stuff with him. By the time we did...
by Oz du Soleil | Sep 29, 2015 | Excel Geekdom
This week Microsoft Excel celebrates its 30th birthday and there’s a lot going on. Over at the Contextures blog, Excel MVP Debra Dalgleish sent out a general call for people to submit their early memories of Excel. This week she will be posting the stories. So,...
by Oz du Soleil | Aug 23, 2015 | Being a Good Analyst, Data Integrity, Data Management, Excel Geekdom
The PASS Business Analytics Conference 2015 was April 20 to 22 and it was an honor to be a speaker, sharing knowledge and getting to know people in the Business Intelligence realm who are outside of Excel. PASS is primarily a SQL community but they recently started to...
by Oz du Soleil | Aug 6, 2015 | Being a Good Analyst, Data Integrity, Excel Geekdom
As we develop tools in Excel, it’s nice to be at a place where everything is automated. One change in a cell cascades through the spreadsheet and updates everything that’s impacted by the single change. However, there are times when we need to override a...
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...