Office Solutions

3 Methods to Set Data to Percentage Format in Your Worksheet

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 »

How to Present Your Data in an Excel Bubble Chart

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 »

How to Disable the Warning When Clicking Outlook Shortcuts

You can create a variety of custom hyperlinks to files on your computer in Outlook shortcuts navigation pane. But when you click on the shortcuts, you will receive a hyperlink warning. This article will introduce a method to disable it. In reality, not only in Outlook but also in other Office programs, this warning can pop up when you execute custom hyperlinks which are unknown to Office. Office 2007 and 2010 come endowed with the general security feature. The warning usually looks like the...

Read more »