by Oz du Soleil | Mar 3, 2015 | Excel Geekdom
On ExcelTV episode 24 someone mentioned a Business Insiders article where Google plans to nab 80% of Microsoft’s Office business. This sounded ludicrous because every time I’ve tried to use Google Sheets for anything serious here’s how it tends to...
by Oz du Soleil | Jan 26, 2015 | Being a Good Analyst, Case Studies, Data Management, Excel Geekdom
Kevin Lehrbass of My spreadsheet Lab posted this video Sunday night and there are aspects of it that need to be highlighted while it’s still hot out of the oven. PEOPLE PROCESSES TOOLS In keeping with a recent theme of People-Processes-Tools, Kevin’s video...
by Oz du Soleil | Jan 23, 2015 | Data Management, Excel Geekdom
Please forgive me because I’m blogging while angry. I’ve read a few articles that compare R and Excel and I’m steamed. But first: why does this matter? Why respond? Shiny New Thing Syndrome is easy to fuel with a comparison of options. Rather than...
by Oz du Soleil | Nov 10, 2014 | Excel Geekdom, Tips
The anti-VLOOKUP people are at it again, and let’s blame Sumit Bansal at TrumpExcel.com (of course, I’m joking). VLOOKUP Vs. INDEX/MATCH – The Debate Ends Here! is a blogpost that’s quite thoughtful in how it addresses something in the Excel...
by Oz du Soleil | Oct 28, 2014 | Data Management, Excel Geekdom
THE PINOCCHIO THEORY In 1977 Bootsy Collins released the hit song Pinocchio Theory. Its main warning is: If you fake the funk, your nose will grow There are a lot of long noses in the data world–specifically with folks who continually bash Excel and write its...
by Oz du Soleil | Oct 22, 2014 | Excel Geekdom, Tips
“Teach me Excel” is a tough request to satisfy because it’s so vague, and the person making the request doesn’t realize the bottomless possibilities within Excel. When the open-ended requests “teach me Excel” come to me,...
