Being good at Excel is a skill

In which I show off my INDEX/MATCH rather than a VLOOKUP.

Line of trumpeters

I made Mrs G very happy last night by demonstrating some of my talented finger skills, I was able to do something within a few minutes it would have taken her a while to do if she had been left to her own devices.

She has many skills, and being an English teacher is one of them, but when it comes to spreadsheets I rule the roost in Casa Ergo Sum. I live in a world of Excel and various analytics packages so when it comes to messing around with a simple table of data I can do it with my eyes closed (of course they are open as otherwise I couldn’t build the pivot table).

I generally kick and scream about being labelled as the number’s guy (or more recently the data monkey) because that is not what my job and skills are about. Just as an economist is not someone who just looks at the economy a data analyst isn’t just about the data.

Yet now I understand that it’s what separates me from everyone else, my understanding of data and how to make it sing. For what I can do with a couple of spreadsheets and a set of figures is make a beautiful chorus of charts and trends. I can see the stories in the digits and use them to explain the world we live in.

And nobody else can.

Recently every time I have seen a piece of analysis by someone else I can see where they are wrong, where their own bias has skewed the results to justify their political aims. When I can tell those who earn much more than me that the numbers are wrong or are duplicitous I feel much taller than my short frame and think “I do a good job”.

Inevitably I’ll be dragged down into dealing with broken spreadsheets or pieces of work that I don’t enjoy, and when I go on vacation I will be asked to do the most painful of all my monthly tasks. Whenever I change jobs I’m always asked what will happen if something broke and nobody could fix it.

I am the person with the precious spreadsheets, I have a role in the business that deserves my own brass band playing trumpets. The only problem is that I don’t like to be too loud, I may want to toot my own horn but in reality I am going to play it tacet.

In response to The Daily Post’s writing prompt: “These Horns Were Made for Tooting.”

Today, share something you love about yourself  — don’t be shy, be confident! — but that few other people know about you or get to see very often.

Thanks for suggesting this prompt, best4673!

Author: geekergosum

Ah, so you worked out the riddle. You just needed to use dwarfish and the doors to Geek Ergo Sum opened. Or perhaps you just used Google. Either way you are here, on my little corner of the Internet.

5 thoughts on “Being good at Excel is a skill”

  1. Oh wow, I’m currently doing an analytics course and need to present something next week. Hello pivot tables. Can you please be a hero and help me? 🙂 (I need a data set, a business problem to argue about, and a beautiful presentation!)

    Like

Think inside the box, feel free to leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s