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! Alternatively, check out my Premium Action Tracker which comes with all passwords to unlock the template as well as 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, aka threats and opportunities. Template can produce a pdf report Read more…
The Action Tracker Template Excel (with Charts) has been refined from the Action Tracker Template Excel (Task Tracker) 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 out of 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 you to quickly and easily identify over utilised resources. This 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 of time when you’re creating spreadsheets – Please skip to Read more…
In this video I am demonstrating my laptop friendly action tracker template 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 handles the rest! The template is an Excel Macro-Enabled Workbook 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 with the build of this example spreadsheet then please check 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 examples I use an IF function with an AND statement 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 basic code behind your macro. – Please skip to any 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: 0:50 – setting out the main table 2:00 – automatically Read more…
