Excel What-If Analysis Data Table | Easy to Use Once you Learn This☝️
HTML-код
- Опубликовано: 6 июл 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Unravel the power of Excel's What-If Analysis Data Table in our latest tutorial. Ideal for professionals and students alike, this video simplifies complex financial forecasting and scenario analysis, guiding you through practical examples. Learn how to make informed decisions by simulating various financial scenarios in Excel.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/what-if-file
In This Tutorial:
▪️ Introduction to What-If Analysis: Grasp the basics of Excel's powerful forecasting tool.
▪️ One-Variable Data Table: Learn to analyze changes in one financial parameter.
▪️ Two-Variable Data Table: Explore how to simultaneously vary two parameters for in-depth analysis.
▪️ Practical Financial Scenarios: Apply these techniques to real-world financial forecasting scenarios.
Use an Excel Data Table What-if Analysis to quickly create multiple results based on a formula you already have. The data table in Excel will allow you to change values in some cells and come up with different answers to the problem. This is what Microsoft Excel's What-if Analysis Data Table does best - it allows you to experiment with different input variables. A Data Table allows you to see how different input values would impact the result at one glance. It's quite a hidden Excel tip and trick. Data Tables can be confusing at first, but this tutorial explains it in simple English and in a way, you will never forget how to use this feature again.
00:00 What-If Analysis in Excel - Most Simple Explanation
00:16 Data Table - 1 Variable
04:47 Bonus Trick: Custom Formatting as icon
05:55 Data Table - 2 Variables
08:07 Wrap Up
🎬 LINKS to related videos:
- Excel Goal Seek Explained in Simple Steps: • Excel Goal Seek Explai...
- Excel Solver - Example and Step-By-Step Explanation: • Excel Solver - Example...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Grab the file I used in the video from here 👉 pages.xelplus.com/what-if-file
thanks i was quite worry for my project
Love it, Leila! Another great, simple, and more importantly, useful, tutorial!
Wow ! Couldn’t have asked for a better explanation. Kudos !
Yet again, your channel has made me more productive at work. I've been itching to make a scenario analysis table with a bunch of complex financial data with moving 1 or two variables... This did the trick! One other thing I'd add, is if you're just moving a columnar variable, you can have many different reference columns that all update with the far left column values! I also couldn't get it to work until I made the Column Input Cell on the same sheet as the What If table. Thanks!!!
Leila, you are the best tutor I have ever listened too. All your presentations makes things look simple and flawless and they are very easy to understand. You are truly my MVP when it comes to Excel and Power BI
100% agree
I don't have a background in finances, but I manage my own budget in Excel. The other day I was wondering how I could make these kinds of projections. This is a great video! Easy to understand and informative. Thank you!
Thanks to your guidance and efforts to make every complicated tasks easier. Your content is incredibly helpful
Super helpful Leila. I don't use this often enough. Thanks!
I owe you big time with your tutorials. Thanks a lot.
Thank you Leila! I had used Data Tables long back and your video was a much needed refresher to revise and start using them again where needed. Great! 🙂
It's a very overlooked yet sometimes quite helpful little feature. Glad you enjoyed the refresher!
Thank you, Leila, for this wonderful tutorial!
I am a professional UX/UI designer trying to switch careers and become a full-time data analyst or at least part-time.
I've been working with SQL for a long time since I am a CS graduate and I recently learned SSIS, and Power BI on my own.
I was actually having a little bit of a rough time with the concepts of data analysis and formulas, etc. so I decided to learn Excel. I stumbled upon Data Tables last week, I got stuck on it and I just couldn't understand why are data tables used and how to use them. It's been two weeks now, I tried searching around and watched numerous videos on RUclips but no one explained it better than you did.
I truly learnt a good skill in this video. Easy to follow and grasp. Thanks Leila!
Wow! You just Simplified a concept that intimidates the life out of me.
Thanks, Leila
Ms Leila, you're my favorite Excel Teacher.
Love you, from Malaysia
I had NO idea this was possible. THANKS, LEILA!
ABSOLUTELY AMAZING... SEEING THESE TRICKS IS LIKE A MAGIC FOR ME.
You are a great teacher. Thank you.
A super model doing math, incredible 😊
Well explained, thanks !
I have been following your your videos for many years now.
I am convinced that we all use not more than 10% of what Excel offers. Great video as always.
I never used this function but now we have a clue. Miss Leila thanks a lot for your excellent video. And thanks to the video editor for that remarkable job
Leila, there is a really neat way to use data tables, eg to run a set of scenarios with many variable parameters. To do this, 1. set up the scenarios, one per row, with the parameters in as many columns as you want alongside. 2. Create a scenario selection cell that will look up all the parameters for a given scenario, using the scenarios number as a row offset, ie 1 will pick the items in the first scenario row. In this way, you can select a whole scenario's worth of inputs by changing one cell. 3. Create a data table with the inputs down the left being the sequence 1,2,3,4.... for the number of scenarios. In the columns alongside, put the values you want to store for each scenario. Now run the data table and it will process all the scenarios and produce a set of results for each. So in this way, you can change many variables using a data table, which is extremely useful.
Very nice! Thanks for sharing your solution.
I would love to see this translated in a video demonstrations. Sounds VERY useful. Please Leila make it happen!
@@LeilaGharani hi
No idea how to execute the idea but that is exactly what I need.
Leila, it would be neat to have a video to demonstrate what’s being discussed here!
This was impressive. Thank you.
I Think I found my Best Teacher in Data Analysis.Thank You And I hope more tips.👍👍👍👍👍👍
Thanks Leila this is so clear im jumping in..
Great & Simple Explanation
Thank you Leila, I love your tutos as always they are very straightforward and easy to understand !
Simply awesome, I learned a lot from this short tutorial. Thank you!
Beautifully done!
Sweet! Thank you
That was great. Thank you!
Thank you for adding some much-needed explanation and clarity to this element of Excel. A video is worth 1,000,000 (1,000²) words. The example helps demonstrate what's going on.
Too bad the real world doesn't work quite so easily. "Yes, I need my interest rate to be twice as much to achieve my goals." and BOOM! The interest rate is double. The most controllable piece of the equation is the monthly contribution. But that's a completely different conversation. 😀 Hmm, now that might be a slightly better example with a double lesson: the data table and the contribution amount.
Thanks, that's neat especially the rows and columns explanation.
Thank you for being helpful
Great video, thank you!
Lesson completed, thank you so much.
just loved!
Leila I follow your channel always and get more information, learn a lot God bless you more!! Thank you for your class👋👋👋👋👋
love you, you make everything simple and easy to understand... you are the best excel trainer
Wake up, watch Leila on RUclips and learn something new. great way to start my day. Thanks!
So nice to return to my standard early morning routine, 'Thursday's With Leila', i.e. hot coffee, biscotti and another insightful training video ... and I know exactly where I will employ this technique. Thank you ... thank you .... thank you.
Sooooooooo nice to have you back ... 😍😍😍😍
Glad you enjoyed our Thursday date :) Biscotti is a good choice!
Thank you for reviving…🙏🏻
thank you so much for this video, it helps me a lot.
Great very useful information 👍 Thanks
Thx for the explanation, it was pretty useful 💕
Thank you so much for this video!
Thanks, very helpful...👍
This was very helpful for me, so thanks Leila
Very nice explanation.
Great. Thanks.
Leila, you are the best teacher ever! I just currently found your channel, and already using some new features you showed me. THANK YOU! You are brilliant!
Great to have you here!
@@LeilaGharani you have an imposter fan
Excellent video!
Thank You.
Thank you Leila.
Short sweet and informative
Thanks 👍..
Great video ! Thank you lala 👍
Brilliant work
You're a lifesaver! Thank you for the crystal clear teaching! 💎
You're so welcome!
Fantastic video and examples. Thank you so much!
Glad you enjoyed it!
Thank you. This is a very useful tool. I think you have explained this very well and it is not complicated at all.
Thank you, explained nicely
Thanks. Very Informative.
As ALWAYS, you are awesome!!
A very big Thank you Leila. Your video Your contents and Your clear pronunciation though you are not a native English speaker. Really awesome!
Great video about data tables. helped me a lot to understand and apply.
Galing, isa kang alamat Lodi.
Mysterious but cool Excel feature. Thanks for sharing!
Thank you so much for sharing
Very very intersting mam, thank you so much.
Always a great learning experience when I watch your videos! Thanks 👍
So nice of you!
Thank you
Awesome.
Great tutorial! This is a ‘classic’ Excel feature from the 1980’s and ‘borrowed’ from Lotus 1-2-3. Before pivot tables, power query and power BI.
I find the implementation in LibreOffice easier to use.
I was struggled with it, thanks a lot. That's really healpful for beginners like me.
Thank you Leila :)
This could have use cases for sure, but it certainly is not very intuitive. Thanks for sharing Leila.
Yes terribly unintuitive when choosing the row and column input cell(s) considering they exist in the base formula. Using the first value in the column or row in the table being created would make more sense to me, but I guess doing it the way they are doing it allows the purpose of the numbers in the row or columns in the destination table be defined as they relate to the base formula. If so, the dialog to choose the inputs could still be made more intuitive so that the relationship being made is more prominently displayed and evident.
Not intuitive at all. Thanks for watching, Matt!
Great video Miss Leila, I will certainly use it in my work, my bosses will love this analysis... I work for a Petroleum Company and on a weekly basis we need to make this analysis... thanks a lot.
Very nice video Leile. Thanks for your hard work 👍
Great analysis video 👌
This is sooooo brilliant! Thank you a lot... 💡👍👍👍👍🙂
Excellent work 😍
perfectly explained. Thank you!
Glad you enjoyed it!
Nice video thanks for sharing
Great One Leila. thank you for this
Oh this is beautiful!!! Thank you so much and I will go use it right away!!
Glad it was helpful, Rebecca!
thank you Leila
Awesome tutorial ma'am.👍
Thanks for sharing, Leila
watched so many data table videos, it kind of always seemed unintuitive. With this video, I kind of got a sense that I got it. Thanks!
Excellent one 🙂
This is really good indeed.
Haven't used Data Table before, very interesting video .. to make it clearer, perhaps a macro button can be created to refresh the data instead of pressing F9 ... the button will make clear that the calculation isn't automatic. 😉
Never tried this. Wow! Just Wow!!
Hope it will come in handy.
GOOD JOB
Thanks
Good work 👍
Hello Leila. I had used this table way back in 2003 when I used to teach MS Office. Thanks anyways. Good day.
Thanks for the share.
Awesome Thanks