Percentage is a very common data form in Excel. To make things easier, Excel has the feature of setting data to the percentage format.
There are 3 different methods to change the format. But you may also need to pay attention to some of the details. In this image below, we need to input the growth rates of sales volume manually.
There are a lot of data that we need to input. Thus, if Excel can change the form into percentage format automatically, the task can be much easier.
Method 1:...
Read more »
You cannot create a column chart or line chart with three data series in an Excel worksheet. Thus, the bubble chart can be your first choice.
The major difference of bubble chart is that the bubble itself also represents a set of data. Therefore, in such a chart, it actually contains three data series. And the following will introduce how to create such a chart.
Create a Bubble Chart
In this worksheet, there are three data series about the sales volume. And now you can create a bubble...
Read more »
As you know, Outlook doesn’t support export filters. So if you have multiple items in Outlook calendar, how can you extract and print out all recurrences of an appointment? This article will teach you to achieve it by 2 simple steps.
I have created lots of items in Outlook Calendar, including irregular meetings, occasional appointments as well as one recurring appointment scheduled on the 2nd Wednesday of every month. Now I hope to extract and print the appointment series only, such that I...
Read more »
