How to Impress Your Boss with Flash Fill in Excel #shorts

Here is a simple way to impress your boss! Instead of wasting time typing in data in Excel manually, use Flash Fill! Start typing your values and once Excel recognizes a pattern it will fill the rest of the values automatically for you. Save time without writing formulas! You can easily split your data in Excel with Flash Fill. No need to write formulas and type these out manually.

Let’s connect on social:

Note: 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!

#MsExcel #shorts

[zhin]

I keep shortcuts a secret from my boss so I can finish the work faster for the same due date without being expected to do it faster next time. Then I get to spend the rest of the time learning more shortcuts!

[scotncan]

I like how your videos get right down to the explanation. No boring intro or outro. I can access the info quickly

[kahhengyeong]

For me, it's more like impress my colleagues.
My boss hardly cares what I actually do, just only need my final output :)

[ourhouse]

I LOVE these short videos. I did your Excel foundation course on Udemy, so these bitesize vids are great just to remind me what I've learnt on the course. Thanks Leila! <3

[chh]

At the 45 second mark, Leila asks " ... how cool is that? ..."

Very cool ... just like the rest of the material on this channel.

[vishaldobariya]

I wonder who are those people who disliked this video. I have seen many videos from Leila which are short and precise to the topic and I believe lot of hard work goes into creation of such videos. I wonder how people cannot appreciate the efforts put in.

[OntarioAndrews]

That is so freaking cool. I just did it as a test. Easy-peasy. Thank you so much. Cheers!

[mieczyslawm]

I love your voice.

I love that calm charisma flowing through the air, surrounding me and disabling my high guard, it feels like the world is perfect, harmless place.
I would love to be so calm as you.

[garynagle]

I’ve used flash fill before, but not quite like this. Thanks for the enhanced tip

[andrewcharlesmoss]

Flash Fill is certainly a clever tool!

[yagr]

Maam from 0:33 minutes i am unable to watch video clearly due to annoying overlay placed

[harounamir]

This is Super Cool ! Thanks for sharing Leila

[joevano]

So much easier than formulas to do the work. Especially if it is a static list.

[GeertDelmulle]

Cool: Yes. Perfect: No...
...and if only it weren't static. Maybe dynamically create a formula, just like Power Query. That would even be cooler! :-)

[wayneedmondson]

Thanks for the Flash Fill fun Leila! Always awesome tips :)) Thumbs up!!

[SaddamKhan-jdsj]

type in the first row and then press Ctrl + E on the 2nd row. By doing this you don't need to start typing in the 2nd row and also you don't need to press enter.

[anthonysais]

Thank you Leila for that highly useful tip!

[miabellisima]

I first learned search, find, len, mid, left and right when this could have done the trick. Learned something new 😊

[cenevspeed_CARS]

Leila please do decrease the length of the end screen. It comes in the way of the real content. Maybe you should set it to be only 5 seconds long.

[najumusmani]

Mam please start live excel learning program for beginner it will be very helpful