Solutions

3 Ways to Disable Auto-Archive of Recurring Calendar Items

When Outlook Auto-Archive is enabled, all items will be removed at a specific date, including recurring appointments and meetings. In order to avoid disappearance of recurring calendar items, you need to disable its auto-archive. Outlook Auto-Archive does make it convenient for us to keep our mailbox clean, but at the same time, it will bring out some troubles as well. For instance, it will clear up the recurring calendar items automatically. In this case, we will miss our important...

Read more »

How to Use the SUMIF Function to Perform a Conditional Sum

The function in Excel enables it to handle complex data. Thus many people choose to apply Excel as their office software. And of course there are many different functions for different purpose. Thus, today we choose to analyze the feature of SUMIF function. SUMIF function can calculate the sum of certain numbers in your specified criteria. In the image below, you need to calculate the total sales volume. And at the same time, you want to add the numbers that are higher than 500. But...

Read more »

How to Find Out All Cells with Same Values in a Row

With the amazing attributes in Excel, many people and companies select it as their first choice. Some of the Excel tips are still unknown to many users. Therefore, we will introduce the function to find cells cells with same values in a row in today’s article. Excel has a function of filter. What’s more, it can select certain rows in one column with certain condition. However, sometimes you will need to select certain elements in a row. But the filter in Excel cannot achieve this...

Read more »