Advanced Excel - 3D Formulas - Advanced Excel Tutorial

Learn how to create a 3D formula in Excel, a formula that pulls data from the same cell in more than one spreadsheet. It can be a little tricky, but after watching this video you'll understand how to do it.

Also mentioned in the video is AMAZING music such as the following:
Classic Synthpop and New Wave:
New Music by Classic Synthpop Bands:
Underground Modern Synthpop:

[LadyHolyKnight]

Thank you so much. The guides you have made are simple and easy to follow especially for someone who had 0 experience with such programs.

[Leann]

Best excel series I’ve found by far. Fantastic instructor and easy to retain.
Btw...can’t believe anyone would actually comment on the values you put in for the movies on a hypothetical teaching tool. Good grief... get a life people!

[georgestocker]

if the 2 bits of data are not in the same cells you can still use them you just have to write worksheet number!(cell reference). e.g. =sum(I2+sheet2!I2) then you can reference any cell

[davischeung]

I need to learn excel for my job after 25 years.It looks like these video got me encourage and confident in that I can learn excel thanks to you.You made it so easy to understand.You are a really great teacher thanks.Now is my job to execute what i have learn.

[kimberlyannfarish]

Finally, someone I understand! Thank you so much.

[jeanneleonard]

Thanks! Easy to follow tips. Before watching your video, I was overwhelmed. Now I am excited about using Excel.

[dinamicco]

Thank you for your excellent explanation of Excel. Learning from scratch, you make it very easy to follow.

[Dr.Nihilist]

Never have I seen a more elegantly done tutorial.

[elijahboyersebastiani]

I love how passionate he is about synth-pop

[cambriaish]

good tutorials AND good taste in music?!!! too good to be true!

[annaceleste]

I just want to thank you for making these videos. I use excel everyday at work and this has made my life so much easier (along with impressed my boss haha).

You have a very clear and diplomatic voice. I also love you’re able to explain things in such a simple way that I understand the first time, what you’re trying to teach me.

I apologize for all the previous comments about the “inaccurate value” of your hypothetical movie collection *laughs* it’s too funny what people get fixated on. Your synthpop was really great too, that was a bonus.

[GinMiko]

I actually learned something new. Thank you, and keep them coming.

[sharonlobo]

Your voice is so pleasant, and these videos have been so helpful, i haven't gotten bored even once. learnt alot. Thank you.

[elenikyr]

Your videos are so inspiring! Its the first time that I have interest in using excel. You must be a great teacher!

[PaulVassell]

Thank you so much! I must remember to click on your ads and go to the checkout whenever I can.

[manicpixiedckgirl]

I'm watching these as a refresh for a job application, but my wife is a huge synthpop fan and so i got a big chuckle out of listening to you gush about it ty

[stanleychinaka]

Amazingly beautiful. Kind of teachers I'd always want to listen to.

[aldrynsunga]

Thankful for you sir for putting these for free! more blessings and stay safe!

[omarmuhammad]

Ur videos are simply amazing..Thak you so very much..

[blessed]

GREAT teacher! You are so easy to follow! You have made my life so easy. Thank you sir. God Bless You so you can continue empowering minds.