will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Excel Twitters 20080712
Posted on July 12th, 2008 by Debra Dalgleish
These are some of the comments posted in Twitter recently, that give a glimpse into what the world thinks of Excel, and what people are using it for. Why are the Excel haters’ comments much more interesting?
Some people love Excel:
- A friend just sent me a real cool College Football schedule in Excel format … anybody interested?
- Love learning about new, useful Excel functions. COUNTIF is perfect for what I need right now.
- merging about 20 different excel documents together. must de-dupe!
- there is something about watching an Excel macro run that I find entertaining
- I just used Excel as a web page mockup tool. Co-worker wanted to “move stuff around” but doesn’t do HTML.
- Entering data into excel….I think I missed my calling
- Just solved something in excel using formula rather than the VBA I was expecting
Others, not so much:
- Office 2007 UI SUCKS!!!! Just wasted hours working on addins in excel and they are MS addins !!!!!!! YUUUUCCCKK!
- Sometimes I really hate Excel. Why isn’t it totalling all the cells in my range?
- Working on other people’s Excel databases is like being forced to use a completely different set of logic, that makes no sense whatsoever.
- discovering the secrets of excel. it’s like learning the rituals of a religion i have no desire to practice, except less interesting
- Yeah I pretty much hate all the other 2007 Office programs too, it’s just Excel I’m working in right now. Argh!
- Excel 2007 makes me insane! They tried to make it “easier” and just screwed everything up.
- The day’s not complete until Excel has crashed for the second time. For the same reason.
- I really really really hate excel right now
- Microsoft Excel is a crafty foe, but this is a battle I must win.
- waiting for excel to open. i’ve got 10 minutes…anyone need anything?
- The project for this week is done…the next person to ask me to make an Excel sheet with drop-down menus is getting stabbed in the eyes.
Filed under: Excel
Comment from Ken Puls
Time: July 12, 2008, 12:59 pm
“Entering data into excel….I think I missed my calling ”
Wow… I felt like that once… when I was 12! (Take your kid to work day, as I recall.)
“there is something about watching an Excel macro run that I find entertaining”
I hope this person just hasn’t found “screenupdating=false” part yet… LOL!
Comment from Debra Dalgleish
Time: July 12, 2008, 1:26 pm
Ken, yeah, I wasn’t sure if that was love or sarcasm, so let’s hope I guessed wrong.
And sometimes I leave screen updating on, just so people can see that things are happening. The macro runs slower, but at least they know it’s still running, and hasn’t hung.
Comment from Jon Peltier
Time: July 12, 2008, 1:46 pm
Hmmmmm. All of the items that mention 2007 are in the second category. Did you see any where the commenter liked the new interface?
Comment from Debra Dalgleish
Time: July 12, 2008, 2:34 pm
Jon, good question. After some digging I found this — about a month ago, someone said, “Having a little more fun than I should be playing with conditional formatting in Excel 2007 at work.” So far, that’s it.
Comment from jarret freedman
Time: July 14, 2008, 9:55 am
on the article - inserting pictures into comments in excel, does anyone know how to program vba so that the comment automatically takes a picture’s address from a cell in the same row and be able to replicate for following rows vs having to manually define the location of the picture for each comment?
Comment from Debra Dalgleish
Time: July 14, 2008, 5:07 pm
Jarret, There’s a sample file at the following link, that might help you get started. You can adjust the code to match your folders. Debra
http://www.contextures.com/excelfiles.html#CM0003