| Topic List |
Page List:
1 |
|---|---|
|
PK_Spam 09/25/21 11:58:12 AM #1: |
Interviewing for a job that apparently makes extensive use of vlookups and pivot tables, neither of which Ive touched in a long time.
I know I can use tutorials to learn it step by step, but Ive always been more of a practical learning type of guy. My sister was my connect for this job, and only after recommending me did she start telling me that I better not make her look bad >_> --- "You're not a good person, you'll never be one, you'll never even convince anyone to mistakenly believe you to be one." -HCE to me ... Copied to Clipboard!
|
|
PunishedOni 09/25/21 12:54:38 PM #2: |
https://www.youtube.com/watch?v=ICp2-EUKQAI
--- hi im chelsea ^__^ You have entered the lair of SOMA - the Sega Online Machine Agent. Turn back now, or prepare to be digitized! ... Copied to Clipboard!
|
|
PK_Spam 09/25/21 6:08:33 PM #3: |
Bump >_>
--- "You're not a good person, you'll never be one, you'll never even convince anyone to mistakenly believe you to be one." -HCE to me ... Copied to Clipboard!
|
|
adjl 09/25/21 7:32:05 PM #4: |
There's really not a lot to learn about vlookups. It's a pretty straightforward "search for this term in this list" function. The fanciest thing you're likely to encounter is handling cases where it can't find the search term, and that's just a simple matter of using IF() and ISNA() to define what should be displayed in those cases.
Pivot tables, on the other hand, have a bit more depth to them. I've seen a few video tutorials around that include sample files to play with, so you might want to try that. I don't know of any specific ones off-hand that would be good to focus on, but that's probably the best approach to take. --- This is my signature. It exists to keep people from skipping the last line of my posts. ... Copied to Clipboard!
|
|
Clench281 09/25/21 7:32:28 PM #5: |
laughs in R
--- Take me for what I am -- who I was meant to be. And if you give a damn, take me baby, or leave me. ... Copied to Clipboard!
|
|
PunishedOni 09/25/21 7:47:48 PM #6: |
there's no reason to use a vlookup when you could use an xlookup
--- hi im chelsea ^__^ You have entered the lair of SOMA - the Sega Online Machine Agent. Turn back now, or prepare to be digitized! ... Copied to Clipboard!
|
|
adjl 09/25/21 7:57:31 PM #7: |
PunishedOni posted...
there's no reason to use a vlookup when you could use an xlookup You can't use xlookup, however, if your employer doesn't have an M365 subscription. It's kind of a pain. That said, xlookup functions pretty much identically to vlookup, except more versatile and intuitive in every way. If you know how to use vlookup, there's nothing new you really need to learn to use xlookup. --- This is my signature. It exists to keep people from skipping the last line of my posts. ... Copied to Clipboard!
|
|
PunishedOni 09/25/21 8:00:58 PM #8: |
adjl posted...
You can't use xlookup, however, if your employer doesn't have an M365 subscription. It's kind of a pain. pay to win --- hi im chelsea ^__^ You have entered the lair of SOMA - the Sega Online Machine Agent. Turn back now, or prepare to be digitized! ... Copied to Clipboard!
|
|
Sahuagin 09/25/21 10:29:10 PM #9: |
adjl posted...
There's really not a lot to learn about vlookups. It's a pretty straightforward "search for this term in this list" function.I was gonna say basically exactly this. vlookup is just a function (though a VERY useful function depending what you're doing) pivot tables though, there's a ton you can do with that, and IIRC it requires a bit of creativity or intuition about how you want to manipulate your data --- ... Copied to Clipboard!
|
| Topic List |
Page List:
1 |
