Excel Solutions

How to Import Data from Other Excel Worksheets

The worksheets in Excel will have deep relation with each other. And now we will demonstrate how to import data from other worksheets. The multiple worksheets in Excel will work together to help you solve your problem. And you can also built connection through importing data from other sheets. In this image below, you can see that this is the worksheet of sales volume of different sales representative. Now you need to import the sales volume of “DataNumen Excel Repair” to another...

Read more »

3 Tips about How the Selected Cell will Change on Different Shortcut Keys in Excel

Selection in Excel is the most basic action we will make. And in this article, we will talk about the selected cell will change on different shortcut keys. There are many different methods to select certain cells. One of the methods is using the buttons on the keyboard. For instance, you will use the arrow keys to change the position. And in this article, we will discuss about the “Enter” and “Tab” buttons in detail. Tip 1: Change the Direction of Enter button You will find that...

Read more »

How to Compare Values Side by Side via Bi-directional Bar Charts in Excel

You will certainly use the bar chart to analyze important values. And now we will demonstrate the creation of a bi-direction chart in Excel. There are many methods about charts in Excel. Now if you want to compare the values in cells, you can also realize it in a bi-direction chart. In the image below, you can see that there are values about two different sales representatives. Now you can insert such a chart and compare their sales volume. Insert a Bi-direction Chart Here are the...

Read more »