Excel Tutorial

How To Create A Pivot Table In Excel

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.

How To Import Filtered Excel Rows From One Excel File To Another Dynamically

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 »

How To Make A Table In Excel

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.