How to Make Daily Activity Report in Excel (5 Easy Examples)

The article will show you some examples of how to make a daily activity report in Excel. Showing the work progress of an organization is very important for the improvement of a company and it’s also useful to evaluate your employees. In this article, I’ll show you some different types of daily activity reports for different purposes.

We will see different kinds of dataset in the following description and I’m showing the first example in the next figure.

How to Make Daily Activity Report in Excel (5 Easy Examples)

1. Making a Daily Activity Report in Excel to Understand Work Progress

The template in this section for the daily activity report is for monitoring the activities of the employees and the status of a project. We have the Serial number for the tasks, Work Title and the Status of it and also we have an overview of the percentage of work done in this report. Let’s show you how to create the template.

Steps:

• First, type the following formula in cell B6.

We are using this formula so that we can put a serial number for each work automatically. The IF Function will leave the serial number entry blank if there is no entry in the Work Title column. As we want a serial number, we set the [value_if_false] as ROW()-5, because our data starts from the 6th row, and the ROW Function delivers our serial number.

• Use the Fill Handle to AutoFill the lower cells.

• Now, put an entry in the first cell of the Work Title You will see 1 in cell B6.

• After that, enter all the other work entries in that column and you will see all the Work Titles are marked with a serial.

• To enter the Work Status whether it is done or ongoing, we will create a drop down list for it. For that reason, select the cell G6 and go to Data >> Data Validation

• In the Data Validation dialog box, select List in the Allow: section and type Done, Ongoing in the Source:
• Click OK.

• You will see a drop down icon in cell G6. Use the Fill Handle to AutoFill the lower cells. This will create a drop down list in each cell of column G.

• You can see the options Done and Ongoing if you click on the drop down icon.

• Now put the entries as you wish.

• To see the percentage of work done, type the following formula in any of the cells.

The COUNTIF Function will count the number of times “Done” present in the Work Status column. The COUNTA Function will count the number of cells through the range G6:G13. After dividing, we will get the fractional value of the ratio between work done and total work. To see this value in percentage, go to the Number ribbon and select Percentage.

• Hit ENTER and you will see the percentage of work done in that cell.

• Select Insert >> 2D Bar Chart.

• A Chart will appear.

• Right-click on the blue bar and click on Select Data.

• Click on Add in the Legend Entries

• In the Edit Series dialog box, set Series values as 1 and click OK.

• Move up Series2 by clicking on the marked icon in the following figure.

• And then click OK.

• Uncheck all the Chart Elements.

• Again, right-click on the bar and select Format Data Series…

• Set Series Overlap and Gap Width to 100% and 0%

• After that, resize the bar and drag it to a suitable position.
• Then right-click on the blue part of the bar and select Fill >> Green. You can choose any other color according to your wish.

• Similarly, set a color of your wish for the left part of the bar. The green part of the bar represents the fraction of work done.

• Now, go to Insert >> Text >> Text Box

• Put the Text Box in a suitable position and select it. Then type the following formula in the formula bar.

This formula will simply provide the value of the percentage of work done in the Text Box. We stored the formula of percentage in cell G1 previously, so we put the value of it in the Text Box.

• Hit ENTER and you will see the percentage in the Text Box.

• And then right-click on the Text Box and select Fill >> No Fill.

• Format and set the orientation of the bar according to your convenience.

• If you change any of the work statuses, you will see the percentage change in the bar.

As we changed the work status from ongoing to done, now there are 5 works done out of total 8 works, which means 62.5% of the work is done. See it in the following figure. As we take the rounded percentage, you will see 63% in the bar as a result.

Thus you can make a daily activity report for monitoring the work progress.

2. Using Excel Table to Make Daily Activity Report in Excel 

Here, I’ll show you how to use the template of Section 1 as a table. Let’s go through the process below.

Steps:

• Select the range B5:H13.
• Go to Insert >> Table

• A dialog box will show up. Check My table has headers and click OK.

• You will see the template converted to a table.

• The advantage is, that if you insert a new entry, it will automatically create the serial number and drop-down list for work status.

• Choose Ongoing in the drop down list and see the percentage change in the bar.

Thus you can make a convenient daily activity report template.

Read More: How to Make Daily Production Report in Excel

3. Making a Daily Activity Report in Excel for Sales Management

In this section, we created a table for the daily report on sales and quantity sold by an organization. Let’s see the description below.

Steps:

• The company sells electronic devices. So we entered some electronic devices, their prices, and sold quantity.

• We also used a formula to calculate the sales amount of individual products.

• To find out the total sales and total items sold, make some modifications and type the following formula in cell E2.

• Press the ENTER button and you will see daily total sales.

• Similarly, type the following formula in cell F2 and press ENTER. You will see the total quantity sold in F2.

Thus you can make a daily report on sales.

Read More: How to Make Sales Report in Excel

4. Making a Daily Activity Report for Hospital Entries

If you work in a hospital, this template of the daily activity report will help you. Let’s go through the discussion.

Steps:

• Create a table like the following picture and add columns if you need to put other information.

• If you want to see the total patients admitted, type the following formula.

• Hit ENTER and you will see the number of the total patients.

• If you put a new entry, you will see the number of total patients automatically changes.

You can use this template for a daily activity report in a hospital.

5. Daily Activity Report for School

If you are a school teacher, you may need this daily activity report template to observe your students’ progression and activities. Let’s have a look at the description below.

Steps:

• Make an Excel chart like the following image.

• Make drop down lists in both the Attendance and Remarks and to see how to create a drop down list from Data Validation, please follow the process in Section 1.

We chose Present and Absent options for the Attendance column.

And then we also selected Good, Satisfactory and Bad for the Remarks column.

• Use the drop-down list to fill the cells according to the student’s activities and to see the percentage of present students, type the following formula.

• Press the ENTER button and you will see the percentage of present

Thus you can make a daily activity report for academic purposes.

Practice Section

Here, I’m giving you a template so that you can make another on your own using the examples of this article.

Download Practice Workbook

Conclusion

In a nutshell, my dedication to this article was to provide you with some examples of how to make a daily activity report in Excel. I hope the templates of this article will match your real-life problems, so you may benefit from it. Although there can be many other templates for daily activity reports, these are the basic reports that we need to use in our daily working life. If you have any questions, ideas, or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles.

Related Articles

• How to Create an Expense Report in Excel
• How to Create an Income and Expense Report in Excel
• How to Make Production Report in Excel
• How to Make Monthly Report in Excel
• How to Make a Monthly Expense Report in Excel

<< Go Back to Report in Excel | Learn Excel