Increase productivity in Excel
My next tooltip is a feature that’s been around since Microsoft Excel 2013 but it’s one very few people know anything about . Whenever I share it with anyone it’s the one tool that gets the WOW factor because of the amount of time it saves when performing what is quite often at very very tedious task
This little known and quite hidden feature is cold Flash Fill and it’s one that I would like to spread the word about because it ties in with my ongoing theme of productivity .
My key focuses of cybersecurity and productivity lead me to looking for the features that I believe will help the most to improve your online experience .
Do you need to extract data out of string of data, or combine two sets of data together. Like extracting Firstname from Fullname or Combining First and Last names together and find you are writing complex formulas or VBA code to do it?
Flash Fill works on pattern recognition and fills your data when it senses a pattern. Sometimes it takes more than one example for Excel to recognise the pattern but when it does it simply fills your data in for you