Excel Twitters 20090522 – Excel Theatre Blog

Everything in Excel should be done with one click, GetPivotData is evil, middle management can’t be trusted with colours, and life isn’t fair. These are just a few of the truths revealed in Twitter this week.

And remember, even if you’ve used Excel for years, you still might stumble onto an exciting feature you didn’t know about.

Data Wasteland

Another of my favourite interview questions: Make a chart in excel as if you were presenting to a client. They usually go 3D 🙁
Chart Chooser by Juice Analytics: Download Tufte-compliance Excel and PowerPoint charts http://bit.ly/14HcyL visualization charts
The ability to cut and paste charts from Wikipedia into Excel just made my day. Is that sad? It is, isn’t it?
Using excel charts as his weapon, he ventures out onto the wasteland of data. <sigh>

Adjust the Colour

Today i learned it is a bad idea to teach middle management how to change colors on excel charts. I think my retina are scorched
I need an excel spreadsheet with coordinating colors.

Fabulous Features

I just saved myself at least 3 hours of time by finding the “text to columns” feature in Excel. Incredibly happy.
NERD-RAVE: I just discovered “New Window” in Excel under the view, it allows me to view multiple tabs on my spreadsheet AT THE SAME TIME …
get numerous excel sheets on your screen and just stare at them, then switch between them occasionally, makes you look busy
Why does Excel help have a workaround for a watermark? Why not just create a watermark feature? Lazy Microsoft.

Evil Pivot Tables

Hey Excel Users! GETPIVOTDATA is EVIL! Please don’t use it, or if you do, use it wisely.
At a table full of accountants. Told a joke about pivot tables. I’m out of material.
DAMMIT!! Why can’t you search a drop down list in a pivot table without having to scroll thru all kazillion entries!?!? Grrrrrrrrrrrrrrrrrrr
Pivot table, hot sauce, and a noodle bowl. Who’s sweating more, me or the cpu? http://yfrog.com/0271xj

Death by Spreadsheet

just set up an excel spreadsheet to calculate my #eurovision favourites based on multiple scoring criteria… iceland ahead at 163 pts
You could make an excel spreadsheet which calculates the average annual death rate from excel spreadsheet use.
I now have so many rooster paintings that I am making an excel spreadsheet to alphabetically keep track of the names. In the 70-80 range.
Need an Excel Macro EXPERT, stat! Will go toward helping beer site, thanks…

VBA Turpitude

Starting day 2 of the Excel and Access Integration Workshop. Day 1 went well. Today we get into VBA and ADO.
Just Published: Working with Lists and Tables: VBA Samples, Part 2 http://bit.ly/CoMs0
Freed temporarily from wallowing in VBA turpitude. It’s like a veil has lifted, outlines are sharper, voices are no longer muffled…
Need to fix some old programming. Does anyone know VBA anymore?

Oh, the Injustice

In Excel…everyone wants everything in one workbook. Everyone wants everything done with one click. That is what I have to deal with.
why do I pay a lawyer all this money if I have to correct his excel spreadsheet???
Just taught someone who makes 3X as much as me how to use MS Excel. Life’s not fair.
My boss has brought a mistake to my attention. Twice. I have informed him that he was in fact checking the wrong column in Excel. Twice.

__________________