Activity Log Template

Purpose of Activity Log:

Activity log helps to track daily activities of a project or all activities which are executing by a person. Activity log template helps to see the status of the tasks or projects.

When we use Activity Log:

While executing any project it is good practice to maintain an activity log to keep eye on all the activities which are executing by a person or team.

What are the advantages of Activity Log:

There are many advantages using an activity log, we can know the all the activities and its status and how they are progressing. It helps an individual to communicate the status of all tasks to reporting manager or client or stack holders. It helps an individual to see whether is able to complete all tasks based on priority.

What are the Features of Activity Log:

We have variety of options to capture the data, summarize and visualize the reports.

Activity Entry or Data Entry:

User have to capture the data for the following fields:Activity Name, Project Name, Priority, Assigned To, Start Date, End Date and Status. The reports will be automatically populated.

Summary:

Overall summary: We can see the overall summary of all tasks. i.e, number of open tasks, number of tasks in progress, number of tasks closed, total tasks on hold and tasks cancelled. We can also filter the charts by Project Name and person to see the overall summary of a project or an individual person.

Total Activities: This chart will give you overall activities and plot by each person which shows number of activities assigned to a person.

Activities by Project/Person: This chart will show you all the activities by status and we can also filter this chart by project or by person.

Activity Priority by Project/Person:This chart will show you all the activities by priority and we can also filter this chart by project or by person.

Activity Status By Date: we can see number of activities by date. we can also drill down this chart by project name,by person name, based on priority and based on project status.

Activity Status By Day: we can see number of activities by Day. we can also drill down this chart by project name,by person name, based on priority and based on project status.

Activity Status By Week: we can see number of activities by Week. we can also drill down this chart by project name,by person name, based on priority and based on project status.

Activity Status By Month: we can see number of activities by Month. we can also drill down this chart by project name,by person name, based on priority and based on project status.

Activity Status By Year: we can see number of activities by Year. we can also drill down this chart by project name,by person name, based on priority and based on project status.

Refresh All Changes:

Once you update or modify the data or add new tasks you can click on the refresh all charts command button to see the updated charts or visualizations.

Remarks:

You can use remarks fields to capture any additional remarks on each action item. You can select the remarks checkbox to show or unselect to hide it.

Template Settings:

You can use the settings area to change the default areas of each section.

Need more features; Please check our Premium Project Management Templates

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


Related pages


vba query tablemacro to unprotect workbookhow to fill color in excel cell using formulamacro delete blank rowslearn macro in excelvba outlook.applicationapplication screenupdating falseunlocking excel sheetexcel 2013 merge cellsvba select casevba selection.pastespecialrtrim vbaexcel autofit column widthsendmail command examplesql basic commandswhat are dml commandsswot template excelhow do you create a macro in excel 2010ms word vba tutorialexcel macro to open fileexcel macro open worksheetpivot excel tutorialreplace function in excel 2007testing template excelifs function in excelexcel pivot table add inhow to lock an excel file 2007building dashboards in excelinsert multiple rows excel 2010how do i add the developer tab to the ribbonto find duplicates in excelrecordset vba excelexcel stock graphhow to use vlookup excel 2010excel 3d charthow to unhide top rows in excelshow developer tab excel 2007excel function sumifvba case isweekly report format excelcapacity planning template xlsinterview questions on testing for freshers with answersexcel merge rowsexcel formula colorrecordset excel vbaunique rows in excelsas do until loophide columns in excelvba autofilter rangetrim in vbameaning of hlookup in excelvlookup functionhow to remove header in exceldbms interview questions and answers for freshers pdfvlookup for dummies excel 2010how to insert a new row in excelexcel unlock passwordexcel cell contains textmicrosoft excel match functionexcel macro hide rowshow to add password in excel 2007activesheet shapesexcel deleting duplicatesbuilding macros in excelcomplex macros in excelexcel hide columnsproject timeline powerpoint template freeduplicate cell excelexcel stacked bar chart exampleradar chart powerpointexcel vba advanced tutorialhow to use sumif function in excelhow to merge and center on excelunlock excelhow to expand cells in exceldefine vlookup in excel