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


Download Practice Workbook


5 Examples to Make a Daily Activity Report in Excel

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.
=IF(C6="","",ROW()-5)

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.

how to make daily activity report in excel

  • 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

how to make daily activity report in excel

  • 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.

how to make daily activity report in excel

  • 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.

how to make daily activity report in excel

  • Now put the entries as you wish.

  • To see the percentage of work done, type the following formula in any of the cells.
=COUNTIF(G6:G13,"Done")/COUNTA(G6:G13)

how to make daily activity report in excel

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.

how to make daily activity report in excel

  • A Chart will appear.

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

how to make daily activity report in excel

  • Click on Add in the Legend Entries

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

how to make daily activity report in excel

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

  • And then click OK.

how to make daily activity report in excel

  • Uncheck all the Chart Elements.

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

how to make daily activity report in excel

  • 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.

how to make daily activity report in excel

  • 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

how to make daily activity report in excel

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

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.

how to make daily activity report in excel

  • 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.

how to make daily activity report in excel

  • 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.

how to make daily activity report in excel

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

Read More: How to Automate Excel Reports Using Macros (3 Easy Ways)


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.

how to make daily activity report in excel

  • 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.

how to make daily activity report in excel

  • 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 Create a Summary Report in Excel (2 Easy Methods)


Similar Readings


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 and their prices and sold quantity.

how to make daily activity report in excel

  • We also used a formula to calculate the sales amount of individual products.
=D5*E5

  • To find out the total sales and total items sold, make some modifications and type the following formula in cell E2.
=SUM(F5:F12)

how to make daily activity report in excel

  • 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.

how to make daily activity report in excel

Thus you can make a daily report on sales.

Read More: How to Make Sales Report in Excel (with Easy Steps)


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.
=SUM(D5:D11)

how to make daily activity report in excel

  • 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.

how to make daily activity report in excel

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

Read More: How to Generate Reports from Excel Data (2 Easy Methods)


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.

how to make daily activity report in excel

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 students’ activities and to see the percentage of present students, type the following formula.
=COUNTIF(D5:D11, "Present")/COUNTA(D5:D11)

how to make daily activity report in excel

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

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

Read More: How to Make Report Card in Excel (Download Free Template)


Practice Section

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

how to make daily activity report in excel


Conclusion

In a nutshell, my dedication to this article was set to provide you with some examples of how to make daily activity report in excel. I hope the templates of this article will match with your real-life problems so you may be benefited 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 or ideas or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles.


Related Articles

Nahian

Nahian

Hello, Nahian here! I do enjoy my efforts to help you understand some little basics on Microsoft Excel I've completed my graduation in Electrical & Electronic Engineering from BUET and I want to be a successful engineer in my life through intellect and hard-work, and that is the goal of my career.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo