File Recovery

How to Count the Work Days by NETWORKDAYS Function in Excel

Nowadays, Excel is people’s first choice of office software. And Excel is used to finish many different and difficult tasks. And the NETWORKDAYS function can also play a significant role in calculating the work days. Suppose you are a HR in a company, you need to calculate the work days of every staff. According to the work days you can check their work attendance. And if you note down their attendance day by day, it will be time consuming. So here you can try the NETWORKDAYS function to...

Read more »

How to Count All Items Meeting a Condition via COUNTIF Function

Excel can be regarded as a very powerful office tool ever since it was created. And many functions in Excel can give us a lot of help. And today we will launch the usage of COUNTIF function. In a worksheet, sometimes you will need to calculate the total number of certain elements in a certain condition. But if you find those cells one by one, you will certainly waste a lot of time. And here is an example of finding how many “A” John has got in his tests via COUNTIF function. And the...

Read more »

How to Get Different Views for Same Data Sets via Pivot Table

Excel files provides you with many useful functions. And in this article, we will talk about how to get different views for same data sets via Pivot Table. Pivot Table can be very helpful in viewing data and information. When the file is very large and there is a lot of information, using Pivot Table can improve your efficiency. And now we will introduce the Pivot Table using the example of student scores. Creating a Pivot Table Select the target area. In the “Insert” ribbon,...

Read more »