Office Solutions

3 Methods to Sum the Values of the Same Cells in Multiple Worksheets (Part II)

In our previous article, we have introduced the 2 methods of 3-D reference. And here we will discuss the third method to sum values. The last way is using the pivot table in Excel. And you need some extra steps to create such a pivot table that can also sum values. Method 3: Add the Button Click the small arrow in the quick access toolbar. Then click “More Commands” in the ribbon. In the “Choose commands from”, select the “All Commands”. Then drag the scrollbar...

Read more »

3 Methods to Sum the Values of the Same Cells in Multiple Worksheets (Part I)

Excel has provided many features for us to calculate data. Here we will introduce 3 useful methods to sum values of same cells in multiple worksheets. Sometimes in an Excel file, you will need to calculate the total value of certain cells. However, those cells are in several different worksheets. In this image, you can find that there are three worksheets about the sales volume of different sales representative. And now you need to sum up the values of each person in the sheet of...

Read more »

2 Means to Quickly Delete All Outlook Emails Older than a Specific Period

Undoubtedly too many emails stored in Outlook will make Outlook work slowly. Thus it is suggested to delete the old emails. This article will introduce 2 methods to quickly delete all emails older than a specific period. In order to improve outlook performance and prevent Outlook file oversized, I will delete the old items periodically, such as old emails, tasks, appointments. The followings are the fastest and handiest 2 approaches. Method 1: Delete by Means of Outlook Auto-Archive To...

Read more »