Excel What-If Analysis & Data Tables | Easy Guide for Big Decisions

[hobbycat]

Very clear as usual !
Drawbacks of tables :
The input cell(s) and the formula(s) MUST be located on the same Sheet (the table’s one) ;
can eventually be very slow ; and if you manage to take control before computation is completed, then you get a partial update of the table ;
to change the table range is tedious / impossible : one must first delete the old range then select a new one.

Enjoy this new year,

[altusklingenberg]

Thank you very much for unselfishly sharing your excel knowledge, it is highly appreciated and adds substantial value enabling me to work smarter. Your profound soft professional approach is unique and sets you above the rest.

[eegpas]

Even having used excel for 30 yrs I found Data Tables challenging...you made them clear as glass! thanks so much!

[dougmphilly]

That was the simplest and quickest tutorial on a complicated subject. Props

[onlyvenividivici]

Started watching your videos couple of days back and i must say this is one of the best YT Channel i have seen so far for excel dashboards n other important tricks n tips.. Thanks a lot 👌

[prasadmoghe]

You are Great teacher. I follow your channel regularly. Thank you for making me knowledgeable.

[sidhantgoyal]

Thank you for explaining data tables in such a simple way. This is the best explanation I found in YouTube.

[drylakes]

Brilliant! I absolutely love your work here, Mynda. Thank you so much.

[hiteshgandhi]

For Break Even generally I use the Goal Seek function but with 👌the use of Data Table for Break Even calculation I got the logic with this tutorial.

[amylourenco]

THANK you for this easy to follow tutorial! I also learned how to use the fill function - an added bonus!

[safesafe]

Short, precise and straight to the point. Great video

[RandomFacts-UTube]

Thank you so... much, mam to explain this concept with examples which make it crystal clear to me. 👍
And not only one, u took two examples for explaining DATA TABLE which I found really a gud thing in this video. 👍
Tysm again mam. ❤️

[signalmas]

I wondered sometimes what that does, but never dug into it. Now I know, thanks to you. Much appreciated

[tech_sultanpur]

Excellent Explanation Mam .... Thanks a Lott (From India)

[martinargimon]

Excellent. As always a 'Top" teaching from you ! thanks very much. Regards. martin argimon (south africa)

[IvanCortinas_ES]

Excellent tutorial Mynda. Thanks for touching on these topics and having a wide variety of content on your channel.

[vijayarjunwadkar]

Very nice! I now understood Data Tables more clearly. Thank you and wishing you a happy, safe and great new year 2021! 😊👍

[hkagga]

Unfortunately, Youtube allows only one like, or else I might have automated likes for few days per video, really really heartful thanks, It might take days to learn few features which you just explained in few minutes, it added a lot of value and had cut shorted my time in banging head. Thanks Mynda.

[RandomFacts-UTube]

Again, for understanding this concept I chose ur chnl. I've not found this kind of explaining style in which I make myself clear promptly, in any another chnl.

[alpstinger]

Man this was the best tutorial. Easily understood it. Thanks!