Project Plan in Google Sheets | Chris Gage | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

4 Lessons (38m)
    • 1. Introduction to Project Management in Google Sheets

      3:21
    • 2. Communications Plan

      8:40
    • 3. The Project Plan in Detail

      17:42
    • 4. Use of the Plan and Next Steps

      7:48
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

91

Students

--

Projects

About This Class

Your own Monthly Project Plan and Communication Plan within Google Sheets.

We will go over in detail the following:

  1. The use of a project plan
  2. How it works and how to edit it.
  3. The use of a communications plan.
  4. How to use the communications plan.
  5. When to project plan and potential uses.

Your takeaway and project

  • Your own project plan.
  • Your own communication plan.
  • A basic understanding of when you can use the tool.

Meet Your Teacher

Teacher Profile Image

Chris Gage

Analysis, Forecast and Business Planning

Teacher

Hello, I'm Chris. I like spreadsheets!

Come and follow my Learn with Chris Roadmap to see what I am working on.

I am an award-winning Director of Business Improvement with a distinct focus on Customer Service.  All in all, I like technology and ways to become more productive and efficient.

I have recently become a published author of Ebooks; as a person with Dyslexia, this has been a real achievement for me. Check them out here if you like my courses.

If you want to ask me any questions or get involved in my community, feel free to join my Learn with Chris Linkedin or Facebook page.

See full profile

Class Ratings

Expectations Met?
    Exceeded!
  • 0%
  • Yes
  • 0%
  • Somewhat
  • 0%
  • Not really
  • 0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Introduction to Project Management in Google Sheets: Hello and welcome to learn and with Chris in Skillshare. So what are we doing today? You guessed it. Google Sheets, specifically, Google Sheets, project planning. So let me just lay out in this RBS requirements first if you're extremely familiar with project planning, for example, our jail Lean Six Sigma. And near the tail is stuff that's me. This course may not be for you, however, the physical output that will be providing could be useful. It's a very useful tool, especially in Google Sheets if you're using that. So what are we doing? What is the project? The project is very simply two elements. First, a communications plan, which is more or less a visual table where you can define what communications and who does what and when and when they come. And the second is the actual project plan, which is very detailed Gantt chart with heavily for my eight elements to shore completion and so forth. A Gantt chart being something where you can track usually timeliness and the particular task against persons or persons as an example, now, just to be very, very clear, the original template for the project client actually came from online. I believe it was an Excel template a couple of years old. I've heavily edited it. I did lots of quality of life and lots of extra for mine. But just to touch that it was free for commercial use their template, so there's no problem there, but I just want to say it was originally somebody else's template. It's unrecognizable, probably even to the person that created it. But to give credit where credit is due. So the project will consist of us looking at the background formula as we usually do, how it works. And we can add to the project plan how we could take away, how we can edit, and then also how you can sort of present this information. For example, printing a pitch sounds simple, but often these charts can be massive, so printing is not that practical. Over there's a few things we've done there just to make that work quite well. So what you'll get from this project, this lesson, is you will get what you plan itself. You can make a copy has all my other lessons. You'll get a communications plan, which is associated in the same spreadsheet. And you'll get a basic understanding of how you can use it and how you can make it work for you, as well as something that looks quite graphically impressive. Without being too, too difficult to manage. It's probably somewhere in between basic and intermediate. In terms of skill level. It's certainly not expert, but it's probably more advanced than a lot of the lessons that I've done. So just to be clear on that, however, the actual formula and the conditional form themselves are quite simple. In essence, there's just a lot of it. So there'll be three bit deals for this. After this introduction, we'll look at the communication plan just kind of in one goal. A is mu, money visual table when we'll look at project plan specifically how it's meat. So formula and hidden table formulas in example, array formulas, although we won't go into that in heavy detail because you won't have to edit that even if I'm to it yourself. And then we'll actually on the last lesson, we'll do a review and summary. Of course. I also see some of the uses for it because it's all very well me, helping you build a project plan to actually understanding how you can use this, I think is quite vital and that's what we'll be doing today. So I really hope you enjoyed this lesson set and I will see you for the first lesson. 2. Communications Plan: Hello and welcome to Lesson 1 with learning with Chris, project plan or management in Google Sheets. So it's just a very quick recap of what we're doing here. We are looking at how we can use a basic project plan or a project management tool within Google Sheets, something that you can own and edit yourself, as well as a small communications plan all contained within Google Sheets, which will be this sheet here. Now, just a bit of housekeeping do remember this is accessible via the link in the description of the class. Remember to make yourself a copy, which is also detailed in this section and description of the class under lesson plan, this will be available as well. So what we do, we've just covered that. We're going to be looking at a project plan and communications plan in Google Sheets. The goal is for you to have a copy that you can use yourself for any project you so wish going forward where you can add it. You have a good understanding of how it works or it does and how you can use it. So we're have three videos, including this one, which is communication, which will jump on to in a second communication, which is very basic. We're just going to look at the communication plan, their table that's there and sort of the part of it. Look at the project plan. They will be listened to the video after this, that will be a far more extensive video. It may be one of the longer ones in my Skillshare. However, it's quite important that we cover all the elements just so you understand what's going on in there. And then on the fourth plus and we'll do a review and summarization as we always do, and also a little bit conversation for me in such situations, you may use this, how you want to use this and potentially what you can do to upgrade it or at least change it in the future. Okay. So without further ado, let us jump straight into communications. So this is our monthly project plan. Very, very simple. Somebody page just telling you which each one is, project name, owner, and start date. As you can see, of change something else within the project plan, that nothing here is of vital importance. It's really just a linking piece. So comms plan, basic communications plan that should be shared with stakeholders. It's important in all communications are plant here, even at this level of simplicity. So let's see what that's repaired. And here we go. Here as a comms plan. Are we looking at? So we're looking at phases or the large-scale important elements. There's all sorts of different names for this. And if you're working in an organization, they may call it by a number of things, depending on what project management they usually do. Big ticket items, mass-scale elements, feces, topics, but these are really a summarization of large-scale elements. So big ticket items, if you will. Now, what we have in the project plan and the plan is actually some anonymized version of our real project I was involved in a number of years ago. Hints why there's a little bit felt then, and I thought it was better just to leave these examples. So what we're looking at here in this test group, we are looking at WIIFM support. Now for the purposes of this, WIIFM doesn't matter. However, if you are interested, WIIFM means workforce management. So what we're seeing here is there's going to be a communication about WIIFM in the fourth week of February. Now, it is your choice if you want to, for example, either deet in there as well, I would suggest just the D because we know it's in family for the purposes of this. I don't think it's that important because usually for a long project like this is simulating. If it's a Monday or Tuesday within a particular week, It's not going to be that relevant to the overall project with some exceptions. So we are seeing that we are going to communicate on WIIFM support in February, that we can follow up the second week, April and WSM ideas on the 1st of me. So why is this important? So at the beginning of any project, it's really quite vital and I'm really stressed and not underestimate this to show your communication plan in advance because one of the biggest grapes, but communication plans is often, or projects in general, I should see, is often that they didn't know some of them is going to happen. They didn't know that we are going to be told. It's somewhat of a defense mechanism people have, it's quite normal. It's certainly not personal. So if you create a project plan and you have something like this within it, a communications plan that you just share. And this is perfectly printable page with people in advance. This is what I'm going to communicate on item B within this fees, you know, John Smith v. Then you can't that there can't be any conversation about you're not communicating because you've already told in advance what you're actually going to do. So I think it's essential not just for stakeholder management, but also to hold you accountable as well. Because it's very easy to quickly look in here. And you'll probably have the details of these on the project plan, which we'll look at in the next video. To fill in this communication plan, please do not underestimate the importance of this. Now, in some ways it would have been easier to look at the project plan first. I don't want to do that because of the complicated elements of it. But these would probably refer to elements within your communication plan that you just think it's worthwhile sending. Sorry, if an elements of your PR plan that you think it's worthwhile eliminating within your communication plan. Up here, as you can see that there's no, you're probably familiar with this now if you've been watching my videos, this is just a little bit at details. Two columns, audience and details. Audience. Who is this communication going to? Senior management, operations. These are specific role titles, planning team plus SR, no details, but you would add your own details in there. Now this communication plan isn't supposed to be a highly detailed elements of communication strategy. This is supposed to just be a stakeholder management tool that you share with people to show this is when you're going to be centered communications. And this is the basic details of this. And a relatively good looking tool as well. It's quite important for stakeholder management. And I just want to re-emphasize one more time. It's very important even if you're a professional project manager. But maybe if I only use software before, no, you have to use Excel or Google Sheets to have something like this. Whether it's this one or not, that would be fine, but the hover communication plan that you share in advance. Now of course, it's likely communication plan will change because most things kept the lead or get it done quicker. And maybe you would have and you're very bottom line as an example in other, but let's just add that other columns. One review. So you may say, I don't know, every every quarter, you're going to review your comms plan. It's probably a very good idea to actually, because it's likely it comes plan is going to change that maybe every week even. But I'm what you would do with that if it was to change every week as you would just send an updated version of this. And probably how the changes in a text format rather than NADPH and fancy and Google sheets or Excel. So there's not really any formula here. There's not really enough to dig into. I just want to talk about the importance of using this communications plan and filling it in. This is quite a good looking comms plan as they go. It's obviously lacking detail. But the point of this to stakeholder management. So for the purposes of this lesson, reviewed the US and we've reviewed the process of it. And there's really not much to the process of it other than villian sections, this is very easy to edit if you want to make this into every single day, that's fine. Or maybe you just want to have weeks and there because that could be Monday to Friday. That's why it's five sections. Because your project may not be that long. This is just text-based with some decent for my ink already introduced. Very easy to add lanes in. Simply insert, particularly either way. That's as simple as this, but it's a good look and visual tool. And most people like having communication strategies for stakeholder management from. So we'll leave it there. I think of it today that enough, we will go on to our next lesson. And that's going to be the monthly level project plan. But it's one that will take awhile. It's quite complex. So this might be worth get a coffee or a cup of tea. And I will see you in the next lesson. 3. The Project Plan in Detail: Hello and welcome to Lesson 2, where we're going to be looking at the project plan, on the project management tool, where we'll be covering how to enter detail, the details themselves, and how to update them. Formulas that are in the Tracking Area and formulas that are in the detail idea. And this is where you find it within the summary page, a monthly level Gantt and tracker for key and sublevel tasks and priorities should be reviewed as it points. For example, a daily stand up. We'll cover it a little bit more about some standard expectations of review. The final video. So let us go straight to it. And here we go. Here is our project plan. Now at first sight, this may or may not be terrified. It doesn't look as terrifying as it did with every single section was filled in. I've left one was so full details. And we will cover what this all means. So we're going to start at the top and just go over all these little sections before we get into any detail. Firstly, the name taste project, the test project just comes from the sale here. So you name your project. Very, very simple. The start date of the actual Gantt tracker itself. So for example, let us change that in February. Then we go the actual track of changes. These are all because of how this formula works. So the very first sale is associated to E2, which is the state. And in this formula, which is equals E date. And then sailing question. So the Excel before and one, which basically means plus one month to the D in question. So this will always change, which is absolutely perfect. There's a very piece of basic conditional form in more than nothing on here, which is very, very simply at the date is within the past month I0. Is it this month? Please be getting hints. September 21, as I'm recording this on the second of September. So let's have a look here. We've got Task Name that probably be speaks for itself. Assignee I, Who is this task for? Progress have thought along is that task. And of course start and finish probably doubles to vital elements when it comes to project planning. Also, as you can see here, there's a plus i o and this is just an regard extra detail. Now, that is the opportunity to make this very large. And I think for some of you, this may very well be a place where you keep a lot of details on your changes as an example. And you can certainly add more columns in here as simply as that, the ego and that will not break anything and the tool. So if you wanted to add changes are enough and along those lines, please feel free. Okay, so let's have a look at the first example we've got here, quality support embedded. This is a project that I was doing within our place. I was consulting and it was assigned to this was my project plan, so a lot of things were assigned to me. But what sport embedded? Chris, Twenty-five percent progress was made. It started in October 2020. Obviously, we can't see that on this chart and it was supposed to finish on the first OF MY 2021. Let's say that it's now changed to October 2021. And there we go. All of a sudden, this has moved all the way along. And what's interesting here, why is this one red? Well, let's just look story I shall we the conditional formatting. If the date is before to D turn rate. Now this one is extremely simple. If you wanted to add a rule that let me show you from the start. If you wanted to add this rule, you would go to Format, Conditional Formatting. I'm presuming most of you know how to do this if you fold my other videos, or indeed you've used Excel or Google Sheets is very similar. It's extremely simple to make. This rule is simply do details before. And that's as simple as that. And I'm not going to apply this because it would overwrite the other formula that's already there. But that's as simple as that. I'll talk about this other formula in a minute. And that's quite handy because once that's telling you is that project should have been finished with a task that should have been finished. And if we were to change that, they're no longer is the case, that that's rate. And there's a little bit more you can do in there. Just as an additional if you want it to do that. You could do the date is before and you can do a sweep the past month, past GRC, you could say up, you know, red, amber, light yellow. So a traffic light system here. So in principle, what we're doing here is we're adding a task, but associating an assignee. And I'll show you how to do the list in a second. Progresses of it's entirely up to you. What percentage of tasks do you think is completed? There's some conditional formatting here, which I won't go into any detail, but in each one of these sections, it's a color change from red to green, with blue being the middle. And it's just to give you a visual idea. In fact, I will show you briefly. Very, very simple to change. You'd go into Format, Conditional Formatting, Color scale, and you can just change the colors based on percent. So the minimum point being 0%, the maximum point being a 100 percent, midpoint being 50 percent. And you could change the colors, for example, I think not blues, probably a little bit too dark. So there we go. There's a slightly lighter blue and we've changed and that change is it for everything. And again, that will work if you add or AD columns. So what is going on in this one, however, we can see here, there's a tick which looks really good. And that's obviously because it's a 100 percent. Now let's just change that to make 5%. All of a sudden tick is gone. Let's go back to a 100 percent. What's going on here to make this happen? So first off, if eight, which is the cell here, equals a 100 percent, which it does provide Kotok tar 100,004 if it isn't, don't do anything. So this is really just seeing the necrotic term. So this could be anything, this could be a, B, C. And the magic is really happening because this character is that tick. You know, you can change it. For example, 15ths and five is an x, which would probably be suitable for this as well. But they began to tick. Else is happening here to change this, we'll call them. This will rule green. Well, we'll look at the cell. Again. A lot of this is conditional for mine Format, Conditional Formatting. So we can see there's a custom formula here. And it says equals E7. It st E7. And it seemed E dollar sign E7 because the first formula was written in the first sale, it's associate to that because of the way conditional format and works, it will always show the first sale it's associated. But because of this dollar symbol in the absolute reference, it's working. It's actually associated to the rule in question that might sound complex, but it's not, it's how conditional format and works in both Google Sheets and Excel. And it's just the eye. So it looks cute reality of conditional formatting. But let's just imagine for a second, S is equals 8. And that's simply saying equals eight if it's greater than 99 percent, which is because eight for the purposes of this is a 100 percent. So if it's overnight 9% turning green. And this basically up here is telling you all the ranges that this is associativity. So B7, which is here, to see 46, which is we debit AR between and everything else. So let's click done. And if we were to look at this column, we can see it's the same formula. And that's simply because we copied and pasted the conditional formatting that we're not gonna do this again, but all you do is copy, paste special paste conditional format, so that it's absolutely perfect. That means when we complete the task, it's very, very clear and obvious. Just done a 100 percent. There we go. Let's have a look at the conditional format and it's in here. So this line here was simply an inserted line. So don't worry about that at the moment. Let's have a look at the conditional formatting right-click conditional format. So obviously we're seeing this formula. This will be all the way along every rule. So from that one, you can ignore it. Likewise, this formula is not relevant. It's just for the array behind which is not necessary for this. And then there's this fancy formula. Now, for the purposes of a basic to intermediate video, we're not gonna go into detail. I were to suffice to see this is looking at the Dietz and convert into deeds to color on this Gantt chart. It's not exceedingly complicated and I think most of you would be able to work it through if you have the time, but that's it. And then within here, this is actually controlling the color. So you can change this to whatever you like. I tend to go for blue and green pastel colors. And they tend to be the most common. But you can actually change this anywhere and it will change the whole thing. So please feel free to do that. So what we're gonna do, And finally, let's have a quick look at the array formula because I've made it into, so you can probably see here row four, row 6. Let's rotate it. So let us unhide that row. And in here, this here is the formula. This makes the magic happen. So in essence, the formula is not super complicated. It's really just looking at the VGS and the like and also the title in order to put the title on there, this is absolutely not the lesson to learn about re formula that locked up fantastic videos out there. It's very advanced. It's probably one of the more advanced elements of Excel farther ahead than have, for example, pivot tables that you may have heard of. But that's where the magic happens. And that's basically to put these names at the star. So just to give you an example, let's change this to. July that every formula is making that name appear in the right section. And you can see there's no formula in that cell is because it's held by the array. Again to Kabuki it for this video. And indeed, I'm not particularly verse to honoree formulas. I do know how to write them, but the advanced, but that's how that actually works. But let us hide that again, also doesn't look very clean with a double. So what we're gonna do, we're gonna make our own group here. So test group, let's call it test group. Skillshare. We're going to see a John Smith is working. Skillshare. Listen to clean the house, feed the dog. There we go. So we're going to assign these to one to me, to Chris 12 Roger. 12 was and feed the dog to everyone. But it's not being done at all. Skillshare has been complete, clean the highest. We've done a little bit of that and nobody's fit that the archaea, these are all starting that, uh, why did we take so long that these are all starting in August? We've got to finish. John Smith has to finish work. And in fact, these late already, skillshare less E2 supposed to be finished by October. Clean the house has to be done by a toolbar and feed dog. Ridiculous example in the way or needs to be done by this N part. And as simple as that, you have made project plot for these items. Now of course, it would generally be something probably more important. Well, feeding the dog is extremely important, but more important than this. However, there's no reason you couldn't use it for chores or something similar. And we may want to add details in it. We won't, because we don't really have any details that however, the reason for this example isn't just want to show how easy is to add. Maybe there's something that we forgot to add that there's no space. You can simply insert another column, another rule even. And we can see that actually started July, finishes in November. Now, the reason I've shown this, It's as simple as are all the formatting works apart from one element. And that is this formula here. This does not copy when you insert a row. So very, very simply, copy paste and then eagle, but it's now working. So if you were to insert for a rose, absolutely fine. Just copy and paste a sale in there. For the purposes of this will actually make these smaller. This is simply for my, So if you wish, you could insert another rule and you could make another heading. Absolutely fine. You can make this as big or as small as you want. It's really that simple. Let's leave the other one down there. Now, another element that I've spent some time making work, although amino be perceived as something that's difficult, is File Print, this fits perfectly onto an A4 landscape. And as long as you don't have more than C45 tasks, L actually fit on one page. And even if he did, it prints quite nicely onto the two pages. So it fits exactly within Peach. I find it quite useful to print these out. Even though it's Google Sheets, It's always online. Sometimes some people just prefer things in their hand and there's no problem with that. That's why it's set up like this. Now if you were to start changing column sizes that may not fit in the same way. And that's why it's state the way it is. So that's really all for the project plan. This is a very good tool if I do say so myself as a seeds based off somebody else's template modified. Quite dramatically. It must be said that this is quite powerful. Quite often you'll be using a garden with an Excel and they can be extremely useful, but they're usually not very visually stimulating or quite tedious to say up. And some of them spatially templates that come with Microsoft are quite out of date to look up visually from being honest and we click something from Windows XP. In fact, some of them are from that range. So this is a modern up-to-date version and Google Sheets. And of course, being Google Sheets, multiple people can be in this at the same time, online editing this and you can see what they're doing, so you can't write over it. Now you can't do that to a degree. And office, whether it's in Teams SharePoint or just direct cheating. But it's absolutely not a smooth. Now, Excel has the advantage over Google Sheets for Gantt charts for extremely complex gunshots. That is no question. If you are having multiple layers, so assign task to another task with lots of array formula you're going to want to use Excel. But at this level, especially for this sort of level of project plan, Google Sheets and it's extremely powerful tool and now this is all yours to use. So the takeaway I would like you to do on this one is to really review what we've looked at, review the conditional formatting. And remember the two ways to look at conditional formatting is either to right-click, go to conditional formatting, or to click on Format and go to conditional formatting. You can more or less edit that to your heart's content. You can change the colors because it's really just color stimulation. And remember, the one element that you have to do more is to copy this formula, click and drag it as an example like that would also work. It's probably easier. And other than that, that's all there is to do. It's printable, it looks good and it's easy to edit. So very powerful tool to use. Okay, so I realize it's been quite a long way, so I do apologize for that, but hopefully that's covered the project plan. In fact, let's go back to our lesson plan. The project plan, how you enter data, details and updating the formula and the tracker area and the formula and the detail area. So we have covered all those elements. I'm aware some of that may be more complex for some people. So feel free to look at this again. Or probably more helpfully for yourself, to just play around in a Google sheet that you have shared with you as part of the project. Okay, So in the next lesson we will have a little talk about how you use project plans. Where to use project plans and maybe base fits and audios for them. And I will see you in the next one. Thank you very much. 4. Use of the Plan and Next Steps: Hello and welcome to lesson number 3, video for on our project plan and project management in Google Sheets. So what have we covered already? We have covered the communication plot, which is this simple but very effective template here. And we've also covered the more detailed and quite powerful tool here, which is a monthly budget planning tool or Gantt chart with some details in there as well. So what we want to talk about in this lesson is when you would use this, There's a number of circumstances you could use this sort of tool and fight that. Let us just look at the tool in question. For example, if you're heading up a project, let's just say you're working in an operation sync to our contact center or maybe a marketing department on you or maybe introducing either a new process that's going to change quite a lot or maybe a new piece of software. You may not be managing the IT element of it. But you are most likely Jing, if you're a manager or you're somebody who had been nominated to look after it, you're most likely going to be managing that function through your project manager. You may not have any experience in project management, but you know how to track things. So with this tool, you would probably go in with their eye that you would do more than you need to do in the sense of adding tasks to this, It's easier to take away tasks if you're not going to do them. Ban, and I don't mean from a practical sense, but from a project management approach than it is to add them either once you're doing them or after you've done them because it's really counterproductive to do it that fashion. So you would label those details within here. And for example, these colored boxes could very well be people or phases. So you might have a four-person team working on this. So you may simply have it by person. More likely you would have it by type of work. So I don't know data entry, data quality, and Communications, something along those lines and you would fill in those details. Recommended best practice would be to share this directly with the individuals who are under the assignee list. And indeed, they can then access it on the can indeed indicate an updated as well. No. There's not too much wanting a bit control factor on this because as shown in previous videos, it's very, very easy. I won't hold it because it takes a little time to load to look at the version history so you can see all changes and it's innovative, easy format to look at is a powerful tool to edit and allow US for it. Another application for this and something that I know my wife used. This actual template for was when we would last moving house. I am and I'm glad she did because I had 2050 items associated to me which was changing addresses for all bank accounts and so forth. And I would almost certainly missed one of them if it hadn't been in there. So there is household reasons that you could use this. I personally use this. I am somebody with a planning background who likes to plan for most things. Thus, I use a plan in my life, so I have a weekly version, which is actually very easy to do. I know I have not shown up in this, but if you were interested, do let me know. And I really just planet what I'm gonna do. Um, and that's as simple as going to the gym. I work remotely generally. I don't go to the office too much. So when I do go to the office, it's in my project plan and I plot that out. And that's just because I like a bit of regard unstructured in my life that may not be suitable for you, or it may be something you wanna do. But you can certainly use that because this can be added to more or less eternally. It can be as big as you want. You could have 2000 items in this. I'd suggest you probably want to start taking away items if you're getting into those numbers, but there's no reason you can't. Of course, there is a filtered here as well. So I didn't show this in the video. You can actually do that. So you can take away that complete the tasks. And they would immediately disappear when you're complete them if you lift up, fill or on. So if you are going to continue to use that and maybe uses as a tracker for your life or for a very long-term project, maybe several year project. This is quite handy for that. And it's Google. So even if you do something, it's likely you'll have a version that you can go back to. I have I can't tell you how many times in front of one of the first reasons I started using Google Sheets more than Excel was because of the amount of time that it wasn't really Microsoft's ball. In fact, not at all, but my time is my file corrupted. I couldn't use it and I can get back to a previous version that doesn't happen in Google. So that's the reason. Now one thing I didn't show you and I've just remembered is this naming list. How do you add to this? Let's just have a quick look. Data data validation. And all I've done here is less than names. You can do that or you can write the name somewhere and just select the range using this books. Probably easier, just typing it in and you can change that to your heart's content in there. And there's a few other options here. And you would have to copy that books into every other books are simply select them all and data validation not be other uses of this. I actually think the column strategy as an external stakeholder management is something I can tell you from previous expedience. That although I may have had a very clear and concise con strategy that's detailed on maybe the documentation was provided at the stake holders. It wasn't great, but it wasn't absorbed. So something like you're seeing on the screen being sent out at the beginning of a project, began in for transformation wherever it may be. It could be really useful. And this is something you can just send out all the types. This is the update. This is a changes. I've seen team managers in a contact center or a call center use this and say this is what we're gonna do. But instead of comms, they're talking about their meetings. I oversee in a contact center. They usually have scheduled meetings, but it's unlikely the schedule goes 12 months out. So the team manager just says we're planning to have this in Week 2, September, and that was next year. And I think that's a really good use of that as well. And that could be it doesn't have to be a context and it can be any sort of enterprise work at all. And realistically, one of the best elements of this is to have a truck history of what you've done and who's done it. And I know it's just not going to be the AD IT field. It's just very, very good to have this. If you start doing things like this, you don't have a very good truck to go into things like Agile, Lean, Six Sigma, or any of the multiple project management tools and measurements that are out there. That's glycine finished. And I do hope it's been useful to, you know, have your own project management tool, quite simple, yet powerful. In a follow-up to this, I will be showing something called article, which I'll go into far more detail. It's actually a project management tool set and I've built from the ground up myself that's based in Google Sheets. A 100 percent free, I may add as well. Leans on all the best elements of Lean, Six Sigma and agile. It doesn't pertain to be better than them. It just cleans and takes the bass parts of each. So I'll be doing that in a folder Skillshare and in the future. Now be quite complex, but it's lace up at the formula and it's more about the mechanics. If I just about had a Google sheet works at all, It's about how you use project management. So if you're interested, that will happen. But if you have any questions on this, please leave comments. I'm more than happy to interact. I'm even happy to help in the background with your own Google Sheet if you're having trouble with elephant, that's not a problem at all. So thank you very much and hopefully I will see you for another learn with Chris.