1. Don't despair your Tipping Season is not over!

    Two lucky people could win $1 million in our free to enter tipping tournaments over the last five rounds of the AFL season.

    Winners will receive a ticket to TopBetta's NRL Grand Final day tournament in Melbourne on September 27th.

    Join Now and have some fun for the rest of the season.

  2. Congratulations to jaydeetee for tipping 7/9 and one off the tie-breaker. FREE Platinum BFSC for you!

    Get your tips in!

  3. Chat with other Comm Games fans in our Commonwealth Games thread.

    And keep up with Aussie athletes in the Aussie Watch Thread.

  4. The ASADA, AFL and drugs in sport Hot Topic board

    Media links, the facts, the statements, the allegations, the charges, the court actions, the notices and the clubs mentioned so far. Hundreds of threads, hundreds of thousands of posts.

Tertiary and Continuing Intermediate Excel

Discussion in 'Education and Employment' started by Selective Retention, Apr 2, 2012.

Put it out there
  1. Selective Retention

    Selective Retention Account Cancelled by User

    Geelong
    Other teams:
    Joined:
    Jan 09
    Posts:
    10,936
    Location:
    Melbourne
    This is listed on practically every job advert but what do they actually expect someone at an intermediate level to do in a job context.

    I've done stats units at uni so have used solver and other add ins like that but I don't see stuff like that as a day to day necessity in the workplace?

    Are they just referring to if statements, vlookup etc as intermediate excel?

    (Log in to remove this ad.)

  2. Colin D'Cops

    Colin D'Cops Account Cancelled by User

    Essendon
    Other teams:
    Joined:
    Nov 07
    Posts:
    13,134
    Location:
    Melb
    I guess it would vary from job to job.

    I'm no expert at all myself, I just completed a spreadsheet test a week ago now as part as my Business course. We used the IF function, VLookup, conditional formatting, data validation, protecting parts of the sheet and were expected to know the formulas like the back of our hand [eg. =MIN(), =MAX(), =AVERAGE()].

    I'm tipping this is entry level stuff, but if you've got this all sorted I wouldn't be too hesitant in applying for jobs, except in the IT industry. There'd be [strike]clowns[/strike] nerds who'd know a few more tricks for sure.
  3. SmackAdder

    SmackAdder BFSC Platinum

    Geelong
    Other teams:
    49ers, SF Giants, SJ Sharks
    Joined:
    Sep 11
    Posts:
    173
    :thumbsu:
    From the sounds of it, Selective Retention, you should be fine to apply for anything involving intermediate Excel skills. For everything else, what Colin said.
  4. checkraiseulite

    checkraiseulite All Australian

    Hawthorn Hawthorn - 2013 Premiers
    Other teams:
    Joined:
    Jul 10
    Posts:
    3,359
    Location:
    wheretheyrespectmyraises
    I (really) sucked at excel during a couple of internships in the accounting/finance sphere.

    I went an did an Advanced excel short course at TAFE, that was 1 evening a week for 6 weeks or so. It helped a lot and wasn't too expensive.

    Also a good thing to put on the resume. Good luck.
  5. Selective Retention

    Selective Retention Account Cancelled by User

    Geelong
    Other teams:
    Joined:
    Jan 09
    Posts:
    10,936
    Location:
    Melbourne
    Thanks guys. I'm reasonably confident I know enough in excel, or at least have the resources from uni to brush up on what I need to know.

    I'm more angling towards if I'm asked in an interview what I can do in excel that my response matches up with what they consider "intermediate excel".
  6. Simon_Nesbit

    Simon_Nesbit Club Legend

    Hawthorn Hawthorn - 2013 Premiers
    Other teams:
    Joined:
    Sep 01
    Posts:
    8,713
    Location:
    Tasmania
    From my experience as an unofficial "Tech Support" in non-IT roles,

    If you can type numbers into a cell = basic.
    If you can make the program do "something" (basic math functions +-/*) = intermediate.
    If you can use more advanced methods (min, max, avg, mode) = advanced.
    If you can completely stuff things up = expert.

    90% of "basic level" IT is just google....and "Microsoft did it".
  7. Falchoon

    Falchoon Premiership Player

    St Kilda
    Other teams:
    10 Year Veteran
    Joined:
    Feb 02
    Posts:
    25,261
    Location:
    ' Tommy Guns '
    Pivot tables, Vlookup, Sumif, if


    If you've got the handle on them, you're intermediate.