From the course: Excel for Project Management

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Track and identify project metadata

Track and identify project metadata - Microsoft Excel Tutorial

From the course: Excel for Project Management

Track and identify project metadata

- [Instructor] So now that we know how to use Excel tables, let's talk about what types of things we want to track. Now, you don't want to put everything in your Project Management table because there's going to be too much data, and some things just aren't relevant. The best part about an Excel table is that it has a lot of the things that we really want already built in. So let me show you. Go ahead and place your cursor on cell A3. You're going to type in a 2 here. The table's going to automatically grow. So your project ID is a numeric field, and we like that. We usually want some sort of unique identifier for each project. And then under task description, I want you to type in Project Execution. And under Assigned To, you can type in your name, and under the Date, you can put a date like the one above. So we'll do May 1st, 2024. And then if you feel like it, you can put in today's date or just something that has a sufficient amount of time after that start date. And then finally,…

Contents