Didn't know how to use Excel until I learnt from this video. I can now do the basics.
@sadiqanwar73215 минут бұрын
Genius
@oldmanobie630018 минут бұрын
I don't know why you sped up your video at places. That's where you lost me. Thumbs down.
@halweiss867140 минут бұрын
It took forever to solve the cube because the last step didn’t work. None of my corners were solved to start the last step and after doing it 4 times, only 2 corners were completed.
@digitalchameleon18842 сағат бұрын
Execellent tutorial. I know what I'll be asking my daughter for my nexy birthday. :)
@DreamWizard92 сағат бұрын
Microsoft is total Sh!te.
@davido5662 сағат бұрын
Actually if you use copilot everything you have access to suddenly become available to Microsoft. If you did this with employee data you are the kind of person that doesn’t care about a breach
@leerv.4 сағат бұрын
HA HA HAAAAA! I feel like a champion!!! This convinced me to buy a cube and finally give it a go. I had of course touched one a few times when I was an 80's kid, but never for more than five minutes and it always ended in frustration. I had to watch this video several times this week, and practice throughout the day.... I even brought my cube to work with me so I could play with it during meetings (hush everyone, you know you've been in a meeting or two where your immediate contribution isn't required!) ... but I finally got it tonight! I solved it three times in a row to make sure it wasn't a fluke! Thank you, Leila!!! :) :) :) <3
@minhhuynh95484 сағат бұрын
Wow amazing. I sometimes complete the first and second layer by instinct but rarely complete the third layer. Know I know the formular. Thank u
@JadeDragon4074 сағат бұрын
That's pretty wild! Anytime I need to do something similar, I bail from Excel and run all that through Access and queries there. I've had various times I would have LIKED to've had data in Excel for more freedom of visual look, but saw no good way to do it. So cool!
@caseonfire4 сағат бұрын
I wish I knew this as a kid
@reghunt24875 сағат бұрын
I learned a couple years ago a set of algorithms like this, but yours are easier to understand, and now I have a better grasp on what I'm dong. Thanks.
@canbalcioglu42295 сағат бұрын
OK, this is another beginners video. I used to solve the cube with the exact same method that is shown in the video. Of course, after several years not holding the cube, you forget these algorithms. The best part is that you do not need any algorithms to solve the first 2 layers, but in order to finish the last layer, you need these algorithms. So, when she said (in the first 30 seconds of the video) that she was fed up with those algorithms and that she came up with a better way, imagine my excitement 😅 Lo and behold, she uses the same stinking algorithms in the same exact way in every other beginners video that I watched many years ago.. Now, I understand many here are first-time cube solvers, so I can relate to their thrill, but please be sure that this is the most common beginners' way to solve the cube, which is simply on every other cube related channel on youtube😊 So, in a way, thanks but no thanks Leila for this clickbait!
@kittybuckley35 сағат бұрын
Thank you🎉🎉🎉🎉🎉
@JadeDragon4077 сағат бұрын
Cool! I really haven't fooled with Pivot Tables as I just generate a tab with formulas that do what you're doing here, but it does get annoying when data rows get added or if in your example a new product gets used in the data... you wouldn't have to reprogram the other sheet to accommodate the new product.
@shinestudyingsharing36487 сағат бұрын
Thanks Madam ❤
@melwynd9 сағат бұрын
Step 7: "Ignore all the mess that we're making"....most reassuring words ever spoken 😊
@jowbloe36739 сағат бұрын
Different cubes have different color schemes, so talking about specific colors is a bad idea as not all cubes will have the same colors on the same faces.
@Dravidan197110 сағат бұрын
Hi how watched a lot of videos in excel from various providers. But you are an expert in Excel videos as you know the latest updates and everything happening in the Excel and you are immediately bringing it to us. Thank you for that. Since you are an expert I have suggestion to you to make a video which I never find in the whole KZbin that how can we think to construct a formula in situations especially complicated formulas, meaning I have a situation I want to build a formula to solve that situation from where I have to start how I will start building my formulas. Breakup into small pieces then we have to start from 1 2 3 like that. If you can make a thorough video on this this will be highly appreciated
@feanor050810 сағат бұрын
10/10 🫶
@lizmarroquin896410 сағат бұрын
I spend 2 days trying different variations of my password. I followed your steps and voila! Life saver!!
@Dravidan197111 сағат бұрын
This formula can be used to merge data from the sheets but can we skip any columns in between are only a complete set of columns only we can add here?
@Dravidan197111 сағат бұрын
What if the data sheets having formulas and references or links to other sheets or something? Only values without formula will work for this function or with formula also can be added in the sheets?
@NyanLinTun-t7s12 сағат бұрын
I would like to know how to search with three or more criteria,please answer to me
@melissasiglerteam13 сағат бұрын
This was terrific!
@Nkc7713 сағат бұрын
Can you made vedio on how to slove megaminx cube
@franciscomarchenag14 сағат бұрын
This is the best video on this topic EVER! I'm 51 years old and never was interested on solving the cube because all the "easy" tutorials were actually loaded with naming positions, nomenclature, confusing diagrams, etc. This video was like a good patient friend explaining me how to do it side-by-side. And now I'm able to solve the cube every time I try it. And my 10 and 8 years old kids also learned with this method.
@75psheth15 сағат бұрын
Las step didn't work for me
@danymatta-i4v15 сағат бұрын
👍
@danymatta-i4v15 сағат бұрын
👍
@jorgevillacis812715 сағат бұрын
i cant see this video the decoration is HORRIBLE !!!!!!!!!!!!!
@johnnorman179316 сағат бұрын
Who cares about all the computer jargon she was talking about, the lady is a BABE..!!!!
@mujuw16 сағат бұрын
This is such a useful video, thank you so much! I'll be sure to explore your courses :)
@kiraramiyazaki68517 сағат бұрын
Okay okay I subscribe you
@nikivl240419 сағат бұрын
I CANNOT FIND THIS FUNCTION AT MY EXCEL. DO I NEED TO PAY? HOW CAN I INSTALL THE FUNCTION?
@esiyada19 сағат бұрын
Method 2 fits for me
@Aloneprabhu9919 сағат бұрын
Nice tips thanks
@heidibanta200520 сағат бұрын
This has been super helpful - thank you for explaining so clearly
@AinuiSteven-f8n20 сағат бұрын
How can follow you
@kawaiku21 сағат бұрын
Thank you for the very wonderful video. I have been out of work for a few months now and I am close to landing a new job so this is helping shake that dust off.
@letsreasontogether349622 сағат бұрын
On my way to purchase a Rubik's cube. Can't wait to try this.
@CrisSer-zt1hw23 сағат бұрын
thank you for a fantastic video Leila. wow just what I wanted and boom its done. love your work
@LeilaGharani21 сағат бұрын
Glad you liked it!
@BLew65723 сағат бұрын
Lost me at 6.50 😢
@LeilaGharani21 сағат бұрын
You need to bring the white edge pieces around the daisy down to the white face. But before you do, you need to make sure that the other color of the edge piece matches the color of the side below it. Example: if you have a white/red edge you need to rotate the top layer until the red edge is aligned with the red center. Then turn the side 2 times to bring the white edge piece to the bottom.
@BLew6578 сағат бұрын
@LeilaGharani Thanks for the reply Leila. I watched this late last night. I was tired and my 61 Yr old brain wasn't braining 😆 I've always wanted to do the rubix cube so I'll watch this again when i have a couple of free hours and can concentrate 😁
@spifariffic23 сағат бұрын
Thank you so much for creating this very clear explanation. Your story in the beginning was similar to my own - I didn't want to memorize algorithms without understanding them! I feel like, now, I am much closer to understanding *why* the patterns are what they are. I still don't quite understand why the patterns you show work, but I feel like if I take it slow and examine the cube at each point, I might be able to wrap my head around it finally!
@tywinders762823 сағат бұрын
People do this in like 4 seconds! Crazy!
@clydemonte9659Күн бұрын
Thank you!!!
@cahiteshsachdevКүн бұрын
Hello Ma'am, Nicely explained. But we can apply a filter in header and add custom filter there.
@tammydee143alldayКүн бұрын
Out of all of the vlookups I’ve seen on KZbin, this is THEE BEST video. Thank you. I’ve been trying to learn this for awhile and I understand your examples clearly. Thank you
@alexandrahenriquez2722Күн бұрын
Sos un astro, mujer, muchas gracias
@orbeuniversityКүн бұрын
Personal Notes: 21:12 Steps for creating a Yellow Cross 25:35 Solving Yellow Edges