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 - 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,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.