Microsoft Excel (Flash Fill)

Microsoft Excel (Flash Fill)

In this lesson, we will learn about flash fill in Microsoft Excel.

Let's say column A contains first names, column B has last names, and you want to fill column C with first and last names combined. If you establish a pattern by typing the full name in column C, Excel's Flash Fill feature will fill in the rest for you based on the pattern you provide.

1.  Enter the full name in cell C2, and press ENTER.

2.  Start typing the next full name in cell C3. Excel will sense the pattern you provide, and show you a preview of the rest of the column filled in with your combined text.

3.  To accept the preview, press ENTER.

If Flash Fill doesn't generate the preview, it might not be turned on. You can go to Data > Flash Fill to run it manually, or press Ctrl+E. To turn Flash Fill on, go to Tools > Options > Advanced > Editing Options > check the Automatically Flash Fill box.

Read Best Story Books

MICROSOFT EXCEL (CREATE AND CLOSE FILE)

MICROSOFT EXCEL (CREATE AND CLOSE FILE) 1.       In This lesson we will learn how to create a new workbook and how to save and close it. 2.       First of all, I will show you how to go to excel file. First go to start button and then search excel as given below in picture. 3.       Just click on excel you will find below different file options. These options are Blank workbook, Welcome to Excel, Formula tutorials, Pivot table tutorials etc. You need to open which file do you want to open. 4.       From here you can open your already saved files. As you can see I saved two files here. First one is Studentsrecords and Entry from. I can open after clicking on any of them. 5.       But if you want to create new workbook then just click on Blank workbook. It will show you excel sheet. Here is blank file, can say raw file. Suppose I want to create it as saved file which I can open when I need. So for this, I need to write something on it. For example, I have put small data about customers and products. 6.       I can save it with different ways, Ether by click CTRL+S on keyboard or go to File tab and save. It will ask for a name to save file; we can put any name which is easy for you. Suppose I give customer records as file name. After than just click on Save button. 7.       Your file has been saved. If you want to change or customize your data. It is very simple to write on existing workbook and Go to FILE Tab> SAVE AS. Your data will be modified. 8.       Last step for closing file. There are many options given on windows operating system to close file. 1.       First option is just click on cross X right upper side of workbook. 2.       Second options is GO to FILE tab> Close 3.       Third option is after click on keyboard ALT+F4 button. File will be closed. Read Best Story Books