Excel...

caroline23
caroline23 Registered Posts: 53 Epic contributor 🐘
Can anyone tell me what functions on excel are useful to know in practice? i have a job interview which requires a excel assessment and i want to make sure i am fully prepared and able to do well

Comments

  • Whirlwind
    Whirlwind Registered Posts: 249 Beyond epic contributor 🧙‍♂️
    Hi,

    In the practice where I work we use all the 'sum' formulas, 'vlookup' and 'if...'. I have seen other jobs advertised that required 'pivot tables' too.

    All the very best with the interview, let us know how you get on!!
  • Paul C
    Paul C Registered Posts: 193 Dedicated contributor 🦉
    Hi Caroline,

    Things that speed work up? Pivot tables, automatic subtotals, key formula's etc . Might be worth knowing where to find answers to problems / queries in excel at work so that you can show you are pro-active and able to solve some issues yourself if stuck (in built help function, Microsoft website etc). Although using these forums shows you know where to look for help and that that you actively use the AAT website resources!

    Best wishes
    Paul
Privacy Policy