Pivot table can help us manage large data and information. In this article, we will introduce how to group or ungroup data in a pivot table. There are many useful features in pivot table. And those features make the pivot table a very useful tool...
Read more »The sequence numbers can always be seen in an Excel worksheet. In this article, we will show you how to auto update the sequence numbers when you insert or delete rows in a range. You will certainly have used the sequence numbers in a worksheet....
Read more »Using defined name in Excel can save you a lot of time. Here we will introduce two methods to automatically update the reference range of a defined name in the worksheet. A defined name has a wide range of use. You can even use a certain name in...
Read more »