How to use Flash Fill and Fill Handle? -Excel

Take the assessment in order to know your career growth:https://bit.ly/3buJgdI

Flash Fill in Excel automatically fills your data when it senses a pattern.

For example, you can use Flash Fill to separate first and last names from a single column or combine first and last names from two different columns.

Note: Flash Fill is only available in Excel 2013 and later. A Fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells.

In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner, as shown in the video. Shortcut – ctrl + D or ctrl + R #excel #excelfunctions #excelshortcuts #flashfill #fillhandle #bpa BPA Educators offers Basic and advance courses of Microsoft Excel, which helps you to keep the data of number and analyze them properly, according to the requirements and needs. Linked videos: Functions in excel- https://www.youtube.com/watch?v=R3GRg7lVycM&t=106s Popular videos: How to use pivot table in excel – https://www.youtube.com/watch?v=zuPy6zuZT2E&t=3s Data validation in excel – https://www.youtube.com/watch?v=xDVHtUYC6w8 KEY FEATURES 1 Live project A Certificate of Professional Training after the completion of course. OJT Certificate. OJT(On the Job Training). Expert advice Call: +91-8512851249 Address: C-8/13, Sector-7, Rohini, Delhi-110085 Website: www.bpaeducators.com Instagram: https://www.instagram.com/bpaeducator/ Facebook: https://www.facebook.com/bpaeducator Twitter: https://twitter.com/EducatorsBpa LinkedIn: https://www.linkedin.com/company/bpa-educators/