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 handles the rest! The template is an Excel Macro-Enabled Workbook 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 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…
