Office Solutions

How to Group Your Received Emails by their Durations since Received in Outlook

By default, Outlook doesn’t support to group the received emails by their durations in month since received, such as 1 month, 2 months and 3 months, etc. This article will introduce how to add the related field and then re-group the received emails via Outlook VBA. As you can see, Outlook will automatically group and sort the received emails by the received date, including “Today”, “Yesterday”, “Two Weeks Ago”, “Last Month” and “Older” and so on. Thus, some users may...

Read more »

How to Create a Wonderful Waffle Chart in Your Excel Worksheet

Except for the default chart types in Excel, you can also create a wonderful waffle chart in your worksheet. In this article, we will show you how to create such a chart. The waffle chart has very good visual effect in Excel. With its special shape, you can demonstrate your data and information in a more intuitive way. However, there is no direct way to insert a waffle chart into your worksheet. You can continue reading this article and learn how to make it. Arrange in the Worksheet In...

Read more »

How to Make a Lucky Draw in an Excel Worksheet via VBA

In Excel worksheet, you can also make a lucky draw. In this writing piece, we are going to show you how to finish this task in Excel. A Lucky draw is very common in our daily life. For example, you need to give bonuses to employees in the end of a year. You would like to select some lucky employees randomly. Therefore, you can use the Excel file to make a lucky draw. Make a Lucky Draw In this part, we will introduce the methods in detail. Open the Excel file with all the information...

Read more »