How to Quickly Subtotal Values in Excel

Excel is very powerful in calculating values in certain conditions. And the function of subtotal is also very useful. Now let’s see how this feature works. You will certainly need to calculate the total number of some values. And most of the time, the numbers need to meet with certain requirement. For example, you need to calculate a sales representative’s sales quantity, or you need to calculate the sales volume of a certain product. If the worksheet is in a mess, you will certainly...

Read more »

How to Solve Data Error (Cyclic Redundancy Check) in Outlook

Errors pertaining to Data Error (Cyclic Redundancy Check) may occur to Outlook when it downloads new emails to local computer. Virtually it involves corrupted Outlook file. In this article, we will explore how to solve it. As usual, it must be Outlook corruption that leads to this kind of errors. But before repairing the PST file, you have to check whether the disk error is the root of file corruption. A free utility exists in Windows, which can be run in Command Prompt. You can follow the...

Read more »

2 Methods to Change the Color of Outlook Notes

When using Outlook Notes, you may notice that the default color is yellow. This article will introduce how to change the default color of Notes. I prefer to make my Outlook more beautiful via multiple colors, no matter in mailbox, calendars, tasks and notes, etc. Thanks to color categories, I can apply the other 26 colors to Outlook Notes without restriction of Outlook Options. Method 1: Change the Default Color of Notes in Outlook Options For a start, go to “File” menu and select...

Read more »