Home »
Blog » Spreadsheet
Improvement Insights Blog
Posts tagged "Spreadsheet"
Ever noticed how long it takes for people to analyze a spreadsheet? Too long. How can a smart chart eliminate the delay and accelerate understanding?
“One of the things I’ve learned is spreadsheets… People do a lot of spreadsheets. 54% of the Excel spreadsheets out there have no formulas in them, or anything else for that matter; they’re just little reporty things.
“Now, one of the things for you to think about with a spreadsheet is, it’s an auditory process. You’re reading it cell by cell, by heading by heading, by whatever by whatever, and reading (an auditory thing) is a very slow process.
Continue Reading "Spreadsheets are Slow – Smart Charts Are Fast"
Posted by Jay Arthur in Agile Lean Six Sigma, Excel, Improvement Insights, Six Sigma.
My career was dipped in various management methods such as MBO and MBWA. Recently I read a new term: Management by Spreadsheet (MBS). Maybe there’s a better way.
“When I was working at the phone company we had a variety of management fads. I think first there was MBO, or “Management By Objectives.” Of course, that assumed that you know what your objectives were. We had MBWA, “Management By Wandering Around,” so the management team was wandering around all the time and just getting in our way. Recently I saw a different phraseology and I kind of liked it: MBS, which stands for “Management By Spreadsheet.”
Continue Reading "Management By Control Chart"
Posted by Jay Arthur in Agile Lean Six Sigma, Improvement Insights, Lean, QI Macros, Six Sigma.
Nobody wants to read your spreadsheet! No matter how hard you try to make it pretty, create great labels or whatever, the only person who can read your spreadsheet is a CFO or Excel spreadsheet geek. And the Excel geek is going to tell you 10 ways to make it prettier.
The purpose of data is to provide insights for action, not just report past performance.
How Do I Know That Most Excel Users Try to Make Their Spreadsheets Readable By People?
According to Renu Davi, Sr. Program Manager for Excel, Microsoft tracks how people use Excel. The vast majority of the 650 million users use it for lists and reports.
Continue Reading "Nobody Wants to Read Your Spreadsheet!"
Posted by Jay Arthur in Data Mining, QI Macros, Six Sigma.
