Project 2010 Essential Training

Project 2010 Essential Training

with Bonnie Biafore

 


In Project 2010 Essential Training, project management expert Bonnie Biafore shows how individuals and teams can use Microsoft Project to manage any level of project. The course demonstrates setting up projects, adding tasks, assigning resources, fixing scheduling issues, dealing with resource conflicts, and tracking project progress. It also covers the new Project interface, featuring the new Ribbon and Backstage view, and explains how to use new features like user-controlled scheduling, the Timeline, and Team Planner. Exercise files accompany the course.
Topics include:
  • Setting up projects and calendars
  • Creating tasks and milestones
  • Linking tasks
  • Setting start and finish dates using manual and automatic scheduling
  • Setting up and assigning resources
  • Understanding duration, work, and units
  • Filtering and grouping items
  • Modifying project views
  • Using the Task Inspector
  • Splitting and delaying items
  • Making tasks inactive
  • Updating progress and costs
  • Viewing project status
  • Running reports

show more

author
Bonnie Biafore
subject
Business, Project Management
software
Project 2010
level
Beginner
duration
4h 41m
released
Sep 15, 2010

Share this course

Ready to join? subscribe


Keep up with news, tips, and latest courses.

submit Course details submit clicked more info

Please wait...

Search the closed captioning text for this course by entering the keyword you’d like to search, or browse the closed captioning text by selecting the chapter name below and choosing the video title you’d like to review.



Introduction
Welcome
00:04Hi, I am Bonnie Biafore and welcome to Project 2010 Essential Training.
00:09Project Management is an important part of doing business, more than ever before.
00:14Workers have to do more with less to be more efficient with their time and more
00:18effective getting results.
00:20Microsoft Project is one of the most widely used project management
00:24applications, and I will show you how to get the most out of this powerful program.
00:28I will explain how to set up different kinds of tasks, like work tasks, summary
00:33tasks, milestones and recurring tasks.
00:37We will explore the different types of resources you use on projects.
00:42I will demonstrate how you link tasks together and assign resources to tasks to
00:46build a realistic project schedule.
00:48I will walk you through using different project views to look at your project
00:52from different angles, so you can check upon where things stand, how much things
00:56cost, or where the project might be getting into trouble.
00:59We will examine other Project features that help you evaluate your schedule
01:03and resource workloads to make sure you are bringing your project in on time and within budget.
01:09By mastering the tools available in Project 2010, you can manage projects more
01:14successfully and help your company achieve its business objectives.
01:18So there is no time to waste.
01:20Let's get right into Project 2010 Essential Training.
Collapse this transcript
Choosing the right Project edition
00:00Project Professional 2010 has all the bells and whistles Project has to offer.
00:05However, if you want to save a few hundred dollars and can do without a few
00:08features, Project Standard 2010 may fill the bill.
00:12Project Professional is more expensive, but it includes every feature that
00:16Project Standard has.
00:17So your decision boils down to whether its additional features are worth the
00:21difference in price.
00:22To download the Edition Comparison pdf document, on the Microsoft Project
00:27Product Comparison page, click the addition comparison link.
00:32You can also see some of the differences right on this page.
00:36Here are a few editions that Project Professional offers, which you will learn
00:40about in more detail in later movies.
00:43The Team Planner view makes it easy to see tasks that aren't assigned to anyone,
00:48or aren't scheduled yet.
00:50It also helps identify when and where resources are overallocated.
00:55Inactivating tasks is a new way to play what-if games, or to keep track of
00:59work that's optional, or simply hasn't been approved yet, like pending change requests.
01:04When you inactivate tasks, you still see them in the schedule, and they still
01:09contain all their values, but those values don't affect your schedule or
01:13resources availability.
01:15Project Professional certainly can do the job, but you can use Project Standard
01:19when your needs are simpler and you want to spend a little less.
Collapse this transcript
Using the exercise files
00:00If you are a premium member of the lynda.com Online Training Library, or if you
00:04are watching this tutorial on a disk, you have access to the exercise files used
00:09throughout this course.
00:11The exercise files are in the Exercise Files folder, which I have placed on the desktop.
00:15But you can store it wherever you like.
00:17There are files for most movies.
00:21They reside in subfolders named according to the chapters.
00:25You don't have to use these files.
00:27You can use files of your own.
00:29If you are a monthly or annual subscriber to lynda.com, you don't have access to
00:34the exercise files, but you can follow along with your own work.
Collapse this transcript
1. Setting Up Project Files
Using the Ribbon
00:00Microsoft introduced the Ribbon in Office 2007, and now Project 2010 joins the party.
00:06Although the Ribbon takes up a lot more space on the screen than the old menu
00:10bar, it also holds a lot more commands.
00:12The Project Ribbon makes a lot of tasks much easier to perform, because the
00:17commands are on the Ribbon instead of buried deep in a dialog box somewhere.
00:21The Ribbon has several tabs, which act like the top-level entries on the old menu
00:25bar, and because managing projects focuses mainly on project, tasks, and
00:30resources, the Ribbon tabs in Project make perfect sense.
00:33You'll learn about how to put commands to work in the rest of this course.
00:37When you first launch Project, the program opens to the Task tab.
00:41We go to the Microsoft Office menu and double-click Project 2010;
00:48you can see the Task tab opens.
00:50Click a tab to show that tab's commands on the Ribbon.
00:54The Resource tab, Project tab, View tab, and so on.
01:00The File tab is like the File menu on the old Menu bar.
01:03You can manage files from this tab, but it offers a lot more than that, as you
01:08will learn in a later movie.
01:11The Task tab is teeming with task-related commands.
01:14The View section helps you choose the task-oriented view you want.
01:20The Clipboard section let's you copy, paste, and cut tasks.
01:24The Schedule section let's you create links between tasks, move tasks around in
01:29the levels of the outline, and update task progress.
01:33The Tasks section lets you change task between Manually and Auto Schedule mode,
01:38review tasks with the Task Inspector, or move tasks in the schedule.
01:43The Insert section has commands for creating regular tasks, summary tasks,
01:48milestones and recurring tasks.
01:51The Properties section has a button for opening the Task Information dialog box.
01:56Then in the Editing section, click Scroll to Task to move the timescale so you
02:01can see the taskbar for the selected task.
02:06The Resource tab has a view section for choosing resource views.
02:11The commands that are active on the tab depend on the view you select.
02:17If the Resource sheet is visible, you can click Add Resources to get resources
02:22into your file in several ways.
02:24If a task or assignment view is open, like the Gantt Chart or Task Usage, you
02:34can click Assign Resources to assign resources to tasks.
02:38The Properties section let's you look at resource information, notes, or resource details.
02:44The Level section has commands for leveling assignments in several ways to
02:48remove over allocations, as you will learn in a later movie.
02:54The Project tab focuses on project- wide activities, like setting up a work
02:58breakdown structure, defining the working time and setting baselines.
03:03You can insert subprojects or create links between tasks in separate projects.
03:08You can also access custom fields.
03:11You can update project status, or you can run reports.
03:17You can tell Project to show exactly what you want to see with the View tab.
03:21In addition to commands for choosing the view you want, you can choose a table,
03:26apply highlighting, choose filters or groups, customize the timescale to show
03:37the calendar to the level of detail you want, or you can tell Project to display
03:42the timeline view, as it is here.
03:45In Project 2010, you can hide or display the Details pane - that's the
03:50bottom view in a combination view - and tell Project which view you want to see in that pane.
03:56The Windows section has commands for opening another window, arranging the open
04:02windows, switching between windows, or closing them.
04:05One outcast, on the View tab, is the Macros command, which let's you run or work with macros.
04:14The Format tab is a chameleon.
04:16It changes commands based on the view you have open.
04:19For example, when the Gantt Chart is visible, the Format tab has commands for
04:28formatting taskbars, showing critical tasks, baselines, slack, and so on.
04:36You can show or hide the project summary tasks, or other summary tasks, at any level.
04:44If a usage view, like Task usage, is visible, the Format tab has check boxes
04:51for the fields you want to see in the Time Phased grid, like Work, Actual
04:56Work and Actual Cost.
04:59If I open the Timeline View, go to the View tab, turn on the Timeline check box,
05:07and then click in the Timeline pane to make it active,
05:13the Format tab has commands for adding tasks and callouts to the timeline or
05:18formatting parts of the timeline.
05:21As you start using Project 2010, take some time to look at the Format tab when
05:26different views are active.
05:28It's a treasure trove of view management commands.
05:32The Ribbon can do a few tricks.
05:35You can reduce the amount of space the Ribbon takes up or tell it to show you
05:39keyboard shortcuts, so you can keep your fingers on the keys.
05:43If you make your Project program window smaller, the Ribbon adjusts sections
05:48and buttons to fit.
05:50On the Task tab, the Insert section has buttons for inserting several types of commands.
05:56If you make the window narrower, the Insert section shrinks to a single Insert button.
06:01When you click it, you see a submenu of the individual Insert commands.
06:08You can also collapse the Ribbon so it hides, until you click a tab,
06:14right-click on the Ribbon and choose Minimize the Ribbon. All you see are the tab names.
06:22Click a tab name, and the full Ribbon tab appears.
06:27When you click a command, the Ribbon hides again.
06:32Then if you want to see the Ribbon, turn off the Minimize the Ribbon check mark.
06:37If you don't like switching between mouse and keyboard, you can also use
06:41keyboard shortcuts to choose commands.
06:44Press the Alt key to show the keyboard shortcut letters on the Ribbon.
06:49Press a letter to choose the tab you want.
06:51For example, U for resource. Then keep pressing letters until you launch
06:57the command you want.
06:58For example, P for Team Planner and then P again on the shortcut menu.
07:03The Quick Access Toolbar is separate from the Ribbon, but it's great for
07:08commands you use all the time.
07:10It sits above the Ribbon, but you can place it below the Ribbon by clicking its
07:15down arrow and choosing Show Below the Ribbon, or you can move it back by
07:24saying, Show Above the Ribbon.
07:26Out of the box the Quick Access toolbar has the Save, Undo, and Redo commands.
07:33You can turn on other popular commands, like New, Open and Save As, or you can
07:38add any commands you want so it's always available.
07:45The Project Ribbon organizes commands and makes it easy to perform many of your
07:49frequently used activities, like hiding or showing summary tasks.
07:54It contorts itself to fit the width of the Project window, so don't be surprised
07:59if you see icon text disappear or sections replaced by a single button.
Collapse this transcript
Navigating the Backstage view
00:00When you launch Project and go to the File tab, the first few commands are old
00:06favorites: Save, Save As, Open, Close, and at the very bottom, Exit, all still do
00:14what they did before.
00:16But the other entries do more, a lot more.
00:19On the Info tab, you see information about the active project file, on the right
00:24side of this page, like a start date and finish date.
00:28Click Project Information and then Project Statistics to see scheduled baseline
00:33and actual values, if they exist.
00:37Click the Organizer button when you want to copy views, tables, and other
00:43elements between files, as you will learn in a later movie.
00:49Click Recent to see all the projects you have opened recently.
00:53This is the quickest way to reopen a file.
00:57If you are going to work on a project for months, click the pushpin to the
01:02right of the file name.
01:03The project gets pinned to the top of the Recent Projects list.
01:07To add projects to the Backstage menu, turn on the Quickly access this number
01:13of Recent Projects check box, and type the number of files you want.
01:20Project displays that number of recent projects above the Info command, starting
01:26with projects you have pinned to the Recent Projects list.
01:29You can create a new Project file in several ways, as you will learn in a later movie.
01:35The New command in the Backstage is your ticket to all of these methods.
01:40The Print page looks like the old Print dialog box.
01:47You can select a printer, choose paper orientation or set margins.
01:57When you are ready to print, choose the number of copies and click the big Print button.
02:03The one drawback to this Print page is that the Options area won't shrink,
02:08and unless you have a widescreen monitor, it's tough to get a good preview before you print.
02:15When you click Save & Send, you can choose ways to save and send your project files:
02:21Send your project as an e-mail Attachment, Synchronize your file with a
02:25SharePoint Task List, save the file to Share Point site or if you click Save
02:32Project as File, it does pretty much the same thing as clicking Save As on
02:36the Backstage menu.
02:39Clicking Microsoft Office Help opens the Project Help window.
02:43You can also get info on your version of project or find resources for
02:53learning more about Project.
03:00To open the Project Options window, click Options. Then you can set Options for
03:07Project or for a specific project file.
03:17The File tab contains commands for managing files and more.
03:22You can set options or print views and reports.
03:25The big difference with the File tab is that it takes over the entire project
03:29window. To get back to a Project view, like the Gantt Chart, click another
03:34Ribbon tab.
Collapse this transcript
Creating a project
00:00You keep a lot of information about a project in a Microsoft Project file:
00:04tasks that represent the project work, resources you assigned to work on those
00:09tasks, the dependencies between tasks that determine the order in which work is
00:14done, and once work begins, the status of the project.
00:18You can create a Project file from a template, an Excel workbook, an existing
00:23file, or a SharePoint Task List.
00:27In Project, click the File tab.
00:29Project's Backstage view is where you create files, regardless which methods you use.
00:39Click New to see the available templates page.
00:43This page has buttons for all the methods you can use to create a project.
00:47Using a template is the quickest way to get started, because a template can
00:51contain tasks, resources, settings, and even values like task durations or
00:57estimated work hours.
00:58Whether you use one of Microsoft's templates, a colleague's template, or one of
01:03your own, a template can get you started with a ton of info.
01:07Or it can have tasks with durations, work hours, resources with pay rates,
01:12assigned tasks, links between tasks, baseline values - you name it.
01:17How you get to a template depends on the template.
01:20To use a Microsoft template, double- click one of the categories below the
01:24Office.com Templates heading.
01:26For example, double-click Plans and then double-click Business.
01:34All the business-oriented project templates appear, showing a thumbnail of the
01:38template and the company that produced it.
01:44Select a template and then click Download.
01:47The project template downloads to your computer, to your Template folder, and
01:51also opens in Project.
01:53When you save the file, by clicking the File tab and then clicking Save, the Save
02:00As dialog box opens.
02:02That's because you are saving a new project file based on the template.
02:06Open the folder where you want to store the new project file, Desktop in this example.
02:12Then in the File Name box type the name for the new file. Click Save.
02:25You have your new project file.
02:27If you are looking for a specific type of project, go back to the New page and
02:34in the Search Office.com for templates box, type keywords for the template.
02:39Try typing wine fundraiser and click the arrow.
02:46Sure enough, there is a template for a wine tasting fundraiser.
02:50I know because I created it.
02:52If you go back to the Available Templates page by clicking the Back button, if
02:57you have used a recent template, an easy way to get to it is by clicking Recent Templates.
03:06The templates that I have opened recently are both showing here.
03:10Again, click the Back button to go back to the full available Templates page.
03:14Clicking My Templates opens the new dialog box, showing the templates in
03:20your Templates folder.
03:21You can tell Project where you want to keep your templates.
03:24To create a project file from one of these templates, just click the template
03:29and then click okay.
03:33There is a glitch in Project's Template Folder option.
03:36You can specify the templates folder by clicking Options to open the Project
03:41Options dialog box and then clicking Save.
03:47The default folder is shown here.
03:50It's buried under AppData/Roaming/ Microsoft/Templates for the Windows
03:567 operating system.
03:58It isn't a great place to keep templates because you might skip that folder
04:01when you do backups.
04:03A folder within my documents, say My Documents\Templates, is more likely to get
04:09backed up and is just easier to get to.
04:11You have to trick Project into displaying templates in a folder like that.
04:16The trick is to set your template folder in another Office program,
04:22close the Project Options box and then open another program, for
04:29example, Microsoft Word,
04:38click the File tab and choose Options.
04:44Click Advanced and scroll down to the General section.
04:51Click File Locations, click Workgroup templates and then click Modify.
05:00Select the folder where you want to store your templates and click OK.
05:03So, for example, choose My Documents and then create a new folder called
05:11Templates and click OK. Click OK to close the File Locations box. Click OK to
05:21close the Word Options box, and you can close Word.
05:27When you go back to Project, templates in that folder will appear in the new dialog box.
05:33I don't know why it works; it just does.
05:35If you capture information about tasks, resources, or assignments in an Excel
05:41workbook, you can use that file to create a project file.
05:44Say you built a list of tasks in Excel and you got estimates of work or
05:48duration from team members.
05:50You can pull that information from Excel into a new project file.
05:54Go to the File tab and click New, and then click New from Excel Workbook.
06:02The Open dialog box opens with the File Type set to Excel Workbook.
06:09Navigate to the folder with the file you want, select the file, and click Open.
06:15The Project Import Wizard opens. Click Next to use a new map and to load the
06:21data into a new file.
06:23When you get to the Map Options screen, turn on the Tasks check box.
06:28If the workbook has resources or assignments, you can turn those check boxes on too.
06:35The Task Mapping page shows the fields that you are going to import.
06:40If a field in the Excel workbook isn't mapped to a project field, you can select
06:45the project field in the dropdown list.
06:47For example, I can import estimated work into the Work field.
06:55The preview shows you an example of the data that you are going to import.
07:00If everything looks good in the preview, click Finish.
07:04Project creates a new file based on the Excel Workbook.
07:08When you click File and click Save, the Save As dialog box opens, so you can
07:15choose a folder and a file name for the new file.
07:23On the File tab, in the New page, you can also click New from existing project,
07:30but that isn't all that helpful.
07:32You select the project you want to copy and click Create New, and Project
07:36opens the file for you.
07:38However, it keeps all values in the original project, including Baseline and Actual values,
07:43so you might have to do more cleanup than you want to, before you can use the
07:47file for you new project.
07:49On the other hand, if you want to start completely from scratch, click Blank
07:54Project and then click Create.
07:58The keyboard shortcut, Ctrl+N, still works too.
08:03Project creates a new file, named something like Project1 or Project2 in this case.
08:12You can also create a project from a SharePoint Tasks List.
08:17If you have tasks in a SharePoint Tasks List, you can turn them into a Project file.
08:22This is a great timesaver if you brainstorm tasks with your team in SharePoint,
08:26and then want to start a schedule from those tasks.
08:29This feature is new in Project 2010 Professional, and it's available as long as
08:34you aren't using Project Server.
08:36If you use Project Server, you can use its more powerful features to collaborate
08:41with your team without the Task List limitation.
08:44For example, task come in from SharePoint as manually scheduled tasks, which
08:49means you have to specify the start and finish dates.
08:52If you synchronize autoscheduled tasks, SharePoint converts them to manually
08:57schedule, so you can't use Project's scheduling features to manage your project.
09:02But if you want to bring tasks in from a Task List, click New from
09:06SharePoint Task List.
09:08In the import SharePoint Tasks List dialog box, choose the URL of your SharePoint site.
09:15In the Tasks List dropdown, you will choose the Task List you want and click OK,
09:21and the tasks appear in a new project file.
09:24No matter which way you create a project file, when you click Save, the Save
09:28As dialog box opens.
09:30You select the folder for the new file, give it a new name, and when the Save
09:34As type box is set to Project, you know you are saving the file as a Project
09:392010 format file.
Collapse this transcript
Saving a project
00:00You don't want to lose the hard work you have done on your Project file, so
00:04'Save early, save often' are words to live by.
00:07Saving an existing project file can be as easy as pressing the Ctrl key and the
00:12S key simultaneously.
00:13But you can Project files in other ways, and to other formats.
00:17You can also choose from a few safety-oriented options to protect your file.
00:22For example, Project will always create a backup of your file before you save
00:26it, so you don't overwrite work by mistake.
00:29Or you can assign a password that someone has to enter before he or she can
00:33open or edit the file.
00:34Project's Save and Save As commands handle all these ways to save.
00:38In Project, when you click the File tab, the Save and Save As commands are at
00:44the top of the menu.
00:46The Quick Access Toolbar also includes the Save command, so it's always only a click away.
00:51But the quickest way to save a file is to press Ctrl+S. If you are saving an
00:58existing file, Project just re-saves it, and if you are saving a new file, the
01:03program opens the Save As dialog box.
01:05If you want to save to another format, on the File tab, click Save As.
01:12If you are saving a new file, the Save As dialog box opens, whether you choose
01:16Save or Save As, and you can also Save As to save a copy of a Project file.
01:22In Save As dialog box, go to the folder where you want to save the file and then
01:29give the file a new name and then just click Save.
01:35On the other hand, if you want to save a project file to another file format,
01:40use the Save As command.
01:42This time in the Save As dialog box, the key is the Save as type dropdown list.
01:49Click the down arrow on the right side of the box.
01:52You can save to Project 2010, Project 2007, and Project 2000-2003 formats.
02:01You can also save Project 2010 or 2007 templates.
02:05If you chose an earlier project format, you will see a warning that you could
02:10lose data if the file uses new features, like manual scheduling.
02:14If you want to export data to Excel, choose Excel Workbook, Excel Binary
02:20Workbook, or Excel 97-2003 Workbook.
02:25Excel Workbook is the Excel 2010 format.
02:29Excel Binary gives you a binary format Excel file, and Excel 97-2003 is the
02:35earlier Excel Binary format.
02:38When you select an Excel format, the Export Wizard launches.
02:42Of course, the old standbys for tab-delimited and comma-delimited files are also available.
02:48When you use these formats, Project saves the active table in the view and opens
02:53the Export Wizard to help you export your data.
02:56You will learn about the Export Wizard in a later movie.
02:59You can save straight to XML format if you want to create a file to publish to
03:04the web or use XM,L on it in some other way.
03:08PDF files and XPS files give you electronic hard copy files that most people can read.
03:15You can open a PDF file with Adobe Reader.
03:18XPS stands for XML Paper Specification, and it's one of Microsoft's ways to
03:24share documents with others.
03:26Let's choose Microsoft Project 2000-2003. Click Save to save the file to the format.
03:41If you choose an older format, you see a message warning you that the file
03:45may be less secure.
03:48Click OK to save the file anyway.
03:52If your file uses new features, you may also see a warning that the unsupported
03:56features will be converted, like manually scheduled tasks converted to
04:00automatically scheduled tasks, and you can just click Continue.
04:04No mention of file formats would be complete without a quick digression to the
04:09file formats you can open with Project 2010.
04:13Project can open files in earlier versions of Project, going back to Project 98.
04:19However, these files won't be able to use Project 2010's new features.
04:24On the other hand, Project can open but not save to Project Databases, which is
04:30an earlier format for storing multiple Projects, or to Microsoft Access Databases,
04:36or ODBC files, which stands for Open Database Connectivity.
04:39A few protection options are tucked away in the Save As dialog box.
04:47To the left of the Save button, click Tools and then choose General Options.
04:54The Save Options dialog box opens.
04:57To create a backup copy whenever you save the file, turn on the Always
05:02create backup check box.
05:04When you do this, you get a copy of the file with the BAK file extension, in
05:08addition to saving your project MPP file.
05:12The Protection password is a password you have to type to open the file, while
05:17the Write Reservation password is a password you have to type to edit the file.
05:22If you set either of these passwords, a Confirm Password dialog box opens.
05:26You have to retype the password, so you don't save a password with the typo,
05:30which would mean you couldn't open the file.
05:33Turn on the Read-only recommended check box, if you want Project to ask if you
05:38want to open the file as read-only.
05:40If you do this, you can always click No to edit the file.
05:45You can also tell Project how you want to save your projects.
05:49To do that, go to the File tab and click Options. Then click Save.
05:58You can choose the format that you want in the Save Files in this
06:01format dropdown list.
06:04You can also tell Project the folder that you want to use, and you can tell
06:10Project how often you want to save the work.
06:13It's a good idea to have this check box turned on, but for now, I am going to
06:16turn this off so that we don't get any interruptions.
06:20Choosing the default file format and the default folder location means that the
06:26Save As dialog box opens with the settings you use most often.
06:31The Auto save every setting can be a lifesaver.
06:34If you forget to save your work for hours, you turn the check box on, and then
06:38choose the number of minutes between saves.
06:41You have to decide the trade-off between saving your work and stopping what
06:45you are doing to save.
06:4645-60 minutes is a happy medium.
06:49You can also tell Project to autosave only the active project or all open projects.
06:56If you want Project to ask for permission before it saves, turn on the Prompt
07:01before saving check box.
07:02A few options help keep your computer secure.
07:07In the Project Options dialog box, click Trust Center, and then click
07:13Trust Center Settings.
07:15If you want to be cautious with older file formats which are prone to viruses
07:20and other malware click Legacy Formats.
07:24The middle ground is to select the Prompt when loading files with legacy or
07:28non-default file formats option.
07:32Then Project asks you if you want to open one of these older formats, and
07:37opens it if you say Yes.
07:39The Allow option goes ahead and opens a file without asking, and the Do not open
07:45option simply won't open the file, kind of like a two-year-old faced with the
07:49idea of eating a Brussels sprout.
07:52To protect your privacy, click Privacy Options.
07:56Turn on the Remove personal information from file properties on save check box.
08:03When you do this and save a file, Project removes the author, manager, company,
08:09and the person who last saved the file from the File Properties. Then click OK
08:15to close the Trust Center, and click OK to close the Project Options dialog box.
08:20The Save command saves an existing file.
08:23Save As opens the Save As dialog box, so you can save a file with another file
08:28name to another file format, or with one of Project's protection options.
08:33To save time and heartache, be sure to set Project's Save Option so the program
08:38behaves the way you want.
08:39You can also set additional options to prevent older file formats from
08:43endangering your computer or to erase personal info from a file before you
08:48send it to someone.
Collapse this transcript
Defining project information
00:00Because a project usually doesn't start on the day that you create your project file,
00:04one of the first things you do after you create the file is to set the start
00:08date for the Project.
00:09That way Project automatically starts task on that date, unless you tell it otherwise.
00:14You can specify other settings for the Project, like the calendar it uses to
00:18determine working and nonworking times, and whether you want to schedule the
00:22project from the start date or work backwards from the finish date.
00:26Here we have an exiting project, and it's showing the default view, which is the
00:31Gantt Chart at the top and the task form in the Details pane.
00:34You can see right now all of the tasks in this project are schedule to start today.
00:40The Project Information dialog box lets you set this project start date, the
00:44calendar of working and nonworking times, and a few other settings.
00:48In Project 2010, you click the Project tab and click Project Information to open
00:56the Project Information dialog box.
00:58When you set the start date for a project, tasks without start dates or
01:02predecessors automatically get the start date that matches the project start date.
01:07Project then uses predecessors and task dependencies to calculate the dates for
01:11autoscheduled tasks in your schedule.
01:14To set the start date, choose the date in the Start date field.
01:19In this case, say August 2nd. When I click OK, all of the tasks reschedule to the
01:26project start, date August 2nd.
01:29Going back into the Project Information dialog box, The Schedule from box is set
01:35to Project Start Date by default, and you should really leave it that way.
01:39Although executives might give you a finish date for a project, it's better to
01:43start from a start date to see when the project realistically can finish.
01:47If the finish date is too late, you can use several techniques to shorten the
01:51duration, like assigning more resources or running tasks simultaneously.
01:55If you try to work backwards by scheduling from the Finish Date, you lose any
02:00wiggle room on dates if the project goes awry.
02:03The Calendar box is set to Standard initially.
02:06Project's built-in standard calendar uses Monday through Friday as working days
02:10and 8 am to 5 pm with an hour for lunch as the work times, and most of the time
02:15standard calendar works.
02:16If you want to modify your working days and times, you can modify the standard
02:20calendar or create your own calendar, as you'll learn in the later movie.
02:24The Project also has a Night Shift Calendar and a 24 Hours Calendar built-in.
02:31When you have the settings the way you want, click OK.
02:34Then you can click File > Save, to save the project with those settings.
02:39To make sure that you adjust your project settings, you can tell Project to open
02:43the Project Information dialog box as soon as you create a new file.
02:47Click File, and then click Options.
02:50In the Project Options dialog box, click Advanced.
02:53In the General section at the top of the screen, turn on the Prompt for
02:57project info for new projects check box, and then click OK to close the Project Options dialog box.
03:05Then if you click New and create a blank project, the Project Information dialog
03:12box opens automatically, so you can change your settings.
03:15After you set the start date in the calendar, you're ready to work on building
03:21your project's schedule in earnest.
03:23As you start defining your project, the program calculates the finish date and
03:27shows that date in the Project Information dialog box.
03:30As you'll learn in the later movie, you also return to the Project Information
03:33dialog box once you begin tracking progress, to specify the current status
03:37date for your project.
Collapse this transcript
Setting up the project calendar
00:00The days and times that people work affect the duration of your project's schedule.
00:05Sure, you could get a seven-day, 12- hour-per-day working calendar to try to
00:08finish a project quickly, but people won't work at that grueling pace for long,
00:13and they'll quickly become less productive.
00:15If you have teams in different parts of the world, what's considered a standard
00:18workweek can differ significantly.
00:21In Project, you define calendars to specify the days and times that people work
00:26and the days and times that they don't.
00:27Project's Calendar options tell the program how to covert durations into hours of work.
00:33To keep calculations accurate, you have to tell Project the typical work hours
00:38for a week and month, for your organization's typical work schedule.
00:42To create or edit calendars, on the Project tab, click Change Working Time.
00:48In the Change Working Time dialog box, the For calendar box shows the calendar
00:54assigned to the project, and shows that by adding the words "Project Calendar"
01:00after the calendar name.
01:01A calendar identifies a set of working and nonworking days and time.
01:06You can assign a calendar to a project to specify the work times for the entire
01:10project, like your organization's standard workdays, the official start and end
01:15of the workday, lunchtime, and official holidays.
01:18You can define additional calendars for projects that follow a different
01:22schedule, like construction on an interstate highway bridge that runs from 9 pm
01:26to 5 am to minimize traffic jams.
01:29The easiest way to define your organization's working and nonworking times is by
01:33editing the built-in standard calendar.
01:35However, if you want to create a new calendar, click Create New Calendar.
01:39In the Create New Base Calendar dialog box, type the name for the calendar, such as LongWeek.
01:49If you select the Create new base calendar option, you have to define every
01:54aspect of the calendar.
01:55So it's usually quicker to copy one of the built-in calendars.
01:59To copy an existing calendar, leave the Make a copy of option selected.
02:03Then in the dropdown list, choose the calendar you want to copy, but in this
02:06case Standard is fine.
02:09Then click OK to save the new calendar.
02:12To edit a calendar, select it in the For calendar dropdown list, as it's shown here.
02:18If you set up calendars for resources, they'll appear at the end of this list.
02:27The Change Working Time dialog box has two tabs for the two approaches to
02:32defining working and nonworking days and times.
02:36Work Weeks are named just that because they represent the work schedules you
02:41usually follow, week after week.
02:43A workweek identifies the working and nonworking days of the week and the work
02:48hours for each workday.
02:49You can set up more than one work week if you work different schedules at
02:53different times of the year,
02:54for example a shorter summer workweek, or you can define an alternate work-
02:58week for a specific resource who's working fewer hours.
03:02You can't create a workweek and apply it to different time periods.
03:06Each time period with a special work schedule needs its own workweek.
03:10The default workweek sets weekdays as workdays and weekends as non-workdays.
03:16You can see here that Monday through Friday all have work hours, and Sunday and
03:24Saturday are nonworking days.
03:28The start and end work times come from the hours you specify in Project Calendar
03:32options, which you'll learn about shortly.
03:35The Start and Finish cells are filled in with NA, which means that the workweek
03:40applies to all dates.
03:43To set up a new workweek, click the first blank Name cell and type a name,
03:49LongHours for example.
03:54In the Start cell, choose the first date that the workweek applies, say October 1st.
04:02In the Finish cell, choose the last date.
04:04Let's say that's December 31st.
04:09The next step is to set up the workdays and times.
04:13With the Work Week selected in the table, click Details.
04:17The dialog box has the heading Details for 'LongHours' to show that you are
04:21setting the working and nonworking schedule for the LongHours workweek.
04:25You can select days in several ways.
04:28You can click a single day,
04:30you could drag over several days, like Monday through Friday, or you can
04:34Ctrl+Click non-adjacent days like Sunday and Saturday.
04:39If you select working days, say Monday and Tuesday, the work hours appear in the table.
04:45If you want to change your workday to a nonworking day, select the Set days to
04:50nonworking time option.
04:52On the other hand, if you want to change the work hours for a workday, or to
04:56change a nonwork day to a work day, select the Set day(s) to these specific
05:02working times option.
05:04Now that we've selected this option, we can actually edit the workdays
05:08for Monday and Tuesday.
05:09To change the work hours in an existing entry, you click the cell and then type the new time.
05:15Project selects the entire cell contents,
05:18so you can just start typing the new time.
05:21Click the last To cell and type 07:00PM.
05:27Actually, if you type a number from 7 to 11 without typing anything else,
05:32Project automatically adds AM to the time.
05:35Project adds PM to the numbers 12, and the numbers from 1 to 6.
05:41Project doesn't like overlapping times in different rows.
05:44If one row has work times of 1 PM to 5 PM and 4 PM to 5 PM in another row, the
05:51program complains when you click OK to close the dialog box.
05:55You have to get back into the Details dialog box by clicking OK in the warning
05:59message and just edit the times to get them right.
06:02To add a new row, click the first blank From cell and type a starting time.
06:08If you want to remove a row, drag across both the From and To cells, and then press Delete.
06:17To set times for other days, you can select those days and edit the times, and
06:21when you're ready, you can click OK to close the dialog box.
06:24I'm going to put in this starting time again, so our work schedule is correct.
06:31You use Exceptions mostly for nonworking time, but some working time can fit
06:37into the exception mold.
06:39Company holidays are a good example of exceptions.
06:43You name each one, like Thanksgiving Day, and choose the date range.
06:48If an exception lasts longer than a week, every day has to either be nonworking
06:53time or use the same work hours.
06:55For this reason, an exception can work for a factory shutdown or for a
06:59multi-day training class.
07:01You can also set up recurring exceptions to set aside the last day of every
07:04quarter for an all hands meeting.
07:07To create an exception, click the Exceptions tab and then click the first blank
07:12Name cell, and type a name for the exception, like Company Meeting.
07:19In the Start cell, choose the first date for the exception, say September 17th.
07:27In the Finish cell, choose the last date.
07:36Then click Details.
07:40The Details For dialog box shows the exception name, Company Meeting in this example.
07:46Because exceptions are often nonworking time, Project automatically selects
07:51the Nonworking option.
07:53If the exception is for a few days of different work times, select the Working
07:58times option, and fill in the Working times calendar.
08:02If an exception occurs on a regular schedule, you can set up a
08:05Recurrence pattern.
08:06For the quarterly meeting, select the Monthly option.
08:09You can choose a specific date in the month or a day, like the second Friday.
08:17Because it is a quarterly meeting, type 3 in the months box.
08:23The options you can choose vary based on whether the recurrence is daily,
08:27weekly, monthly or yearly.
08:30The range of recurrence tells Project how long the exception repeats.
08:33You can end it after a number of occurrences, or by a specific date.
08:38In this example, type 8 in the occurrences box to run the meeting for two years.
08:45Click OK to save the exception.
08:47Back in the Change Working Time dialog box, you can also assign a calendar to an
08:52individual or a group of resources to schedule around vacations, a half-time
08:57work schedule or other non -standard working times.
09:00You can even assign a calendar to a task, for instance to schedule a
09:04banking system cutover to run around the clock over the weekend to minimize
09:08service interruptions.
09:10When you finish working on calendars, click OK to close the Change Working Time dialog box.
09:15You can copy calendars using the Organizer.
09:22That way you can use them in other projects, or you can copy a calendar into the
09:27project Global template to share that calendar with all new projects.
09:32You will learn how to use Organizer in a later movie.
09:37You have to match a project's calendar options to its calendar working time to
09:41tell Project how to convert durations for working times into hours of work.
09:46To do that, on the File tab, click Options.
09:50Then click Schedule.
09:52The label, Calendar options for this Project, tells you that the calendar options
09:57apply to the project shown in the box.
10:00When more than one project is open, you can choose a different project name to
10:04assign calendar options to a different project.
10:07To adjust calendar options for all new projects - that means not existing ones -
10:13in the dropdown list, choose All New Projects.
10:17Project's default calendar options are perfect for your typical 40 hours workweek.
10:23Hours per day is set to 8 and Hours per week is set to 40.
10:28The Hours per day sets the number of work hours for a single workday, so in this
10:33case, 8 hours of work.
10:35If you use longer or shorter workdays, type the number of work hours in this box.
10:40And Hours per week defines the number of work hours in one week, so five 8-hours
10:45days in 40 work hours.
10:47Days per month converts between days and months, and is set to 20 workdays.
10:53That's basically for four weeks, each with five workdays.
10:56The Hours per day, Hours per week options have to match your work calendar if
11:01you want project's calculations to be correct. Say Hours per day is 6 hours.
11:06For a task with a two-day duration, Project multiplies the two days by six-hours
11:11per day to get 12 work hours.
11:13If someone is assigned to the task at 100% and works 8 hour day, as according to
11:18the project calendar, that's total of 16 work hours.
11:21You will see different work hours depending on whether you set the task duration
11:25in hours or days, but if you keep your calendar and calendar options in sync,
11:30the issue never arises.
11:32The Week starts on is set initially to Sunday, which is fine.
11:37If your corporate time tracking system, however, starts on Monday, change this
11:41setting so that both programs start on the same day of the week.
11:45Fiscal year starts in is important only if your corporate fiscal year starts
11:50in a month other than January, and you want to produce fiscal period reports in Project.
11:56For most tasks, the start time is based on when the predecessors tasks finish.
12:02Choose a time in the Default start time box for tasks that don't have predecessors.
12:08If you start you days earlier or later, change the time in this box.
12:13Default end time is for tasks in which you specify a task's finish date without
12:18specifying a finish time, and it's set to 5:00 PM initially.
12:23If your workday ends earlier or later, change the time in this box.
12:27Calendars tell Project about the working and nonworking times for the entire
12:31project, for specific resources, and in some cases, specific tasks.
12:36And they're one of the keys to how long task take and how long resources work.
Collapse this transcript
2. Creating Tasks
Creating a new task
00:00In the past, Project always calculated when tasks started and finished based on
00:05dependencies you created between tasks.
00:07If you wanted to fix a task's start or finish date, you could set a date
00:11constraint on the task.
00:13Project 2010 has two scheduling modes.
00:16Auto Scheduled mode makes tasks work the way they always have, with Project
00:20calculating their start and finish dates automatically.
00:23The new scheduling mode, Manually Scheduled, gives you control over task dates
00:28and comes in handy in several ways.
00:30Whether you create a manually scheduled or auto scheduled task in Project, the
00:34only thing you have to do is type a task name.
00:38Here's a project with some existing tasks.
00:40Let's look at the Identify potential sites task.
00:43Now, if you use project management software to help you schedule and manage projects,
00:48why would you want to start setting your own task dates?
00:51Well, one of the reasons is, early in project planning, you might not have all
00:56the information you need to define a task, and with Manually Scheduled tasks,
01:00you can start with a task name, and you can fill in the other details as you get them later.
01:05For example, you might know when the task will start, but you don't know
01:09how long it will take.
01:11With a manually scheduled task, you can leave the Date and Duration
01:14fields blank if you want.
01:16You can fill in specific dates, or the duration, or you can even fill in a field
01:21with a note about the information you don't have yet.
01:24For example, here you can talk to the realtor about when this is likely to start.
01:29The appearance of the taskbars in the Gantt Chart time scale shows what
01:34information is filled in or missing on manually scheduled tasks.
01:38See how the taskbar shows a cap at the start date, because that's the only
01:42information that you've provided so far.
01:45Let's look at the Review requirements with management task.
01:48In some cases, tasks have to occur on specific dates, like meetings, training
01:53classes, and conferences.
01:55Those tasks start, whether you are ready or not.
01:58You can type the dates in the Start or Finish fields of a manually scheduled
02:01task, and that's when the task is scheduled.
02:04This approach is also an easy way for a beginner to start managing projects.
02:08You can create tasks and set their start and finish dates without learning about
02:12task dependencies, date constraints, and other mysterious project features.
02:17The Review requirements with management task is manually scheduled for December
02:2215th, which happens to be the quarterly meeting of your head honchos.
02:27It doesn't matter whether you finish the budget and other requirements earlier.
02:31December 15th is the first day you can meet with the big kahunas to get
02:34their okay to proceed.
02:36As you'll learn in a later movie, you can also use a date constraint to set a
02:40task's start or finish date, but manual scheduling lets you fix both dates.
02:45With manually scheduled tasks, you can also plan a project from the top-down.
02:50Suppose your boss told you how long you have to complete a project, but you
02:54don't have any idea whether that length of time is sufficient.
02:57You can create manually scheduled summary tasks with the high-level
03:01durations you've been given.
03:03When you create tasks for the work in that summary task, you can see if you have enough time.
03:08Here, the black summary bar shows the duration you entered manually for the
03:12Planning Move summary task.
03:14The red bar shows the duration of all the subtasks.
03:18The bar is red, because it's longer than the duration you set for the summary
03:23task, and that means that you don't have enough time.
03:26If you change the duration to 90 days, the bar turns blue, because now you
03:31do have enough time.
03:32You can point to the bars to see the screentip with the information about the task.
03:37Now, let's look at another file to see how to create manually scheduled and
03:41auto scheduled tasks.
03:42In this case, we're going to open the OfficeMove_CreateTasks file.
03:48In the Open box, you can just double-click the file name.
03:52Project sets the Task mode to Manually Scheduled by default.
03:55The status bar shows the Task mode that's set for New Tasks to create.
03:59Since the Task mode is set to Manually scheduled, you can create a new manually
04:03Scheduled task by typing a name in the Task Name cell.
04:07When you type the task name, press Enter.
04:10The entry table shows the Task mode in the column to the left of the Task Name.
04:15The pushpin shows that the task is manually scheduled.
04:18The question mark means the task duration and date information is complete.
04:23To start this task on January 10th, 2011, click the Start cell.
04:28Click the down arrow, and in the calendar, go to the date that you want.
04:33A black bracket appears at the start date in the Gantt Chart time scale to show
04:37that you've set the start date.
04:39With manually scheduled tasks, you type placeholder text when you don't have
04:43the information yet.
04:44Say you're waiting for Marco to give you an estimate of the duration of this task.
04:49Click the Duration cell and type a note.
04:52Project fills in this cell with your note, but nothing changes in the time
04:56scale, because you haven't provided a duration yet.
04:58When you get the estimate from Marco, say four weeks, in the Duration cell,
05:03type "4w" and press Enter.
05:06Project changes the value to four weeks and draws a teal taskbar that spans the
05:11four weeks in the time scale.
05:13Because you've provided two values, the Start date and the Duration, Project
05:18calculates the Finish date for you.
05:21The black bracket at the Finish date at the task shows that.
05:24The question mark on the Task mode icon disappears as well, because the task
05:28duration and date info is now complete.
05:31Project has another look for manually scheduled tasks with duration, but no dates.
05:36In the next blank Task Name cell, type "Choose location."
05:41In the Duration cell, type "1w," for one week and press Enter.
05:46Project starts the task at the project start date, January 10th, 2011, but
05:51because you haven't given any dates, the taskbar is a shaded bar with no end
05:56brackets, to show that the task has only a duration.
06:00To create a new auto scheduled task, type the task name, say Define budget.
06:05In the Task mode cell, click the down arrow and choose Auto Scheduled.
06:10Because the task is auto scheduled, it has to have a duration, start and finish date.
06:15Project sets the duration to one day with a question mark
06:19to show that it estimates the duration at one day.
06:22It also sets the Start date to the project's start date and calculates the
06:26Finish date for you.
06:28The taskbar for an auto scheduled task is a blue bar instead of the teal color
06:32for manually scheduled tasks.
06:34If you changed the duration, Project recalculates the finish date.
06:38Type "5d" in the Duration cell and press Enter, and the Finish date is
06:43recalculated to January 14th, 2011, and the taskbar gets longer in the time scale.
06:49The question mark on the Duration also disappears, because you actually
06:53provided a duration.
06:54Whether you create auto scheduled or manually scheduled tasks, you start
06:58by typing a task name.
07:00Then you can fill in other fields, like duration or dates if you want, but for
07:04manually scheduled tasks, you can leave fields blank, fill them in with
07:08estimated values, or type placeholder notes about the info you still need.
Collapse this transcript
Creating a milestone
00:00Another popular category of task is the milestone.
00:04A milestone is a great way to show when you've reached a key point in the project:
00:08a software module tested, a construction walkthrough completed, or even better -
00:12a customer acceptance that triggers a payment.
00:14Milestones have zero duration,
00:16so you can add as many to a project as you want without increasing the length of
00:20the project or taking up resources time.
00:22Project 2010 offers a command specifically for creating milestones.
00:26To create a milestone, go to the place that you want to insert the milestone in
00:31your project and select the task that follows the milestone.
00:35Then to create a milestone task, on the Task tab, click Milestone.
00:41Project fills in the task name cell with a generic name, New Milestonem and
00:45selects the text, so you can start typing the name of the milestone, Planning
00:49complete in this example.
00:51When you press Enter, you can see that the Duration is automatically set to zero
00:55days, the earmark for a milestone task, and the task shows up as a diamond in
01:00the Gantt Chart time scale.
01:02Now that we have the milestone, what you would do is to link the milestone to
01:07the previous tasks that represent the work completed by the milestone, and
01:12you'll learn how to link tasks in a later movie.
01:15Creating a milestone is a breeze in Project, now that there's a command for
01:19milestones on the Ribbon.
Collapse this transcript
Creating a summary task
00:00Project 2010 includes the Insert Summary Task command on the Task tab of the Ribbon.
00:06This command lets you create a brand- new summary task with one new subtask, or
00:10you can use it to create a summary task for several existing subtasks, ideal for
00:15organizing your tasks into a hierarchy.
00:17If you're trying to see if the time you've been given by the Project customer is
00:21long enough, manually scheduled summary tasks are just the ticket.
00:24Project can keep track of the duration you give a summary task, and the total
00:29duration of all the subtasks, and show you whether the work fits in the time you have.
00:33In this example, we have the OfficeMove_SummaryTasks project open.
00:38If you forgot some tasks in your plan, you can insert a new summary task
00:42with one new subtask.
00:44Click the first blank row in the Task table.
00:46On the Task tab, click Summary.
00:49Project inserts a new summary task with the creative name of New Summary Task,
00:54and one new subtask called New Task.
00:56The New Summary Task name cell is selected, so you can just type the name for
01:01the task, Identify costs, and press Enter.
01:04In the New Task cell, type the name of the subtask.
01:08You can move these tasks to where they belong in the list.
01:12Drag over the task ID cells, 31 and 32 here.
01:16The pointer changes to a four-headed arrow.
01:19Drag the pointer until it is over the task below where you want the selected
01:23tasks, Hire contractors in this example.
01:27When you release the mouse button, the tasks drop into position.
01:31If you want to make several existing tasks subordinate to a new summary task,
01:36select those tasks in the Task table.
01:38For example, drag over the phone- related tasks from Evaluate phone system needs
01:44to Order long-distance service.
01:46On the Task tab, click Summary.
01:49Project inserts a new summary task and makes the existing tasks one level
01:55lower in the outline.
01:56The New Summary Task name cell is selected, so you can type the name for the task.
02:01With manually scheduled summary tasks, you can plan a project from the top-down.
02:06Suppose your boss told you how long you have to complete a project, but you
02:09don't have any idea whether that length of time is sufficient.
02:13You can create manually scheduled summary tasks with the high-level
02:16durations you've been given.
02:18For example, let's look at the Construct office space task.
02:22This summary task is manually scheduled, because you can see the pushpin in the
02:26Task mode cell, and the duration is set to eight weeks.
02:30That's the time frame your boss gave you.
02:32The red bar shows the duration of all the subtasks.
02:36The bar is red, because it's longer than the duration that you've given for the summary task.
02:42If you change the duration to 10 weeks, the bar turns blue, because now you have
02:48enough time to complete all the subtasks.
02:51Organizing your tasks into summary tasks and subtasks makes it easier to keep
02:56track of the work you're doing, and what you've accomplished.
02:59The Insert Summary Task command on the Ribbon can help whether you're building
03:02brand-new summary tasks or turning existing tasks into subtasks, and with manual
03:08scheduling, you can also compare timeframes you have to work with to the
03:11durations that Project calculates.
03:13This top-down planning helps you see whether you have to find a way to shorten
03:17your schedule, or you have some wiggle room if delays crop up.
Collapse this transcript
Creating a recurring task
00:00It would be unbelievably tedious to create each occurrence of a task that
00:05occurs on a regular schedule, like status meetings, software reviews, or
00:10management presentations.
00:11In Project, you can create recurring tasks.
00:14You set up the basic information about an individual occurrence and tell
00:18Project the frequency.
00:19The program creates individual tasks for each occurrence and a summary task to hold them all.
00:25You can insert a new recurring task anywhere in your task list.
00:28In this example, click the blank Task Name cell at the end of the task list.
00:33Then, on the Task tab, click the Task down arrow and choose Recurring Task.
00:40In the Recurring Task Information dialog box, in the Task Name box, type the
00:45name for the recurring task, like Status Meeting.
00:49The Duration box is set to one day, which is the duration for one occurrence, in
00:54this case, one Status Meeting.
00:56In the Duration box, you can type the duration, like one hour for a
01:00mercifully brief meeting.
01:02The Recurrence pattern section is where you tell Project about the frequency.
01:07You can choose one of the frequency options: Daily, Weekly, Monthly or Yearly.
01:13If you select the Daily option, you can choose how many days
01:17between occurrences.
01:19Select the days option to schedule the occurrences for working or nonworking days.
01:24Select the workdays option to schedule only on workdays.
01:28If you select the Weekly option, you can choose the days of the week.
01:32Turn on the check box for each day of the week you want in occurrence.
01:35For example, to have a status meeting every other Friday, turn on the Friday
01:40check box and tell it to recur every two weeks.
01:44If you select the Monthly option, you can select a day of the month or a
01:48particular day of a particular week of the month. And if you pick Yearly, you
01:53can also pick a date or a particular day within that year.
01:57In this example, we'll go with the Weekly to have a Status Meeting every other Friday.
02:01The Range of recurrence section is how you tell Project how long the
02:05recurring tasks should recur.
02:07In the Start box, set a date before the first occurrence.
02:11In this case, we'll start in October of 2010.
02:15You can set a number of occurrences.
02:18Select the End after option and type the number of occurrences you want, or you
02:23can select End by and give an end date.
02:26If your project runs longer than you planned, Project doesn't automatically
02:29extend recurring tasks.
02:31You have to edit the task to add more occurrences or create a new task for the extra ones.
02:36When you've set all of your options, click OK to create the task.
02:40Project inserts the new summary task into the task list.
02:44To see all the individual occurrences, click the Plus sign, and if you want to see
02:48all the occurrences in the timescale, click Scroll to Task.
02:52The indicator column has a circular icon with arrows, to indicate the task is a recurring task.
02:59You can view the frequency and range for the task by hovering the pointer
03:03over the indicator.
03:05To open the Recurring Task Information dialog box, double-click the task's summary name.
03:10Creating a recurring task is an easy way to set up a bunch of individual tasks,
03:15as long as they recur on a regular schedule.
03:18Project creates the individual occurrences according to the frequency you set,
03:22and creates a summary task to hold all the occurrences for you.
Collapse this transcript
Copying and organizing tasks
00:00Most Project team members use Word, Excel, and Outlook,
00:04so it's easy to get task information from them in Word documents, Excel
00:08spreadsheets or e-mails.
00:10You can also copy tasks within your Project task list.
00:13Copying project tasks saves time when you do the same sort of work in different
00:17summary tasks or phases,
00:19like the same construction tasks for several buildings on a corporate campus.
00:23Whether you're creating your initial task list or revising it, you can organize
00:27your tasks at any time, insert new tasks, or delete tasks you don't need.
00:31You might want to move task to another place in the task list to rearrange your
00:35work breakdown, or to put the tasks in the order in which they occur.
00:39Suppose your teams define the tasks they will perform and send you the Word
00:43documents or e-mails.
00:45Here is a Word document with some tasks.
00:47You can copy the text from this file, or from an e-mail, and paste it into Project.
00:52Project 2010 can translate indents in Word documents, Excel spreadsheets, and
00:58Outlook e-mails into outline levels, so you can paste in summary tasks and
01:02subtasks in one fell swoop.
01:04In this example, the Word document has task names only.
01:08The summary tasks are at the left margin.
01:11The subtasks are indented.
01:13Select the tasks and press Ctrl+C to copy them, or on the Home tab, you can click Copy.
01:20Then switch over to Project.
01:23Click the first blank Task Name cell in the table.
01:27To paste the project, you can press Ctrl+V, or on the Task tab, you can click Paste.
01:33The task names flow into the Task Name cells, starting with the first cell you've selected.
01:38Project indents the tasks, based on the level they were indented in Word or Outlook.
01:44In addition, Project copies the highlighting on the two milestone tasks from the Word document.
01:49You can choose to keep the formatting from Word or Project.
01:53If you look closely, you see an option indicator to the left of the first Task Name.
01:58Click it and a dropdown menu appears.
02:00You can choose to keep the source formatting or match the
02:03destination formatting.
02:05If the tasks you want to copy are already in your task list, the steps are even easier.
02:11You can select several tasks to copy by dragging the pointer over all the
02:15task ID cells you want.
02:17In this project, click task ID 4 for Review with management.
02:21If you click only one cell in the Task row, the Copy command copies only
02:25the value in that cell.
02:26The pointer changes to a four-headed arrow.
02:29Press Ctrl+C to copy the task to the clipboard.
02:32To paste the task, click the task row where you want the copy.
02:36For example, select the last row and press Ctrl+V. If you forget a task, you can
02:41insert it into your existing task list.
02:44Say you forgot to schedule a walkthrough of the new Office Space.
02:48To insert a new task between two tasks, click the lower task row, Repair new
02:53office, in this example.
02:56On the Task tab, click Task.
02:59The task comes in at the same level as the task below it.
03:03The Task Name cell says New Task, so just start typing the task name, and press Enter.
03:09If the task isn't at the outline level you want, click Indent Task or Outdent Task.
03:14You can also insert a summary task into the list, as you learned in an earlier movie.
03:19If you want to move tasks, you can drag them to where you want them,
03:22perhaps another part of your work breakdown or to arrange them in the order
03:26in which they occur.
03:27Click the task ID cell to select the entire task row.
03:31In this project, click the Obtain necessary permits task.
03:35The pointer changes to a four-headed arrow.
03:38When you drag the task, you see a horizontal line that shows where the task will
03:42drop, just above the hire contractors task.
03:45If that's where you want it, just release the button to drop the task into place.
03:50To delete a task, just select its ID cell and then press the Delete button.
03:55If the task is a regular task, Project deletes it.
03:58If you delete a summary task, Project asks you if you want to delete the summary
04:02task and all its subtasks.
04:04You can click OK to continue with the delete or cancel.
04:07If you want to delete a summary task without deleting its subtasks, first
04:12outdent the subtask to the same level of the summary task.
04:15For example, select these two subtasks and then outdent them.
04:20Then you can select the summary task and press Delete to delete it.
04:24If you see an indicator, you can click it to delete the entire task or just the
04:29contents of the Task Name cell. In this case, select Delete the entire task.
04:34You can identify summary task by the Plus or Minus signs to the left of the name.
04:39Click on minus to collapse the summary task and hide its subtasks.
04:43Then if you want to see them again, just click the plus to expand the summary task.
04:48Copying task information from other Office programs like Word, Excel, and Outlook
04:53is much easier with Project 2010.
04:55Project can recognize outline levels and formatting that comes from those other
04:59programs, but you can also fine-tune task organization in Project, insert or
05:04delete tasks, move or copy them, or you can change the outline level to change
05:08subtasks into summary tasks, or vice versa.
Collapse this transcript
Displaying summary tasks and WBS codes
00:00Most of the time you want to see summary tasks in Project because they make it
00:04easier to digest what's going on.
00:06But sometimes you want to see just the lower-level tasks, for instance to assign
00:10resources to tasks or to check progress.
00:13Displaying or hiding summary tasks is much easier in Project 2010 - the check box
00:18you need is right on the Ribbon - and the same goes for the project summary task.
00:22Work Breakdown Structure codes, also known as WBS codes, uniquely identify each
00:28task in your project.
00:29Initially, Project uses the outline number as the WBS code.
00:34But you can also build a custom WBS using a code mask to tell Project what each
00:40level of your WBS code should look like.
00:43Showing and hiding summary tasks is really easy in Project 2010.
00:48On the Tasks tab, you can choose the view that you want, for example, the
00:52Tracking Gantt that we are showing here.
00:54Then click the Format tab.
00:56If you want to hide the summary tasks, just turn off the Summary Tasks check box
01:02and all you see are the lowest level tasks.
01:04To bring the Summary tasks back, just turn on the check box again.
01:08The project summary task is a good tool for checking project-wide values like a
01:13full project duration, the project finish date and the total project cost.
01:18To see this task, just turn on the Project Summary Task check box.
01:22The project summary task is like an ultra-top-level summary task, and it has a
01:27special task ID of zero.
01:30On the other hand, the WBS code is a field you have to insert into a table.
01:35To add the WBS field to a table, right- click a column heading and choose Insert
01:40Column. The dropdown list shows all the task fields Project has to offer, but in
01:46this case it's just easier to type WBS and then press Return.
01:50Project selects WBS in the list and inserts it into the table.
01:55If you want to set up your own format for WBS, click the Project tab and then click WBS.
02:02On the dropdown menu, choose Define Code.
02:06The WBS Code Definition dialog box opens.
02:10The first box you come to is the Project Code Prefix.
02:15The only time you need to set this is when you add several projects to a master project.
02:20By defining a unique project code prefix for each project, the WBS codes in
02:25the master project will be unique, even if the individual projects use the same code mask.
02:30For example, you can make the prefix something like Offmv, for office move.
02:37To get down to business with the code mask, click the first sequence cell and
02:42click the Down Arrow.
02:43As you can see, you can use numbers, letters, or a combination of the two.
02:48For example, you can abbreviate phases, and use something like Tst for test, while
02:54using Numbers for lower-level Summary Tasks, and letters for subtasks.
02:58Choose the type of character you want for the highest level of the hierarchy.
03:02Ordered numbers and letters mean that Project increments the numbers or letters
03:06as you add task to the WBS.
03:09For example, ordered numbers go from one to two to three.
03:13Characters (unordered) means you can mix numbers and letters, and Project won't
03:18increment the values.
03:19That way you can provide your own code.
03:22In this case, we will start with Ordered Numbers.
03:25In the Length cell, Project fills in any, which means the entry can be any length.
03:30But keep in mind a WBS code can only be up to 255 characters.
03:36So keeping the lengths to less than four makes your full WBS codes more manageable.
03:41For ordered numbers, Project increments the number until it reaches the
03:45limit based on Length.
03:46For Characters, you can type as many letters and numbers as you want.
03:50If you choose a length, the entry at that level can be between one character
03:54and the length you set.
03:55For example, if you set a number to a length of two, Project numbers that level
04:00from one to 99 and then starts over at one.
04:02We will leave the top level at Any Length.
04:05In the Separator cell, choose the character to separate the top level from the next level.
04:11You can use a period, a hyphen, a Plus sign, or a forward slash.
04:17In the next row, repeat steps to get the sequence, length, and separator for the
04:22second level. In this case I will use uppercase letters, set the length to 3, and
04:30keep the period as a separator.
04:32I will use lowercase letters, at the length of 3 for the third level and go back
04:38to Ordered Numbers with a length of 2 for the final level.
04:43The Code Preview box at the top of the dialog box shows a sample of the code
04:48mask you have built so far.
04:50The Generate WBS code for new task check box is turned on, and you really want
04:55to keep it that way.
04:56It tells Project to automatically assign a WBS code to each new task you create.
05:01You also want to keep the Verify uniqueness of new WBS codes check box turned on.
05:06That way Project will warn you if you create a duplicate WBS.
05:10This warning comes in handy if you decide to manually renumber a few tasks and
05:14make a mistake. When you are done setting the code mask click OK.
05:17Now you can see all of the WBS codes for the tasks in this project.
05:23Project automatically assigns WBS code's tasks as you create them.
05:27But if you rearrange your task list your WBS will be out of sequence.
05:32As long as you haven't used the WBS codes for anything, like naming the
05:36documents that define work packages, you can renumber the WBS codes in your
05:41project to neaten things up.
05:43On the Project tab, click WBS and choose Renumber.
05:47Make sure that the Entire Project option is selected and click OK.
05:52Then to proceed with renumbering, click Yes.
05:55Project reapplies the WBS codes putting ordered letters into alphabetical order
06:00and ordered numbers into sequence.
06:02Showing and hiding summary task is something you do a lot, and all it takes is
06:06turning on a check box.
06:08But to see WBS codes, you have to add WBS field to a table and project.
06:13You can use the basic WBS format that comes with Project or set one up to match
06:18what your company uses.
06:20It's your choice.
Collapse this transcript
Linking tasks
00:00A task's Start or Finish Date is often determined by the Start or Finish
00:04dates of other tasks.
00:05A predecessor task determines when a successor task starts or finishes.
00:09These associations between tasks are usually called task dependencies, but they
00:13also go by the names links and relationships.
00:16A task link is all about one task controlling the timing of the other, with
00:20finish to start dependencies, the predecessor starts first, and when it finishes,
00:25the successor task begins.
00:27Because finish to start dependencies are so common, the Link Task command
00:32creates only that type.
00:33In this example, you dig a trench, and when the trench is done you pour
00:37concrete in the trench.
00:39If the two tasks are adjacent, you can drag over the first and then the second task.
00:45On the Task tab, click Link Tasks.
00:48The link line between the tasks appears in the Timescale.
00:52The Link Task command also makes it easy to link two tasks when you can't see
00:56both in the view at the same time.
00:58You can click the predecessor first and then Ctrl+Click the successor.
01:02When the start of one task controls the start of another task, you use a start
01:06to start dependency.
01:07For example, when you start registration for a conference, you can start
01:12recording the registrations you receive.
01:14Several places in Project let you create any type of task dependency.
01:18The Task Form in the Details Pane is the easiest.
01:22To work with links, right-click the Task Form and choose Predecessors & Successors.
01:28Select the Predecessor, which is Start Registration.
01:32Then in the Task Form, click the Successor name cell, click the down arrow, and
01:38choose Record submitted registrations.
01:41In the Type cell, type SS, for start to start, and click OK.
01:47You see the start to start link in the Timescale.
01:50With a finish to finish dependency, the finish of one task triggers the finish of another.
01:56When you finish recording registrations, you also finish sending confirmations.
02:01You can work on task dependencies in the Task Information dialog box.
02:05Select the Send confirmations task and then on the Task tab, click Information.
02:12In the dialog box, select the Predecessors tab.
02:15The Task Information dialog box only assigns predecessors to the selected task.
02:20Click the Task Name cell and click the down arrow and choose Record
02:25submitted registrations.
02:27In the Type cell, choose Finish-to-Finish.
02:30Click OK to create the link and close the dialog box, and you can see the
02:35Finish-to-Finish link line in the Timescale.
02:37Start-to-finish dependencies are rare, which is good, because they could be confusing.
02:43The start of one task triggers the finish of another.
02:46So the predecessor actually occurs before the successor.
02:50For example, the start of the Get married task rings in the finish of the Be single task.
02:57Sometimes there is a delay between the predecessor and the successor, which
03:01is called lag time.
03:02For example, when you finish recording registrations, it takes a few days to
03:07catch up on sending confirmations.
03:09Select the Record submitted registrations task.
03:13To continue sending confirmations for two days after recording registrations in
03:18the Lag cell down in the Task Form, type 2D and then click OK.
03:24On the other hand, some tasks can overlap a little bit.
03:26You can overlap tasks, called lead time, by entering a negative value in Lag field.
03:32Project tries to help by automatically editing task dependencies when you insert,
03:37move, and delete tasks.
03:39If you insert a new task between two existing tasks, Project removes the
03:43existing link and create finish-to- start dependencies between all three tasks.
03:47To prevent Project from providing this assistance, click File and then Options.
03:54In the Project Options dialog box, click Schedule.
03:58Make sure that the Autolink inserted or moved tasks check box is turned off, as
04:03it is here. Click OK to close the dialog box.
04:07Most of the time creating task dependencies between tasks is all you need to put
04:11tasks into sequence to build your project's schedule.
Collapse this transcript
Setting task dates
00:00Most of the time, you don't want to interfere with Project's ability to calculate
00:04the schedule, or you'll end up micro-managing your tasks.
00:07But sometimes you have to restrict task dates.
00:11In Project 2010, you can use manually scheduled tasks or date constraints to do this.
00:17But each method has its pros and cons.
00:19Whether you use date constraints or manual scheduling to set task dates, you
00:24reduce the flexibility of your schedule.
00:26So use these features sparingly.
00:29In an earlier movie, you learned how to create manually scheduled tasks.
00:33Now let's look at setting date constraints. Because you don't set date
00:37constraints very often, the Task Information dialog box is a great place to make this change.
00:43Select the task you want to work on, Schedule open house for employees, for example.
00:48On the Task tab, click Information, then click the Advanced tab.
00:55Every task in Project actually comes with a date constraint,
00:58although most of the time the constraint is completely flexible, like the As Soon
01:02As Possible constraint.
01:04Other day constraints, like Must Start On, make tasks occur on specific dates, a
01:10lot like manually scheduled tasks.
01:12The one difference is that a date constraint controls either the start or the
01:16finish, while you can set both dates with a manually scheduled task.
01:21In Project 2010, the main reason to use a date constraint instead of manual
01:26scheduling is to create a partially flexible constraint.
01:29For example, you want a task to start after a specific date, but anytime
01:34after that date is fine.
01:36As Soon As Possible means the start and finish date are scheduled as soon as
01:41possible, based on the task length, the duration, resources, and work times.
01:46As Late As Possible is also flexible, but it doesn't leave any buffer for delays
01:52if something goes wrong.
01:53On the other hand, Must Start On and Must Finish On are completely inflexible.
01:58They set dates for a task with no wiggle room whatsoever, and then the other
02:02types are partially flexible.
02:04Start No Earlier Than means a task has to start after a certain date, but then
02:10it can start anytime after that.
02:12For example, the open house for employees has to start after the office
02:16construction is complete but can be anytime after that.
02:20In the Constraint type box, if you choose Start No Earlier Than, then you also
02:25have to choose the constraint date.
02:27In this example, let's choose September 1.
02:30Then click OK to set the task with the date constraint.
02:34You can also set date constraints in the Task Details form.
02:38Click the View tab, and then in the Details dropdown list, choose More Views.
02:44In the More Views dialog box, double-click Task Details form.
02:49In the Constraint box, you can choose a constraint that you want and choose the date.
02:54If you want to get rid of lots of date constraints, a table is the easiest place to do that.
02:59Right-click a column heading and choose Insert Column on the shortcut menu.
03:03In the dropdown list, choose Constraint Type.
03:06You can start typing the name of the field and then choose it when you see it in the list.
03:12Choose the constraint type you want to use, which is usually As Soon As Possible.
03:18You can drag a constraint type from cell to cell by dragging the rectangle from
03:23the lower-right corner of the cell across other cells.
03:28When the crosshair turns to a plus, just drag down the other cells that you want.
03:33Sometimes date constraints seem to materialize out of thin air.
03:36Actually, you can create date constraints without realizing it, if you aren't careful.
03:41If you drag a taskbar horizontally in the Timescale, Projects sets at start no
03:46earlier than constraint.
03:47Date constraints let you restrict one date with different levels of flexibility.
03:52Manually scheduled tasks are great for pinning both dates to the calendar,
03:57so pick whichever method is best for the task at hand.
Collapse this transcript
Switching between manual and automatic scheduling
00:00A project can have a combination of auto scheduled and manually scheduled tasks.
00:04In Project, you can set an option for the Task mode you use most of the time,
00:09but you can switch between modes in a flash.
00:11The Entry, Schedule, and Summary tables include the Task mode column.
00:16To display one of these tables, right-click the All Cells box at the
00:21intersection of the column headings in the task ID rows. Then you can choose
00:25the table you want.
00:26If you want to change the Task mode for an existing task, just click the
00:30task's Task mode cell,
00:33click the down arrow, and click the mode that you want.
00:36You can also add the Task mode field to any table.
00:40If I pick a table that doesn't have the Task mode, I can right-click a column
00:44heading and choose Insert Column, and then start typing the field name.
00:50When I see it in the list, I can choose it to insert the column.
00:54If you want to change the scheduling mode for all new tasks, you can set a
00:58scheduling mode option in Project.
01:00Click File and then choose Options.
01:04In the Project Options dialog box, click Schedule. Under the Scheduling options
01:09for this project heading, click New tasks created dropdown list and choose
01:14Manually scheduled or Auto Scheduled for the Task mode that you want for all new
01:19tasks that you create in the future.
01:21And if you want to use that scheduling mode for all new projects, in the
01:25Scheduling options for this project dropdown list choose All New Projects.
01:30Keep in mind manually scheduled tasks work only in Project 2010 format files.
01:36If you save a project file with a manually scheduled task to an earlier file
01:40format, the tasks go back to the old standard of auto scheduled.
01:45Click OK to close the Project Options dialog box.
01:48There is one more way to switch between auto scheduled and manually scheduled.
01:53In the Status Bar, you can click New Tasks, and then choose the mode that you
01:58want for new tasks that you create.
02:00So go ahead and set the mode that you typically use.
02:04After that, you can switch modes for one task, or all new tasks, whenever you
02:08need to.
Collapse this transcript
3. Creating Resources
Understanding resources
00:00Projects need resources, people to do work, equipment, materials, travel to
00:06scope out a location, and so on.
00:08Project comes with several types of resources to model the resources you use in the real world.
00:13After you define project tasks, you can start identifying the resources you need.
00:18When you add those resources to Project you tell the program how much the
00:21resources cost and how much they're available.
00:24Then when you assign resources to tasks, Project can calculate the schedule and
00:28cost, identify overallocations, track progress, and provide information about
00:33your project's performance.
00:34To see the resources in a project, on the View tab, click Resource Sheet.
00:40Project offers several types of resources.
00:43The Work resource type is the one you'll use most often, but Material and Cost
00:48resources come in a close second and third.
00:51Time is the critical factor with work resources.
00:54People and equipment are available to work only so many hours in a day, and even
00:58then, they might not be available to work full-time on your project.
01:02For example, the IT manager is available only 25% of the time on the office
01:08move project, because the rest of her time is spent keeping the IT
01:12infrastructure up and running.
01:13Resources can have their own calendars, which is great for setting aside a
01:17resource's vacation time or specifying a nonstandard workweek.
01:22Work resources availability affects the project schedule.
01:26In this case, the amount of time that's available is listed in the Maximum unit's column.
01:31At the same time, you can see that Project doesn't care whether you use people's
01:34names or generic titles.
01:37Using titles or skills as placeholder names means you can figure out how many
01:41resources you need with different types of skills.
01:44Then when you obtain warm bodies, you can add their names to your project file
01:48and replace the placeholder resources with real people.
01:51Work resources costs usually depend on the amount of time you use them,
01:55whether you pay an electrician by the hour or ran a crane by the day.
01:59The IT manager's hourly rate is $80 per hour.
02:04With materials, you use quantities, not time.
02:08The cost of materials do affect the cost of your project, and for material
02:13resources, the material label field is where you tell Project the units
02:18you use to measure the material, whether it's cubic yards of concrete, gallons of
02:22paint, or reams of paper.
02:24For example, with a brochure, you pay for it by the piece.
02:29The only time materials affect the schedule is when you have to wait for the
02:33materials to arrive.
02:37On the other hand, Cost resources are specifically for additional costs not
02:42related to work or material resources.
02:45Travel, fees, utilities, mobile phone usage are all examples of pure costs that
02:51work well as cost resources.
02:54With cost resources, you could track how much you spend on different types of costs.
02:59If you assign the lodging cost resource to each task that requires an overnight
03:04stay, you can see the total cost for lodging.
03:07If you have cost resources for airfare and for mileage, you can compare how much
03:11you spend for flying versus driving.
03:13The Cost resources work a little differently than Work and Material resources.
03:19You don't apply a cost when you create a cost resource;
03:23instead, you assign the cost when you apply the resource to a task, as you'll in a later movie.
03:29Work resources are perfect for resources you use for periods of time, like
03:34people and equipment.
03:35Material resources handle the supplies and other consumable items you use to
03:40complete a project, and cost resources take care of pure cost items, like travel and fees.
03:45Between these three resource types, you can document everything you need
03:49to perform a project.
Collapse this transcript
Creating a work resource
00:00A work resource, like a person or a piece of equipment, is limited by the
00:04time it's available.
00:05A person can't work 24 hours a day without eventually melting into a puddle
00:10of unproductive goo.
00:12Even equipment needs some time off for maintenance.
00:15In addition to entering information like name, initials, and workgroup, you can
00:19tell Project how much a resource is available and the resources work schedule.
00:24The Resource Sheet is the easiest place to create and add basic
00:28information about resources.
00:29If it is not visible, you can click the View tab, and click resource sheets to display it.
00:36The entry table that you see contains the basic fields for work material
00:40and cost resources,
00:42so it's a great place to start when you're creating all types of resources.
00:46Click the first blank resource name cell and type the name of the resource.
00:51A standard like last name, first name helps you find resources later on.
00:55But you can also create generic resources for a skill set, by using the job
00:59description as the resource name, like IT admin.
01:06When you get people assigned to work on your project, you can replace the
01:09resource name with the person's name.
01:12Keep in mind you can't use commas or brackets in resource names.
01:16When you press Enter, Project automatically fills in the Type field with work,
01:20so you can leave this cell as it is.
01:22For work resources, you can't type anything in the Material cell.
01:27So Initials are the next thing that you enter.
01:30Project initially fills in the Initials field with the first letter of the
01:34resource name, but that results in lots of duplication in meaningless initials
01:39for all but the smallest projects.
01:40So be sure to type the person's first and last initials or an abbreviation of
01:45the job description.
01:47Initials are great when you want to see who is assigned to a task in the Gantt
01:51Chart Timescale, without having the resource names hogging the screen.
01:56The Group field can represent any type of category you want: departments,
02:01subcontractors versus vendors, or skill sets.
02:04In addition to grouping resources in the Resource Sheet, you can use the Group
02:08field to filter the task list to tasks performed by the specific workgroups, or
02:13to group tasks by the type of resource required.
02:17The Maximum units field is where you tell Project what percentage of time the
02:21resource is available for the project.
02:24For example, most resources work full-time during normal working hours,
02:28so Project automatically fills in 100%.
02:32For people who work part-time, you can change the percentage,
02:37for instance 60% for people who work three days a week, or 50% for people who
02:40work four hours each day.
02:44You can even tell Project that a resource is really a five-person team by
02:48setting the Maximum units to 500%.
02:51A resource's availability actually depends on the Maximum unit's field and
02:56the resources calendar.
02:58If a resource works the regular work schedule, maximum units of 100%
03:02represents 40 hours a week.
03:05But if a resource calendar has work time as Monday through Friday and four -hour
03:09work days, maximum units set to 100% represents only 20 hours a week.
03:16Project also sets the Base calendar cell to the calendar you use for the
03:20project, standard in this example.
03:22You learned about creating calendars in an earlier movie.
03:26If you want to assign a different calendar for a resource, for instance night
03:31shift, choose the calendar in this cell's dropdown list.
03:36The Code field provides another way to categorize resources, which you can then
03:41use to sort, filter, or group tasks and resources.
03:45If your organization assigns job codes, you can enter them in the Code field and
03:50then filter for tasks that require a specific job code.
03:53If you type a resource name into an assignment and the resource name doesn't
03:57exist in your project file, the program adds a new resource with default values for you.
04:02That can save a lot of time because you don't have to switch to the Resource
04:05Sheet to create a resource before you assign it.
04:08But if you type the name incorrectly, you could end up with two resources in your
04:12project file for a single resource in the real world.
04:15To get Project to tell you when it creates a new resource, click File and
04:20then click Options.
04:22In the Project Options dialog box, click Advanced. In the General Options for
04:28this project section, turn off the Automatically add new resources and tasks
04:33check box and click OK.
04:37You can also enter or edit resource information in the Resource
04:41Information dialog box.
04:44To open this dialog box, click Resource and then click Information.
04:49In fact, this dialog box provides access to a lot more resource fields, like
04:54variable cost rates and availability.
04:57When you finish setting the values for a resource, click OK to close the dialog box.
05:02With Work resources, you tell Project how much the resource costs and how much
05:07it's available to your project.
05:09With that information, Project can calculate the project schedule and cost
05:13for you.
Collapse this transcript
Creating a material resource
00:00A material resource represents tangible items used up by the project, like
00:04gallons of gas, reams of paper, cubic yards of concrete, or bottles of wine for
00:09the new office open house.
00:11Material resources don't have a regular time component like work resources.
00:16They can sit around waiting until they're needed.
00:18So you can skip several fields that you fill in for work resources.
00:22To create a material resource, start on the Resource Sheet.
00:26The entry table that appears has all the fields you need to set up
00:29material resources.
00:31As you do, for Work Resources, click the first blank Resource Name cell and type
00:36the name of the material resource, like Wine for that open house.
00:40When you press Enter, Project automatically fills in Work in the Type cell.
00:46So click that cell, click the down arrow, and choose Material.
00:50When you do that, the Material cell becomes active, while Project empties a few
00:56other fields like Maximum Units, Overtime Rate, and Base Calendar.
01:01Material resources mostly don't go by units of time, and that's why the
01:05Standard Rate cell for material resources have just the dollar value without a
01:10slash and a time period.
01:12That's also why the Material label field becomes active.
01:15That's where you define the units of measurement for a material resource.
01:19For example, if you buy wine by the gallon for the open house, type Gallons in
01:24the Material label field.
01:26To set the costs per unit, type the number in the Standard Rate field,
01:32for example, 6 for the $6 gallon bottle of fine red wine you're serving.
01:38Material resources do you have one time-related trick.
01:42Suppose that a task consumes materials depending on how much time passes,
01:46for example, gallons of gas when you're driving somewhere or gallons of wine if
01:52the Open house runs longer than you'd planned. You can set up an assignment for
01:56a material resource so its consumption depends on the task duration.
02:00The trick is to add the /hr to the Units field of the assignment.
02:04To see how this works on a task assignment, click the View tab and choose Gantt Chart.
02:10Select the Open house task. To display the task form, turn on the Details check box.
02:18In the Task Form, select the Resource Name cell and add Wine to the task.
02:25In the Units cell, type 6/ and then 'hr' for hours.
02:32Click OK to finish the assignment.
02:35Project changes the value in the cell to 6 gallons/hr.
02:40If you right-click and display Cost, you can see that the cost is a $144.
02:47That's the six gallons per hour, times four hours for a total of $144.
02:51Now, back on the Resource Sheet, you can also fill in the Initials field with an
02:57abbreviation for the material resource name.
03:01And if you want to group material resources, you can fill in the group field or
03:05simply leave this field blank.
03:08You'll learn about filling in the cost fields in more detail in a later movie.
03:12Creating material resources is similar to creating work resources, but you don't
03:16have to fill in as many fields, because material resources don't depend on time
03:20the way work resources do.
Collapse this transcript
Setting up resource costs
00:00When you assign cost rates to work and material resources, Project can use them
00:05to calculate project costs.
00:07Project multiplies the rate by the amount of time assigned to determine the
00:11cost of each assignment.
00:13The Resource Sheet is the easiest place to enter cost fields, but you can enter
00:17them in the Resource Information dialog box, too.
00:20The Standard Rate field is the typical pay rate for a work resource for a time period.
00:26To set the Standard Rate for a Work or Material resource, type the monetary
00:30value in the resource's Standard Rate cell.
00:34For the Office Manager, you can type 60 and press Enter.
00:38If the pay rate is by the hour you don't have to type the /hr. Project
00:43automatically adds it to the value.
00:45If you pay a resource for a different time period, like a retainer to your
00:49webmaster, you can type a different unit of time after the slash, for example 1,000/mon.
01:02On the other hand, material resources don't go by units of time.
01:06That's why the Standard Rate cells for Material Resources don't have the
01:10slash and a time period.
01:12You still use the Standard Rate field to set a material resource's cost rate,
01:17except that the standard rate represents the rate per unit.
01:21The unit is what you type in the Material Label cell.
01:25For example, for a keycard, you set a cost for each keycard to the new office, or
01:32Gallon for each gallon of wine you get for the open house.
01:36To set the price for the Keycard resource, type 5 in the Standard Rate cell
01:43and press Enter.
01:44Because the Material Label is Card, Project knows that each card costs $5.
01:51To see how Project calculates cost from these rates, click the Task tab and
01:55click the Gantt Chart.
01:59The Order security system has the office manager a work resource assigned.
02:06When I right-click the Task Form and choose Resources & Successors, I can see
02:11that the Office Manager is assigned to work 8 hours.
02:15If I assign the Keycard to the task, in the Units cell, I can type 175 to add
02:24175 cards to this task.
02:29When I click OK, Project adds card, which is the units, to the value.
02:35Now to see the cost, right- click the table and choose Cost.
02:41The cost for the office manager is $480. That's $60/hour for the 8 hours the
02:47office manager is assigned.
02:49On the other hand, the cost for the keycards is $875.
02:53That's $5 a piece for the 175 keycards.
02:57Now, let's go back to the Resource Sheet and look at a few other cost fields.
03:02On the View tab, click Resource Sheet.
03:05Overtime Rate applies only to work resources, because it's the rate charged if a
03:10resource earns a higher rate for working overtime.
03:13If someone gets the same rate no matter how many hours he works, you can skip the
03:17Overtime Rate field altogether.
03:19The only time you have to fill in the Overtime Rate field is when someone gets
03:23paid more for their overtime hours.
03:26You can also fill in a value for Cost/Use, if you pay an amount each time you use the resource.
03:32For example, if the wine bar has $150 setup charge for each setup, you can type
03:38$150 in the Cost/Use field.
03:43Then every time you assign wine to a task, the $150 setup fee is included in the
03:48cost for the wine resource, along with the cost for each gallon you order.
03:53Accrue at is set to Prorated, which means that the cost is spread out over time.
03:59If you want to track costs when they occur, you can change the Accrue at to
04:02reflect when money is actually spent.
04:07Choose Start to show the cost as soon as the task starts, like paying for an
04:11airline ticket before you take your trip.
04:14End means you pay at the end of a task,
04:16for instance, when you don't pay a consultant until the work is done and accepted.
04:20Initially, Project fills in the Standard Rate and Overtime Rate field with $0.00/hr.
04:26If most of your resources cost the same amount per hour, you can tell Project
04:30the standard rate or overtime rate you want to use.
04:32To do that, click the File tab and then click Options.
04:37In the Project Options dialog box, click Advanced. Then you can type the Default
04:43standard rate that you want to use, say $60/h and if you want to set an Overtime
04:51rate, you can type that as well.
04:55Then click OK to save those default rates.
05:00The Resource Sheet is the place to go to enter cost information for work
05:04and material resources.
05:06After you enter cost information, Project can use it to calculate the cost for
05:10tasks when you assign resources to them.
Collapse this transcript
Creating a cost resource
00:00The Cost Resource type is perfect for costs that aren't time-based, or related to
00:05materials the Project consumes.
00:07Unlike the Fixed Cost field, you can apply more than one cost resource to
00:11a task, so you can track the cost for lodging, airfare, fees, and other costs separately.
00:16Then you can look at the total cost for a cost resource to see how much
00:20you spend by category.
00:22A cost resource is easy to create.
00:24To get to the resource sheet, on the View tab, click Resource Sheet.
00:30Then, in the first blank Resource Name cell, you can type the name of the cost
00:36resource, Catering in this example.
00:41Click the down arrow in the Type cell and choose Cost.
00:45The standard values for a work resource disappear.
00:49The only other fields with values are Initials and Accrue At.
00:54As you do, for work resources, you can change the Initials by typing a new value.
01:00To change the Accrue At value, choose the value from the dropdown list.
01:07You actually specify the assignment cost when you assign a cost resource to a
01:13task, so the cost can vary for each assignment.
01:16To see how this works, click the Task tab and click Gantt Chart.
01:21Select the Visit Oakland site task.
01:25The Airfare and Lodging resources are assigned, but there is no Cost yet.
01:30To set the cost for a trip to Oakland, click the Airfare Cost cell and type 150.
01:36Click the Lodging cell and type 190. Then click OK to save those assignments and costs.
01:44Now, select the Visit Seattle site task.
01:47To assign the Airfare and Lodging cost resources, click a blank Resource Name
01:52cell and choose the resource.
01:55First, assign Airfare, and then in the next Resource Name cell, choose Lodging.
02:02Click OK to assign the resources.
02:06Now, in the Airfare Cost cell, type $350 and in the Lodging cell, type 360 and
02:15click OK to save those costs.
02:17To see how much you're spending by category of cost, the Resource Usage View is better.
02:23Click the View tab. Click Resource Usage.
02:29Scroll down to see your cost resources.
02:34The cost value in the Lodging summary row shows the total cost for all lodging
02:40assignments in this project.
02:42You can see that the Visit Oakland site and Visit Seattle site add up to
02:46the $550 for Lodging.
02:50Likewise, the Airfare value in the summary row is equal to the cost for the
02:56Oakland and Seattle trips.
02:58Cost Resources are great way to track costs that aren't labor or material
03:02related. Just remember, you assign the cost for a cost resource when you assign
03:06the resource to a task.
Collapse this transcript
4. Assigning Tasks to Resources
Understanding duration, work, and units
00:00Task Duration is eternally connected to the work and units of a
00:04resource assignment.
00:05The mathematical relationship is easy to manage when you first assign
00:09resources, but editing resource assignments and getting the right results can be a challenge.
00:14Understanding how duration, work, and units work together is the key to getting
00:18your resource assignments right every time.
00:20To understand the relationship between duration, work and units, all you need
00:25is some basic algebra.
00:27Duration = Work/Units. Units are the percentage, or decimal amount, that the
00:34assigned resource works on the task.
00:37Full-time is 100%, or .1. Halftime is 50%, or .5.
00:44If you estimate work at 40 hours and specify that the resource works on the task
00:5050% of the time, Project calculates the duration to be 10 days.
00:55That's the equivalent of 80 hours.
00:57On the other hand, if you estimate duration to be 5 days, and the resource works
01:0240% on the task, the work is 2 days, or 16 hours.
01:08Similarly, Project calculates Units if you give it the duration and the work.
01:12If you set the work at 40 hours and the duration at 160 hours, that's 20 8-hour days.
01:19The percentage of time the resource works on the task is 25%, shown here as .25.
01:26Project has built-in rules about which values it changes.
01:30Unless you give Project specific instructions, the program tries to change
01:35duration first, then work and finally, as a last resort, units.
01:41For example, if you give Project work and units, it will calculate duration.
01:48Similarly, if you give it duration and units, it calculates work. And if you
01:54give it duration and work it will calculate units.
01:57You can also see that if you leave the Unit cell blank, Project uses 100%, or the
02:03resources Maximum units.
02:06You can bypass Projects built-in calculation rules by setting the task type field.
02:12Let's look at the Identify physical requirements task.
02:15Say your boss tells you the task has to be finished more quickly, so you decide
02:19to assign a second person to help you.
02:22You want the duration to shorten and the work to remain at 80 hours.
02:26One way to do that is to change the Task type field to Fixed Work.
02:33In the Task type dropdown list, just choose Fixed Work. Then you can add the
02:39Office Manager to the task.
02:45When you click OK, the Duration drops to 5 days, and each person works 40 hours,
02:52for a total of 80 hours.
02:54The Effort driven check box is one more factor in how resource assignments
02:59change when you add or remove resources.
03:02Effort-driven scheduling means a task's total work stays the same as you add or
03:07remove resources to a task.
03:09Effort-driven scheduling is the norm because you often add resources to shorten
03:13a task by having several people work on it simultaneously.
03:17Meetings are one example of tasks that don't follow the effort-driven
03:21scheduling formula.
03:22Meetings don't get shorter when you add people to the attendee list; instead, the
03:27total work for the task increases, even if the duration stays the same.
03:31Look at the Present selection to management task.
03:36With the relocation manager as the only resource, the Duration and the Work
03:40are both four hours.
03:42To add attendees and increase the work, first turn off the Effort driven check
03:47box. Add the management folks and the office manager to the task.
03:55In each blank cell, choose a different manager and then finally add the office
04:07manager to the task.
04:11When you click OK, you see that every person assigned to this task is
04:16assigned for 4 hours;
04:18however, the Duration for the task is still four hours, but the total work
04:22adds up to 20 hours.
04:24Keeping costs down and using people's time effectively are two reasons to learn
04:28how to run an efficient meeting.
04:30The values you enter for Duration, Work, or Units determines how Project
04:34calculates resource assignments, but the Task type and Effort driven scheduling
04:38setting also affect resource assignment changes.
04:42By understanding how each of these features work, you can modify assignments and
04:45get the results you want.
Collapse this transcript
Assigning resources to tasks
00:00Your project's schedule doesn't come into focus until you assign resources to tasks.
00:05How many resources you assign, their work schedule, and availability for your
00:09project all affect how long tasks take.
00:12Project offers several methods for assigning resources to tasks.
00:16You can use your favorite method or use the best methods for the assignment task at hand.
00:21If you know the resources you want to assign, the Task Form sits
00:25conveniently below the Gantt Chart, and can handle most of the assignment
00:29fine-tuning you throw at it.
00:31The Task Form shows information for the task that's currently selected in the top pane view.
00:37In this case, with Identify physical requirements selected, you can see that
00:42task down in the task form.
00:44So, to assign a resource click the first blank Resource Name cell. In the
00:49dropdown list, choose the resource you want to assign, the Relo PM.
00:55To use the resource's Maximum units from the resource sheet, you can leave the
00:59Units cell blank and click OK.
01:03Project fills in 100%, which is the Relo project manager's Maximum units.
01:08To allocate the resource at another percentage, you can click the Units cell,
01:12type the number, like 50 for 50%, and click OK.
01:17In this case, let's bring the Duration back down to the 40 days.
01:23The percentage in the Units cell is a percentage of the resource's work
01:28schedule, which comes from the resources calendar that you learned about in an earlier movie.
01:33For regular work schedules, 100% is full- time and usually represents 8-hour workdays.
01:39Notice that the work hour is that Project calculates for this assignment is 160 hours.
01:45That's 4 hours a day for 40 workdays.
01:49To assign another resource to the task, click the next resource name cell,
01:54choose the resource, like Relo Assistant, fill in the Units and click OK.
02:02You can see here that Project distributes the hours for the PM to the Assistant,
02:08so the total hours are still 160 hours, split 50-50 between the two resources,
02:15and the Duration has now dropped to 20 days.
02:19Assigning material resources is almost the same as assigning work resources.
02:24Instead of telling Project how much time the resource spends, you fill in the
02:28quantity of material. Select the Open House task.
02:32In the Resource Name cell, choose Wine on the dropdown list.
02:40In the Units cell, type the quantity of wine based on the material label you
02:44defined in the resource sheet.
02:46In an earlier movie, you set the wine resource units to gallons.
02:50So, if you type 20, you assign 20 gallons of wine to the open house, and you can
02:55see that Project fills in the label when you click OK.
02:59The Assign Resources dialog box has several tricks up its sleeve. Click the
03:03Resource tab. Actually, select this task, and then click Assign Resources.
03:12You can drag the Assign Resources dialog box out of the way so you can see what you're doing.
03:18It stays where you put it, and it stays open until you move it, or close it.
03:23The Assign Resources dialog box is one of the few that can stay open while you
03:27do other things in Project.
03:29You can also use this dialog box to look for specific types of resources, or for
03:33resources with enough available time.
03:36In the Task view, select the task you want to assign resources to, Walkthrough
03:41office in this example.
03:44In the Resource Name column, click the resource that you want to assign, in this
03:50case the Relo PM, and click Assign.
03:55Several things happen. The resource you clicked jumps to the top of the list and
04:00a check mark appears next to the Resource Name.
04:04The Unit cell fills in with the resources Maximum units, and the cost of using
04:09the resource for the work hours shows up in the Cost cell.
04:12If you want to change the units, type the percentage in the Units cell.
04:18To assign several resources at the same time, click the first resource name,
04:23then Ctrl+Click the other resource names.
04:27In this case, I'll click the Office Manager and the Relo Assistant.
04:33When I click Assign, all the selected resources move to the top of the list with
04:38a check mark, to show their assignment to the task.
04:42If you have tons of resources on your project, you can filter the resource names
04:46in the Assign Resources dialog box to look for the resources you want.
04:51If you don't see the Resource list options, for example when it's collapsed
04:55like this, click the plus to display them.
04:59To find resources based on criteria, turn on the Filter by check box. Then, in
05:06the dropdown list, you can choose a filter like Resources-Work to show just
05:12the work resources.
05:14To view the full Resource list again, in the Filter by dropdown list, choose All Resources.
05:22The Available to work check box helps you find people who have time available
05:26between the task's Start and Finish date.
05:29You can turn on the Available to work check box, and then in the Available to
05:33work box, type the time you need from a resource, like 16h for 16 hours.
05:41Then the Resource list in the Assign Resources dialog box can show you only
05:47the resources who have that amount of time available between the task's Start and Finish date.
05:53When you are done assigning resources, you can close the Assign Resources dialog
05:57box by clicking the Close button.
06:00The Task Form and the Assign Resources dialog box all help you assign resources.
06:06The Assign Resources dialog box has the most bells and whistles, and it can sit
06:10anywhere on your screen and stay open while you do other things.
06:14In a later movie, you'll learn how to assign resources with the Team Planner
06:17View, which is new in Project 2010 Professional.
Collapse this transcript
Viewing resource assignments and finding over-allocations
00:00After you assign resources to tasks, you have to make a second pass through your
00:04schedule to make sure your resource assignments work.
00:07Workloads have to be just right so you keep your team members busy
00:11without burning them out.
00:12The Gantt chart, the Task Form, and the Assign Resources dialog box that you use
00:18to assign resources focus on tasks and assignments for one task at a time.
00:23Project's Resource Usage view makes it easy to scan all of the assignments for a
00:27resource, review day-by-day assignment details, and find overallocations.
00:33Other views and filters provide shortcuts for hunting down the overallocations
00:37hiding in your schedule.
00:38To quickly scan how many resources are overallocated, look at the Resource Sheet.
00:44On the View tab, click Resource Sheet.
00:47If a resource is overallocated even once, the text in the Resource's row is
00:52red and bold, and the Indicators column contains a yellow diamond with an exclamation mark.
00:58In this view, you can see how many resources you have to work on, but you can't
01:02tell how much balancing you'll have to do.
01:05The Resource Usage view is great when you want to see all of our resource's
01:09assignment and the day-to-day assigned hours that produce overallocations.
01:14On the view tab, click Resource Usage.
01:17In the Resource Usage view, each resource in the project appears in a summary row.
01:23Right off the bat, you can see how many hours the resource is assigned on your
01:26project in the Work column.
01:29The summary row shows the total hours assigned to the resource. The assignment
01:34rows show the hours for each assignment.
01:36When you first display the Resource Usage view, you probably won't see over-
01:41allocations immediately.
01:42Even if you do, overallocations can be spread out of over time, or across many assignments.
01:48You can jump from overallocation to overallocation by clicking the Resource
01:53tab and then clicking Next Overallocation.
01:58This command starts looking for overallocations from the currently selected
02:02date and assignment.
02:04It works its way down the time period, from assignment to assignment.
02:07When it gets to the last assignment in a column, it moves to the next time
02:11period. Because of that, it's better if you change the time phase grid to show
02:15weeks instead of days.
02:18Right-click the Timescale heading and then choose Timescale.
02:23Click the Bottom Tier tab and then choose Weeks. Click the Middle Tier and
02:32change that to say Months and then click OK.
02:36If the command doesn't find any overallocations, try searching from the
02:39beginning of the project.
02:41You can press Ctrl+Home to move to the first column in the first row. Then press
02:46Ctrl+Up Arrow to move to the first cell in the first row.
02:50If the resource is overallocated at all, the text in the summary row is red
02:54and bold, and the yellow diamond with an exclamation point appears in the Indicators column.
03:00The time phase grid on the right shows hours assigned during each time period.
03:05If the hours are higher than the resources maximum available time, the
03:09hours appear in red too.
03:11Unfortunately, if several tasks contribute to the overallocation, the hours in
03:16the summary row are red, but the hours in the assignment rows aren't.
03:24You can focus on the overallocated resources by filtering the resources in the view.
03:30Click the down arrow to the right of the Resource Name column heading.
03:34On the dropdown menu, point to Filters and then choose Overallocated Resources.
03:41The list of resources changes to all red and bold, because all of these
03:45resources are overallocated.
03:48The Overallocated Resources filter works on any view.
03:51When you want to see all the resources again, click the down arrow next to the
03:55Resource Names heading.
03:57In the Filters dropdown list, choose All Resources.
04:03When you are trying to figure out how to balance out overallocations,
04:07other fields can help.
04:08The Overallocation field that tells you how many hours you've gone beyond the
04:12resource's available time.
04:14On the other hand, the remaining availability field shows the hours that
04:18resources have available, if you're looking for replacements.
04:21Project 2010 makes it easy to display or hide other fields in the Resource
04:26Usage time phase grid.
04:29Click the Format tab and then turn on the check boxes for the fields you want, in
04:34this example Overallocation.
04:36Another row appears in each assignment for overallocated hours.
04:41The Resource Allocation view goes one step further, if you want to manually delay
04:46tasks to remove overallocations.
04:49It displays the Resource Usage view in the primary pane and the Leveling Gantt
04:54Chart in the Details pane, so you can add a leveling delay, which you'll learn
04:58about in the later movie.
05:00To display the Resource Allocation combination view, on the View tab, click Other
05:06Views and then choose More Views.
05:09In the More Views dialog box double-click Resource Allocation.
05:15The resource graph is a great companion to the Gantt Chart, Task Usage or
05:20Resource Usage View.
05:22It shows resource allocation by time period.
05:25On the View tab, turn on the Details check box. In the dropdown list,
05:30choose Resource Graph.
05:32Vertical bars show the selected resource's allocation by time period.
05:43When the vertical bar shoots pass the horizontal line of the resources
05:47availability, the bar above the line is red to show that the resource is overallocated.
05:53The Resource Graph doesn't show the assignments for the overallocated time.
05:57That's why it's better to display in the Details pane with the Resource Usage
06:02view in the primary pane.
06:04Like the Resource Usage view, you can change the fields you see in the Resource Graph.
06:09Make sure that the Resource Graph is the active view by clicking it.
06:13Then click the Format tab.
06:15In the graph dropdown list, choose the field that you want to see, for
06:19example, Overallocation.
06:21Project has several views that help you see resource assignments and resource overallocations.
06:26You can filter views or show different fields to help you to decide how to
06:30reallocate resources.
06:32The best way to look at assignments is to display a view like
06:36Resource Usage in the primary pane, so you can see the big picture of a resource's assignment.
06:41Then you can display another view like the Leveling Gantt or the Resource Graph
06:45in the Details pane to dig deeper and figure out a solution.
Collapse this transcript
Modifying resource assignments
00:00Resource assignment changes come in all shapes and sizes.
00:03You can add or remove resources from a task, change the task duration or work,
00:08or adjust the percentage of time resources devote to a task.
00:12To get the assignment results you want, you have to juggle Project's Effort driven
00:15scheduling setting with the task type you choose, and the values you enter for
00:20duration, work, and units.
00:22In this movie, you're going to edit the same task over and over again.
00:26After each change, you'll undo the change, so you can see how each edit has
00:30a different effect.
00:31When you want to add, remove, or replace resources on a task, the Assign
00:35Resources dialog box is your best bet.
00:39Click the Resource tab and then click Assign Resources.
00:43The Assign Resources dialog box appears.
00:45In the Gantt chart, or another task view, select the task you want to edit, like
00:50Identify physical requirements.
00:52The resource assigned appear at the top of the list in the Assign Resources
00:57dialog box, with check marks to the left of the name to show they're assigned.
01:02The units they're assigned at and the resulting assignment costs show up in the table.
01:07To add a resource to the task, click the name of the resource, like Office manager.
01:13If you want to set the units for the new assignment, in the Units cell, type the percentage.
01:18Otherwise, project sets the units to 100%. Then click Assign.
01:25In the Gantt chart table, you see a feedback triangle in the upper-left corner
01:29of the Task Name cell.
01:31That's Project's way to tell you it needs some help figuring out how to make the
01:35change you asked for.
01:37Click the triangle and then click the smart tag indicator that appears.
01:42Project opens a dropdown menu with the changes you're most likely to make.
01:47If you added resources, the first option is Reduce duration so the task ends
01:52sooner, but requires the same amount of work.
01:56Project selects this option automatically, because shortening duration is
02:00usually why you add resources.
02:02The duration shortens based on the resource units, but the total work stays the same.
02:09In this case, Project assigns the Office manager at 100%.
02:13The duration shortens to 15 days, but the total work is still 240 hours.
02:19On the Quick Access Toolbar, click Undo to undo this change.
02:25Now assign the office manager again. Click the feedback triangle and click the
02:33smart tag indicator, but this time select the second option: Increase total
02:39work, because the task requires more person-hours.
02:42Keep duration constant.
02:43That keeps the duration and recalculates the work.
02:48The duration stays at 30 days, but the amount of work changes.
02:52This option is great if you add resources to complete new features the
02:55customer asked for.
02:57Project assigns the office manager at 100%.
03:00In this case, the total work increases to 480 hours.
03:05Once again, undo the change.
03:08Reassign the office manager one more time.
03:14This time the third option, Reduce the hours that resources work per day.
03:19Keep duration and work the same.
03:22This option redistributes the work to all the resources, because the total work
03:27stays the same, and the duration stays the same, each resource can work fewer
03:31hours each day, which means a smaller value for units.
03:37If you choose this option, Project assigns the three resources at 33%, but keeps
03:42the duration at 30 days and the total work at 240 hours.
03:47To remove an assigned resource, select the resource and click Remove.
03:52We select the office manager and click Remove.
03:57The assigned check mark goes away, and the resource name goes back to its
04:01original location in the alphabetical list of unassigned resources.
04:07When you remove resources, the smart tag shows similar options for increasing
04:11duration, decreasing total work, or increasing units.
04:19You can replace one resource with another.
04:21In the Assign Resources dialog box, select the resource you want to replace,
04:29say the Relo Assistant.
04:31Then click Replace.
04:33In the Replace Resource dialog box, select the new resource, Office manager, for
04:38example, and click OK.
04:43Because you are simply swapping one resource for another, you don't have to
04:46answer any smart tag questions.
04:49Undo this replacement.
04:53If you assign a new resource and tell Project the units or work to give to the
04:58resource, you answer one of the questions that Project has.
05:02In this case, add the office manager, but set the units to 25%, and click Assign.
05:14Project keeps the existing resources at their percentage and adds the
05:17office manager at 25%.
05:20It figures out how much work to assign to each resource based on the units.
05:26Based on the work hours, Project calculates the new duration to be 50 days.
05:31You don't have to understand the ins and outs of effort-driven scheduling and
05:35task types, if you use Project's smart tags when you edit resource assignments.
05:39You make a change in the Assign Resources dialog box, and the program asks you
05:44what you're trying to do.
05:45You give it a little guidance, and it makes your wishes come true.
Collapse this transcript
Using Team Planner to assign resources
00:00The Team Planner view is new in Project 2010 Professional, and it's an easy way
00:05to work on resource assignments for small teams.
00:08Team Planner shows a swim lane for each resource assigned to the project.
00:12The tasks they're working on appear in a timescale, and you can drag tasks to a
00:16resources row to assign it, drag assignments from one resource to another, or
00:20move assignments around in time.
00:22Team Planner isn't as helpful for large projects with auto scheduled tasks and
00:26oodles of resources.
00:28You have to scroll through lots of resources in the timescale to find the
00:31assignments you want to work on. But for small teams, it's great.
00:35To display Team Planner, click the Resource tab, and then click Team Planner.
00:42Choose Team Planner on the dropdown menu.
00:44Before you start assigning tasks with Team Planner, let's look at how the view is set up.
00:49The upper-left of Team Planner view lists the project's resources, one resource
00:54per row, like swimmers ready for a race in a pool.
00:57If a resource is assigned to manually schedule tasks without start or finish
01:01dates, those tasks appear in the Unscheduled Tasks column,
01:07like the Meet with management task assigned to the Relo Project Manager.
01:11There are two ways to assign a task from the bottom half of the Team Planner window.
01:16You can drag the task to the row for the resource you want to assign, like
01:21Identify physical requirements to the Relo PM resource.
01:28One pitfall with this method is that you might drop the task on a different date
01:32than the task's current dates.
01:34For manually scheduled tasks, it isn't that big a deal -
01:37you can drag the task to the correct date, but dropping an automatically
01:41scheduled task on a different date creates a date constrain.
01:45To avoid date constraints, you can also assign a task by right-clicking its bar
01:49like the Draft the budget task.
01:52On the pop-up menu, choose Reassign To, and then click Relo PM on the dropdown menu.
02:01One thing to note: the Team Planner timescale on the right shows bars based on
02:06task's start and finish dates, but because these bars are associated with the
02:10resource, they're assignment bars.
02:12If a task has more than one assigned resource, a bar for the task appears in the
02:17row for each assigned resource.
02:19Now that the Identify physical requirements and Draft the budget tasks are both
02:24assigned to the Relo PM, you see red lines above and below the tasks.
02:30The red lines mean that the resource is overallocated.
02:34The resource's name also changes to red when the resource is overallocated.
02:39Team Planner is happy to prevent overallocations in the first place.
02:44Click the Format tab and then click Prevent Overallocations.
02:50If you try to assign a task to a resource that's already allocated, Project
02:54reschedules the assignment to the resource's next available slot,
02:58the way it did the Draft the budget task.
03:01Another way to eliminate overallocations is to drag the bar to
03:05another resource's row.
03:06For instance, you can drag the Draft the budget task to the Relo
03:10Assistant resource.
03:15Let's try one more method.
03:17First, reassign the task back to the Relo PM resource, starting the week of December 12th.
03:26Actually, we have to go back and turn off the Prevent Overallocations to get this to work.
03:35To tell Project to chop up the assignment into a resource's available time,
03:40select the assignment, Draft the budget in this case.
03:44Then click the Task tab, click Move, and choose When Resources are Available.
03:55Project moves the assignment to when the resource is available and splits the
03:59task into pieces if necessary.
04:02Team Planner is a great way to manage resource assignments for small teams,
04:06particularly for projects that are manually scheduled.
04:09You can drag and drop assignments and move them around in time to your
04:12heart's content.
Collapse this transcript
5. Working with Views
Choosing a different view
00:00Over the lifetime of a project, you look at project information from many perspectives.
00:04That's why Project has dozens of built-in views that you can display in
00:08different panes within the main project window.
00:11In addition to a plethora of different views, Project lets you pick the view you
00:15want in a number of places within the program.
00:18When you create a new file, Project initially displays the timeline, which is a
00:22new pane in the Project 2010 window.
00:27To create a new file, click File, then click New and double-click Blank project.
00:36Click OK to close the Project Information dialog box.
00:39This pane up at the top is the Timeline view, and you can see that Gantt
00:43Chart is in the bottom.
00:45However, as you work on a project, you'll look at it in different ways.
00:49Let's look at a completed project plan.
00:52The Gantt Chart view here shows the tasks in the project, the task lengths that
00:56determine your schedule, the resources assigned, and more.
01:00This view is called a single-pane view, because it contains just one view, the Gantt Chart.
01:06But the Gantt Chart view does have a left and a right pane.
01:10The left side is a table of data, and the right side is a timescale that shows
01:14when tasks are scheduled against a calendar.
01:17You can also show two views at a time.
01:20For example, to see the Timeline, click the View tab and turn on the
01:24Timeline check box.
01:28Then the Timeline appears above the Gantt Chart view.
01:31Project automatically selects Timeline in the Timeline box,
01:35so it appears above the Gantt Chart, but you can choose another view if you want.
01:40The Timeline shows the dates covered in the Gantt Chart timescale.
01:44You can drag the blue timeline bar to scroll the Gantt Chart's timescale dates.
01:54Or, you can drag one end to change the date range that you see in the timescale.
02:01You'll learn more Timeline tricks in a later movie.
02:04Instead of the Timeline, you can display the Details pane below the primary pane.
02:09To display the Details pane, click the View tab and then turn on the Details check box.
02:17Project automatically selects Task Form in the box, and the Task Form dutifully
02:22appears below the Gantt Chart.
02:23If you want to see a different view in the Details pane, click the down arrow.
02:28To choose from any view, click More Views, and then in the More Views dialog box,
02:35you can double-click the view you want,
02:37for example, the Task Details Form.
02:41When the Details pane is opened, it shows information about what you select
02:45in the primary pane.
02:46Select a task in the Gantt Chart, and the information about the task appears in
02:50the view in the Details pane, like the Task Details Form here.
02:56You can see, when I select Identify physical requirements, the resource is
03:00assigned, and the units and cost all appear in the Task Details Form.
03:05Select another task and the information you see in the Details pane changes to show that task.
03:10Views called Combination Views display one view in the primary pane and another
03:16view in the Details pane.
03:17If you want to hide the Details pane to concentrate on your primary view, you
03:22can turn the Details check box off on the View tab.
03:29A shortcut is double-clicking the horizontal divider between the two panes.
03:35To restore the Details pane, you can double-click the box immediately below the
03:39vertical scrollbar or turn on the Details check box on the View tab.
03:44Here's the box below the vertical scrollbar.
03:47Just to keep your pane terminology clear, Project also has Task panes, which
03:53aren't related to View panes.
03:55For example, click the Task tab and then click Inspect.
04:02That opens the Task Inspector pane to the left of your view.
04:06The Task tab and Resource tab include commands for displaying the most commonly
04:10used Task or Resource views.
04:13On the Task tab, the View section has a button labeled Gantt Chart.
04:18Click the down arrow and then choose the view that you want to display.
04:24On the dropdown menu, click More Views to open the More Views dialog box, which
04:30contains all built-in and custom views.
04:34Click the Resource tab.
04:37The View section has a button labeled Team Planner, so you can click it to see
04:41the Team Planner in no time.
04:43But to see another view, click the down arrow and choose the view you want.
04:49The View tab provides easy access to several popular views.
04:55The Task View section has buttons for the Gantt Chart, Task Usage, Network
05:00Diagram, Calendar, and Timeline.
05:09The Network Diagram is a planning view that helps you see the task dependencies
05:13between tasks as you build your schedule.
05:16The Calendar looks like a desk calendar with your project tasks drawn across the date boxes.
05:21It's a great way to send schedule information to team members in a format
05:25they're used to, and you've already seen the Timeline.
05:28The Resource View section has buttons for Team Planner, Resource Usage, and
05:32the Resource Sheet.
05:33The Team Planner makes it easy to assign resources to tasks on small, less formal
05:38projects, and the Resource Usage view is like the Task Usage view except that
05:42you can see the hours that a resource works on assignments by time period.
05:46Project also has View shortcuts on the right side of the Status Bar.
05:51You can click one of the icons to display the Gantt Chart, Task Usage, Team
05:57Planner, or the Resource Sheet.
06:00When both the primary and Details pane are open, Project applies the view you
06:05choose to the active pane.
06:07So before you choose a view, be sure to click the pane you want to switch,
06:11either the primary pane or the Details pane.
06:14The vertical title bar is a dark gray to show you which pane is active.
06:19If you have a favorite view, you can tell Project to display that initially.
06:24Click File and then click Options.
06:27In the Project Options dialog box, on the General tab, you can choose the
06:32default view that you want in the dropdown list.
06:34After you select that view, click OK to close the dialog box.
06:39Project can display a primary view pane, along with either the Timeline or a view
06:44in the Details pane.
06:45Click the pane you want to switch and then choose the view you want to see.
06:48Project has shortcuts on the Ribbon and the Status Bar for opening the most
06:52commonly used views, but you can always click a View command button and choose
06:56more views to get to every view that's available in your file.
Collapse this transcript
Choosing a different table in a view
00:00Sometimes the view you're looking at is okay, but you want to see different
00:04fields of information.
00:06The table that appears on the left side of many views, like the Gantt Chart or
00:10Resource Usage, is nothing more than a collection of Project fields.
00:14Similar to views, Project comes with lots of built-in tables, and you
00:19can customize your own.
00:20You can switch the table you see in several ways.
00:23The Gantt Chart view initially displays the entry table, which is perfect when
00:27you're first building a plan.
00:29The Entry Table has columns for status indicators, like overallocated resources,
00:35and the Task mode so you can set tasks to Manually Scheduled or Auto Scheduled.
00:39Then the entry table has basic task fields like Task Name, Duration, Start,
00:46Finish, Predecessors, and Resource Names.
00:49With most tables, you can't see all the fields in the table at the same time.
00:54In the Entry Table, you can see only through the Start Field here.
00:58If you want to see more of a table's columns, drag the vertical divider between
01:02the table and the timescale to the right.
01:05Another option is scrolling within the table.
01:10If the table is narrow, you can click in the horizontal scrollbar to move within
01:14the columns in the table.
01:17To change the table in the view, click the View tab, then click Tables and
01:23choose the table that you want.
01:25For example, the Cost table shows cost for each task or assignment.
01:31You can see the current cost, the baseline, actual cost, and remaining cost.
01:37The Variance is the difference between the baseline and the current estimate, but
01:41in this case there is no baseline, so the Variance is the total value.
01:46The Summary Table shows Duration, Start and Finish, Cost, Work, and the Percent Complete.
01:52One other way to show a table is to right-click the All Cells box, and then
01:58choose the table that you want.
01:59You can also choose other tables, like Variance, if you are evaluating project progress.
02:07To choose any table available in your project, choose More Tables, and then in
02:15the More Tables dialog box, select the table you want and click Apply.
02:21In this particular view, the date columns aren't wide enough to show the full dates.
02:27You can widen a column automatically by double-clicking the vertical bar
02:31between the two columns.
02:37A table is a collection of several fields with information about tasks,
02:41assignments, or resources.
02:43You can change the table in a view depending on the project management task you
02:46are performing, or what aspect of project performance you want to evaluate.
02:51It's always your choice.
Collapse this transcript
Inserting and rearranging columns in a table
00:00Project comes with lots of built-in tables, but they don't necessarily
00:04contain the fields you want to see, in the order you want, or with the settings you want.
00:08You can add, remove, or rearrange columns right within the table in the View,
00:12whether it's a built-in table or one you fiddled with before.
00:16You can change field settings to display information in columns exactly the way
00:20you want, and you can save your new and improved masterpiece as a new table
00:24without breaking a sweat.
00:26Making changes to a table by working on a directly in the view is the best way to go.
00:30You can see the results immediately and try again, until you get it right.
00:34Let's work on the Summary table.
00:38Right-click the All Cells box and choose Summary on the dropdown menu.
00:42To insert a column in a table, right-click the column heading to the right of the new column,
00:47for instance, Finish.
00:50On the dropdown menu, choose Insert Column.
00:54Project displays the Field Name dropdown list, which shows the abundance of
00:58Project fields you can choose from.
01:00The fastest way to a field is to start typing the field name.
01:04Project selects the first field that matches the letters you've typed.
01:07For example, to insert the Baseline Finish Field, start typing Baseline Finish.
01:13By the time you get to baseline F, Project has selected the field, and you can
01:18click it to add it into the Table, or say you want to insert the % Work Complete
01:24Field. Right-click the heading again, choose Insert Column, and then you can
01:29choose % Work Complete, right on the dropdown menu.
01:33Tables in Project 2010 also include the Add New Column heading in the last
01:38column of the table.
01:42Click the down arrow and choose the fields you want from the dropdown list.
01:48The Add New Column column can figure out what type of field you want to add.
01:52For example, if you type a date into the column, like 12/1/2010, Project adds
02:04the custom Date2 Field to your Table.
02:07To remove a column, right-click it's heading and choose Hide Column.
02:16If you want the columns in a different order, you can drag columns to where you
02:20want them in the table.
02:21For example, let's say we want to put % Work Complete next to % Complete.
02:28Click the column heading. The pointer changes to a four-headed arrow. Now you
02:32can drag the column to where you want.
02:35As you drag, a vertical line shows you where the column goes if you release the mouse button.
02:41When the line is in between the columns you want, just release the mouse button,
02:46and the column snuggles in between its new pals.
02:49Field settings let you change the way values look in a column.
02:53To change a column's settings, right- click the column heading, say % Work
02:57Complete, and choose Field Settings on the dropdown menu.
03:05Initially, the column heading shows the name of the Project field, but you can
03:10change the title to whatever you want.
03:12In the Title box, type the heading you want, such as Completed Work.
03:19You can align the title within the heading cell by choosing left, center or
03:24right in the Align Title box.
03:28Turn on the Header Text Wrapping check box to wrap the title over several lines
03:33when the column is narrow.
03:35That way it will show on multiple lines, as it does here.
03:39The Align Data box is where you tell Project how to align the values in the column cells.
03:44For example, dates and numbers are usually aligned to the left.
03:48Text or Yes/No fields are often aligned to the right, or the center.
03:54The Field Settings dialog box has a Width setting to change the width of a column.
03:59But the easiest way to resize the column is to click Best Fit. Then Project
04:04changes the column width, so it's wide enough for all the values in the column.
04:11Let's look at the tracking table for one other feature of tables.
04:17Project 2010 has a new setting that automatically wraps the text in columns like
04:22Task Name, which mean very long Task Names wrap over several lines as you
04:27change the column width.
04:30The row height automatically adjusts to show the full cell contents.
04:35If you widen the column, some things go to a single line.
04:38If you narrow it, they go to two or even three lines.
04:43If you want to apply wrapping to a column, right-click the column and
04:47then choose Wrap Text.
04:51Project keeps the changes you make to a table in your Project file, so the table
04:55looks the same way the next time you apply it.
04:59If you want to save the modified Table as a new one, click the View tab, click
05:05the Table's down arrow and then choose Save Fields as a New Table.
05:12In the Name box, type the name for the table and click OK.
05:20Project comes with lots of tables, with different sets of project information.
05:24You can use those tables as a foundation for the information you want to see, by
05:28adding, removing, or rearranging the columns in any table.
05:31And Field Settings change the appearance of the information in those columns, so
05:35you can see the info you want, just the way you want.
Collapse this transcript
Sorting tasks, assignments, and resources
00:00The alphabetical order in your address book makes it easy to find the people you contact.
00:05You often sort tasks, assignments, and resources in Project for the same reason.
00:11You might sort tasks by WBS code while you're planning, and then by Start Date
00:16while you're tracking progress. Or, perhaps you sort your resources first by
00:21Resource Type and then by Resource Name to make all the work, material, and cost
00:27resources easy to find.
00:29Project 2010 makes sorting easier than ever before.
00:32You find the Sort command on the View tab.
00:36Click Sort, and a dropdown menu with several common sort criteria appears.
00:42Choose by Start Date to see tasks in the order they start,
00:47for example, to give team members their assignments in the order they work on them.
00:52You can make tasks even easier to see by hiding summary tasks.
00:57Click the Format tab and turn off the Summary Task check box.
01:04Now you can see just the work tasks in your Project.
01:09Back on the View tab, if you click Sort and then choose by Finish Date, you sort
01:15tasks by when they finish.
01:17So you can see which resources you need to the very end of the project.
01:21If you assign priorities to tasks, to help with leveling resources, you can also
01:25sort tasks by priority.
01:31Sorting by cost is helpful if you're trying to find the most expensive tasks for
01:35a cost-cutting initiative.
01:37And finally, sort by ID puts the tasks back in the order they were originally.
01:43Project 2010 introduces an even easier way to sort by a column in a table.
01:49Click a column heading down arrow -
01:51Duration, for example.
01:54The dropdown menu includes sort options specific to the column.
01:58For the Duration column, the two sort commands are Sort Smallest to Largest and
02:03Sort Largest to Smallest.
02:05If you click the down arrow in the Start column, the sort commands are Sort
02:11Earliest to Latest and Sort Latest to Earliest.
02:14On the other hand, clicking the down arrow in the Task Name column shows Sort A
02:20to Z and Sort Z to A.
02:22The sort options on the dropdown menu sort by one criterion at a time,
02:27but you can also build a Sort that uses up to three fields.
02:31Click Sort and then choose Sort By, at the bottom of the dropdown menu.
02:37If a Sort is applied, the field you're sorting by appears in the Sort By box.
02:42To choose a different field, click the Sort By down arrow and choose the field
02:46you want, for example, Duration.
02:51If you want to see the longest duration first, select the Descending option.
02:55To add another sort criterion, choose a field in the first Then by box - for example, Cost.
03:05To see the highest Cost first, choose Descending.
03:09If you want the task names to appear in alphabetical order within each sort,
03:13choose Name in the next Then by box, and select the Ascending option.
03:21To apply the Sort, click Sort.
03:24Now your tasks are sorted by longest duration and highest cost,
03:29the perfect targets for innovative, schedule and cost-cutting efforts.
03:33You can also sort resources.
03:35Say you build a team of resources, but the list is a hodgepodge of names
03:39and resource types.
03:41On the View tab click Resource sheet, you can click Sort and choose Sort by
03:47on the dropdown menu.
03:50You want your resources sorted first by resource type, and then by resource
03:53name, so that different types of resources are grouped together and then shown
03:58alphabetically within each type.
04:00Choose type in the Sort By box. Choose Descending to show work resources first.
04:08In the Then By box, choose Name. Choose Ascending to list
04:14resources alphabetically.
04:16To make this new sort order permanent, turn on the Permanently Renumber
04:20Resources check box.
04:22When you click Sort, Project reorders the resources and changes their ID
04:27values to this new order.
04:30If you're sorting tasks, the Sort dialog box shows the Permanently
04:34Renumbered Task check box.
04:37Say you sort tasks by WBS code and want them to remain in that order.
04:41You can turn on the Permanently Renumber Task check box, so Task IDs change to
04:46list Tasks by WBS code.
04:48Sorting comes in handy in all sorts of situations.
04:51In Project 2010, you can choose common sort criteria on the Sort dropdown menu on the View tab,
04:58or you can build multi-criteria sorts using the Sort dialog box.
05:02Clicking a column heading gives fast access to sort criteria,
05:06specific to the column you click.
05:08So choose the Sort method that you prefer or is best for the task at hand.
Collapse this transcript
Grouping tasks, assignments, and resources
00:00Grouping tasks or resources is helpful when you're trying to focus on categories.
00:05For example, you can group tasks by the Overallocated field to find tasks with
00:10overallocated resources.
00:12You can nest groups to group tasks first into critical and non-critical, and
00:17then by overallocated resources.
00:20Grouping offers another benefit; the summary rows for each group rolls up values
00:25for all the items below.
00:27If you group by internal and external resources, using a custom resource field,
00:33you can see how much you're spending on labor for employees, contractors, and
00:37third-party vendors.
00:39To apply a Group, click the View tab.
00:43Then click the Group down arrow, on the dropdown menu choose the group you
00:48want, like resource.
00:51Project creates summary rows for each resource.
00:54If I click the Minus sign, I can collapse the group with no resource names, and
00:59now you can see the groups for all the other resources in the project.
01:03The Group's summary rows show the total for the values in the group's numeric fields.
01:08So, for example, you can see how much you're spending on each resource in the project.
01:14To choose any group that's available, including custom groups, click the Group down arrow.
01:20On the dropdown menu, choose More Groups.
01:24In the More Groups dialog box double- click the group you want, like Critical.
01:29Now you can see the group of non- critical tasks, and if you scroll down,
01:35the critical tasks.
01:38Another way to apply a group is by clicking the down arrow to the right of the
01:42column heading you want to group by.
01:44Then on the dropdown menu, you choose Group By.
01:49Click the down arrow in the Duration column. Point to Group By, and you can
01:54group by duration or weeks.
01:57If you make changes to a project, like adding resources to shorten duration, the
02:02changes can affect the group, task, resource, or assignment it belongs to.
02:06So be sure to reapply the group to see those new groupings.
02:10To remove a group, on the View tab, click the Group down arrow. Then choose No Group.
02:18You can also click the down arrow in a column heading and choose No Group on the dropdown menu.
02:25Right now, the No Group Command is not selectable because there is no group applied.
02:30To create a multilevel group, you have to dig a little deeper.
02:34You can copy an existing group as a foundation, and make changes to it.
02:38Suppose you want to find tasks that are good prospects for crashing.
02:42They are on the critical path, and their durations are long.
02:44So you can shorten them if you're willing to spend a little money.
02:48You want to create a new group based on the critical group.
02:52On the View tab, click the Group down arrow, and then on the dropdown menu,
02:56choose More Groups.
03:00In the Groups list, select the group you want to copy, Critical in this case, and click Copy.
03:08In the Name box, type a new name for the group, like Critical Duration.
03:16If you want the group to show up on the dropdown menu on the Ribbon, turn on
03:20the Show in menu check box, as it is here.
03:23To add another field to Group By, click the first blank Field Name cell, click
03:28the down arrow and then choose the Field you want to group by,
03:33in this case, Duration.
03:38In a task-oriented view, Project fills in the Field Type cell with task.
03:42If you're working on a Resource view, it fills in resource.
03:46If you want to group by assignments, choose Assignments in the Field Type cell
03:52and turn on the Group assignments, not tasks check box.
03:55For example, in a Task Usage view, you might group by assignments to see which
04:00resources generate the highest cost.
04:02If you want to see critical tasks first in this group, in the Order cell, choose Descending.
04:09Descending shows numbers, from the largest to smallest and text from Z to A.
04:14With groups on a field like duration, you could end up with a lot more groups
04:18than you bargained for:
04:19duration of one day, one-and-a- half days, 1.75 days, and so on.
04:25The solution is to define group intervals.
04:28For example, on a 1-month project, the intervals for the duration group could be days.
04:33On a multiyear project, the interval for the duration group could be
04:36two-week intervals.
04:37With the Field selected, click Define Group Intervals.
04:43The Group On field is set to Each Value, which creates a separate subgroup
04:48for each unique value.
04:50To change the interval, click the down arrow and choose the interval you want,
04:55Weeks for example.
04:57The Group on dropdown list varies based on the field.
05:01Duration has choices like Days and Months, while Cost has a numeric Interval size.
05:06To start the interval at a specific value, which helps group very small values,
05:12type the number in the Start At box.
05:14To start at one week, type 1, to have the first group show any duration less than 1 week.
05:21To define the interval size, type the number in the Group Interval box,
05:26like 2, for two-week intervals. Then click OK.
05:31Click Save to save this group.
05:35Now that this group is in the More Groups dialog box, you can click Apply to
05:39apply it to your view.
05:41You can see in this group that first we group by critical tasks and
05:47non-Critical Tasks.
05:50Then within the critical tasks, the tasks are grouped by duration, so you have
05:55less than 1 week to 1 week, 1 week to 3 weeks, 3 weeks to 5 weeks, and the
06:03longest group, 5 to 7 weeks.
06:05The non-critical group has the same intervals.
06:13Groups help you organize tasks, assignments, or resources into categories,
06:19like tasks by duration, assignments by resource, or resource by standard rate.
06:25One handy feature of groups is that they roll up the values of the items
06:28underneath so you can see the totals, like cost or work.
Collapse this transcript
Filtering tasks, assignments, and resources
00:00Project filters display the information you care about and screen out what isn't important.
00:05Project comes with a bunch of built-in filters.
00:07For example, the Incomplete Tasks filter shows tasks that aren't done yet, and
00:12hides the ones that are complete,
00:14so you can focus on tasks you can still do something about.
00:17Some filters include prompts like the Using Resource filter, which asks which
00:22resource you want to filter by.
00:23Auto-filter is an easy way to set up a filter on the fly.
00:27Auto-filter options appear on a dropdown menu when you click a column heading.
00:31So filtering is easier than ever.
00:33The View tab includes a Filter box where you can choose a filter to apply.
00:39Click the Filter down arrow and a dropdown menu with several common filters appears.
00:45Choose Critical to see only the tasks on the critical path.
00:51On the Filter dropdown menu, the Date Range and Using resource filters have
00:57ellipsis after the filter names.
00:59That means that you have to give the filter some info to tell it what to do.
01:03For example, choose Date Range.
01:06Type the first date of the date range in the prompt box that appears,
01:1011/1/2010, for example, and then click OK.
01:16Then type the end date of the date range, 12/1/2010, and click OK.
01:23And Project filters the task list to task the start or finish after the first
01:28date, and start or finish before the second date.
01:31Project has more filters than the ones that appear on the dropdown menu.
01:35To access any filter that's available, on the dropdown menu in the filter box,
01:41choose More Filters.
01:43Then in the More Filters dialog box, you can double-click the filter that you
01:47want, for example, manually scheduled tasks.
01:51To remove the filter, click the Filter dropdown arrow and choose No Filter.
01:58Let's look at the summary table.
01:59To show that, right-click the All Cells box and then choose Summary.
02:05Let's widen the Table pane so we can see all of the columns.
02:10I widened the Table pane by dragging the vertical bar between the Table pane and the Timescale.
02:16Similar to sorting and grouping, Auto- filter commands appear on a dropdown menu
02:21when you click the down arrow in a column heading.
02:24Click a column heading down arrow, % complete, for example.
02:29The dropdown menu includes filter options specific to the column.
02:34Point to filters. The first batch of options is Not Started for tasks that
02:39haven't started yet.
02:41In Progress, for tasks that are somewhere in progress, and Complete for the ones
02:46that are already done.
02:48But you can also choose percentage ranges, like within 1% and 25%.
02:54The dropdown menu also has check boxes for all the values that appear in that
02:58column, so you can turn specific values on or off.
03:04Let me apply the In Progress filter.
03:06When a column auto-filter is applied, a funnel icon appears to the right of the
03:12column title, and the Status Bar also says AutoFilter Applied.
03:18If you click the down arrow in the Start column and point to filters, you can
03:23choose from periods like Next Week, Next Month, or This Year.
03:29To remove a filter in a column, click the AutoFilter Filter icon, and then
03:36choose Clear Filter.
03:38I will clear the one for % Complete as well.
03:44If you make changes to a project, they can affect what should appear in the filtered list.
03:49But project doesn't update the filter for you.
03:52You have to reapply the filter to see the changes.
03:55The fastest way to reapply a filter is to press Ctrl+F3.
04:00You can build your own filters, too.
04:02The quickest way to a custom filter is to start with one that already exists.
04:05Say you want to build a filter that looks for critical tasks that are longer
04:09than two weeks, so you have the most chance of shortening the schedule.
04:13You can copy the built-in critical group and then edit the copy to add a test for duration.
04:18On the Filter dropdown menu, choose More Filters.
04:23In the More Filters dialog box, select the Critical Filter and then click Copy.
04:29In the Filter Definition dialog box, type a name for the filter in the Name box,
04:36CriticalDuration, for example.
04:39If you want your filter to appear on the filter dropdown menu, turn on the Show
04:43in menu check box, as it is here.
04:45Building a test that compares a field to a value is an easy way to get started.
04:51Select a blank field name cell.
04:55Click the down arrow and choose the field you want, Duration in this example.
05:01Then click the Test cell.
05:04Click the test cell down arrow and choose the type of test.
05:08For the Duration test, choose is greater than or equal to.
05:13That filters for tasks equal to or longer than a duration you set.
05:18The tests you can use for filters should be familiar from high school math classes.
05:22Equals, does not equal, is less than, and so on, compare numbers to one another.
05:27Is within and is not within test to see if a value is or isn't within a range.
05:33And contains, does not contain, and contains exactly, are tests for text strings.
05:39Click the Value cell.
05:41In the Value cell type or choose the value to compare to, two weeks in this case.
05:46If you have more summary rows than subtasks, you can turn off the Show related
05:51summary rows check box, to see only the work tasks that passed the filter.
05:58Then click Save to save the filter. To apply the filter to your project, click Apply.
06:06A good way to learn about more specialized filters is to copy an existing filter.
06:11In the Filter dropdown menu, choose More Filters.
06:15Select a filter, like Late/ Overbudget Tasks, and then click Edit.
06:21You can see how the filter is put together, or you can use it as a
06:25foundation for a new one.
06:28Click Cancel to close the Filter Definition dialog box. Then click Cancel to
06:33close the More Filters dialog box.
06:36Filtering is a great way to focus on just the information you want to see.
06:39You can use built-in filters or build your own in several ways.
06:44If you create your own filters, the easiest approach is to copy a built-in
06:48filter that has some of the tests that you want and add to it.
06:51It is as easy as that.
Collapse this transcript
Modifying task bar styles, text, and layout
00:00Changing the formatting of taskbars makes it easy to emphasize the
00:04information you want, just like showing critical tasks in red and
00:07non-critical tasks in blue.
00:10You can format individual taskbars if you want to highlight a few key tasks,
00:15like milestones that trigger payments.
00:17You can also tell Project how to format all the taskbars in a category, like
00:22summary tasks or tasks that are late.
00:25When you format a category of taskbars, Project tracks the tasks that belong to
00:30the category and changes their formatting if their category status changes.
00:34For example, if a task falls off the critical path, the red taskbar is changed to blue.
00:41Adjusting the layout of tasks is helpful, mainly when task dependency lines
00:45become overwhelming.
00:47You can hide them, or at least make them a little neater.
00:50Changing the format for some task categories is easier in Project 2010.
00:54For example, to show critical tasks with red taskbars, click the Format tab in the
01:01Gantt Chart view, and then turn on the Critical Task check box.
01:06If you don't want to see critical tasks in red, turn the check box off, and the
01:11taskbar is changed to blue, like non-critical tasks.
01:15To go back to the critical path, turn the check box back on.
01:18Bar styles apply only to the view that's active.
01:22To format categories of taskbars, click the Format tab.
01:27Click the Format down arrow and choose Bar Styles.
01:34In the table, select the category of taskbar you want to format, let's say the
01:42Manual Summary taskbar.
01:44Then click the Bars tab.
01:47As you might expect, the Start section controls the appearance of the
01:51beginning of the taskbar.
01:53The Middle section controls the middle, and the End section controls the end of the bar.
01:59If you want to change the shapes at the beginning or end of the taskbar, you
02:03choose the shape, the line style, and the color.
02:07In the Start section, click the Shape down arrow.
02:12Choose the triangle.
02:16Change the color to dark blue.
02:18Now you can do the same with the end mark.
02:22Click the Shape down arrow, choose the triangle, and click the down arrow in the
02:28color box and click dark blue.
02:32In the Middle section, you can change the color to dark blue to stay consistent.
02:37Click the down arrow and choose the same dark blue color.
02:41Bars come in wide, medium, or narrow.
02:44If you choose a bar that isn't full height, you can choose a position at the
02:48top, middle, or bottom of the taskbar row.
02:51Most tasks are full height, but progress bars are narrow bars in the middle.
02:56If you click the Shape down arrow in the Middle section, you can see the
03:00different bars you can choose from.
03:02Adding fields to taskbars means you can see task information in the Timescale;
03:07for example, taskbars come with resource names on the right end, but you might
03:12want to show initials instead to save space.
03:15In the table, select the category of taskbar you want to format.
03:21Let's select Task for regular tasks.
03:25Then select the Text tab.
03:27If fields are already associated with the taskbar category, you see them in the
03:32corresponding positions, like resource names here.
03:35You can add fields at the left, right, top, bottom, and inside of taskbars.
03:42Select a position box, like right, for resource names, click the down arrow,
03:47and then choose the field to display at that position, in this case Resource Initials.
03:58If you want to remove a field, you can select the position box and then press Backspace.
04:04When you finish formatting the bar style, click OK.
04:09Now you can see initials next to some of the bars.
04:12You can format individual taskbars, for instance to show customer meetings with green bars.
04:18Select the tasks you want to format in the View.
04:22On the Format tab, click the Format down arrow and choose bar.
04:28The Format Bar dialog box has the same Start, Middle, and End sections that
04:34you see for Bar Styles.
04:36You can choose the shapes, styles, and colors you want.
04:40The preview at the bottom of the dialog box gives you an idea of what your
04:44selections look like.
04:45But the background isn't quite white, so you can't gauge how the color will work
04:50until you see the bars in the view.
04:52To add fields to an individual taskbar, click the Bar Text tab.
04:57Choose the fields you want, as you do for Bar Styles, and then click OK.
05:02In this case, I'm going to click Cancel to not apply anything to this bar.
05:08There is a shortcut for changing a taskbar's color in Project 2010.
05:13Right-click the taskbar you want to change.
05:16In this case, I'm going to go to the Task tab and click Scroll to Tasks, so I
05:21can see the taskbar.
05:22Now I right-click the bar.
05:24On the mini toolbar above the taskbar, you can click the Bar color down arrow
05:30and then choose the color you want.
05:33Theme Colors give you color-coordinated shades, or you can click More Colors to
05:38pick exactly the hue you want.
05:42Following link lines between predecessor and successor tasks can be challenging.
05:47Layout options can clean up the Timescale a little.
05:50On the Format tab, click Layout.
05:56If you want an L-shaped link line to neaten things up, select the third
06:00option, as it is here.
06:01But if you want to hide link lines completely, select the first option.
06:06Then click OK to apply your settings.
06:09Formatting taskbars is an effective way to show off the information you want to see.
06:14You can emphasize entire categories of tasks, like critical tasks, or you can
06:19format individual bars to highlight a few key tasks.
06:23Choosing layout options also helps by keeping the Timescale neat and tidy.
06:28You can format things any way you want.
Collapse this transcript
Modifying text styles and text formatting
00:00Like Bar Styles, Text Styles apply formatting to text in different categories,
00:06like row and column headings, text positioned around the edges of taskbars, or
00:11the text for critical tasks in a table.
00:14You can use Text Styles to change the font, font size, font style, color,
00:20and background color,
00:21for example, to increase the font size to make tables more readable, or the font
00:26color to emphasize critical tasks.
00:29You can also change the format for a single text string to make sure you don't
00:33forget to check on a task with troublesome issues.
00:35To format categories of text, click the Format tab. Then click Text Styles.
00:44In the table, select a category of text you want to format.
00:48If you want to format all the text in the view, for instance so you can hide
00:52your reading glasses in the desk drawer, select All in the Item to Change
00:57dropdown list, like it is here.
00:59When you choose All, the formatting you choose applies to all the text in the active view.
01:06Changed cells represent the changed highlighting feature.
01:10If you want to make items that have changed stand out, you can change the text
01:14and background color for the changed cells category.
01:20In the Text Styles dialog box, pick the font you want, like Arial or Times New Roman.
01:36Font Style includes Regular, Italic, Bold, and combinations of those.
01:42In this case, choose Italic, and the Font Size determines the size of letters you see.
01:47You can type a number in the size box to pick a size that doesn't appear in the dropdown list.
01:55In this example, choose 12.
01:58In the Color dropdown list, choose the color you want, red to stick with
02:02the critical theme.
02:05Keep in mind dark colors are easier to read than light shades.
02:09Look at the screen or print samples to make sure that the colors work.
02:15Click OK to apply this Text Style.
02:18Like the shading that Project applies to changed cells, you can change the
02:22background color for categories, like critical tasks, or inactive tasks.
02:27To highlight cells that use a Text Style, in the background Color dropdown list
02:31you can choose the color you want.
02:33Let's choose critical tasks, and then in the Background Color, we can choose a dark red.
02:41Background Pattern comes in handy if you use black-and-white printers.
02:45The Sample box shows what the color and pattern formatting choices look like.
02:49Click OK to apply the formatting.
02:53You can also format text for an individual row, or even a cell in a table.
02:58Project 2010 makes this type of formatting even easier with the mini toolbar.
03:03Right-click a row, a cell, or several cells.
03:06In this case, select this one task.
03:10Then right-click a cell and a mini toolbar appears.
03:14You can click a tool to change the font, font size, font color and style.
03:28Here, I am clicking a dark blue for this particular cell.
03:32Formatting Text Styles or individual text makes information stand out.
03:37If you format text categories, project takes care of changing the formatting
03:41if a task, resource, or assignment switches categories.
03:45Formatting individual text emphasizes important information that doesn't fall
03:50into a category, like a particular task that the customer really cares about.
Collapse this transcript
Using the Timeline view to summarize a project
00:00The Timeline is a new view in Project 2010,
00:03that's great for distilling key information about a project.
00:07You can emphasize a few important tasks on the timeline or add key milestones as
00:12callouts, but the timeline also provides an easy way to adjust the dates you see
00:17in the primary view in Project.
00:19You can drag the ends of the Timeline bar, or drag the bar itself, so the timescale
00:24shows the dates you want.
00:25If the Timeline doesn't appear above the primary view, click the View tab, and
00:32then turn on the Timeline check box.
00:36Project displays the Timeline above the Primary view.
00:40The Timeline shows the Start and Finish date for the project.
00:44A light blue bar indicates the date range that's currently visible in the
00:49Gantt Chart Timescale.
00:50To scroll through the dates in the timescale, point at the blue bar in the timeline.
00:56When you see a four-headed arrow, you can drag to the left to move the Gantt
01:00Chart Timescale back in time, or to the right to move forward in time.
01:08To change the earliest date you see in the timescale, drag the left end of the
01:12blue bar in the timeline.
01:15To change the latest date, you drag the right end.
01:22You can also change the duration that appears in the timescale by dragging the
01:26Zoom slider in the status bar, down in the right corner of the window.
01:35To add tasks to the Timeline, or customize it in other ways, first click the
01:40Timeline pane and then click the Format tab.
01:46To add a task in your project to the timeline, click Existing Tasks.
01:52The Add Tasks to Timeline dialog box opens and displays check boxes for every
01:58task in the project.
01:59You can turn on the check boxes for the tasks you want to add to the timeline,
02:04such as Finalized lease and Open house. Then click OK.
02:19You can see the Finalized lease task as a bar in the Timeline.
02:23When you select a task in the Timeline, you can show it as a bar or a callout.
02:28Bars show up within the Timeline bar and are good for individual tasks you want to highlight.
02:33Callouts appear above the bar, which is good for milestones or project phases.
02:38To change between the two, select the task in the timeline, and then on the Format
02:43tab, click Display as Bar or Display as callout.
02:50You can also insert new tasks, callouts, or milestones on the timeline.
02:56In this case, let's add a callout. On the Format tab, click Callout Task. Then in
03:04the Task Information dialog box, you give the task a name, and you can type the
03:11date, in this case, 3/31/2011.
03:16Click OK to add it to the timeline, and there's our payment.
03:20To remove a task from the timeline, you can simply select it, right-click, and
03:26then choose Remove from Timeline.
03:29On the Format tab, clicking Detailed Timeline toggles between showing bars and
03:35showing bars with the task name and dates.
03:38Let me expand this so that you can see that. Here's the bar without any text, and
03:49when I click Detailed Timeline, it shows the text in the bar.
03:52When the Pan & Zoom check box is turned on, as it is here, you can drag the
03:57Timeline bar to change the dates in the timescale.
04:00However, if you want to set the Timeline to show the full Project date range,
04:05turn off this check box.
04:07If you want to share the Timeline view with others, on the Format tab,
04:10click Copy Timeline.
04:12You can send it by e-mail, or you can paste it into another program, like PowerPoint.
04:18When you choose an option, Project places the timeline on the clipboard, so you
04:22can paste it into the destination program you want.
04:25The Timeline view is usually a narrow band above the main view in the Project window.
04:30Its claim to fame is emphasizing a few key tasks, so don't try to stuff every
04:34project task onto it.
04:36But you can also use it as a shortcut for adjusting the dates that appear in the
04:40Timescale of the main view, for instance, to scroll around in time or to quickly
04:45show a specific date range.
Collapse this transcript
6. Fine-Tuning the Project Schedule
Using the Task Inspector to handle scheduling issues
00:00Task Inspector is new in Project 2010.
00:04This feature scans your project for issues, like tasks that start before their
00:09predecessors, or a subtask that occurs after the summary task's finish date.
00:15Manually scheduled tasks are prone to schedule problems because Project doesn't
00:19calculate their dates.
00:21If their predecessors move, the manually scheduled tasks stick to their original dates.
00:27Red squiggly lines, like the ones for misspellings in Microsoft Word, show
00:31potential schedule problems in Project 2010.
00:35When you right-click a cell with a red squiggly line, you can choose a command
00:40to correct the problem, or open the Task Inspector to see what's going on and
00:45choose the corrective action you want to take.
00:48If you look at the Prepare materials task, you see a red squiggly line on the finish date.
00:55The same thing goes for the Present to management task.
00:58Scheduling problems that arise often start somewhere else in the project.
01:03Predecessors that are delayed, time that's unavailable in a resources calendar,
01:08or date constraints are a few examples of items that can foul up a schedule.
01:13If you right-click a task, a few commands for correcting scheduling problems
01:18appear on the shortcut menu.
01:20Right-click Prepare materials.
01:24The first command on the shortcut menu is Fix in Task Inspector;
01:28we'll look at that shortly.
01:31The second command is Respect Links.
01:34That's because this manually scheduled task isn't following its task link to the
01:39Prepare management presentation task.
01:42Keep in mind using Respect Links on a manually scheduled task may temporarily
01:47correct a scheduling problem, but it might return if the predecessor task
01:51changes, or is delayed.
01:54Choosing Respect Links moves the tasks so it now follows its predecessor.
01:59You can see that in the Timescale.
02:02However, the red squiggly line doesn't go away, so there is actually another problem.
02:09Task Inspector can help identify problems with the Prepare materials task.
02:14On the Tasks tab, click Inspect. You can also right-click the Task and choose
02:20Fix in Task Inspector.
02:23The first section of the Task Inspector lists problems with the task.
02:29In this case, there are a couple of them.
02:31The Resources are assigned in nonworking time, and the Task finishes after its summary.
02:39The second section of the Task Inspector shows different repair options, and if
02:44you scroll down, you can also see factors that affect the scheduling of the task,
02:49in this case the Manually Scheduled setting is the most important.
02:54The Repair section lists several repair options. Extending the Summary task will
03:00correct the problem that Project sees, but it isn't really what you want,
03:04because the management meeting is going to occur on December 17th, regardless.
03:10The other repair options would correct the problem of resources working during
03:13nonworking time, but because the management meeting is fixed, these repairs
03:18actually won't work either.
03:20This just goes to show the Task Inspector isn't infallible.
03:24However, just to see how repairs would work, you can click Reschedule Task to
03:29move the task to when the resources are available.
03:34You can see that the task finish date moves out, but the Task Inspector still
03:39shows several problems.
03:42In this case, because the repair didn't fix the problem, go up to the Quick
03:46Access Toolbar and click Undo.
03:48And before we move on, let's scroll up so that we can see the summary task.
03:55The factors that appear in the Task Inspector pane may change as you modify the schedule.
04:01For example, click Extend Summary.
04:05You can see that the summary task now expands to include the task dates for all
04:10of the task below it, and the repair options change.
04:16Sometimes you want to ignore problems.
04:19Maybe you get a resource to agree to work extra hours, so you want to ignore a
04:23resource over-allocation.
04:26The Present to management task has a red squiggly line, but it's scheduled on
04:31the right day, so you decide to hide this squiggly line for the problem.
04:36Right-click the task and choose Ignore Problems for This Task. Project hides the line.
04:45If you decide to review problems you've ignored, on the Task tab click the
04:49Inspect down arrow, and choose Show Ignored Problems.
04:56The red squiggly line is back.
04:59The Present to management task has a problem, because the Prepare materials
05:04predecessor finishes later.
05:07It turns out that the real problem with the management meeting is that the real
05:11OPM and assistant have to start working on the presentation sooner.
05:16The task link between the Draft the budget and Prepare management presentation
05:20makes sense, but it doesn't get the presentation done in time.
05:25In an earlier movie, you learned how to modify resource assignments,
05:28for example to increase the units that the real OPM and assistant work on
05:32tasks. It turns out that's the real solution to getting this presentation done in time.
05:38Project identifies problems or potential improvements to your schedule with red
05:43and green squiggly lines.
05:45You can right-click a task to choose commands that can fix the problem, or you
05:49can open the Task Inspector to dig a little deeper and choose a repair option
05:53that makes the most sense.
05:55But sometimes the problems go beyond what Task Inspector can handle, and you
05:59have to come up with your own solutions, like modifying resource assignments or
06:03adjusting task dependencies.
Collapse this transcript
Splitting and delaying tasks and assignments
00:00When tasks overlap, the assigned resources may have more work than they can get
00:05done with the time they have available.
00:08If you don't have other resources you can assign, you can delay tasks so the
00:12assigned resources can work on the tasks one after the other.
00:16You can also split tasks into pieces, so the resources can go back and forth
00:21between tasks until all the work is done.
00:24In this project, the Select site and Estimate costs tasks have
00:29overallocated resources.
00:31The overallocation indicators are the red people icons in the indicators column.
00:36The tasks use the same resources and are scheduled at the same time.
00:41Project has the Level Resources feature, which can split and delay task to
00:46remove resource overallocations, but sometimes it takes time just to get level
00:51resources to do what you want.
00:54If you have just a few tasks to reschedule, you can split or delay tasks to
00:59resolve the overallocations on your own.
01:02Say you want to delay the Estimate cost task until the Select site task is complete.
01:08You can delay the task by adding a value to the Leveling Delay field for the task.
01:13The Leveling Gantt view makes it easy to work on task delays.
01:18On the Task tab, click the View dropdown and choose Leveling Gantt.
01:25The table in the Leveling Gantt view includes the Leveling Delay column, so you
01:30can enter leveling delays.
01:33The leveling delay moves the start date out for the task and all its resource
01:37assignments. Because it's the same field that the level resources feature uses,
01:42it's specifically for removing resource overallocations.
01:47Let's expand the table so that we can see the dates for these tasks.
01:52In the leveling delay cell, you type the length of time to delay the task.
01:57In this example, the Estimate costs task starts the same day as the Select site
02:03task, November 11/1/10.
02:04So you want to delay the task to start after the Select site task finishes.
02:11You see in the table that the duration for the Select site task is 5 days. Click
02:17the Leveling Delay cell for the Estimate cost task. Type 5 and press Enter.
02:24Project changes your entry to 5 edays.
02:28The e stands for elapsed time, which means it doesn't take nonworking time into account.
02:35Now, the Estimate costs task waits until after the Select site task is done, as
02:41you can see in the timescale.
02:44The narrow line before the taskbar shows the Leveling Delay that you added.
02:50And you can see that the overallocated resource indicators have disappeared
02:54from the indicator cell.
02:56Even though you start one task after the other, you don't want to use a task
03:00link to do this. That's because the link would be there, even if you decided to
03:05use a different resource.
03:06By using a Leveling Delay, it's much more obvious that the delay is there
03:11because of our resource overallocation.
03:14Splitting a task means that you break the task into pieces. Then you can
03:19schedule each piece separately.
03:21For example, the Finalize lease task and the Hire contractors task overlap, and
03:28both use the office manager.
03:31Let's scroll to see these more clearly.
03:35Say you want to split the Finalize lease task to squeeze in hiring contractors.
03:40On the Task tab, click Split Task, which looks like a broken taskbar.
03:48The pointer changes to a Split taskbar pointer. Click the Finalize lease taskbar
03:55where you want the split to start.
03:58In this case, it's on the date that the Hire contractors task starts.
04:02Drag the split to where you want that part of the task to resume, at the end of the other task.
04:11Project splits the taskbar in two, and moves the second part.
04:15The dotted line between the two pieces shows the split, and you can see that the
04:20resource overallocation indicators for both tasks disappear.
04:25Delaying a task is one way to remove resource overallocations.
04:29By using the Leveling Delay field, you make it clear that the delay is due to
04:34Resource Availability.
04:35If you decide to use different resources, you can remove the delay, so the tasks
04:39occur as soon as possible.
04:41Splitting a task is another solution, in which you break the task into two or
04:45more pieces, so you can reschedule other work somewhere in the middle.
Collapse this transcript
Adjusting a work contour
00:00Project assumes that resources work the same amount every day, from the start to
00:04the finish of every task.
00:07But you know that work sometimes starts slowly, ramps up to a steady level, and
00:12then tapers off while someone ties up loose ends.
00:15At other times, people work more and more as days pass to get the work done by the due date.
00:21You can apply Work contours to resource assignments to reflect how work really gets done.
00:28Work contours change the amount of work that is assigned during each period over
00:32the length of assignments.
00:34Work contours apply to assignments for auto scheduled tasks, not
00:38manually scheduled ones.
00:39And the Flat contour is what Project applies automatically.
00:44It scheduled the same hours of work each day, like eight hours, if a resource
00:48works 100% on the task.
00:50To see what the work hours look like for the Flat contour, select the Inventory
00:55Office task, click the View tab, and then click Task Usage.
01:04Each day, the Office manager and the Relo Assistants are assigned to work 8
01:10hours for the length of the tasks.
01:13Contours come in several shapes.
01:15The benefit of using Work contours is that you may eliminate overallocations
01:20without reassigning resources.
01:21You use the time that assignments don't demand a resource's full attention to overlap tasks.
01:29The reduced hours on some days though, mean that a task will have a longer
01:33duration than it does with the Flat Contour.
01:36To apply a Work contour to an assignment, double-click the Relo Assistant row,
01:41below the Inventory Office task.
01:44The Assignment Information dialog box opens.
01:48The Work contour box shows that the Flat contour is applied.
01:52When you click the Work contour down arrow, the dropdown list has contour names.
01:58It doesn't show how they shape the assignment hours.
02:01But some of the names are easy to figure out.
02:04Back Loaded means that the highest level of work is loaded at the end of the assignment,
02:09a lot like your adrenaline level as you approach a deadline.
02:13Click Back Loaded and then click OK.
02:17The indicators column displays the Back Loaded indicator, which shows, graphically,
02:22how work is distributed over the course of the assignment.
02:27If you look at the hours for the assignment in the timescaled grid, you see
02:31that the first day is .8 hours.
02:34When you scroll to the right, you can see the hours increasing, until it reaches
02:43the 8 hours a day at the very end.
02:47The last day is slightly less, but that represents what's left over at the end of the task.
02:53Front Loaded is easy to figure out.
02:55It starts with a maximum at the beginning and decreases until the end.
03:00You can use the Work contour indicators to figure out the other contours.
03:06On the Quick Access Toolbar, click Undo to get rid of the Back Loaded contour.
03:12Now double-click the Relo Assistant assignment again.
03:16This time choose Double Peak and click OK.
03:21Double Peak looks like a suspension bridge.
03:24It comes with a peak near the beginning, another one near the end, with lower
03:28hours tapering up and down over the rest of the time.
03:32Once you know what Double Peak looks like, you know what Early Peak in Late Peak do.
03:37Early Peak has a peak at the beginning like the first part of the Double Peak.
03:40Then it tapers off until the end.
03:43Late Peak starts slow and increases to a peak near the end.
03:48The workload in a Bell contour increases to a peak and then tapers off to the end.
03:54Finally, the Turtle contour is like the Bell contour except that it ramps up and
03:58down more quickly, with a maximum hours for a longer period in the middle.
04:03You can't define Custom contours;
04:06however, you can manually change the hours and the time phased grid on the right
04:10side of the Task Usage view.
04:13Click an assignment cell and type the new hours for that period.
04:19If you manually edit work hours, the indicator cell displays the edited work icon.
04:25It looks like a contour indicator, but it has a pencil on it as well.
04:30Work contours change the hours assigned each day, so that some days have more
04:34hours and some have less.
04:36Contours are often a better reflection of how much time resources spend on their
04:40assignments over time.
04:42Even though Work contours lengthen assignments, you may be able to eliminate
04:46resource overallocations with less of an impact on the project finished date
04:50than delaying task until resources are available.
Collapse this transcript
Leveling resources
00:00The Level Resources feature delays and splits resource assignments to help you
00:05get rid of overallocations.
00:07If you level your entire project, don't expect Microsoft Project to figure out
00:11everything you hoped it would do.
00:14In many cases, it delays some assignments for eons, or splits tasks into teensy pieces,
00:20so resources have to keep jumping back and forth between tasks.
00:24With Project 2010, you can focus leveling on specific tasks or resources, so you
00:30can level the items that are giving you the most trouble.
00:34The leveling Gantt Chart view helps you see the results of leveling right away.
00:39That way you can undo the leveling if you want to try different options, or level
00:43different parts of your project.
00:45On the Resource tab, click the View down arrow and choose Leveling Gantt.
00:51On the Ribbon, you see Level Selection, Level Resource, and Level All.
00:57If you want to level the entire project, you click Level All.
01:02If you have a few resources in great demand, you can select those resources and
01:07then click Level Resource.
01:09In this project, the tasks for evaluating lease sites and identifying costs have a
01:14lot of resource overallocations.
01:17You can tell Project to level just those tasks.
01:21Select the tasks that you want to level.
01:27You drag over the task IDs from Evaluate lease sites down to Hire contractors.
01:34Once the tasks are selected, you can click Level Selection.
01:40The green bars show the original dates for the tasks. The blue bars show
01:46the leveled schedule.
01:47For example, Finalize lease and Identify additional costs both have leveling
01:54delay lines in front of them.
01:56In fact, the Finalize lease task is moved later by about a month.
02:03The Estimate cost task has a split in it.
02:06That's to give the Relo PM time to identify additional costs.
02:11The Inventory Office task has a longer duration.
02:14That's because the Relo Assistance assignment was delayed until the second part
02:19of the Estimate cost task.
02:21As you can see, the leveling features sticks to delays and splits to get rid
02:26of overallocations.
02:28Before you level resources, you can consider other ways to remove overallocations.
02:33For example, in earlier movies, you learned how to add resources to task to
02:38reduce the time overallocated resources have to work, or you could replace
02:43resources with people with more available time, or use Work contours.
02:48If you don't like the leveling results you see, on the Quick Access Toolbar you
02:53can click Undo to undo the leveling command. Or as an alternative, if you've
03:00leveled, you can also click Clear Leveling on the Resource tab and then choose
03:06Entire Project and click OK.
03:11Leveling Options let you control some aspects of Project's leveling strategies.
03:16Click Leveling Options. The Resource Leveling dialog box opens.
03:21When you choose Leveling Options, Project uses the same settings each time you
03:25level until you choose different options.
03:28Your first choice is Automatic or Manual.
03:32The Manual option is the smart choice, because you don't want Project to level
03:36assignments after every little change you make to your project.
03:40When you select the Manual option, you simply click a Level command on the Ribbon
03:45to tell the program to do its leveling magic.
03:48The next choice can have a huge effect on how much Project has to level.
03:52You already know that overallocations can work themselves out over time.
03:58A resource could be over allocated on Monday and have free time on Thursday.
04:03If you level using longer time periods, Project may have fewer over-
04:07allocations to deal with.
04:09In the Look for overallocations on a Day by Day basis box, choose the longest
04:15time period you're comfortable with.
04:17Week by Week works for most projects.
04:20Click the down arrow and choose the timeframe you want.
04:25Turn on the Clear Leveling values before leveling check box.
04:29That tells Project to remove any previous leveling delays.
04:34Starting from scratch each time you level is usually the best approach,
04:37so you see the changes that Project makes more easily.
04:40However, if you added from leveling delays manually, you might want to turn the check box off.
04:46Project automatically selects the Level entire project option.
04:50You can choose the level option if you want to set a date range, for example, to
04:55level just the phase of the project you're working on now.
04:58The Leveling order is set to Standard initially, and that's what you want unless
05:03you decide to assign priorities to tasks.
05:07Project turns off the Level only within available slack check box initially.
05:13This setting removes all overallocations and pushes the project finish date
05:17out as much it has to.
05:19If you're trying to remove overallocations without moving the finish date,
05:24turn this check box on.
05:26That way Project levels only if the leveling doesn't push the finish date out.
05:32Project also turns on the Leveling can adjust individual assignments on a task check box.
05:37So it levels only the assignments that overallocate resources, and that's
05:42usually what you want.
05:43When you turn on the Leveling can create splits in remaining your check box,
05:47Project can split or delay tasks that haven't started and add splits to the
05:51remaining work for tasks in progress.
05:54With the check box turned on, Project doesn't use splits, so a resource can
05:58complete work without stopping.
06:00Unfortunately, that usually pushes tasks out to something close to the end of time.
06:06Project turns on the Level manually scheduled task check box, which is what you want.
06:11Manually schedule tasks tend to result in more overallocations than
06:15auto scheduled ones.
06:17When you're done setting all your options, click OK to close the dialog box.
06:21Then you can click a Leveling command to start leveling with the new options.
06:27Leveling takes a lot of factors into account.
06:30The best way to get the results you want is to level small portions of
06:33your project at a time,
06:35a few tasks or a few resources.
06:38You can also choose leveling options to give Project hints about how you want it
06:42to level your project.
06:44And remember, if you don't like the results, press Ctrl+Z or click Undo to
06:49undo them and try again.
Collapse this transcript
Inactivating tasks
00:00Inactivating tasks is a new feature in Project 2010 that helps you document
00:05tasks in several situations.
00:08Suppose you have tasks that you define, but you aren't ready to include them in your project.
00:13Perhaps you have a couple of alternative approaches for the same work, or
00:17optional work that you might not have budget for, or even change requests that
00:21haven't been approved.
00:23You want to see them in your project file, but you don't want them contributing
00:27to the cost or resource workloads just yet.
00:30Inactive tasks do just that.
00:33Then if you get the go ahead for these tasks, you reactivate them and all the
00:38information flows back into your project plan.
00:41This Office Move Project has two alternatives for new locations.
00:46I click on the vertical scrollbar to show the two different options:
00:50Evaluate build sites and Evaluate lease sites.
00:54Right now, both sets of tasks are rolled up into the Schedule, Cost and Workloads.
01:01You can see the Choose new location summary task has a cost for both
01:06options rolled up into it.
01:08Likewise, the work hours, 1000 hours for Evaluate build sites and 376 hours for
01:15Evaluate lease sites are rolled up into the Choose new location summary task.
01:20Making tasks inactive removes their values from your project's rolled up
01:25Schedule, Cost and Workload, but the tasks, their resource assignments, and
01:31other information remain in the plan.
01:34Suppose you decide to inactivate the tasks for Evaluating build sites to focus
01:39on the faster and less expensive lease option. Select the Evaluate build sites
01:44summary task and its subtasks.
01:48Click the Task tab and then click Inactivate.
01:54Several things happen.
01:56First, the tasks you inactivated are grayed out and have a strikethrough line
02:01drawn through their values.
02:03The Inactive Taskbars changed to white with a thin black border.
02:09If you check the Choose new location summary task, you see that the Finish
02:13date, Cost, and Work are now equal to the values from the Evaluate lease sites summary task.
02:20The Cost is $33,840 in both cases, and the Work is 376 hours.
02:28The inactive tasks still have all the information you entered.
02:33In fact, you can edit the inactive tasks.
02:37Select an inactive cell on the table and edit its value, or double-click the
02:42task to open the Task Information box.
02:45In this case, I'll change the duration to 50 days.
02:50If you decide to reactivate the tasks, the edited information is still there.
02:54For example, say you want to see what the project looks like if you go with the build option.
03:01Select the build option tasks again and click Inactivate.
03:07The tasks change back to their original look, and the values roll up into the summary tasks.
03:13In this case, scroll down to make sure you have all the Evaluate lease site
03:18tasks, select them, and click Inactivate to make them inactive.
03:25Now you can see that the Choose new location summary task is equal to the
03:29Evaluate build sites values.
03:32Inactive tasks are perfect for alternative options, or tasks you don't have approval for.
03:37You can define tasks and assign resources as you would normally.
03:41Then when you make them inactive, Project keeps the information but doesn't roll
03:46values up into summary tasks.
03:49If you decide to add the tasks to the project, you simply reactivate them,
03:52and you're ready to go.
Collapse this transcript
7. Tracking and Managing Projects
Understanding baseline, scheduled, and actual values
00:00When you finish your project plan, you can save it in Project in a Baseline.
00:04Those are the target values you aim to achieve when you execute your plan.
00:08As you work on your plan in Project, you see the current plan, which is your
00:12schedule and cost based on changes you make to the plan, along with the effects
00:17of actual performance.
00:19Project uses baseline values and current values to calculate the variances and
00:24other performance measures.
00:26By comparing your current schedule values to the baseline, you can see whether
00:30the project is on time and within budget.
00:33When you get the project plan the way you, the Project customer and the
00:37management team want it, you save that plan.
00:40In Project, you save a baseline, which is a set of dates, task durations, work
00:44hours, cost and other fields that you try to meet when you execute the project.
00:49The Gantt Chart View shown here doesn't show the baseline initially.
00:53One view that does show your baseline is the Tracking Gantt.
00:57On the Task tab, click the View down arrow and then choose Tracking Gantt.
01:02If necessary, you can click Scroll to Task to see the taskbars in the timescale.
01:07The Tracking Gantt has two taskbars for each task.
01:11The top taskbars, blue here, show your current project schedule.
01:16The bottom taskbars, gray, are your baseline schedule.
01:20Another helpful view for looking at different values is the Task Details Form.
01:25On the View tab, make sure that the Details check box is turned on, and then
01:30click the down arrow. Choose More Views, and then in the More Views dialog box,
01:34double-click Task Details Form.
01:37You can see that there are options for Current, Baseline and Actual, so you'll
01:42be able to look at all those values.
01:44These two views together can help you get a handle on the difference between
01:48Baseline, Schedule, and Actual values.
01:50Let's look at the Identify requirements task.
01:53In the Task Details Form, select the Baseline option.
01:57The Start and Finish boxes display the Baseline Start and Finish dates for the
02:02task: November 1st and November 26th. And if you look at the gray taskbar on the
02:07timescale, you can see that that's when it occurs.
02:10When you first save a baseline, the Baseline and Current values are the same,
02:15but then, as you work on your project, the Current values will usually change.
02:21When you enter actuals, Project recalculates the task dates, duration, work, and costs.
02:26The Current values can also change whenever you edit your plan.
02:30In this case, the blue bar shows the Current dates and duration for the task.
02:35You can see that it starts on the same date as the baseline, but it
02:39actually isn't as long.
02:41That means the task finished early.
02:43You can also see the Current values by selecting the Current option in the Task
02:48Details Form. And you can see here that the Start date was the same, November
02:521st, but the Finish date did come in earlier, November 23rd.
02:57This task is complete, so it also has Actual values.
03:01If you select the Actual option in the Task Details Form, then the Actual values
03:06for the task appear, and you can see that because the task is complete, the
03:10Current and the Actual values are the same.
03:12When tasks are in progress, the Baseline, Current and Actual values may all be different.
03:18Let's look at the Identify costs task, and we'll look at the baseline.
03:23The Baseline Start is January 20th, and the Baseline Finish is March 11th.
03:28The Duration is 20 days.
03:30If we now look at the Current values, you can see that it starts on January 6th
03:35and finishes on February 25th.
03:38The Duration is still 20 days.
03:40On the other hand, if you select the Actual option, there is no Finish date,
03:44because the task is in progress.
03:46It hasn't finished yet.
03:48One way to see Baseline fields is to display the Baseline table.
03:52First, let me click this cell to deselect the task.
03:55Then on the View tab, click Tables and choose More Tables.
04:00In the More Tables dialog box, double- click Baseline to apply the table to the view.
04:05I'm not sure what this invalid duration is, but I'm going to click OK to dismiss
04:11the message and move on with work.
04:14In the Baseline table, you can see Baseline Duration are your target
04:18durations for your tasks.
04:20The Start and Finish are your target dates, the Work is the amount of work
04:25that you've estimated for your tasks, and the Cost is what they will cost if
04:30you do all of that work.
04:32When you first save a baseline, your original plan and your Current values are the same.
04:37Then as you record Actual values, your Current values can change.
04:41Project keeps track of your original plan in the Baseline, but it also keeps
04:45track of actual progress your team is making.
04:48The difference between your Baseline and the Current plan is called Variance,
04:51and it tells you whether tasks are ahead of or behind schedule, and whether costs
04:56are within or exceeding budget.
Collapse this transcript
Saving and clearing a baseline
00:00When project stakeholders approve the project plan, your next step is to save
00:04the baseline in Project.
00:06You can save additional baselines at later dates, for example, to track trends
00:11in Project performance as the team makes progress.
00:14Project can save up to 11 baselines.
00:17If you don't want a baseline anymore, or you run out of baselines, you can clear
00:21a baseline to remove the baseline values.
00:24When the project plan is the way you want, you are ready to save the baseline.
00:28Click the Project tab, then click Set Baseline and choose Set Baseline on the dropdown menu.
00:35The Set Baseline dialog box opens.
00:37The options that Project selects initially are almost always what you want for
00:42your first baseline.
00:43The Set Baseline box is set to Baseline.
00:46That's the baseline that Project uses to calculate variances.
00:50The entire Project option is selected, so it saves the entire project.
00:54So go ahead and click OK.
00:57Project stores the current values for start, finish, duration, work, and costs in
01:03the corresponding Baseline Fields.
01:06To see this, start by right- clicking the All Cells box. That's at the
01:11intersection of the Column headings in the task ID rows,
01:14and then choose Variance. And here you can see Baseline Start and Baseline Finish.
01:19You can also see that the current start date matches the Baseline start date.
01:24Now click set Baseline again and choose Set Baseline.
01:29And you can see that one of the baselines is saved.
01:32You can tell because it has a date when it was saved in the dropdown list.
01:37Saving an additional baseline is a good idea if your project goes through big changes.
01:42Say your project is halfway complete, when it gets put on hold, while another
01:46project gets all the attention.
01:48When you get back to work, the original Baseline start and finish dates aren't a
01:52good reflection of reality.
01:53So you can save a new baseline with your new target dates and other values, so
01:58you can track performance going forward.
02:00You can keep the original baseline if you want, because Project can save up to 11.
02:04The primary baseline is in the field that starts with Baseline.
02:08But you can choose Baseline 1 through 10 for other baselines.
02:12To set an additional baseline, just choose the one that you want in the dropdown
02:16list, Baseline 1 in this example.
02:19Leave the entire Project option selected and click OK to save this baseline.
02:24Project 2010 makes it easy to look at other baselines.
02:28If you display a Gantt Chart View, click the Format tab, then you can choose the
02:34Baseline dropdown arrow, and choose the baseline that you want to look at.
02:39You can also overwrite a baseline that you saved, but sometimes you simply
02:43want to get rid of a baseline that you saved by mistake, or because it's just so out of date.
02:48To clear a Baseline, go back to the Project tab, click Set Baseline and then
02:54choose Clear Baseline.
02:57Then you can choose the baseline that you want to clear, let's say Baseline 1, and click OK.
03:03You can save up to 11 baselines in Project.
03:06So you can keep track of the status that you want from month to month, or year to year.
03:11If you run out of baselines, or you save one by mistake, you can always clear
03:16it to clear out the values in the corresponding Baseline Fields.
Collapse this transcript
Editing tasks and adding them to a baseline
00:00Every so often, you have to edit a baseline after you save it.
00:04For example, someone finds a big mistake in a plan you saved.
00:07If the baseline already has values, you don't want to overwrite the entire
00:11baseline, because you lose the variances that may already exist.
00:15In this case, you can resave the parts of the baseline with changes.
00:19At other times new tasks may arise, such as change requests that your
00:23customer agrees to pay for.
00:25In this situation, the new finish dates and costs aren't variances.
00:29They are part of the updated plan.
00:31So you want the baseline to reflect these changes.
00:34You can add the task to the baseline and set the baseline values for those
00:38tasks, and Project leaves your other baseline tasks alone.
00:42If you want to change a baseline before you have any actual values in your
00:46project, you can simply overwrite the baseline.
00:49Click the Project tab, then click Set Baseline and choose Set Baseline.
00:55In the Set Baseline dialog box, choose the baseline that you want to overwrite,
01:00in this case it is baseline.
01:02Leave the entire Project option as it is, and just click OK.
01:06A message box warns you that you're about to overwrite the baseline.
01:10Just click Yes, to rewrite the values.
01:13But suppose your project has actual values and some tasks already have
01:17variances from the baseline.
01:19You don't want to lose that information.
01:21In the case, you want to resave specific tasks in the baseline.
01:26You can filter the task list to show all the incomplete tasks.
01:30Click the View tab, then click the Filter down arrow and choose Incomplete Tasks.
01:36To select all the tasks in a filtered list, click the All Cells box.
01:41Then on the Project tab, click Set Baseline and choose Set Baseline.
01:47In the Set Baseline dialog box choose the baseline you want to resave, baseline once again.
01:53But in this case, now you want to select the Selected Tasks option.
01:58So you just baseline the tasks that you have selected and click OK.
02:03Just as before, a message box warns you that you're about to overwrite the
02:07Baseline. Click Yes.
02:09You can resave parts of a baseline, either to reflect edits you have made to
02:13the project, or to include new tasks that you've added.
02:16When you save selected tasks in a baseline, you can tell Project how you want
02:20the new values to roll up into summary tasks, which help you see the effect of
02:24the baseline edits you made.
Collapse this transcript
Updating the schedule
00:00The level of detail you use to track progress depends on your organization, the
00:04type of project, and the information your stakeholders need.
00:08It may also depend on how much time you have to collect progress data and enter
00:12it into your project file.
00:14Project lets you fill in progress information using almost any level of detail,
00:19from a quick percent complete to the actual hours worked.
00:23If are progressing according to plan, the Mark on Track command is an easy
00:28way to update them.
00:29First, click the Project tab. Then click the Status Date Calendar.
00:33We are going set a Status Date, in this example 2/11/2011, and click OK.
00:41From then on, you can see the current status date right on the Ribbon.
00:45The next step is to select the task or tasks you want to update.
00:49In this case, click Finalize lease and Ctrl+Click Estimate costs.
00:55Then on the Task tab, click Mark on Track.
00:59Projects sets the actual Start date to the scheduled date and updates the
01:03percent complete based on the Status Date.
01:06Finalized lease doesn't finish until after February 11.
01:10So you that it updated the progress to the Status date.
01:14On the other hand, Estimate cost does finish before the Status Date, so it
01:19shows as 100% complete.
01:21Another quick but less accurate update method is Percent Complete.
01:26The first thing to remember is percent complete represents the duration that's
01:30complete, not how much work is done.
01:32But for easy updates, percent complete gives you an idea of where you stand.
01:37A quick way to update a task's percent complete is from the task mini toolbar.
01:42Right-click at task and then click the down arrow for Percent Complete and
01:47choose the percent complete you want. Let's choose 50%.
01:51On the other hand, to set percent complete to any value, you can use the
01:56Update Task command.
01:58Select the tasks you want to update to the same percent complete value,
02:02for example, Identify additional costs and then Ctrl+Click Inventory office.
02:08On the Task tab, click the Mark on Track down arrow, and choose Update Tasks.
02:16In the Update Tasks dialog box, type the percentage in the % Complete box, let's
02:21say 80% and click OK.
02:24Project updates both of these to 80%.
02:26No matter how you update tasks, Project shows the % Complete with a narrow black
02:32bar in the middle of the taskbar, up to the % Complete mark -
02:3680% on both of these tasks.
02:39The Update Task dialog box contains all the fields you can use to update progress,
02:44so you can use it to update progress for a variety of data.
02:48If you have several tasks with the same update values, you can select them all,
02:52and then open the dialog box to enter the update values.
02:56In this example, select the Inventory office task again.
03:00On the Task tab, click the Mark on Track down arrow and choose Update Tasks.
03:05You can see that the Update Task dialog box includes % Complete, Actual
03:10duration, Remaining duration, and Actual Start and Finish.
03:14If you type a value in the % Complete and Actual duration, Project calculates
03:20the Remaining duration and updates the total Task Duration.
03:24For example, type 25% in the % Complete dialog box, and type 8 days for Actual duration.
03:33Click OK.
03:35Now open the dialog box again.
03:37You can see that the remaining duration is 24 days. That's the other 75%, based
03:43on the actual duration of 8 days.
03:45The new duration for the total task is 32 days.
03:49If you don't enter the actual start, project just uses the scheduled start date
03:54for the actual start.
03:55You can also skip the % Complete box and fill in the Actual and Remaining
03:59duration. Then Project figures out the % complete from those two values.
04:04For completed task, you can simply fill in the Actual Start and Actual Finish
04:08dates, and Project calculates the rest.
04:11If you display the Task form in the Details Pane, like it is here, you can
04:15select a task in the Gantt chart view to see its values in the task form.
04:19Right-click the task form and choose Work.
04:22That way you can see the total work, the Actual work, and the Remaining work.
04:27If you want, you can type in Actual work and Remaining work,
04:31in this example, let's say 50 hours, and for Remaining work 80 hours, and click
04:37OK, to update the task that way.
04:40Project has an almost infinite variety of methods for updating progress. The key
04:44is to use the method that's easiest for you, but gives the level of accuracy
04:49that you and your stakeholders need.
Collapse this transcript
Using overtime
00:00One thing you don't want to do is assign overtime as part of your
00:04original project plan.
00:05If you count on people working long hours from the get go, there won't be
00:09any wiggle room left if you need them to work even more once the project is underway.
00:15But if a project schedule starts to slip during execution, you can assign some
00:19overtime to keep the schedule on track.
00:22How you do that in Project is a little different though.
00:25Projects overtime feature is a bit unwieldy, but the good news is you can
00:30often handle overtime assignments without going anywhere near Project's over-
00:34time-related fields.
00:36The only time you have to resort to Projects overtime feature is when resources
00:40get paid more for their over time hours.
00:43When resources earn a salary or earn the same hourly rate, no matter how many
00:48hours they work, you can handle overtime with easier techniques.
00:52The best approach is to set resources' work schedules to longer hours for a period of time.
00:58For example, you can edit a resource's calendar and define an overtime work week.
01:02On the Project tab, click Change Working Time.
01:06In the For Calendar dropdown list, choose the Resource, in this case Relo Assistant.
01:14Click the Work Week's tab.
01:16In a blank name cell, type a Work Week name like Overtime.
01:21In the Start and Finish cells, you can choose the date range for the overtime.
01:26Let's say January 9th, 2012 to January 27th.
01:33Then click Details.
01:36Drag over Monday through Friday to choose the dates, and select the option Set
01:42day(s) to these specific working times.
01:44Now you can change the end time for the work days to 7, to add a couple of hours
01:52of work and click OK.
01:54Click OK to close the Change Working Time dialog box.
01:59One thing you don't want to do is increase a resource's maximum units in
02:04the resource sheet.
02:05Doing that tells Project to assign the resource for longer hours for the entire
02:10project, and that's bound to generate some complaints.
02:13But if resources are paid more for overtime hours, then you do have to assign
02:18overtime hours in Project or the labor costs won't be correct.
02:23As you learned in an earlier movie, the overtime rate in the resource sheet
02:27tells Project how much someone is paid for the overtime hours you
02:30specifically assign.
02:32Click the View tab and then click Resource Sheet.
02:35In the Movers Overtime rate cell, type 75, and press Enter.
02:41The easiest way to assign overtime hours is by customizing the task usage or
02:46resource usage view to show overtime hours.
02:50On the View tab, click Task Usage.
02:54We want to add overtime work to the table.
02:58So right-click a column heading and choose Insert column. Then start typing Overtime.
03:04As soon as you just see Overtime Work, click it to add the column to the table.
03:10We also want overtime in the time phase grid.
03:15To do that, click the format tab and click Add Details.
03:22Scroll down in the list and select Overtime Work and click Show to add it to the
03:29Show these fields list.
03:31Then when you click OK, you can see that there is a row for each assignment, for
03:37Overtime Work as well as Work.
03:39We are going to add some overtime to the pack and move task for the movers.
03:45So let's scroll down to that task, just near the end of the project.
03:53Here is Pack & Move and with the Movers assigned.
03:56If I scroll over a little bit in the time phase grid, you can see that it starts
04:02on the 20th and goes into the second week, ending on the 29th.
04:09But we want this task to end in the first week, so we are going to assign some overtime.
04:14The hours in the second week add up to 66 hours,
04:17so we are going to use those as overtime.
04:19You can't actually edit the overtime hours in the individual time periods.
04:24So the way you add overtime is you type the hours in the overtime work cell in the table.
04:30Type 66 and press enter.
04:34Project automatically sets the 66 hours to overtime and the rest is regular hours.
04:40And it divides the over time over the new duration of the task, so the total
04:45work for each day increases.
04:48The cost for the task will increase as well, because 66 hours are being charged
04:53at a higher rate of $75 per hour.
04:56If resources earn the same amount per hour, no matter how many hours they work,
05:01you can assign overtime simply by setting up a workweek with longer hours for
05:05the timeframe you need.
05:07However, if resources earn more for overtime you have to set their rate in the
05:11Overtime Rate field and then fill in the Overtime Work field with the number of
05:15hours of overtime you want to assign.
05:18That way Project takes care of calculating the cost for regular work hours and
05:22overtime work hours, and gets your labor cost correctly.
Collapse this transcript
Updating costs
00:00For work and material resources, you don't have to do anything to update costs.
00:05Project calculates the cost for people, equipment, and materials based on the
00:10rates and other cost fields you define for the resources and the work hours, or
00:15quantities, you add to the assignment.
00:17However, if you use cost resources, you have to update those values to
00:22your actual values.
00:24To see that you don't have to update labor and equipment costs, right-click the
00:29All Cells box and choose Tracking.
00:35Drag the vertical divider over, and you can see that Project has calculated
00:40actual cost based on work hours for the people assigned the tasks.
00:46If you have work resources that can't speak for themselves, like cranes or
00:50helicopters, you do have to designate someone to tell you the work hours
00:54for that equipment.
00:56If you assign material resources, the actual cost includes the quantity of
01:01material multiplied by the cost rate per unit.
01:04The only update you might need to make is updating the actual quantity of material used.
01:11To do that, on the View tab, click Resource Usage. Scroll down to one of your
01:17material resources, in this case Keycard.
01:22Double-click the assignment to open the Assignment Information dialog box and
01:28then click the Tracking tab.
01:31In the actual workbox, type the actual quantity.
01:37In this case, let's type 175 and click OK.
01:42If I right-click the task form and choose cost, you can see that the actual cost
01:49is less than the original cost.
01:52When you assign cost resources to a task you also estimate the cost value.
01:57Then if the actual cost is different, you update the actual cost the way you do
02:02for material resources.
02:04Lodging and meals are both cost resources.
02:07So you can do the same thing and double-click the assignment to open the
02:12Assignment Information dialog box.
02:14Then on the Tracking tab, you can type the actual cost for the assignment,
02:18in this case, 150 and click OK.
02:22Now you can see down in the Task Form that the original cost was $200, but the
02:27actual cost is only 150.
02:30For the most part Project handles updating costs in a project.
02:33However, you do have to update actual quantities for material resources, and
02:38you may have to update the actual cost for cost resources, if your estimates
02:42weren't correct.
Collapse this transcript
Making global progress updates to a project
00:01Every so often, you need a way to record project progress quickly, and minute
00:05detail isn't important.
00:07Perhaps your project was put on hold for a few months, and you want to
00:10reschedule all the unfinished work when the ball starts rolling again.
00:14Project has an easy way to reschedule unfinished works, so you can pick up
00:18where you left off.
00:19Or as a last resort, you can also tell Project to bring your file up to date as
00:24if everything happened just the way you planned.
00:27You can tell Project the date to resume work and let it reschedule all the work
00:31that isn't complete.
00:32With a task-oriented view like the Gantt Chart displayed, click the Project tab,
00:38then click Update Project.
00:40In the update Project dialog box, select the Reschedule uncompleted work
00:45to start after option.
00:48And then in the box, choose the date when work should restart, March 31st,
00:532011 in this example.
00:57Leave the entire project option selected and click OK.
01:03Tasks that were in progress restart on March 31st.
01:07If we go and look at the Finalized lease task, I'll go to the Task tab and click
01:12Scroll to Task, so we can see this,
01:14and you can see that a split is now in the task, so that the uncompleted work
01:19has moved to March 31.
01:22Any tasks that haven't started but were scheduled to start before March 31st
01:27are now set to start on March 31st instead.
01:30And of course, any successors linked to these tasks move forward in time, so they
01:34still follow their predecessors.
01:37When you do this, look over your schedule carefully for edits you might have to make.
01:42For example, manually scheduled tasks are tasks with date constraints will need
01:46to be changed manually.
01:48And you may want to save a new baseline, which you learned about in an earlier movie.
01:53On the other hand, if your project is mostly on track, and you don't
01:57need accurate numbers to get paid, an automatic progress update can get
02:01you up to date quickly.
02:03For this update, let's open the Office Move on Track file. Click the File tab and
02:09click Open. Then double- click Office Move on Track.
02:14To update specific tasks, select them first.
02:18For example, starting at the beginning of the project, we can scroll down and
02:24Shift+Click Task ID 24 to select everything up through planning complete.
02:30Notice that the milestone is scheduled to finish on March 11th.
02:35Now on the Project tab, click Update Project.
02:38In the Update Project dialog box, make sure Update work as complete through is selected.
02:45And in the Date box choose the status date for updating.
02:49Let's make it March 3/1/2011.
02:54Project automatically updates tasks scheduled to start before that date, but
02:58what about tasks that start before the cut off date or finish after?
03:03To update tasks as partially complete, select the Set 0% - 100% complete option.
03:12This option tells Project to update completion based on how much of the task
03:16should be done by the cut off date.
03:18On the other hand, if you select the Set 0% - 100% complete only option, Project
03:25updates only tasks that should have been 100% complete before the cut off date.
03:30Because we selected tasks, be sure to select the Selected tasks option, then
03:36click OK, and Project updates the selected tasks.
03:40You can see that all the tasks that finish before March 1st are set to 100%, but
03:46Finalize lease, which finishes on March 4th, is at 70%.
03:51However, the milestone Planning complete is still set to finish on March 11th.
03:57Project offers a few shortcuts for updating your project's progress.
04:01These shortcuts don't provide accurate values of where your project stands.
04:05So you don't want to use them, if you rely on numbers and Project for billing
04:09customers or paying contractors.
04:11However, the Update Project command does get your tasks updated quickly, so you
04:16can go back to managing your project and tracking progress accurately once more.
Collapse this transcript
Using earned value
00:00Earned value analysis measures progress by determining how much of the
00:04project cost you've earned.
00:06You start by saving a baseline in your project file so you have something
00:10to compare progress to, and then you enter actual values to record your actual progress.
00:16Earned value measurements convert your plan and you progress both into dollars
00:20to figure out where your project stands, in terms of budget and schedule.
00:24Earned value measures progress through a specific date, so you have to set a
00:28status date in Project.
00:30On the Project tab, click the Status Date Calendar icon. Then in Status Date
00:37Select Date box, type the status date you want,
00:41in this example 2/10/2011 and click OK.
00:46Earned value analysis starts with three basic measures. To get your bearings with
00:51earned value switch to the tracking Gantt view.
00:55Click the View tab, click the Gantt Chart down arrow, and then choose Tracking Gantt.
01:01We also want to display the Earned Value table.
01:04Right-click the All Cells box and choose More Tables.
01:09Then in the More Tables dialog box, select Earned Value and click Apply.
01:17The first earned value column has a title of BCWS. That stands for Budgeted Cost
01:23of Work Scheduled, and it's also known as the planned cost for scheduled work.
01:28In plain English, that means it's how much you plan to spend on the work
01:33scheduled through the status date.
01:35And how much you planned to spend on the work scheduled is nothing more than the
01:38baseline cost for the work scheduled.
01:42Let's look at the Select site task.
01:46The BCWS value for Select site is $5,760. That means that through the status
01:53date, February 10th, you plan to spend that money on selecting the site for the new office.
01:59The next column, BCWP, stands for Budgeted Cost of Work Performed, and that's the
02:06earned value because it's the baseline cost you've actually earned for
02:11completing work through the status date.
02:13In this example, the budgeted cost for work performed, or earned value, is $7,200,
02:20so you see that the earned value is higher than the planned value, and that means
02:25that you got more work completed through the status date than you had
02:29originally planned.
02:30So just remember, when earned value is higher than planned value, the project
02:34is ahead of schedule.
02:36If earned value is lower than planned value, you haven't accomplished as much as
02:40you planned, and the project is behind schedule.
02:43The third value is actual cost of work performed.
02:47It's how much you actually spend through the status date. And in this example,
02:52actual cost for selecting this site is $3,600.
02:57The task is complete, so that means that you spend only $3,600 to select the
03:03site, but had planned on spending $7,200.
03:07If the actual cost is less than the earned value, the project is under budget.
03:12Planned value, earned value, and actual costs are all expressed in dollars, so
03:18you can compare them to evaluate schedule and cost performance.
03:22If you graph these three values, you can use the positions of the three lines,
03:27relative to one another, to see if the project is on time and within budget.
03:32The Earned Value Over Time visual report shows use these three measures.
03:37Click the Project tab and then click Visual Reports.
03:42Click Earned Value Over Time and click View.
03:49The Earned Value Over Time visual report opens in Excel. The graph you see here
03:54is what you always want to see for a project.
03:57The earned value line, the blue line, is above the planned value line, which
04:03is red, and that means that the project has been ahead of schedule since the beginning.
04:08The earned value line is also above the actual cost, which means that the
04:12project is under budget, too.
04:15The earned value graph shows costs along the Y axis and time along the X axis.
04:21Let me scroll down so you can see fourth quarter of 2010, first quarter of 2011.
04:30Okay, now we're going to go back to Project and just look at one more thing with
04:34the Earned Value table.
04:35I'm going to close Excel. Click No to throw this file away.
04:40Now that we've looked at the visual report, click Close to close the
04:45Visual Reports dialog box.
04:47The Earned Value table includes other measures that forecast final costs based
04:53on project performance so far.
04:55For example, the SV field is the variance between the earned value and planned value.
05:02If SV is positive, more work is complete than you plan, so you're ahead of schedule.
05:08The tasks in the office move all have positive variance, which is good.
05:12The CV field is the variance between earned value and the actual cost.
05:17If CV is positive, the baseline cost is greater than the actual costs, so the
05:22project is under budget, like the tasks for this move.
05:25Estimated completion, the EAC field, is an estimate of how much a task will cost
05:31when it's done, based on its performance so far.
05:34And the last one, BAC, budgeted completion, is just the baseline cost.
05:40Earned value measures can analyze both schedule and cost performance. The Earned
05:45Value table shows several earned value measures, task by task.
05:49However, the Earned Value Over Time visual report is a visual graph that shows
05:54you scheduled and cost performance at a glance.
Collapse this transcript
8. Viewing and Sharing Project Information
Viewing project status
00:00Reviewing project status frequently is the best way to get early warning of
00:04problems that are brewing.
00:06In Project, you can start with a 30,000-foot view and then drill down to find
00:11the tasks that are in trouble.
00:12Project views, reports, and several other features help you evaluate your project status.
00:18The project summary task is an easy way to keep high-level status visible.
00:23The project summary task shows up with a special task ID of 0, and the way you
00:28show it is on Format tab
00:31you turn the Project Summary Task check box on, the way it is here.
00:35If you turn it off, the summary task disappears.
00:38Turn it back on and task ID 0 reappears.
00:42The great thing about the project summary task is that it summarizes your entire project.
00:47You see the full duration.
00:48You see the start date of the project, the finish date, and other values.
00:53To quickly scan what's going on in your project, you can apply different tables
00:57and look at the values in the project summary task.
00:59For example, on the View tab, click Tables and then choose Variance.
01:07That'll show you the scheduled variance for your project.
01:09We can drag the vertical divider over here, so I can see the Finish Variance.
01:15And you can see that the Finish Variance is 13 days.
01:19That means, for this project, right now, the finish date is 13 days later than you planned.
01:25On the other hand, if you click Cost, you can see that the variance is -$3,240.
01:34The project is actually below budget by that amount.
01:38Another way to see high-level status is through the Project Information dialog box.
01:44Click the Project tab and click Project Information. Then, at the bottom, click Statistics.
01:51The Project Statistics dialog box shows the current, baseline, actual and
01:57remaining values for your project.
01:59You can also see the percentage of duration and work that's complete.
02:04The project summary report shows statistics similar to the Project Statistics
02:09dialog box, with more Variance values.
02:13Click Close to close this dialog box. Then click Reports.
02:18In the Reports dialog box, double-click Overview and then double-click Project Summary.
02:28You can click the zoom in to see this report in more detail.
02:32Just click those scrollbars to move, to see the report information.
02:40If variance values for Start, Finish and Duration are greater than 0, the
02:45Project may be behind schedule.
02:47Cost variances greater than 0 are signs that the project is over budget.
02:52When the Work Variance is greater than 0, the project could be behind schedule,
02:57over budget, or both.
02:59In this example, the Work Variance is positive, and you can see that the
03:03Duration Variance is 13 days;
03:06so the project is behind schedule.
03:08Another way to see status for tasks is with status indicators.
03:12Let's go back to the Gantt Chart view.
03:15To see status indicators, right-click a column heading in a table and choose
03:20Insert Columns, start typing Status, and then choose Status Indicator.
03:26A clock with a check mark shows tasks that are on time.
03:30If there are tasks that aren't finished but are running late, you would see a
03:34clock with an exclamation point inside a red diamond.
03:38To draw taskbars for a baseline, go to the Format tab, click Baseline, and
03:45then choose the baseline that you want to see.
03:50You can see in the Timescale that the grey taskbars represent the baseline.
03:55To see how much slack tasks have, turn on the Slack check box.
03:59A narrow black line sticking out from the right end of a taskbar shows how
04:03much a task can delay before it delays its successors.
04:09You can see slack here on the Finalize Lease task.
04:14Click the Slippage down arrow and then select a baseline to show slippage,
04:18with narrow black lines, from the baseline start dates to the current,
04:22scheduled start date. Here's slippage.
04:26The length of the Slippage line shows how far tasks have slipped from the
04:30baseline start date.
04:32Project has all kinds of tools to help you evaluate how your project is doing.
04:37Give them a try, and then use the ones you like the most.
Collapse this transcript
Looking for schedule and cost problems
00:00When your project's current values start to stray from the baseline, you know
00:04tasks are taking longer than they should, and could end up costing more than you planned.
00:09In Project, you can look at variances and other values to head off potential
00:13problems before they become reality.
00:16One way to find delays in your project is to look for tasks that should have
00:20started already but haven't.
00:22The Should Start By filter shows tasks that should have started by the date you
00:27specify but haven't.
00:29On the View tab, click the Filter down arrow, and then choose More Filters.
00:37In the dialog box, select Should Start By and then click Apply.
00:44In the Start By box, type the Should Start by date, 3/1/2011 in this example, and click OK.
00:53This filter looks for tasks without actual start dates, whose start dates are
00:58earlier than your Should Start By date.
01:00You can check with the resources assigned to these tasks to see why they
01:04haven't started yet.
01:05To remove the filter, click the Filter down arrow and choose No Filter.
01:11Now you can see all of your tasks again.
01:13Another problem is when tasks start on time and then fall behind.
01:19To find problems like these, you can look for tasks whose finish dates are later
01:23than the Baseline finish.
01:25The Slipping Tasks filter finds these tasks, whether they started late, are
01:29scheduled to start late, or are just taking longer than they should.
01:34On the View tab, click the Filter down arrow and choose More Filters.
01:41In the dialog box, select Slipping Tasks and click Apply.
01:46To remove the filter, go back to the Filter box and choose No Filter.
01:51On the other hand, work hours that grow beyond your estimates can lead to longer
01:56task durations and higher costs,
01:59so it's important to catch these variances early.
02:01The Work Table shows Work Variance.
02:05On the View tab, click the table's down arrow and then choose Work.
02:11The Work Table also has the % Work Complete column. That's the percentage of the baseline work
02:18that's done.
02:20A positive Work Variance means the scheduled hours are higher than the baseline
02:25work, and that's a problem.
02:26So you should investigate what's going on with these tasks.
02:30The Slipped Late Progress filter looks for tasks that are running late, but
02:35it also checks for completed work that's less than what you planned, for the
02:39date that you pick.
02:40Click the Filter arrow and choose More Filters.
02:46In the More Filters dialog box, select Slipped Late Progress and click Apply.
02:56You can see here that there are quite a few tasks that you have to investigate.
03:00The Cost Table shows Cost Variance, as well as several cost fields.
03:05Right-click the All Cells box and then choose Cost.
03:10You can see here that some tasks have positive variance and some have negative.
03:16Overall, the project is under budget by about $3,000.
03:21On the other hand, if you want to look at tasks whose scheduled cost is greater
03:25than the baseline cost,
03:27on the View tab, click the Filter down arrow and then choose More Filters.
03:34In the More Filters dialog box, select Cost over Budget, and click Apply.
03:40And you can see that there's one task here that's gone over budget.
03:44Project comes with tables and filters to help you keep an eye on task dates,
03:48work hours, and cost.
03:50By checking for values that stray from the baseline, you can spot problems
03:54easily and take corrective action.
Collapse this transcript
Running a text-based report
00:00Project's text-based reports are easy to run, and they are great when you want
00:04to produce a checklist of upcoming assignments, or send people a quick summary of
00:09where a project stands.
00:10Text-based reports offer a few basic options for choosing, arranging,
00:15and formatting data.
00:16Unlike visual reports, text reports show data in a specific way.
00:21If you want a different perspective, you have to run a different report or
00:25create custom report with the layout you want.
00:28Running a text-based report is as easy as 1,2,3.
00:31First, you open the Reports dialog box by clicking Reports on the Project tab.
00:39Then you select the Report category and finally, you select and run the report you want.
00:46If you double-click the Overview category, you see several reports that give
00:51different high-level perspectives of your project.
00:53For example, double-click the Project Summary report.
01:00The report opens on the Print page of the Backstage view, so you can preview the report.
01:06It shows the scheduled, baseline, and actual values for the start and finish
01:09dates, duration, working cost.
01:12The Print options appear on the left side of the Print page.
01:17You can choose the printer you want to use.
01:21You can choose the page orientation.
01:23Click the down arrow to choose Portrait or Landscape.
01:26You can also choose the size of the paper you use.
01:31In Project, you can select the dates for the report.
01:34That's a great way to save trees if your project spans several months, or even years.
01:40If you want to adjust margins or add information to the header or footer, click
01:45the Page Setup link. Click Cancel to close that box.
01:50To print more than one copy, type the number you want up in the Copies box.
01:54Then to print the report, click the nice, big Print button.
02:00One drawback to the Print page is that it doesn't leave much room for a
02:04preview of your report.
02:06You can zoom in just by clicking the report, but then you actually have to
02:10scroll around, using the horizontal and vertical scrollbars, to see the content in the report.
02:17If you click the One Page button, you can see the report at its actual size.
02:24If your report has more than one page, you can click Multiple Pages to actually
02:28get an overview of what the report looks like.
02:34Let's go back and look at a different report.
02:38On the Project tab, click Reports, and this time double-click the Current
02:43category. Double-click the Tasks In Progress Report, which shows tasks people
02:49are currently working on.
02:51You can click the left, right, up and down arrows to switch between pages in the report.
02:57Here I am on the first page. Click the right arrow to go to the second page of the report.
03:02The arrows are gray or black, depending on how many pages there are in the report
03:07and which page you are looking at.
03:10In this case, the only direction I can go is to click left to go back to the
03:14first page of the report.
03:16If you want to get a more thorough look at the report before you print, your
03:20best bet is to print to a file like a PDF.
03:25In the Printer dropdown list, you can choose one of the other options, like
03:31sending it to OneNote or to the Microsoft XPS Document Writer, which is
03:36Microsoft's version of Adobe PDF format. Then you can click Print to send it to a file.
03:43If you want to customize a report, you can go to the Custom category.
03:47Let's go back to the Project tab and open up the Reports dialog box again.
03:53This time double-click Custom.
03:56The Custom Reports dialog box shows all of the existing reports. Select the
04:02report that you want and then click Copy.
04:07After you copy the report, you can make changes, like choose the table to
04:11display or the filter to apply, and then you click OK, and you can run your custom report.
04:17Text-based reports are great for checklists or quick overviews.
04:21You can report details too, but the reports can spit out page after page.
04:25Check out all the reports that Project has to offer.
04:28To keep reports concise, or to show specific information, try the different
04:33report settings until you see the information just the way you want.
Collapse this transcript
Generating a visual report
00:00Project's visual reports let you change them on the fly because they use Excel
00:05PivotCharts and Visio Pivot Diagrams to look at data in different ways.
00:11For example, you may start with costs by month, but with a quick modification,
00:15you can show costs by resource, or by project phase.
00:19Generating a visual report is easy.
00:21On the Project tab, click Visual Reports.
00:25In the Visual Reports dialog box, select the visual report you want to run,
00:30like Baseline Cost.
00:32The Assignment Visual Reports are the most flexible because they include
00:36time-phased data about both tasks and resources so you can look at your
00:40project from every angle.
00:43A preview of the visual report gives you an idea of what the report looks like,
00:47for example, a bar graph, a pie chart, or a tree.
00:51In the Select level of usage data to include in the report dropdown list, choose
00:56the shortest period of time you might want to see.
01:00Weeks is a good compromise, but you can go shorter or longer, to days or months, for
01:06shorter or longer projects.
01:09Then just click View to create the report.
01:15It can take some time for the report to generate.
01:19If you use an Excel visual report, Excel starts up and opens an Excel file with
01:25your project data in it.
01:26The Chart1 worksheet is a special graph that displays the data in your report in
01:31the way that you tell Excel to.
01:33If the chart is too big for the window, you can drag the Zoom slider on the
01:36right side of the Status bar.
01:42The second worksheet is called a PivotTable.
01:46Here it says Assignment Usage, and this PivotTable is how you configure
01:50the look of the report.
01:51Excel-based visual reports are bar graphs, pie charts, or line graphs, and
01:57they're great for comparing values side-by-side.
02:00To see the PivotTable, click on Assignment Usage.
02:03The Baseline Cost Report initially shows actual cost, baseline cost, and cost,
02:11and you can see that those are the fields that have check marks in the
02:15PivotTable Field List.
02:17So that tells you that you can display any field that you want by turning on its check mark.
02:23You can change the order that the fields appear in the chart.
02:27Let me go back to Chart1 and show you, Baseline Cost, Cost and Actual Cost, and
02:35those are the three fields, down in the Sum Values section:
02:39Baseline Cost, Cost, and Actual Cost.
02:42If you want to change the order, just drag a field to a different position.
02:47For example, drag Actual Cost to be above Cost. And if you go back to the chart,
02:56now you can see that Actual Cost is in the middle.
03:00Back on the Assignment Usage worksheet, you see that the Baseline Cost Report
03:07starts with a column for the entire project, and then has additional entries for
03:13each top-level task.
03:16Changing the category in the Row Labels area is how you categorize data in different ways.
03:23To break down the Baseline Cost Report by time periods, drag the Weekly Calendar
03:29from the Report Filter box into the Row Labels box.
03:34If the Weekly Calendar is first in the list, the report categorizes, first by
03:39time period, and then by tasks.
03:46Let's go back to the chart, and now you can see that there are time periods, and
03:52then the top-level tasks.
03:58Let me zoom out a little bit.
04:00I'm going to zoom out some more so that you can see the text in this chart.
04:18I'm not sure I can zoom out enough, so that the text doesn't overwrite itself;
04:22however, the one thing that you want to see is that each time period has its own
04:29set of graphs for those top-level tasks.
04:33To see more or less detail, you expand or collapse the information in the
04:38PivotTable worksheet.
04:39So, let's go back to Assignment Usage.
04:43Click the 2001 Plus button to show the quarters in the year.
04:50Then click the chart worksheet, and we'll zoom back out, and now you can see
04:56that for 2001, you can see the quarters when you didn't before.
05:00You can also filter the information that appears in a visual report.
05:04If you want to look at a specific time period or resource, you can drag the
05:08field into the Report Filter area.
05:11For example, drag tasks from the Row Labels box into Report Filter, click the
05:22Tasks down arrow, and turn on Select Multiple Items.
05:28Now you can expand your project - let's make this box a little bigger - and you
05:35can see that you can turn off the top- level tasks that you don't want to see.
05:41When I click OK, it's just going to show those items in the chart.
05:47So these bars now just show everything up through planning the move.
05:51A Visio-based Visual Report starts Visio and creates a Visio Pivot Diagram.
05:57The Visio file has one page for the diagram and a background page for things like logos.
06:02Visio-based Visual Reports break information down in a hierarchy, like a work
06:08breakdown structure.
06:09You can drill down level by level, and use icons to highlight good, bad,
06:13and indifferent values.
06:15Visual Reports can slice and dice project information in all sorts of ways.
06:19You can categorize data, summarize, or look at details and filter out what
06:24you don't want to see.
06:25Check out the visual reports that Project offers and then experiment with the
06:29settings in Excel PivotTables and Visio Pivot Diagrams to see what you can do.
Collapse this transcript
Working with the Global Template
00:00The Global Template file is where Project stores elements like views and tables,
00:05and settings like the date format you use.
00:07Project uses the Global Template with every project file you create,
00:11so elements and settings are available whenever you work on those files.
00:15The Organizer in Project helps you manage file elements.
00:18You can copy things between a file and the Global Template, or even between two project files.
00:25To see what the Global Template stores for you, click the File tab.
00:31On the Info page, click Organizer.
00:35The Organizer dialog box has tabs for the elements it works with, like views,
00:41tables, filters, groups, calendars, fields, reports, and so on.
00:47You can also see the name of the Global Template is Global.MPT.
00:51What that means is it's a Microsoft Project Template.
00:55It's really just a regular project template file.
00:58You can click a tab to see what's in your active project file, on the right, and
01:03the Global Template, on the left.
01:05For example, click Tables to see the tables that are available or Calendars and Filters.
01:14To look at the elements in a different open file, click the down arrow on the
01:19right side and choose the file you want.
01:22In this case, just one file is open,
01:24so we keep that one selected.
01:26Whenever you make a change to an element, like changing the table for a view or
01:31inserting a column into a table, you have customized that item.
01:35And Project keeps that customized item in your project file.
01:40That's why you see so many views listed on the right side of the Organizer.
01:44All of these views have been changed slightly in this particular file.
01:48Say you like a view you have customized so much you want to use it in every new project you create.
01:55You can copy it to the Global Template.
01:58Select a view on the right side of the dialog box,
02:01let's say the Gantt Chart.
02:02So you don't overwrite projects build in Gantt Chart, click Rename.
02:08In the Rename box, type a new name for the view, maybe something like
02:13MySpecialGantt, and click OK.
02:19And you can see that view is now in the Global Template file.
02:23Click the Close button to close the Organizer.
02:27When you create a new project file, it grabs all the views from your Global
02:31Template and uses them.
02:32You can also delete items with the Organizer.
02:35If you don't want an item in your file, you can select it on the right side of
02:39the Organizer and then click Delete.
02:41For example, you can select one of these views, Resource Allocation here,
02:48and then click Delete.
02:49Click Yes to confirm that you want to delete it.
02:52You can't delete an item that's in use.
02:54So if the view you want to delete is visible, first select another view.
02:59In Project 2010, you can tell the program to automatically copy items to
03:03the Global Template.
03:04If you are the only person who uses your copy of Project, this means your
03:09customized elements are available for every new project you create.
03:13Let's close the Organizer by clicking the Close button, and then on the
03:18File tab, click Options.
03:21In the Project Options dialog box, click Advanced.
03:26Scroll down to the Display section and make sure that the Automatically add new
03:33views, tables, filters, and groups to the global check box is turned on.
03:38On the other hand, if you share a Global Template with others, it's better to
03:42turn off the check box,
03:44so your customized elements stay in your project files.
03:48Then if you do want to share them, you can copy them to the Global Template
03:52using the Organizer.
03:53The Global Template is a project template file that the program uses to store
03:57things like views, tables, filters, and calendars.
04:01The Organizer helps you manage the elements in your project files and the Global Template.
04:05You can copy your favorite elements to the Global Template with the Organizer.
04:10That way they are ready and waiting for you in every new project file
04:14you create.
Collapse this transcript
Importing and exporting information
00:00When you import or export data, you can control the data you send between
00:04programs, and where it goes in the destination file.
00:07Project has wizards for importing and exporting data, so you can follow the
00:11wizard's lead to get data where you want it go.
00:13Excel spreadsheets provide a great framework for getting data into Project.
00:18It's easy to map the columns in Excel to fields in Project.
00:23To import an Excel spreadsheet, click the File tab and then click Open.
00:29In the Open dialog box, click the Microsoft Project Files down arrow, and then
00:35choose Excel Workbook to bring in an Excel 2010 workbook.
00:40Select the workbook that you want and then click Open.
00:44In the Import Wizard window, click Next.
00:50Project automatically selects the New map option, and that's what you want, so
00:55click Next to continue.
00:58To import the data into a new project, leave the As a new project option
01:02selected, and click Next.
01:05With an Excel workbook, you can import more than one type of information, each
01:09from a different worksheet.
01:11In this example, turn on the Tasks check box to import tasks.
01:16If the Excel file has a row with headers, leave the Import includes headers
01:20check box turned on, and click Next.
01:23Project fills in the Excel worksheet name in the Source worksheet name box.
01:29If the spreadsheet contains more than one worksheet, choose the name from the dropdown list.
01:36Project tries to map fields in the Excel workbook to fields in Project.
01:40In this file, it figured out WBS, Name, and Duration.
01:45Where you see not mapped, you know you have to tell it how to match up the data.
01:50Select the cell that goes with Estimated Work.
01:53Click the down arrow and then type "Work" and select it in the list.
02:01That maps the Excel Work to the Project Work field.
02:05Because you are importing tasks, not assignments, you can skip the
02:08Resources field in Excel.
02:10You actually don't have to import every field in your Excel file.
02:14The Preview area shows what your imported data looks like.
02:18The first row shows the names of the source fields in Excel.
02:23The Project row shows the Project fields mapped to the imported fields, and the
02:28Preview Rows show sample values.
02:31If everything looks good, click Finish to import the data.
02:36Project brings the data into a new Project file.
02:39If you want to export some information from Project to Excel, you can use the Export wizard.
02:45Click File and click Open.
02:50Select the OfficeMove_ Progress file and click Open.
02:57On the Task tab, click the View down arrow and choose the view with the data
03:01you want to export,
03:02for example, the Gantt Chart as we have here.
03:06If you want specific fields, display the table with those fields.
03:11On the View tab, click the Tables down arrow and choose cost.
03:16To export all the data in the table, click the All cells box.
03:21That's the intersection of the column headings and the task ID rows.
03:25Click File and then click Save As.
03:29In the Save as Type dropdown list, choose Excel Workbook.
03:35That saves in Excel 2010 format file.
03:39In the File Name box, type the name for the file, like ExcelExport, and click Save.
03:49In the Export Wizard, click Next to get going.
03:53The wizard automatically selects the Selected Data option, which exports the
03:58data you selected in the view.
04:00So click Next to continue.
04:03Select the Use existing map option to use the map that's already present.
04:08Click Next and choose Cost data by task. Click Next.
04:15To export tasks, make sure that the Tasks check box is turned on, as it is here.
04:22Each type of data goes to a separate Excel worksheet if you export more than one type of data.
04:28Click Next.
04:30The Destination worksheet name box shows the name for the Excel worksheet.
04:35You can type a different name if you want.
04:37In this example, Project uses the map you selected to map project fields to
04:43Excel columns in the Excel worksheet.
04:46If the mapping looks the way you want it, go ahead and click Next. Then click Finish.
04:55Project exports the tasks into the new Excel file.
04:59If we go to Windows Explorer, you can see ExcelExport is sitting in the folder
05:05and if you have Excel 2010, you can open it up.
05:08Importing data into Project is a great way to get information from team members
05:12like tasks and estimates into your Project file.
05:15On the other hand, exporting data from Project comes in handy when you want to
05:19work on the data in ways that Project isn't so good at,
05:22or you want to transfer the data to another program like, your
05:25company's accounting system.
05:26Either way, Project has wizards that guide you through every step.
05:30At the same time, you have complete control over the data you want to exchange
05:34and where you want it to go in the destination file.
Collapse this transcript
Sharing project information in other ways
00:00You can e-mail your project file as an attachment, whether you do that in
00:04Outlook or from within Project.
00:06You can also create a picture of your project to include in presentations.
00:11Just like other Microsoft programs, Project files can turn into linked or embedded
00:15objects when you copy and paste from Project to another program.
00:19If your organization uses SharePoint, you can use it to share your project
00:24file with your team.
00:25If you want to e-mail your project file from within Project, click the File tab
00:31and then click Save & Send.
00:33On the Backstage, click Send as Attachment.
00:37If your e-mail program isn't running, it starts and opens a new e-mail message
00:42form, with the Current Project file already attached.
00:46Fill out the form as you would normally and send it.
00:49The Copy Picture Command creates an image of the Current View, perfect for
00:54publishing a high-level schedule to your intranet, or sending resource
00:58assignments to someone's manager.
01:00So first, display the view you want.
01:02For example, on the View tab, click Resource Usage.
01:07If you want to see specific rows, select them first. I click the Minus Sign
01:14button on the unassigned tasks to hide those.
01:17Let's go down to the office manager.
01:19Now I am going to click the first Office manager row and Shift+Click the last
01:29assignment for the office manager.
01:32I'm also going to expand the Resource Name column, so that I can see the
01:36assignments and make sure that the last column that you want to see is
01:41completely included in the Window;
01:43partial columns won't show up in the picture.
01:46Click the Task tab, click the Copy down arrow, and then choose Copy picture.
01:54In the Copy Picture dialog box, choose an option. Project automatically selects
02:01For screen, which is what you want when you copy for a picture to put in a
02:05PowerPoint presentation.
02:07Select For printer, if you're going to print a picture in a hard copy report.
02:12And if you want to create a file, select To GIF image file, and then you would
02:17tell Project the name of the file and where to put it.
02:20If you selected rows, Project automatically selects the Selected Rows
02:25option. And if you want, you can show specific dates in the Timescale by
02:29choosing the From and To dates.
02:34Let's pick 1/1/2011 to 2/28/2011. Click OK.
02:47Because we selected so much information, Project is telling me that it might be
02:52too large to paste into other applications, but I'm going to be optimistic, and
02:56I'm going to keep the selected range. Just click OK.
03:00Project copies the picture to the clipboard.
03:03Now you can go into another application, like Word, and then, in that program,
03:09paste it into the document.
03:11Let's see how this works in a Word document.
03:14In this case, I already have Word open, with a blank document ready.
03:19On the Home tab, click the Paste dropdown arrow and then click the Paste icon.
03:27And there is your picture in the Word document.
03:30If your company uses SharePoint to collaborate, you can share your project files
03:34on your SharePoint site.
03:36Let's go back to Project.
03:38To save a Project file to SharePoint, click the File tab and then click Save & Send.
03:45If you want to save the file to the SharePoint site, you can click Save to SharePoint.
03:50You have to tell Project where the SharePoint site is, but then you click Save
03:55as to save the file in that location.
03:56The other command you might notice is Sync with Tasks List.
04:01With Project 2010, this feature lets you publish Project tasks to a
04:06SharePoint Tasks List.
04:08On the Save & Send page, you click Sync with Task Lists.
04:13You can tell Project where the SharePoint site is, and the task lists that you
04:17want to use, and the program publishes the tasks.
04:21But before you get too excited, keep in mind that this approach has a few
04:25serious limitations.
04:27It isn't the solution if you use Project to calculate your schedule and you
04:31have a large team of resources,
04:33but it's handy for a handful of manually scheduled tasks and a couple of colleagues.
04:38The big limitation is that SharePoint doesn't calculate project schedules,
04:42so tasks you synchronize are always manually scheduled.
04:46If you synchronize auto-scheduled tasks, SharePoint will convert them
04:51to manually scheduled.
04:53Project offers several ways to share your project information with others,
04:56from attaching project files to e-mails, to copying and pasting information
05:01into other programs, to creating a picture of a schedule, to publishing a file
05:05to a SharePoint site.
05:07Explore the different methods available in your environment. Before you know it,
05:11you'll know which way is best for sharing in any situation.
Collapse this transcript
Conclusion
Goodbye
00:00Now you know the basics for setting up a schedule in Project.
00:03You've seen how to create projects, and set up basic project information and calendars.
00:08We've explored creating and linking different types of tasks to build a schedule.
00:12We've created work, material, and cost resources, and assigned them to tasks.
00:17You've also seen how to work with Project's views to fine-tune your schedule,
00:21track progress, spot problems, and take corrective action to bring a wayward
00:26project back on course.
00:27Finally, you've walked through creating different types of reports and explored
00:31other ways to share project information with others.
00:34So go ahead and start managing your projects with Microsoft Project.
Collapse this transcript


Suggested courses to watch next:

Visio 2010 Essential Training (6h 11m)
David Edson


Time Management Fundamentals (2h 43m)
Dave Crenshaw

Leading Productive Meetings (1h 22m)
Dave Crenshaw


Are you sure you want to delete this bookmark?

cancel

Bookmark this Tutorial

Name

Description

{0} characters left

Tags

Separate tags with a space. Use quotes around multi-word tags. Suggested Tags:
loading
cancel

bookmark this course

{0} characters left Separate tags with a space. Use quotes around multi-word tags. Suggested Tags:
loading

Error:

go to playlists »

Create new playlist

name:
description:
save cancel

You must be a lynda.com member to watch this video.

Every course in the lynda.com library contains free videos that let you assess the quality of our tutorials before you subscribe—just click on the blue links to watch them. Become a member to access all 98,609 instructional videos.

start free trial learn more

If you are already an active lynda.com member, please log in to access the lynda.com library.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Access to lynda.com videos

Your organization has a limited access membership to the lynda.com library that allows access to only a specific, limited selection of courses.

You don't have access to this video.

You're logged in as an account administrator, but your membership is not active.

Contact a Training Solutions Advisor at 1 (888) 335-9632.

How to access this video.

If this course is one of your five classes, then your class currently isn't in session.

If you want to watch this video and it is not part of your class, upgrade your membership for unlimited access to the full library of 1,894 courses anytime, anywhere.

learn more upgrade

You can always watch the free content included in every course.

Questions? Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com.

You don't have access to this video.

You're logged in as an account administrator, but your membership is no longer active. You can still access reports and account information.

To reactivate your account, contact a Training Solutions Advisor at 1 1 (888) 335-9632.

Need help accessing this video?

You can't access this video from your master administrator account.

Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com for help accessing this video.


site feedback

Thanks for signing up.

We’ll send you a confirmation email shortly.


By signing up, you’ll receive about four emails per month, including

We’ll only use your email address to send you these mailings.

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

By signing up, you’ll receive about four emails per month, including

We’ll only use your email address to send you these mailings.

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked