Office File Recovery

How to Group or Ungroup Data in a Pivot Table in Your Excel Worksheet

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 for data analysis. The image below shows the pivot table in a worksheet. The first column is the date of the range. By default, they will all be listed in the column A. But if you need to know the sales volume in a certain period, such as in a...

Read more »

2 Useful Methods to Convert Numbers to Dates in Your Excel Worksheet

The numbers in cells will not turn into dates automatically in a certain condition. Therefore, in this article, we will provide two methods to help you solve this problem. You will certainly need to input dates into excel worksheet. And there are many different types of date format. On the other hand, you will also copy some dates into Excel cells. However, if there is no symbol for dates, i.e. the hyphen symbol (-) or the slash symbol (/), those numbers will not change into dates...

Read more »

How to Connect Different Files by Inserting Objects into Your Excel Worksheet

Most of the work will relate to many different types of files. In this article, we will show you how to insert objects into your Excel worksheet to connect files. When you are working on a task, you will certainly use many different types of files. For example, you will use Excel to analyze data and information. And you will use the PowerPoint to demonstrate some research results. Besides, there are many other types of files. Actually you can connect Excel files with other types of files by...

Read more »