Excel Solutions

How to Show Tasks in an Intuitive Gantt Chart in Your Excel Worksheet

Excel is excellent in planning schedules. And in this article, we will show you how to show the schedules in a Gantt chart in your worksheet. You will probably have used Excel to make plans for your work. But only list those tasks in cells will be a little boring. Thus, now you can also demonstrate those tasks in a Gantt chart. The image below shows the test tasks of this month. In column B and column c, there are the start dates and the end dates. In order to show the information in...

Read more »

How to Quickly Use Your Mouse to Move Contents in Your Worksheet

In your worksheet, you will certainly move contents in one cell to another cell. And here we will talk about how to use the mouse to finish this task quickly. There exist many conditions that you need to move contents. For example, you input the contents into the wrong cell, or you need to move the contents for calculation and so on. In the image below, you can see the column header in cells. You were intended to input the date into column A. And then you need to change the worksheet and...

Read more »

2 Methods to Convert KB to MB and Vice Versa in Your Excel Worksheet

Excel haven’t provided direct feature to convert KB to MB and vice versa. Hence, here we will introduce two methods to solve this problem. In an Excel worksheet, you will input numbers with certain units. However, some units cannot participate in calculation, such as the byte unit. For example, you can see the numbers in the image below. There are several numbers with the unit “KB” in this column. On the other hand, it is impossible to directly use a formula to calculate the...

Read more »