To Ensure our learners safety during COVID-19 outbreak, We have stepped up precautionary measures for our Classroom trainings. There is now an option to attend our classes online live also as our classes will be streamed online
Microsoft Excel and VBA Programming Training Centre | Excel Training Singapore
Excel training Singapore, Excel online training, Learn Excel quickly, EXcel courses Singapore, Microsoft Excel courses Singapore, MS Excel Courses Singapore
15718
page-template,page-template-full_width,page-template-full_width-php,page,page-id-15718,ajax_fade,page_not_loaded,,qode-title-hidden,qode-theme-ver-14.2,qode-theme-bridge,wpb-js-composer js-comp-ver-5.4.7,vc_responsive

Excel Tip – Flash Fill

Flash Fill is a very useful Excel feature to automatically fill the data once it senses a pattern. Pattern could be, combining text from multiple columns, extract characters from some text in  a column, combine text with any character string and any other of these kind.

For Example, lets say you are given with Employee name and their ID and you would like to combine Initial letter of Last Name, First Name and Employee ID  to create Employee Code. For that, you just need to type that pattern in adjacent column for any one of the row data and then just press Ctrl+E to flash fill for all the rows of data as shown below:

To learn many such useful Excel features, attend our comprehensive Excel Courses in Singapore. It is 100% subsidised by SkillsFuture Credit for all Singaporeans above 25 years of age. For others, special discounts available. For Enquiries, please call 66699754 or e-mail to info@ssdn.com.sg.