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 »
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 »
If you frequently need to create appointments or meetings with the same subjects or bodies, why not create templates to avoid waste of time? This article will teach you 2 rapid means.
I often send meeting invitations on behalf of my superior in Outlook. On average, these meeting invitations have the same subject – “Weekly Meeting for Marketing Group 2”. Plus, the meetings are always held in the same location and have the same attendees. Therefore, I wish to create a meeting template in...
Read more »
