Excel Tutorial

If you want to extract the file names of the files contained in a certain folder, put them in the worksheet for other uses, it is very troublesome to input them one by one or copy and paste them. In fact, we can use the two excel functions FILE and INDEX together to extract the file name in […]

This article will tell you how to import filtered excel rows from one excel file into a new excel workbook. And when the source excel rows data is changed, the data in new excel workbook will also be changed dynamically by refresh the connection. There are two method to achieve this, i will introduce them

This article will show you how to import data into excel workbook from local files, the local file format can be excel, csv, text, xml, html and pdf. It also show you how to export an excel workbook to those format files.

In this article, I will show you how to retrieve data from a web page and import the data into an excel worksheet. With this function, you can prepare excel data very efficiently.

The table is very useful in excel worksheets. Using a table can make your data more regular and manageable. You can sort data, filter data, etc. This article will show you how to make a table in excel cells and how to make it beautiful.

When you copy or input a url or an email address text into the excel cell, it will add a hyperlink automatically. Sometimes this is useful, but for most times this is not useful at all. This article will tell you how to remove the hyperlink and how to disable auto hyperlinking in excel settings.

Microsoft Excel provides a filter function for you to find out required rows by the customized condition in a very long excel worksheet. The filter feature includes a basic filter that provides simple condition filtering and an advanced filter that provides complex condition filtering. This article will show you both the 2 filter features with

Excel provides an auto recover unsaved workbook feature for you to recover the unsaved excel workbook. This feature is very useful. It can save you a lot of time when you exit Excel without saving the workbook changes. This article will tell you how to use it.

Sometimes you may want to verify user input data type or value in excel cell. And excel just provide such a feature for you to customize the cell data validation process. You can define which data type and what data values are valid for one or multiple excel cells. If the data is not valid,

In this article, I will show you how to make an excel cell expand it’s width and height to fit the input text width or height automatically.