How to Make an Action Log with Excel - create an action list for your projects - Simple Tutorial

#projectmanagement

I'm going to show you how to make an action log with Excel. Microsoft Excel is an excellent tool for creating lists, and lots of people are familiar with it. So I'm going to give a demonstration on how to create a really useful action log for your projects.

Timestamps:
0:00 - Intro
0:28 - Building an action log
1:00 - Adding column titles for the action log
2:02 - Adding dropdown lists in Excel for your action log
3:39 - Changing the date format in Excel for your action log
4:49 - Making the Excel page with your action log more easily printable.
5:23 - Adding Filters in Excel to make your action log easier to find actions in.
6:12 - Reminder to make the action log accessible to your team to improve collaboration.

#actionlog #productivity

[morufsurakat]

Great. Thanks, Stuart. I found this video helpful ❤

[maxwellheaton]

Great video btw! How would you be able to add in Milestones?

[jens_cymru]

This is AMAZING!!! You just made my life so much easier. Thank you.

[davidc]

how do I color them, so I can make complete green, late as red, etc, ( coloring the cell not the letters).

[sharon_singh]

Great work but would be better if you spoke and showed each step slowly

[kernel_cataclysm]

Just 'why'? 1) there are so many Open Source cost free project management tools out there that do this 100 times easier. 2) Why don't you use the table funtionality of Excel but do all the table layout manually? 3) Why don't you use pivot function for evaluaion but the filter function of the data table itself?

[memolani]

Next step: How to add to-do list from the Action Item.