3 Effective Methods to Calculate Values Based on Cell Colors in Your Excel Worksheet

Different cell colors can help you identify the values in cells. When you need to calculate values based on cell colors, you can use the 3 methods in this article. In an Excel worksheet, you will certainly mark different colors for different cells. Most of the time, the same color will be in different cells in a range. The image below shows a worksheet with different cell colors. When you need to calculate the values by the cell color, you will find that it will be hard to select those...

Read more »

2 Ways to Convert Automatic Numbering to Normal Texts in Your Word Document

In this article, we intend to show you 2 ways to convert automatic numbering to normal texts in your Word document. Generally, we benefit a lot from the AutoNumber feature in Word. It saves us much trouble in listing items and organizing paragraphs. However, here is the twist. A document normally requires revisions more than once. And it’s in the process of adding and deleting texts that the numbers get affected. Therefore, we need to convert these “dynamic” numbers to plain texts. So...

Read more »

4 Effective Tips for Storing Files in Your Outlook Mailbox

Do you know that Outlook can serve as a file storage location? You can easily drag and drop files to the mail folder. They will be stored in Outlook mailbox. If you intend to use this feature, you should follow the 4 tips mentioned in this article. To move and store files in your Outlook mailbox, you can straightly drag and drop the files to one mail folder, like the following screenshot: If you are using an Exchange account or IMAP account in Outlook, storing files in Outlook mailbox...

Read more »