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


how to create pivot table in excel 2003excel combo boxexcel unhide allsample excel exercises beginnersvlookup in ms excel 2007combo box vbavba excel for eachexcel basic macroshow to copy cells in excelexcel advanced vbaexcel vba create workbookcapacity plan template excelexcel 2007 macro examplesexcel macro caseexcel vba database queryexample of vlookup functioncombobox in excel 2007copy paste macro excelms access vba insert into tablevba save excel fileexcel with vba programmingpivot table in excel 2007 with example pptvba array uboundwhere do i find a tick in excelexcel macro open workbookconcatenate function in excelvba syntax errorexcel 2010 delete duplicatesms excel basic tutorialspider chart powerpointturn on autofilter excel 2010useful vbac language viva questions with answers pdfms excel macros examplespowerpivot tutorial 2010offset vba excelrunning excel macrosexcel hlookup functionlistbox excelwhere to find pivot table in excelvba colorindexexcel vba unselectvba break statementexcel vba protect sheetdays360 excel formulahow to unhide worksheets in excelxy bar chart excelmacro to delete duplicate rowscombobox in excel 2007what is the default column width in excelhow to remove duplicate numbers in exceledit excel macrosexcel userform data validationhow to copy an excel workbookvba excel select rangevba declare arrayexcel chart gridlinessql queries in excelmatch formula in excel with exampleplot chart in excelinteger vbaexcel countif functionddl sql commandspowerpoint macro exampleshow to make pivot tables in excel 2010excel if cell contains text thenvba excel colorindexhow to create a userform in excel 2010return array in vbapower pivot tutorialsvba excel hyperlink