Excel

Excel Hints & Tips Part 6

Excel added a new feature a few years ago that makes it super easy to fill lists of things in a different way once it recognises a pattern. This feature is called “Flash Fill” and in today’s first exercise we will use it to unscramble a list if names, add email addresses, extract flight numbers from destination codes and years from dates. The second tip explores the new “IFS” function and the third uses a neat solution to filling downwards in a column. Note: Excel 2019 or Microsoft 365 is required for IFS.

Introduction level, no experience required

Events

Date
Feb 15, 2023
Time
2:00 PM

Related Courses

FAQ's

If you go to the My Account area, you will see all the learning events you’ve attended. You can download the related handouts for as long as you maintain your subscription. You can watch recordings of all events for up to 30 days after the event.
If you go to the My Account area, you will see all the learning events you’ve attended. You can access the recording of any session you attended for 30 days afterwards.
They will be emailed to you automatically and are accessbile via the certificates tab on the My Account page.
Any courses or modules which are CPD accredited are clearly indicated
There may be an issue with your choice of speaker, please check your settings in Zoom.
Yes – our courses are designed to be accessed using any mobile device
On your Login page, hit the Forgotten Password button. Follow the instructions on the next Reset Password screen and you’re done!
Product
Lite
Duration
60 Mins
Facilitator
David Millard
Register FREE today
in order to access events you must sign up for a SeedL Account.
Register Now