Excel Skills to Make an Impression

Discussion in 'General Distance Learning Discussions' started by Mac Juli, May 23, 2021.

Loading...
  1. Mac Juli

    Mac Juli Well-Known Member

  2. Rachel83az

    Rachel83az Well-Known Member

    I'm not sure how impressive you can get with Excel skills. It's not like you can just walk down the street and do random spreadsheets, haha
     
  3. Maniac Craniac

    Maniac Craniac Moderator Staff Member

    I can juggle flaming spreadsheets with my feet, blindfolded while train surfing.

    I'm also working on mastering some razor sharp balisong database tricks
     
    Rachel83az and SteveFoerster like this.
  4. SteveFoerster

    SteveFoerster Resident Gadfly Staff Member

    Sounds like someone needs to take the course!
     
  5. Dustin

    Dustin Well-Known Member

    I volunteer as tribute! I already know how to use V/HLOOKUP and INDEX/MATCH in order to pull really specific information on queries. I know the very basics of pivot tables, but it's always a lot of trial and error so hopefully I can learn something new. Some of the error things mentioned like dynamic arrays are totally new to me.

    I've registered on FutureLearn for the first time and I have 6 weeks access to the course, I'm not sure if that's typical.
    • Week 1 is IF statements, comparative operators (=, >, <, >=, etc.)
    • Week 2 is all about pivot tables
    • Week 3 is dynamic arrays, SORT/SORTBY, FILTER
    • Week 4 is V/HLOOKUP, INDEX, MATCH, XLOOKUP
     
  6. Vonnegut

    Vonnegut Well-Known Member

    Every upcoming manager or executive should be striving to have solid/impressive Excel, MiniTab, and Tableau skills. Understand how to analyze, synthesize, and visually present data analytics is a fundamental skill set. While it may not be a requirement to always be impressive with them, not being competent can be a dealbreaker.
     

Share This Page