Excel File Recovery

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 »

How to Use the SUMIF Function to Perform a Conditional Sum

The function in Excel enables it to handle complex data. Thus many people choose to apply Excel as their office software. And of course there are many different functions for different purpose. Thus, today we choose to analyze the feature of SUMIF function. SUMIF function can calculate the sum of certain numbers in your specified criteria. In the image below, you need to calculate the total sales volume. And at the same time, you want to add the numbers that are higher than 500. But...

Read more »