Excel Solutions

How to Use SUBSTITUTE & REPLACE Functions to Change Patterns in Your Cells Automatically

Due to the special functions in Excel, more and more people rely on it to finish their work. Hence today, we will demonstrate on using SUBSTITUTE & REPLACE function to change patterns of contents in cells. SUBSTITUTE and REPLACE function are very practical in dealing with statistics. And the feature of this function can perform very well in certain condition. For instance, in this image below, there are many student numbers. Those numbers are for students of the last year. This year,...

Read more »

How to Add a Diagonal Line in Your Excel Cell

Most of the time, you will use Excel to arrange and store data. Therefore, you will be very familiar with some features of Excel cells. And some capabilities in Excel have many other usages. Hence today, we will launch the application of how to add diagonal line into the first cell. In an Excel worksheet, you will certainly make a table. For each of those tables, there will be a cell that is the header of the whole table. And usually this is the upper left cell. In this cell, you need to...

Read more »

How to Make a Line Chart Synchronize with Your Table Automatically

Excel is very powerful in handling statistics. It offers different features that are able to satisfy the needs of business houses. Thus it is widespread all over the world. And in today’s article, we will introduce how to enable line chart synchronize automatically with the update of data. Line chart is a very common but useful tool in Excel. And with the lines in the chart, it can help you analyze the tendency in certain area. For instance, through the sales volume line chart, you can...

Read more »