Action Tracker Template Excel (Task Tracker)

£4.99

Customisable – change fields… status terminology… set an administrator… access passwords for VB… You can do all of this plus more from the ‘Admin Tab’. Most importantly,  there is now a setting that allows you to enable or disable password protection on all worksheets making customisation so much easier.  The ‘Admin Tab’ can be accessed by clicking the ‘OPEN ADMIN’ button top right of the ‘List’ sheet.

PDF Records & Outlook Emailing – communicating your teams activity is made very easy, just click and a PDF of the tracker is recorded and attached to an Outlook email ready to send.

Automatic Status & KANBAN Filters – with a little information the tracker works out a status.  Your team can then prioritise and focus their effort using the clickable KANBAN filters.

See this action tracker template being used in our video demo below. Shown is the black header layout, you will also receive the white header layout.

Description

Video Demo:

Key Features of this action tracker template :

  • New functionality added to make customisation even easier by allowing worksheet passwords to be enabled or disabled via the Admin Tab (option located bottom left of the Admin sheet).  The old template version would require you to unprotect and enter the password every time you made a customisation.
  • Comes with worksheet and VBA passwords for you to unprotect.
  • Status text can be edited from the Admin Tab.
  • New ‘On Hold’ field, status and Kanban chart.
  • Two New drop down fields that can be edited, enabled and disabled on the Admin Tab.
  • A New additional free text field that can be edited, enabled and disabled on the Admin Tab.
  • New setting on Admin Tab to change worksheet zoom % across all sheets.
  • New PDF & Email (Outlook) functionality – setup in the Admin Tab with a built-in Windows browser create a save directory and then activated each time from a button on the Tracker.  This functionality can be used to PDF your tracker, save as a record and issue out to your team as a regular update.
  • Tested using Windows 10 and Microsoft Excel 2016.
  • Programmed in Microsoft Excel and Visual Basic for Applications.
  • Integrates with Microsoft Outlook.

Please note these terms and conditions:

  • This is a macro enabled workbook (.xlsm) and will require content and macros to be enabled on first opening. This is done easily by clicking the prompts at the top of Excel. 
  • This template has only been tested using Windows 10 and Microsoft Excel 2016.
  • This is an Excel file template and must be opened with your own copy of the Microsoft Excel application. 
  • Lakes Projects are in no way responsible for any loss of data or IT issues that result from using this template. 
  • As this is a downloadable product you waiver the 14 day right to cancel.
  • This is an instant download.

By continuing with this purchase you accept these terms and conditions.

Reviews

There are no reviews yet.

Be the first to review “Action Tracker Template Excel (Task Tracker)”

Your email address will not be published. Required fields are marked *