Vlookup and pivot tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2329915%22%20slang%3D%22en-US%22%3EVlookup%20and%20pivot%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2329915%22%20slang%3D%22en-US%22%3EI%20need%20to%20learn%20how%20to%20use%20the%20above%202x%20functions%20for%20a%20new%20job%20role.%20Haven't%20used%20excel%20for%20years.%20I've%20looked%20at%20several%20videos%20but%20am%20still%20unclear.%20Can%20anyone%20help%20me%2C%20in%20layman's%20terms%20please%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2329915%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2331311%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20and%20pivot%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2331311%22%20slang%3D%22en-US%22%3EI%20would%20suggest%20not%20only%20looking%20at%20several%20videos%2C%20but%20also--even%20more%20important--taking%20on%20the%20task%20of%20creating%20a%20spreadsheet%20following%20the%20examples%20in%20those%20videos%20and%20creating%20your%20own.%20You%20may%20have%20done%20that%2C%20I%20realize...but%20you're%20asking%20us%20to%20do%20what%20the%20videos%20do%20after%20telling%20us%20they%20haven't%20helped.%20In%20layman's%20terms%20%22you're%20asking%20for%20what%20you've%20declared%20won't%20work.%22%3CBR%20%2F%3EYou%20also%20might%20try%20some%20non-video%20sources.%20Here's%20a%20good%20one.%20But%20create%20your%20own%20examples%20and%20work%20along%20with%20the%20instruction.%20THAT%20IS%20how%20to%20learn%20it.%20%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fsearch%3Fquery%3Dpivot%2Btable%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fsearch%3Fquery%3Dpivot%2Btable%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fsearch%3Fquery%3Dvlookup%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fsearch%3Fquery%3Dvlookup%3C%2FA%3E%3CBR%20%2F%3EOnce%20you've%20mastered%20VLOOKUP%2C%20you%20might%20want%20to%20research%20further.%20XLOOKUP%2C%20for%20example%2C%20is%20more%20powerful%20(and%20newer)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2332000%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20and%20pivot%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2332000%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20didn't%20realize%20that%20there%20were%20instructional%20templates%20like%20that!%20Good%20to%20know.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I need to learn how to use the above 2x functions for a new job role. Haven't used excel for years. I've looked at several videos but am still unclear. Can anyone help me, in layman's terms please?
6 Replies
I would suggest not only looking at several videos, but also--even more important--taking on the task of creating a spreadsheet following the examples in those videos and creating your own. You may have done that, I realize...but you're asking us to do what the videos do after telling us they haven't helped. In layman's terms "you're asking for what you've declared won't work."
You also might try some non-video sources. Here's a good one. But create your own examples and work along with the instruction. THAT IS how to learn it. https://exceljet.net/search?query=pivot+table
https://exceljet.net/search?query=vlookup
Once you've mastered VLOOKUP, you might want to research further. XLOOKUP, for example, is more powerful (and newer)

@Alison111 

I'd start from templates available in File->New as

image.png

As next step google "excel my first pivottable".

Lot of resources, each has pros and cons, and, as usual, there is no one which could be "best". Best for one is not best for another, it very depends on personality, initial skills level and desired result.

@Sergei Baklan 

 

I didn't realize that there were instructional templates like that! Good to know.

@mathetes 

I don't know why but people quite seldom use these templates to learn this or that functionality. From my point of view they are very professional and you may find lot tips and tricks working with these templates, not necessary related to main functionality. UI, reporting, navigation, formatting, etc - quite many useful things.

@Sergei Baklan 

 

I've just never realized that there was something like the "Take a tour" template there on the top left, something that actually contains instructions. AND that it's there in the basic Excel package itself, not something you have to go hunting for on the internet.

I see it is labeled as "New" so maybe it is just that. I'm generally NOT a template user, having been greatly disappointed by the few I've tried. I have more fun developing my own layouts...but then too I began back in the early days of Lotus 1-2-3 (and before).

 

mathetes_0-1620318936767.png

 

@mathetes 

I also don't use these templates for real projects, but take some nice things from them from time to time.