Where are Excel & Google Spreadsheet Headed? Part 1 of 6
Part 1: The Introduction Part 2: Bill Jelen & Hiran de Silva Part 3: Craig Hatmaker & Rob Collie 1 Part 4: Craig Hatmaker & Rob Collie 2 Part 5: Jordan Goldmeier & Carl Arriaza Part 6: Szilvia Juhasz & Closing Comments The next few blogposts will...
Three Things I Learned About Digital Analytics From Teaching About Digital Analytics
I've written several blogposts referring to my friend (and fellow bassist) Keidra Chaney, and it's a pleasure to have her as a guest blogger today. She and I share a passion for empowering people to work with data because we've seen that there's need for more than...
3 Words for 2014: Vision, Choose & Immodesty
Through Chris Penn and Susan Murphy I discovered this exercise in 2013 and it was pretty darned effective. Rather than a new year's resolution, pick 3 words that will trigger actions or remind you to avoid certain things. Chris Brogan started this several years ago...
Data Visualization, Dashboards & the Dialect Study
Let's talk Data Visualization today because the Joshua Katz study "Beyond Soda, Pop, or Coke" is stirring folks up again! "I don't sound anything like I'm from Boston!" "Arkansas?! I've never even visited Arkansas?" "Do I really sound like I'm from upper Wisconsin?"...
4 Insights From My Excel Students
A conversation with a fellow teacher enlightened us both to the fact that the wide range of students bring realities into the classroom that we’d never encounter on our own. This blogpost lists 4 insights that have come through my Excel students.
App Development, ExcelWebApp, Break-Even Calculator
October 2012, I posted a mild complaint about the ability to build a calculator in Excel and then publish online via ExcelWebApp. The Excel piece was easy. The WebApp piece was disappointing but was infinitely better than Google's version. Yesterday a friend asked me...
Big Data, Schmig Data. How ‘Bout Some Perspective?
Last night I taught the 3rd of a 3-session private workshop in a nonprofit organization. The initial conversation was from the nonprofit's IT Director, Margo, who requested, "We're upgrading to Excel 2013 and would like someone to come in and show us what's new."...
Excel: The Dennis Rodman Of Business Intelligence Tools
In the world of Business Intelligence, Excel is the Dennis Rodman among other technologies. Excel is everywhere, getting the hard work done while the SQL and web developers get the glamour. It’s time for Excel developers to step up and claim respect.
Steve Harvey, Expertise & Experience
Today's blogpost is driven by a concern that experts are irresponsibly encouraging people "you can do this, too." And those of us who want to learn a new expertise aren't asking: what will it take for me to become effective? In the world of Excel and Data Management,...
Interviewing, Excel Skills & Data Management Mentality
Interviewing for an Excel-heavy role requires asking more about Data Management than Excel details.
What Elements Are In a Strong Spreadsheet? (Contiguous Data)
QUESTION What are the elements of a strong spreadsheet? This question came from Judie Knoerle of Red Cup Presentations. Judy and I attend a networking group and I spoke highly of a friend's spreadsheet. My friend had asked me to look at her spreadsheet and "look at"...
BFTBY: Keep Your Data In One Place, Don’t Work So Hard!
A friend asked me to look at her spreadsheet and it was beautiful. She set it up so that she didn’t have to work so hard. She left her data all in one place, resisting a natural urge to peel it into categories, and opening the door into Data Hell.
In this blogpost we discus the merits of contiguous data.