Excel Tutorial

After inserting a new row in the excel table, how to automatically update the row number of the existing row which have to move down? This article will tell you how to implement it.

A pivot table is a form of table representation of the data source. The data in the data source table can be easily edited and modified, but the data in the pivot table cannot be edited. This article will introduce the fields and layout operations of the Pivot Table.

Pivot Table is the best tool for the comprehensive analysis of detailed data. It organically combines the advantages of classification and consolidation. It can easily and flexibly adjust the basis of classification and summary and display the characteristics of data in many different ways.

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 …

Excel Tips How To Easily Extract File Name In Folder Read More »

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 …

How To Import Filtered Excel Rows From One Excel File To Another Dynamically Read More »

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. Use a table can make your data more regular and manageable. You can sort data, filter data, etc. This article will show you how to create a table in excel cells and how to make it beautiful.

Excel auto-correct feature is very helpful when you input wrong text in an excel cell. It can help you to correct some typo mistakes. But for some time this feature is not needed so we should disable it. For example, if you want to type text ehr in an excel cell, then excel correct it …

How To Stop AutoCorrect In Excel Read More »

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.