3 Efficient Ways to Import External Data into Excel

Excel is very powerful in dealing with information. And today we will launch 3 methods to import external data into Excel. In your daily life, you will use some files to store some daily affairs. For example, you will use the text document to store shopping list. But later you need to import external data into Excel to arrange the information. However, you may find that the format of the pasted information in the Excel like this: Therefore, here we have three methods to import external...

Read more »

How to Use the Replace Feature to Change Your Cell Formats in Batch

There are many features in Excel. And some of them do favor to our work with simple steps. And we find such a substitute function contained in the Replace feature. Usually, you will use the Replace feature to find and replace some certain elements. And here is a sample of using the Replace feature to change cell formats. And in the image below, you can see many scores of students. And you need to select all “A” of those scores and change the format to highlight the good scores. But...

Read more »