Datamartist gives you data profiling and data transformation in one easy to use visual tool.

« | »

Vlookup, Excel and social media.

Somebody is always doing a study on how much lost productivity is costing companies when people do something other than work at work. It used to be that the business intelligence companies were always going on about how much time people “wasted” using excel- now a days it’s the huge cost of employees using social media sites like twitter and facebook. Lets look at BOTH. What happens when people use Excel and tweet about it? Bankrupcy can’t be far…

vlookup-wasting-time-or-serious-businessOn a whim (ok, I was procrastinating at work on social media sites when I should have been doing data analysis), I decided to do a twitter search for things excel like, including “vlookup” that granddaddy of all Excel functions.

Heard recently on twitter;

I just discovered VLOOKUP in excel. This may just be the best day of my life.

I predict your life will get better and better. (It’s obviously been no great shakes so far.)

lol, I’m such a banker…I haven’t done this stuff in Excel in over 2 yrs, but after like 30 min, I’m back vlookup-in’ my a@$ off!

Go, go go!

omg excel documents are boring!

Data is never boring, just misunderstood.

If only Excel would stop freezing, things would be better.

Amen.

Excel crashes everytime I try and make a pie chart. How am I meant to do my report now?

Use a bar chart, you should never use pie charts.

And from the overworked department:

VLOOKUP + CTRC C + CTRL V for 10 hours today.. What a life 🙂

starting to see everything in cells and formulas… =IF(ISERROR(VLOOKUP(HUNGRY,DONUTS:BURGER,1,FALSE)),”GO HOME & SLEEP”,”DINNER”)

I hate spreadsheets and I hate data alignment, thankfully I like VLookup

My method of teaching VLOOKUP to people involves telling them to look for the banana in the fruit bowl. Strange? Yes. Effective? Absolutely.

I tend to use the watermelon analogy, but whatever works for you.

I fought Excel and…I won! VLOOKUP function, I own you! (insert evil laugh here)

so boring! you wan’t to help me on my essey question? Explain how a #VLOOKUP and a #HLOOKUP benifit business? LOL

Just did an excel spreadsheet with nested VLOOKUP functions. I feel dirty.

I’ve showed you how to do a vlookup 5x already. If you can’t figure this out, mebbe you shld look for a new job.

A job that doesn’t require Excel skills? Is that possible?

And one final sentiment:

Excel should die.

There is an excel tweet about every 15 seconds. No wonder the global economy is having some issues on the rebound. Get to work people!

Tagged as: ,

Twitter

« | »

Leave a Response