This action tracker template can be used as both action tracker and task tracker. Log and track actions and tasks easily with automatic status and priorities – give it a go! Main Features: Push button adding of new actions, automatically Read more…
The Risk Register Template Excel (Risk Management) is a great template to use if you want to implement a standardised risk management process into your Project Management Office (PMO). Most importantly the template allows for both negative and positive risks, Read more…
This free to download Excel Resource Management template allows you to list the resources allocated to your project and then assign these resource to tasks with set work. The template will automatically create your resource utilisation chart and histogram, allowing Read more…
In this video I explain why you would use a dollar sign ‘$’ when adding formulas to an Excel spreadsheet, covering Relative, Absolute and Mixed cell references. This is very handy to know as it can save you a lot Read more…
In this video I am demonstrating on of my action tracker templates available at https://lakesprojects.co.uk/. The template has lots of features that help you and your team to focus on quickly log actions and prioritising close out – the template Read more…
In this video I show you how I would typically go about designing a new Excel spreadsheet template. This a purely a step by step of my thought processes before I start the build. If you want to follow along Read more…
In this video I show you how to use an IF function using Excel’s built-in ‘Insert Function’ wizard. I also display the full formula so that you can learn to enter directly into the cell if you wish. In my Read more…
In this video I show you how to record macros in Excel using the ‘Record Macro’ utility on Excel’s ‘Developer’ tab – this includes showing you how to enable the ‘Developer’ tab, changing ‘Macro Settings’ and also viewing the visual Read more…
In this video I show you how I would typically go about building a new Excel spreadsheet template. I talk through the below Excel functionality – feel free to skip to any part of the video you’d find most helpful: Read more…
The Action Tracker Template Excel (with Charts) has been refined for use on a laptop screen. This template comes with the additional feature of automatic KPI’s / Performance Charts that can be used for your team to track on-time close Read more…
