The 'average' excel user

[Cbrine]

****, Where do I sign up!!! I'm not sure what £500 a day is in Canadian $'s but I pretty sure that more then double what I currently make!! I even quit drinking coffee about a year ago, so they would have to pay me to stand around or somthing instead

 

[Norie]

It's about 1,009.18 CAD.

Or in layman's terms 11,542.2 Estonian Kroon's.

 

[Cbrine]

Yeah, ummm...The multiplier just went way, way up . I'm not sure what an Estonian Kroon is but, I pretty sure I would like to make about 11,000 of them a day.

 

[Norie]

Cal

How about 1866335 Venezuelan Bolivars?

 

[boris_excel]

it funny that a lot of the posts use pivot tables to gauge the level of excel knowledge. I wonder if its because I included it in my original post or people feel that this is a good indicator to gauge someone's excel ability. what other measures do you use to gauge one's ability?

i also agree that the 'average' excel user that i have seen falls below the pivot table range. as a result, is the 'average' excel user actually a 'beginner' if you use the beginner-intermediate-advanced ranking?

B

 

[Greg Truby]

I 2^nd Mark; though I'd say Mark's describing the "median" Excel user, since you've got yer outliers like Cal & Richard who are so far above the typical user that they would skew the "average".

And Norie, unfortunately to spend them Bolivars, yer probably gonna hafta be in Venezuela. While it wasn't so bad when I was there several years ago, ain't so sure I'd be all that stoked to live in Caracas these days.

 

[Norie]

Greg

What could you buy for 1866335 Venezuelan Bolivars?

 

[milesUK]

Is it only me or should one not include layout and formatting in your 'average' skills definintion.

My experience is that sheets lacking any formatting are difficult to understand and the pertinent info (created by your Lookups and PT's) is not 'under the eye'.

I would expect a logical layout and a careful use of borders, font size, colour and condittional formatting, etc to be amongst an average users skills.

On top of that at least knowing that Comments, Sort, Filtering, Page Breaks, Charts, and Tools-->Options! all exist if not in regular use.

Just my 2p worth

 

[Norie]

Miles

I know layout and formatting can be important, especially when the results
might be presented to other users.

But I would think actually getting the correct results would be more important,
and a nice presentation a cherry on the top.

 

[milesUK]

Norie, Yes, I agree with your last statement. Data comes first but I also find that formatting is important to help guide the sheet users (me included) attention to the input/output ranges and present controls in a logical order.

An ugly car will get you to work as reliably as a nice one. Given the choice the majority (here's wher someone proves me wrong ) will prefer not to drive dull cars with no character .

Appreciate that not everyone has the time/resources for a cherry tho.