For all you Excel Nerds, check out flashfill and xlookup

Sign up, and you'll be able to ignore users whose posts you don't want to see. Sign up

Report problem with this ad

Nov 8, 2019
8:40:03am

Negative Equity All-American

For all you Excel Nerds, check out flashfill and xlookup

Videos:

https://www.youtube.com/watch?v=1KimYFzET1w

https://www.youtube.com/watch?v=xnLvEhXWSas

Report problem with this ad

Negative Equity

Previous username: Neg
Bio page: Negative Equity
Joined: Jul 26, 2009
Last login: May 4, 2024
Total posts: 10,991 (2,421 FO)

Report problem with this ad

Messages

Author

Time

For all you Excel Nerds, check out flashfill and xlookup

Negative Equity

11/8/19 8:40am

Hehe you use Excel instead of R or Python. Hehe.

Genghis Spreads

11/8/19 9:32am

There's a lot of value in these options. But if you think they're the right

Cougar8Duck

11/8/19 12:27pm

Like I said, excel is good for something quick. No self-resepcting person uses

Genghis Spreads

11/8/19 1:46pm

RE: Like I said, excel is good for something quick. No self-resepcting person

Negative Equity

11/8/19 2:25pm

Alteryx can do much of what R/Python can do and you don't need to code.

11/8/19 2:28pm

If you think that Excel has everything you'll need, that will hurt your career.

11/8/19 2:30pm

That would entirely depend on the career.

Negative Equity

11/8/19 2:31pm

Okay, let me clarify. A career that requires the usage of data in any form.

11/8/19 2:34pm

I'll definitely look into it. Thanks.

Negative Equity

11/8/19 2:42pm

enjoy your fad applications. excel will be waiting when you come back.

MormonThug

11/8/19 10:25am

RE: enjoy your fad applications. excel will be waiting when you come back.

11/8/19 11:07am

Nothing wrong with Excel if you want something quick. But for heaven's sake,

Genghis Spreads

11/8/19 11:12am

Those videos I shared were excel videos. So far in my work experience

Negative Equity

11/8/19 1:02pm

sorry. joke response meant for Genghis' post.

MormonThug

11/8/19 1:22pm

Then go check out Tableau and Alteryx.

11/8/19 11:06am

I'm curious how these solutions actually work in one off analysis cases where

Cougar8Duck

11/8/19 12:09pm

Yes, you would use Alteryx for the data prep, then analyze the output in Tableau

11/8/19 12:11pm

Report problem with this ad

Posting on CougarBoard

In order to post, you will need to either sign up or log in.

Report problem with this ad