ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is the benefit of using FLASH FILL in Excel? and what is accuracy of this function?

user-image
تم إضافة السؤال من قبل Majid Abdulrahman Mohammed Al-Thorah , Senior Auditor , Grant Thornton
تاريخ النشر: 2016/02/25
krushnasinh chavda
من قبل krushnasinh chavda , General Accountant , Pixel Digital Systems LLC - UAE

 

Flash fill is time saving feature which fill in data when pattern is recognized. It can also remove, insert and format. This feature can even reverse text, numbers and dates.

 

Oliver Watling
من قبل Oliver Watling , Procurement Category Manager - Facilities , E2V Technologies Plc

Flash fill essentially makes data input faster and more accurate as it helps avoid typing errors by automatically detecting previous input.

Abu Bakar Ashfaq
من قبل Abu Bakar Ashfaq , Senior Consultant , PricewaterhouseCoopers Middle East

In a new column next to existing data, enter a value that represents what you want to extract, combine, etc. Then, in the cell below, use this shortcut. Excel will try to apply the same pattern to all rows in the data. You can use Flash Fill with text, numbers, and dates.

مستخدم محذوف‎
من قبل مستخدم محذوف‎

 

 

The property, which placed in Excel is a transfer or a rating or the inclusion of data from the boxes which codified them into other boxes as a package where you are when you're trying to do this process to take you time and effort, especially when some of the work, such as an account statement to customers or others shall be this way such as the process of Copy and Paste. Hence comes the importance and accuracy of this property but it is not the sophistication prospect errors such as the mobilization of all the data in one box instead of unloading all the information in a separate box.

           

 

 

المزيد من الأسئلة المماثلة