How to Represent Data with a Pie of Pie Chart in Your Excel Worksheet

Chart in Excel can reflect data and information more intuitive. In this article, we will introduce you the pie of pie chart in Excel. Pie chart can well present the relationship of each data set. But do you know that you can also create a pie of pie chart in your worksheet? With such a chart, not only can you display certain data and information, but also you can see the subset of a certain classification. The image below shows the sales volume of a product. Except for the sales volume...

Read more »

How to Quickly Create a Contact Group from the Recipient List of an Email with Outlook VBA

At times, when you send or receive an email with many recipients, you may want to create a contact group for these recipients. This article will introduce a quick way to accomplish it with Outlook VBA. In our previous article “How to Create a Contact Group from Recipient List”, we have learned a common method to create the contact group for email recipients. That is to firstly select and copy the recipients from the emails, and then create a contact group manually and paste the...

Read more »

How to Auto Create a New Appointment When an Email Is Flagged in Outlook

Some people desire to automatically or quickly create a new Outlook appointment when they flag an email. This article will introduce an approach to realize it with Outlook VBA. Sometimes, I may receive an email which mentions an appointment or meeting. But it is just an email instead of a common meeting item in Outlook. In this case, I have to create a new appointment in my Outlook calendar manually. That’s a bit troublesome. So I wish that Outlook can automatically create a new...

Read more »