Grab the file I used in the video from here 👉 pages.xelplus.com/vstack-file
@IGNACEGIRUKUBONYE6 ай бұрын
Hello Leila! Thanks a million for your teaching materials, they are helpful. I have a question: After combining sheets with VSTACK, I can't turn the data into an Excel Table. Why is it so? What can I do to keep the data Dynamic? Thank you for your feedback!
@Alkamanojofficial4 ай бұрын
Whast about version of Excel?
@RenierWessels2 жыл бұрын
This was awesome Leila. Being able to showcase all of that in under 7 minutes is pretty amazing. I struggle with keeping my videos short myself. The production value of your content is amazing. Well done.
@LeilaGharani2 жыл бұрын
Thank you Renier. You have great videos on your channel.
@RenierWessels2 жыл бұрын
@@LeilaGharani thank you. I appreciate your reply!! Keep up the great work.
@truthByFire2 жыл бұрын
This channel is fantastic. Great content!
@dheerajy22022 жыл бұрын
@@LeilaGharani big 🧢
@Idiot1230092 жыл бұрын
@@LeilaGharani Leila Gharani is always amazing. Excellent and precise on topic. Excellently explained. Always pray for you.
@pdrg2 жыл бұрын
Then the Regional Manager arrived and didn't even look at it...
@magnushultgrenhtc2 жыл бұрын
My thoughts exactly. "We're running two minutes late and will have to cut the presentation."
@soft.learning2 жыл бұрын
It happens sometime
@usmanahmed5854 Жыл бұрын
😂
@LetsCOLORup Жыл бұрын
Lol
@amoorinet.. Жыл бұрын
Far from the main purpose of reports which is documentation I don't know what the size of the company you work for, but as a professional management approach, top position people prefer short reports. An example in the field of construction in which I work is that area managers are interested in achieving the Milestone without details, and project managers are interested in achieving a number of activities without details. And construction managers are the ones who care about this huge amount of reports.
@chh88602 жыл бұрын
VSTACK??? ... I'm speechless ... another stunning display of Excel mastery ... Some people look forward to Friday's ... I look forward to Thursdays ... w/Leila ... 😍 PS " ... we just had to switch things up for a change ... let me know what you thought about it ..." 😞 ... 🥱 ... 😴 ...
@LeilaGharani2 жыл бұрын
Thank you for still looking forward to Thursdays! Even after all this time.
@texian21122 жыл бұрын
Why isn’t there a love button? As always thanks for this valuable productivity hack. Keep doing what you do Leila. Love this and all your other posts.
@cruzinsweetsntreats2 жыл бұрын
There is from the content creator, such as Leila, but not from us, as I too, would like to respond as such on numerous others. 🤟💌😍
@ashutoshaurum Жыл бұрын
Whenever I KZbin a problem on Excel and it's your video, I know it is the best of the lot. Thanks for the wonderful explanation!.
@roderickmose46912 жыл бұрын
"Hold my coffee".......just gotta love the lady! Excellent and creative as always. Well done again, Leila!
@CameronWilson-m5f18 күн бұрын
I've spent all day trying to figure this out, what a massive massive help!!! Thank you so much.
@LeilaGharani5 күн бұрын
Happy to help!
@dagnabit278512 жыл бұрын
This is amazing! Side note: I'm the noob who didn't know you could drag and drop tabs from a different file so I learned quite a bit in this video.
@LeilaGharani2 жыл бұрын
Glad you liked it :)
@Rogue-productionsCoUk2 жыл бұрын
This totally fits my learning style! Great to see the problem and have the solution stepped through. Excellent demo of 3 function in 7 minutes!!
@LeilaGharani2 жыл бұрын
Thanks for the feedback! Happy to hear that.
@mamachugh11252 жыл бұрын
This is fabulous Leila! I always appreciate your tutorials. Short and sweet, as always.
@LeilaGharani2 жыл бұрын
Thank you so much!
@superohitupadhyay2 жыл бұрын
I feel superman among my colleagues, I have gone through all your videos on UDEMY as well as KZbin, many thanks for making our job easier, more power to you, and about your acting style in this video, since your content is so informative you don’t need it, however it’s making video more interesting.. Thanks (your follower from India)..
@tommyriddley81292 жыл бұрын
I have been following you and it has resulted in me signing up for your courses on Udemy. Although I have to take several attempts at the lessons it is great using your practice files so I can concentrate on developing my understanding of the functions. Thanks for sharing your knowledge.
@abdulsaidmkamara73052 жыл бұрын
Leila Gharani !!! She does it again Thank you !! I will be implementing this soon, You have taken by the hand from a below average excel user to Finance Executive level execution in a few months. You are one of the best things to happen to my career.
@LeilaGharani2 жыл бұрын
Thank you Abdul! You've done the hard work. I'm glad to be a part of that.
@ujjwaldeo67702 жыл бұрын
OMG😲 I had no clue about this before today. In actual tasks on our jobs, things would be so much easier...just using this, esp. the VSTACK....simply wow👌. Thanks Leila👍🏻
@LeilaGharani2 жыл бұрын
You are so welcome!
@BEDSTUYKEV314 ай бұрын
2 snaps up. Thank you! I needed a workaround from PowerQuery since I had to consolidate worksheets in non-table format
@lucasb409 Жыл бұрын
I have been struggling with using the filter function wrapped on VSTACK until I noticed something. I MISSED the fact your condition was for only 1 column, not the whole row. My Value# error is gone and it works! My project is saved. Thank you!
@tianyi052 жыл бұрын
Finally Excel gets this function, Lotus123 had it back in the early 1990's, except sheets in Lotus didn't have to be identically laid out, columns in sheets could be in any order and some sheets could have extra columns, also could add rows to individual sheets as definition of the array was dynamic.
@Cappurnikus2 жыл бұрын
Very cool function. Thanks for sharing! I recently solved this same scenario but with VBA. It was a very small loop but also considered the last row of each sheet to ensure there will never be missed info. Thanks again!
@Bill_Woo2 жыл бұрын
Tip, freeze header rows. The sooner you do that in the process, the more you'll benefit. I know Leila knows that and surely she's covered it in other videos, but it's hugely useful for what she does on this one.
@michaellucas71772 жыл бұрын
Thank Woo!
@cruzinsweetsntreats2 жыл бұрын
What's the overall benefit per your strong suggestion to freezing the header rows?
@Bill_Woo2 жыл бұрын
@@cruzinsweetsntreats When you have more than a screenful of data you then always immediately see/know which column you're operating on. Bonus, as Leila smartly uses keyboard instead of mouse in many situations (because it's faster, more accurate, and allows undistracted visual focus), control home stope at the top of the data instead of top of the worksheet (though some may not find that to be an advantage).
@cruzinsweetsntreats2 жыл бұрын
@@Bill_Woo that's what I realized moments later, as old-skool, compared to converting a range to a table, which then the header row is automatically programmed to do just that, show at the top when scrolling down. 🤫👍😁 I've now got mine to include a conditionally formatted group of columns that are calculating my mileage, just outside the vstack, yet in my Pivot Table range for use. 👍
@cruzinsweetsntreats2 жыл бұрын
@@Bill_Woo I've done split screen before, but wasn't putting the 2 together. Though in searching, if I desired, I found the proper method of adding the table header on each page, for the same reason, continuity of the data.
@unkchaos20072 жыл бұрын
I was thinking of how am I going to combine a bunch of files by copy paste, till I saw this video... I asked the question yesterday and this video pops up in my home youtube page today... Amazing! That just solved yesterday's problem for me. Thank you :D
@LeilaGharani2 жыл бұрын
Great timing 😊
@nathanmclauchlan51482 жыл бұрын
Wow. Amazing. Thanks so much, you made it rather easy to combine data from multiple sheets, remove blank rows and sort the data
@rob4canada2 жыл бұрын
Loved the new video style and explanation of VSTACK and how it could be used in a real world example.
@chrism90372 жыл бұрын
Thanks Leila! I still don''t have VSTACK but can't wait to get this and other new functions.
@Hey_Dave2 жыл бұрын
Love the switch-up!! Amazing! I always learn something new from your videos.
@hiteshbhatia7872 жыл бұрын
Big fan of urs....as always u bring the solution of problems with dynamic formulas and building dynamic environment in Excel....
@michebernier52982 жыл бұрын
Thank you so much for this video, it was great reminder that formulas can be built with main intent, then sub requests added in as they were requested, all too often many of us build the formula from the beginning to the end, and forget we accomplish one goal, then add another goal, and so forth. Example, delivery and content was fantastic -- Thank you !
@luisfeps2 жыл бұрын
Thanks from Brazil. Amazing videos with so dynamic teaching techniques.
@lucyene50602 жыл бұрын
😱😱OMG... I'll try on my report now You're amazing!!!!!🤗🤗
@pravinr1972 жыл бұрын
The purpose of VStack function in excel is beautifully explained. The purpose is to combine different worksheet data into one table in a dynamic way.
@pwells23892 жыл бұрын
Really enjoyed your helium voice for the newbie :) Great info too. I've been using Excel for ages and didn't know about the 3D worksheet referencing (I thought that was dead with Lotus 123) or the { bracket feature. Many thanks.
@hussainakhtar1094 Жыл бұрын
This is just a master blaster... I love using these tricks, playing around, and doing analysis with data. The beauty of the array functions is that the file size does not increase significantly.. Thank you Laila awesome stuff.
@LeilaGharani Жыл бұрын
Glad you enjoy it!
@hussainakhtar1094 Жыл бұрын
@@LeilaGharani I have used these on inventory sheets and it worked awesome
@jamesgriffin7732 жыл бұрын
Thank you for this heads up. This is a function I really want. For a long time iferror was the life changing function. Sumifs came along. Then the dynamic arrays improved my life. This will solve so many questions from auditors.
@officialpreside102 жыл бұрын
Wow. You never disappoint. Weldone Ma'am
@spacedudey2k Жыл бұрын
Fantastic tutorial. And I think I will use this on a project I’m working on currently. Thank you, Leila.
@loganwebb13382 жыл бұрын
I loved this! I am relatively novice with excel but I've learned a massive amount from you. I found the other day that I did not know how to stack data without manual copy pasting and have been trying to figure that out for nearly a month. Thank you for showing this vstack formula!
@igortorrealba2 жыл бұрын
Looooove this format Layla! I encourage you to consider doing more like this!!!
@efs83dws2 жыл бұрын
Very good presentation. You are the best on KZbin for presenting Excel functions and features.
@alimohamedahmed23282 жыл бұрын
I used to follow all your videos it is very useful and amazing for me specially i am senior General LedgerAccountant, thank you so much.
@LeilaGharani2 жыл бұрын
Glad to hear that!
@JeremyMcMahan2 жыл бұрын
Fun video! The part about sorting with two columns and the curly braces for ASC/DESC was gold!
@mzmarquette2 жыл бұрын
Wait, wait, wait ... didn't know you can actually drag a tab from a file over to a completely different file?????? OMG just tested and I'm blown away of not knowing this sooner!! *Leila THANK YOU!!!!* I can't even tell you how much your Excel tutorials have helped me with my work.
@LeilaGharani2 жыл бұрын
Agree! That‘s a great feature 🙌
@fernsehdesign Жыл бұрын
I like the voice of the Noob especially. Cute realistic drama that you created there. Looking forward to the next episode.
@sarahmclin2434 Жыл бұрын
My boss suggested I check out your channel to learn some of the newer excel features. I am so glad he did! I loved this video.
@rodrigodiaz15583 ай бұрын
I knew there was some way more simple that the index formula stuff that honestly make my head hurt, THANKS LEILA!!!
@NoTengoIlusiones2 жыл бұрын
Love the video. Sense of humor and useful as always . A big and fat like !
@shehubilyaminuroro2 жыл бұрын
Hi Laila. This video is great, because it helps me in organizing different report from my Sales Representatives. We appreciate.
@LeilaGharani2 жыл бұрын
That's great to hear!
@PurplePegasus25312 жыл бұрын
THANK YOU SO MUCH!! I was literally just having this issue at work and now I can use this in real time! You're so great at making excel accessible! You're making me a superstar at work
@kenhappich90322 жыл бұрын
As always your presentations are so extremely informative and I love how add the humorous theatrical drama. Your presentations are definitely polished !!!
@michaellucas71772 жыл бұрын
Wish I could thumbs-up this like ten times!!!!
@mananglucing38110 ай бұрын
Thanks a million!!! You are making the life of many so much easier
@LeilaGharani10 ай бұрын
Happy to hear that!
@RichardJones732 жыл бұрын
You've excelled yourself again Leila, Queen of Excel
@MistressKuroko2 жыл бұрын
You saved me! 😭my manager asked me to create a report dependent on data from lots of different tabs and I had no clue what to do!
@bellondayako4162 Жыл бұрын
Loved the way tutorial was presented.
@QueenTuT1000 Жыл бұрын
I thought excel was going to get to best of me until I found your video. I have used Excel for 20+ years and with all of the new stuff it is hard to keep up. Thank you for all of your videos to help out.
@LeilaGharani Жыл бұрын
Glad it was helpful, Melissa!
@AQmanchamoli2 жыл бұрын
Great Leila !! i have no clue about this function availability so far....it surely gonna help in filing my GB certification in my Organisation ❤️ more power to u and happy learning together 💕
@snicho2 жыл бұрын
Ah, it's a beautiful thing! A great practical example. A good use of combining functions. Well presented. And the format works well too. :)
@lankavenkatasuri73882 жыл бұрын
Very beautiful functions.. Very very useful classic method..
@kimbereleybrown9449 Жыл бұрын
Thank you! This was so helpful and easy to understand.
@82MMaarrkkuuSS822 жыл бұрын
Once again... AWESOME Leila!!! thank you very much!!!
@LeilaGharani2 жыл бұрын
Glad you like it!
@Cdaddyx12122 жыл бұрын
Honestly I always thought I was quite advanced in Excel but it is amazing how you overlook small things that can actually be very useful. Thank you so much Leila for your videos and especially how you go through the formulas in a step by step way so it is easy enough for me to keep up. I learned more from you than the official advanced classroom training I had.
@LeilaGharani2 жыл бұрын
Thank you for the kind feedback!
@hectorbrac1002 жыл бұрын
This is amazing Leila! I wished I had seen your video a few months ago when I had to figure this out on my own by try and error yet though I came to the same set of formulas I realized that doing so in Power query was less messier and more customizable. It's still great to know that the same result can be achieved in different ways
@HANSMKAMP Жыл бұрын
I love that!! Both the way the video is made, and its contents. Also the strength of VSTACK, FILTER and SORT!
@srazon Жыл бұрын
so that beautiful fuction combination is an alternative to power query i guess, a least the i use it.. simply beautiful!
@thierryhoornaert99502 жыл бұрын
Thank you, Leila. This is great stuff and a real time saver!
@MrYashaskm2 жыл бұрын
This new method of explanation is great 👍 ..
@thenotidevil2 жыл бұрын
It was just awesome as all your videos. Thanks for sharing and guiding us with all this knowledge.
@LeilaGharani2 жыл бұрын
My pleasure!
@rasyidihramsyah799211 ай бұрын
Short, brief and straight to the point, no reason to not subscribe to this brilliant channel
@LeilaGharani11 ай бұрын
Thanks! Glad to have you aboard :)
@maxkonta6284 Жыл бұрын
I thought I knew how to use Excel... really amazing.
@Gs-Excel2 жыл бұрын
Your video is a nice one. I do have plenty in my channel. Yet, its something i have ever liked to watch the method of teaching.
@cdyard12 жыл бұрын
Great demonstration of how 3 functions could be used together. And I love the way you show this. ;-)
@phil86972 жыл бұрын
Nice acting Leila. Made me chuckle. I learnt something too.
@JettingChen10 ай бұрын
As always, you’re a lifesaver.
@javiercabello35732 жыл бұрын
Hi Leila ! Great video and awesome sketch ! It was easy to understand and even with a touch of comedy. But my question is: would this work better than using power query on that workbook ? Is it faster only with vstack formula ?
@LeilaGharani2 жыл бұрын
The advantage is that formulas are dynamic. So, if that's important to you, VSTACK is a good choice.
@javiercabello35732 жыл бұрын
Thanks for answering Leila. Keep up the great work !
@samanthadaroga4811 Жыл бұрын
This was a great video. Very helpful! Thank you kindly.
@mktindogrosir3539 Жыл бұрын
this video is amazing, really open my eyes there are still a lot fuction that can help me outm thank you so much
@drag0nblight Жыл бұрын
I have learned a lot from this channel. I am actually using some of them for my sideline gig. No more looking up on a list on paper, just Excel.
@BrPdP2 жыл бұрын
great to use with warehouse inventory data. thanks for this idea
@Ticky66MN2 жыл бұрын
Dang, that was an awesome video. Love the style and the resulting education...very impressive. Thank you.
@SamOlliver2 жыл бұрын
Thanks Leila, your videos never cease to be useful and informative! 😀
@LeilaGharani2 жыл бұрын
Thank you, Sam!
@javer11 Жыл бұрын
Leila you saved me again! ❤ Thank you. Will find some time to study your power query videos soon, for now, this is all that I needed😘 God bless you❤️
@voiceofsoul7865 Жыл бұрын
Leila, your videos are as beautiful as you are. I am getting much knowledge from your videos, and your teaching style is also awesome.
@carlosd.villanuevaa.38332 жыл бұрын
Great video, Leila! It helped us, the crowd, better understand these functions that, otherwise, can be difficult to explain in general terms. Thank you so much for putting this content!
@thezonemtb7 ай бұрын
This is almost what I need. I need to pull data like this but as an example I need to search from a column and return it from all the sheets. Then I need to edit a different column on that row across all the sheets from that search. Example: Search a name in column C but edit the sales column and have it spill into every sheet that info is on.
@msrchannel4721 Жыл бұрын
Thank you very much. Your videos are very helpful.
@GlenroyCarty9 ай бұрын
This just saved me a day's work and tons of frustration. Thanks
@LeilaGharani9 ай бұрын
Great to hear!
@osamasaid84762 жыл бұрын
you are great teacher god bless you
@canirmalchoudhary81732 жыл бұрын
I liked the new approach and learnt 3D referencing
@alterchannel25012 жыл бұрын
WOW. Thanks so much for this. You're Great.
@DinoDelight2 жыл бұрын
Another great explanation, im still waiting for vstack. I did not know you can drag and drop a tab from another workbook....that's gonna save me a massive amount of time
@operamaniak812 жыл бұрын
I LOVE IT. Mind blown... I don't work in sales, so the thumb didn't prepair me for this at all...
@MrRoelith2 жыл бұрын
Crazy helpful. Thank you!
@hammerdata16032 жыл бұрын
Nice! I love the situational approach and humor, awesome way to learn! I love "Learning with Leila"! I do like the approach taken, lots of options combined, just wish VSTACK was available to everyone. I actually think Power Query would be more dynamic though. Either way, I watch since there's almost always something you throw in which is new to me or I have forgotten.
@LeilaGharani2 жыл бұрын
True - Power Query would probably be as fast, specially if we start from a blank workbook and then connect to the workbook with all the tabs which would keep the source data separate to the report. I also hope Microsoft doesn't wait too long to release this new set of functions.
@albertleslieurena27662 жыл бұрын
@@LeilaGharani what I do like about vstack is that it's a perfect alternative for web Excel. I have been having issues where my colleagues cannot refresh the data from power query because the feature is not available online
@izzatkiswani2 жыл бұрын
The Queen Of Excel 🌹🌹🌹
@compilationhero11 ай бұрын
Really enjoying your videos. Thanks for sharing!
@andrewcharlesmoss2 жыл бұрын
Great acting skills, Leila!
@Luciano_mp2 жыл бұрын
Very good Leila. I liked! Thank you.
@dafyddthomas7299 Жыл бұрын
Excellent didn't know about Vstack function or how it works - thanks for another great video
@LeilaGharani Жыл бұрын
Glad you liked it!
@GurayVural-nz1lk Жыл бұрын
An impressive video! Thanks a lot for the tips.
@rockymarquiss83272 жыл бұрын
I enjoyed the format and the information is good as well
@captvo Жыл бұрын
Excellent tutorials by you! These new functions are so useful. For the headers, when working with Tables, I find it easier by just adding the header row from the first table once --> 𝐕𝐒𝐓𝐀𝐂𝐊(𝐓𝐚𝐛𝐥𝐞𝟏[#𝐇𝐞𝐚𝐝𝐞𝐫𝐬],Table1,Table2,Table3).
@LeilaGharani Жыл бұрын
Thanks for sharing!
@mattschoular88442 жыл бұрын
Thanks Leila...The video format was good. It explained a hypothetical real world example nicely.