Excel pivot table

I love Excel pivot tables, so it’s nice to see so many tweets that share the pivot table love. The Ribbon, however, doesn’t enjoy the same level of universal adoration. Maybe it’ll grow on us over time.

Pivot This Mess

• I will forever remember this day, for a few moments ago I realized the importance and use of Pivot Tables in Excel.
• I would recommend using a pivot table first. Pivot tables rule the Excel world! 8^)
• Working on my Romantic Comedies list… I need a spreadsheet and possibly a pivot table for this mess.
• Excel fun: run macros, watch screen flash like crazy, hit refresh button to see pivot tables and graphs update. It’s like magic! But not…

Sounds Bad

• Excel, is it really necessary to make 3 different noises when i try to save and close a CSV file? urgh
• aaand down goes Excel. Boom.
• a form asked me for the duration of a project, i put in "3-6" and i nearly sent it off with Excel having substituted that with 39878
• My Excel spreadsheet just suffered a minor loss of fidelity. I have no idea what this means, but I am saddened for it.

Scary Stuff

• Excel spreadsheets are the technological equivalent of the cockroach – http://bit.ly/53BdZ2
• The future isn’t going to be designed on an Excel spreadsheet. (via Paul Bennett/IDEO , http://bit.ly/6Ok5Ri )
• daily dose of Excel…that scared and turned me on at the same time.

And Finally

• Can someone please tell me how to switch from StupidView to Classic View in new Excel?

______________

P.S. For help with Excel pivot tables, see Excel Pivot Tables Blog

______________

It’s amazing that you’re so smart, but your co-workers don’t have a clue how to use Excel. They’re lucky to have you to bail them out of trouble! Of course, it would help if we all had fancy new versions of Excel, with all the features that we really need.

Pivot Table Genius

• Exercising my Excel nerd muscles: 15K rows, 73 columns, 2 pivot tables, and a vlookup function all in one spreadsheet.
• my wife is a pivot table genius! Now she has transfered her knowledge and I am a dangerous pivot table apprentice – bwahhahahaha
• excel, i take back everything bad i ever said about you… this pivot table you just did is amazing
• Those who cannot do a pivot table properly within 5 minutes must eat a bowl of worms! While hanging upside down. From a helicopter.

Crappy Old Excel

• How did "unhide all sheets" not make the cut into Excel 2007?
• Seriously – £5k to upgrade to excel 07? What are you going to turn my computer into ‘Short-Circuit’; actually that would be ace – do it!
• Okay Excel, it’s almost 2010. Are you going to give me more than 40 choices for font and fill colours?
• Best get off to work, I have to work out how to manipulate more records than my crappy old Excel 2003 can handle

People Are Idiots

• asked a coworker to send a spreadsheet i’m supposed to work on, and he sent a screenshot of the excel screen instead of sending the file.
• People at my work are idiots. There I said it. Excel has filters it’s really not that difficult to check info on a spreadsheet
• Spending the morning redoing a coworker’s project instead of doing my own work. She couldn’t tell the difference between Word and Excel.
• anyone want to go to work for me tomorrow & tell them that i didnt save the excel spreadsheet i spent all day doing yesterday, am an idiot
• A work colleague in an IT management position above me just asked me ‘how do you sort in Excel’. A bit worrying I know!

____________

P.S. You can be a pivot table genius too, if you read the Pivot Table FAQs

____________