Excel Tweets Roundup 20190125
Is it possible to add too many sheets to your Excel workbook? Maybe we should have an 8 PM meeting to discuss this. Or, we could just communicate via our Excel files instead – that sounds like a better idea!
This Week’s Tweets
Here are my favourite Excel tweets, from this week’s collection.
________________________________________________
I just learned how to spell check an entire excel workbook in one go and I feel invincible!
— Stephannie Roy (@DocSteph) January 23, 2019
________________________________________________
Is there anything more upsetting than an Excel worksheet with no formulae in?
(Well, Brexit probably, but it’s a close thing…)
— Jonathan Minton (@JonMinton) January 21, 2019
________________________________________________
Many praise Pivot Tables for innovation (it is) but Excel’s “Text to Columns” and just opening/pasting CSV perhaps even larger impact in terms of “saved me a million minutes”.
— Steven Sinofsky (@stevesi) January 22, 2019
________________________________________________
My boss: Fill out this 1000 row Excel spreadsheet
Me: Take it away, Mary.
Mary Oliver: pic.twitter.com/3fkOrqi70V— Haley (@astral_cars) January 24, 2019
________________________________________________
My most marketable, professional skill is my ability to stare at an excel workbook for 4 hours and still not make any sense of it.
— Katie Kurtz (@katiekurtz15) January 24, 2019
________________________________________________
Stupid meeting for my research group. Who meets at 8 pm to code Excel macros ;-;
— head lich in charge (@positron147) January 24, 2019
________________________________________________
today my boss asked me how i was at excel and was highly pleased with my answer of: “well i passed a class for college on it 6 years ago with a 100% and i’m an excellent googler so i’ll go with proficient i guess”
— Megan (@fantasima) January 23, 2019
________________________________________________
How many worksheets are too many for one Excel workbook? Currently I am at 40 worksheets and that number is rapidly increasing. Has my obsession with Excel gone too far? #Excelobsession #OCD #dataanalysis #communitycomposition #metadata pic.twitter.com/Z6nDxpoC52
— Heather A. Stewart (@StressedScience) January 22, 2019
________________________________________________
Personally, I attribute vast portions of world GDP growth past 1990 to the VLOOKUP function…
— Tomas Rollo (@tomasrollo) January 22, 2019
________________________________________________
My manager early this morning: how much do you know about charts in excel?
Me: I know a lot, what’s up?
Manager: Oh cool – I just need *insert something impossible*
— J. (@_JessiKay) January 23, 2019
________________________________________________
One day I will memorize the Excel formula for standard error instead of googling it every time I start a new workbook. One day.
— David Bayless (@davbayless) January 23, 2019
________________________________________________
The problem I have with people is the talking part. Why can’t we all just communicate via elaborate and beautifully crafted Excel spreadsheets?????
— Lily (@Echo_of_hope) January 22, 2019
________________________________________________
Excel Tweets Roundup
Thanks for reading this week’s Excel tweets roundup, and see you back here soon!
I stare at spreadsheets all day!
_____________________
According to Microsoft, fewer workbooks have formulas than have pivot tables. Both figures are in the single digit percentages.
Wow! I’m not surprised that pivot table use is so low, but expected formulas to be much higher than single digits.
Those stats came from Microsoft, and it’s based on their telemetry data. So it’s probably skewed towards non-savvy users who don’t even know it’s there and so don’t turn it off, and away from corporate users whose IT departments lock everything down.
The analysis is that many worksheets are used for making lists. No formulas. And often when an analysis is done and sent to these people, someone has build a model with pivot tables and no formulas. So workbooks with pivot tables outnumber those with formulas.
Ah, that makes sense, thanks!