Excel Training- How To Use The FlashFill Tool
Eoin Lynch – Oct 17th, 2022
Heres a taste of some of the amazing top tips, tricks and shortcuts included in our training sessions.
Anyway, let’s have a look at the awful options a lot of these I know guys you will already know but let’s kick into this straight away. The first one days of the week the abbreviated version so you can see i’ve got Monday here or Mon, I’m going to grab my autofill, then little crosshair drag it down and look what it does it gives you Tuesday, Wednesday, Thursday. I’ll do a brief abbreviated version you can see it also works with the full version so there’s monday I drag it down and hey presto you can see it gives you seven days a week well guess what if it works for the days of the week, it’s also going to work with the months of the year.
Okay, second last example. Example number four. So, now what I’m looking to do is I’ve got all these account numbers, okay but really they don’t work for me that well I’d like to have these dashes and break them up. As you can see here, look there’s the example 775-576-644 okay. Every third one I want to dash in here I give the example. Guess what you already know the answer flash fill, I’ll do the rest just brilliant and the last one for today guys is this one what if you want to just extract a certain piece out of it. So, for example I want to take up all these account numbers but I’m looking to take out the numerical part out of august. So, I put in my example two, three, five, six and guess what you already know flashfill does the rest. I mean how good is that? What I love about this one is it’s giving you an insight into the new stuff that Microsoft are bringing out all the time it’s one of the reasons I’ve been using this application for 20 years and it still keeps me interested still love working with excel look that’s it for today guys.
Microsoft Excel is an extremely critical tool in the world of business, education and home offices, but are you using it as efficiently as possible? Even if you are familiar with Microsoft Excel, the number and variety of keyboard shortcuts you can use to speed up your work may shock you.
If you find yourself constantly reaching for your computer mouse or your laptop’s trackpad, you are slowing yourself down and hobbling your typing speed, costing yourself time and energy in the long run. Learning how to correctly use keyboard shortcuts can save you a lot of this time and energy, while boosting your overall productivity. You can find out more about these shortcuts and much more about business, websites and Microsoft Office in our helpful Blog section.
If you found this tip on learning about Microsoft Excel helpful, InvestinU offers a range of training supports, including Webinar Excel Training, for Microsoft 365 which can be found here.