you are viewing a single comment's thread
view the rest of the comments
[–] 3 points 4 months ago* (last edited 4 months ago) (4 children)

Pivot tables are quick. If used properly you can summarize data much quicker than any excel formula. When I use them it pretty much always takes under 30 seconds to get what I want. Imo, there are 2 things every user of excel should learn to use. Vlookup (edit: or xlookup, see below) and pivot tables. Once you learn to use both, you will use them all the time.

  • source
  • parent
  • hideshow 4 child comments
  • [–] 2 points 4 months ago (3 children)

    Vlookup

    Please use xlookup instead.

    Forget about lookup, vlookup, hlook-up or index(match()).

    Only use xlookup.

  • source
  • parent
  • hideshow 3 child comments
  • [–] 1 point 4 months ago* (2 children)

    No place I have ever worked has had a version of excel with xlookup, so I can't really comment on it. Im not on 365 or a newer desktop version. We are on Office 2019, as I suspect many offices still are.

  • source
  • parent
  • hideshow 2 child comments