LogFAQs > #958417608

LurkerFAQs, Active DB, DB1, DB2, DB3, DB4, DB5, DB6, DB7, DB8, Database 9 ( 09.28.2021-02-17-2022 ), DB10, DB11, DB12, Clear

Topic List	Page List: 1
Topic	Any good Microsoft excel tests out there?
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. Pivot tables, on the other hand, have a bit more depth to them. 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 --- *The truth basks in scrutiny.* https://imgur.com/GMouTGs http://projecteuler.net/profile/Sahuagin.png <cite>Sahuagin posted [p:958417608] in Any good M... [t:79679004]...</cite> <quote>adjl posted... </cite> <quote>There's really not a lot to learn about vlookups. It's a pretty straightforward "search for this term in this list" function. Pivot tables, on the other hand, have a bit more depth to them.</quote>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 --- The truth basks in scrutiny. https://imgur.com/GMouTGs http://projecteuler.net/profile/Sahuagin.png</quote> ... Copied to Clipboard!
Topic List	Page List: 1