7 EXCEL Tips That Will Blow Your Mind! (will change your life)

It's a new direction for OneTake! No more frivolous videos about Movies and TV Shows. Instead we're focusing on something that actually matters: spreadsheets.

Use the chapter markers to skip ahead or just sit back and enjoy the spreadsheets.

0:00 Intro
1:00 The Best Way to Compare Lists
13:10 Dynamic Drop-down Lists
39:00 Finding the First or Last Cell's Value
58:03 Combine First and Last Names
1:02:18 Delete Every Other Row
1:06:57 Split First and Last Names
1:09:25 Using Index-Match Instead of VLOOKUP
1:27:53 Concluding Thoughts

#excel #tutorial #microsoftexcel

[masterrserch]

I just can't believe that THIS went a full goddamn hour and a half 🤣🤣
Brilliant




(Whats REALLY funny is I actually pretend to know Excel, and it's been a part of like every job I've ever had, so I said "oh ok, this is different, but I could probably actually use the stuff in here.."
Then I clicked, heard the intro, saw HOW FRIGGIN LONG the video is, and went NOW I SEE ...lol.... happy FourOne!)

[davey]

You really have a talent for explaining this stuff (better than some of the more popular Excel channels, IMO). I'd definitely subscribe if your plan A got revived.

[frednunziata]

Well this is out of left field! I am super excited to watch this as it would be a massive help for my new role I gained. Super awesome Gil. Watching tonight when I get home.

[MovieKnightYT]

This is hilarious... and surprisingly informative!

[Larry_Canonica]

Nice. Love how OneTake made me do a double take.

[lauraf]

Omg I love you. April 1st and knowledge. Haha

[nieshamahepath]

Hey, neat stuff. At first, I thought your combined tab was going to be formed using "append".

[SilverScale.]

Lolololololololol... but actually, useful and well made! 😀

[iocomposer]

Ha! Classic. Even on April 4th. Still funny.

[luizafantin]

It’s so weird hearing your voice and cadence on something so specific and that isn’t movies/tv!

Fyi, You do have fans that appreciate Excel content as well as your usual content! At least one, that is…