Language

Excel

Hints and 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 of 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 18, 2025
Time
3:30 PM

You must be logged in to access these events

Login or Register

Duration
60 minutes
Facilitator
David Millard
Quiz
No
Certificate
Yes
Recommendation
100%
of Users who said they'd recommend this course.
On Demand
Please login to access On Demand content. Login
Login / Register
In order to access events you must have an Account.
Login / Register