Excel File Recovery

How to Use Different Average Functions in Excel

In using Excel functions, you will certainly need to use the different average functions. In this article, we will explore the usages of all the average functions. There are 4 variants of average functions: AVERAGE, AVERAGEA, AVERAGEIF and AVERAGEIFS. In the following part, we will talk about them in details. 1.    AVERAGE AVERAGE function is used to calculate the average of a range. This function can also calculate the average of the arguments in formulas. Now we will use the example...

Read more »

How to Present Your Data in a Half Pie Chart in Excel

Sometimes you need to present data in a pie chart. And in this article, we will show you how to present your data in a half pie chart. Suppose now you need to present the sales volume in a half pie chart. There are 12 months with the corresponding sales volume. And here you need to create two separate half pie charts for every half year. Below we will show you the steps to create the two half pie charts. Arrange the Data Before you create a half pie chart, you need to arrange the...

Read more »

How to Quickly Insert a Blank Row/Column into Every Two Adjacent Rows/Columns in Your Excel

In this article, we will introduce a method to quickly insert rows or columns into every two adjacent rows/columns quickly. In the image below, now you are going to input rows into to every two adjacent rows in this range. Instead of add rows one by one, you may also follow the methods below. Insert Rows Input the number “1” into cell D2 in this range. Secondly, input number “2” into cell D3. After that, select the two cells. And then double click the fill handle...

Read more »