[Microsoft official academic course microsoft project 2013 pdf free download

By microsoft official academic course microsoft project 2013 pdf free download our site, you agree to our collection of information through the use of cookies. To learn more, view our Privacy Policy. To browse Academia. Olivia Qin. Anibal Ponte. Log in with Facebook Log in with Google. Remember me on this computer. Enter the email address you signed up with and we’ll email you a reset link. Need an account? Click here to sign up. Download Free PDF.

Dhirender Dagar. Related Papers. Microsoft Excel Step by Step. All rights reserved. Microwoft part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, coursf, photocopying, recording, scanning or otherwise, except as permitted under Sections or of the United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc.

Other product and company names mentioned herein may be the trademarks 20113 their respective owners. The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious.

No association with any real company, organi- zation, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. The information contained in this book is provided without any express, statutory, or implied warranties.

Pro x support contact and views expressed in this document, including URL and other Internet Web site references, may change without notice. Some examples depicted herein are provided for illustration only and are fictitious.

No real association or connection is intended or should be inferred. All other marks are property of their respec- tive owners.

Your use of the Licensed Materials indicates your acceptance of the terms and conditions of this Agreement. License Wiley hereby grants you, and you accept, a non-exclusive and non-transferable license to view, use and display the Licensed Material on the following terms and conditions only: a. You acknowledge that the Licensed Material is being licensed to you and dlwnload is subject to the terms and conditions of this Agreement.

The Licensed Material is for your personal use only. You may not upload, copy, modify, print, transmit, transfer, sublicense, sell, make or distrib- ute copies of the Licensed Material in whole or in sownload. If you transfer possession of any copy or modification of the Licensed Material to any third party, your license is automatically terminated and any attempt to sell or otherwise transfer the Licensed Material shall be null and void.

Such termination will be in addition to and not in lieu of any equitable, civil, or other remedies available to Wiley. If you accessed the Licensed Material from a third party website or using a device http://replace.me/27361.txt requires you to accept any other user agreement, you are bound by both this Microsoft official academic course microsoft project 2013 pdf free download and any third party website or device-specific agreement.

In the event of a conflict between this Agreement and any third party agreement, the more restrictive terms will apply. You agree that any materials in print format that may be included with this license for example, materials printed on demand or portions microsoft official academic course microsoft project 2013 pdf free download ordered or printed from any third party platform are licensed for your personal use only and may not be transferred or sold under any condition.

All terms of this Agreement also apply to these print materials. Term This Agreement shall terminate upon the conditions discussed elsewhere in this Agreement, or if you fail to comply with any term or condition of this Agreement. Upon such termination, you agree to immediately discontinue all access to the Licensed Material. By accepting this Agreement, you do not become the owner of the Licensed Material, but you do have a limited license to use it in accordance with the provisions of this Agreement.

You agree to protect the Licensed Material from unauthorized use, upload, download, reproduction, or distri- bution. You further agree not to translate, decompile, disassemble microsoft official academic course microsoft project 2013 pdf free download otherwise reverse engineer the Licensed Material. General This Agreement represents the entire agreement dosnload us and supersedes any prior Agreements, oral or written, and any other communication between us relating to the subject matter of this Academjc.

This Agreement will be governed microsot construed as if wholly entered into and per- formed within the State of New York. You acknowledge that you have read this Agreement, and agree to be bound by its terms and conditions. Microsoft and Wiley teamed up to produce micfosoft series of textbooks that deliver compelling and innovative teaching solutions to instructors and superior learning experiences for students.

Infused and informed by in-depth knowledge from the creators of Microsoft Office and Windows, and crafted by a publisher known worldwide for the pedagogical quality of its products, these textbooks maximize skills transfer in minimum time. Students are challenged to reach their potential by using their new technical skills as highly productive members of the workforce.

With MOAC, we recognize that, because of the rapid pace of change in the technology and curriculum developed by Microsoft, there is an ongoing set of needs beyond classroom instruction tools for an instructor to be ready to teach the course. The MOAC program endeavors to provide solutions for all these needs in a systematic manner in order to ensure a successful microsoft official academic course microsoft project 2013 pdf free download rewarding course experience for both instructor and student—technical and curriculum training for instructor readiness with new software releases; the software itself for student use at home for building hands-on skills, assess- ment, and validation of skill development; and a great set of tools for delivering instruction in the classroom and lab.

All are important to the smooth delivery of an interesting course on Microsoft software, projeft all are provided with the MOAC program. Presenting the extensive procedural information and technical concepts woven throughout the textbook microspft challenges for the microsoft official academic course microsoft project 2013 pdf free download and instructor alike.

More than a standard list of learning objec- tives, the skill matrix correlates each software skill covered in the lesson windows 10 install error usb free download the specific MOS exam objective domain.

This feature provides an overview microsoft official academic course microsoft project 2013 pdf free download the soft- ware features students will be working with in the lesson. The orientation will detail the general properties of the software or specific features, such as a ribbon or dialog box; and it includes a large, labeled screen image.

Numbered steps give detailed, step-by-step instructions to help students learn software skills. The steps also show results and screen images to match what students should see on their computer screens.

The images reinforce key concepts, provide visual clues about the steps, and allow students to check their progress. These resources provide all the materials instructors need to deploy and pcf their courses. However, your instructor might ask you to copy the practice files on your own at the start of class. Also, if you want to work through any of the exercises in this book on your own at home or at your place of business after class, you may want to copy the practice files.

Nielsen has worked in the publishing microspft for more than 25 years as an author, devel- opment editor, technical editor, and project manager, specializing microsofft Microsoft Office, Windows, Internet, and general technology titles for leading educational and retail publishers.

She is the author courae co-author of over 40 computer books and has edited several hundred Microsoft official academic course microsoft project 2013 pdf free download publications and more than two thousand online articles. Joyce also worked as a research analyst for a major shopping mall developer, where she developed and documented spreadsheet and database applica- donload used nationwide. Joyce currently mcirosoft in Tucson, Arizona.

Microsoft Office Software This content was created using the Office Professional desktop version. If you have signed up for Officesome features may be added or updated. The foundation of Excel and locations where you do your work are cells, rows, and columns within a worksheet, and worksheets as part of a workbook. Many of the tools you use while working in Excel are located on the ribbon that displays across the top of the window.

The ribbon is organized into task-oriented command tabs. Each tab is divid- ed into task-specific command groups with commands and options that relate to the group name. Because you can customize the ribbon and new tabs might appear, such as the Developer and Add-Ins tabs, your screen might appear different than Figure You can open Microsoft Excel in Windows 10 by moving to the lower-left corner of your screen, clicking on Start, clicking All apps, and then clicking Excel Excel opens to a list of templates and in most cases you choose Blank workbook or open a previous file.

A workbook, or spreadsheet file, is shown in Figure Think of a workbook as a physical book with many pages. The filename Book1 and the program name Excel appear in the title bar at the top of the screen. Book1 or Book2, Book3, and so on is a temporary title for your workbook until you save the workbook with a name of your choice.

The new workbook contains one qcademic Sheet1 by default—similar to the http://replace.me/26695.txt page in a book—where you enter infor- mation. If a workbook has more pages or worksheetsyou use the sheet tabs that are located just above the Status bar and are identified as Sheet1, Sheet2, and Sheet3.

Be sure Microsoft Excel is installed on your computer. Then perform the following steps: 1. With the Windows desktop displayed, click the Start button in the lower-left corner of the Windows 10 screen. Click All apps near the bottom of the Start menu. In the list of applications, scroll down as necessary and click Excel Click Blank workbook to start a new file. Click to learn more about Excel. Overview 3 4. Click Blank workbook. A blank workbook opens, and the worksheet named Sheet1 is displayed as shown previously, in Figure LEAVE the workbook open for the next exercise.

Take Note If you use Excel often, you will want to pin the application to the Start menu. From the All apps menu, right-click the app name, and choose Pin to Start. You can also choose More and then Pin to taskbar to allow you to click больше информации icon in the Windows microsoft official academic course microsoft project 2013 pdf free download at the bottom of the screen to start Excel.

A worksheet is a grid composed of rows, columns, and cells. Each worksheet column starts at the top of the worksheet and goes to the bottom of the worksheet and is identified by a letter.

Each row starts at the left edge of the worksheet and continues to the right and is identified by a num- ber. Each box, or cell, on the grid is identified by the intersection of a column and a row. Thus, the first cell in an open worksheet is A1. You enter information by typing it into the selected or active cell, which is outlined by ссылка на подробности bold rectangle. This is also called the current or highlighted cell.

Project training – Microsoft Support

Stay organized, focused, and in charge. Tackle anything from small projects to large initiatives. You may or may not be a project manager, porject now you can be the boss of any project with источник powerful, easy-to-use app.

Work confidently with downloda powerful project management tool that makes getting started and managing projects both simple and easy. Even complex projects are easier to manage when you can choose methods and tools that best suit your needs. Use Project and Teams to empower collaboration and xcademic of projects, including file sharing, chats, meetings, and more.

Enable all team members to update tasks simultaneously so you can get more done together. Easily plan your projects with the power of dynamic scheduling based on effort needed, project duration, and allotted team members. Build the desktop or mobile experiences you want and easily microsoft official academic course microsoft project 2013 pdf free download automated workflows.

Yemen Zambia Zimbabwe. Watch the on-demand sessions from the Project Management for a Connected World event. Register and watch нажмите чтобы прочитать больше. Microsoft Project Meet the simple, powerful, reimagined Project for everyone.

See products and pricing. Sign in. Microsoft Project. Get Project, starting at ow:[[msrpwithcurrency]] per month. Learn more. The power to make project management simple. Easy to start, simple to use, and vice versa Work confidently with a powerful project management tool that makes getting started and managing projects both simple and easy. Take the pain out of painstaking projects Even complex projects are easier to manage when you can choose methods and tools that best suit your needs.

Microsoft Project and Microsoft Teams, the power of two Use Project and Teams to empower collaboration and management of projects, including file sharing, chats, meetings, and more.

Get started using Project See plans and pricing. On Tech Community.

Microsoft official academic course microsoft project 2013 pdf free download

In cell C3, type De to begin the next last name, Delaney. Excel guesses that you want to enter the rest of the last names in column C and displays a preview of the results. Working with Microsoft Excel 29 9. The remaining last names fill down the column. These processes are discussed as the exercises in this section continue.

You can also copy specific contents or attri- butes from the cells. For example, you can copy the format only without copying the cell value, or copy the resulting value of a formula without copying the formula itself. You can also copy the value from the original cell but retain the formatting of the destination cell.

Just select the cell or range of cells you want to copy and hold down Ctrl while you point to the border of the selection. When the pointer becomes a copy pointer arrow with a plus , you can drag the cell or range of cells to the new location.

As you drag, a scrolling ScreenTip identifies where the selection will be copied if you release the mouse button.

In this exercise, you practice copying data with the mouse. Open the 02 Customer Houses file. Select the range AA Press Ctrl and point to the right border of the selected range. The copy pointer is displayed. Troubleshooting Be sure to hold down the Ctrl key the entire time you are dragging a data series for copying with the mouse, or you will move the series instead of copying it.

With the copy pointer displayed, press and hold down the left mouse button and drag the selection to the right, until HH22 appears in the scrolling ScreenTip next to the selection. Release the mouse button and then release Ctrl. The data in AA22 also appears in HH Moving a Data Series with the Mouse Data can be moved from one location to another within a workbook in much the same way as copying.

To move a data series, select the cell or range of cells and point to the border of the se- lection. When data is moved, it replaces any existing data in the destination cells. In this exercise, you practice moving a data series from one range of cells to another.

USE the 02 Customer Houses workbook from the previous exercise. Select EE Point to the right border of the selected range. The move pointer a white arrow with four smaller black arrows attached is displayed. With the move pointer displayed, hold down the left mouse button and then drag the selection to the right, until II22 appears in the scrolling ScreenTip beside the selected range.

Release the mouse button. In your worksheet, the destination cells are empty; therefore, you are not concerned with replacing existing data. The data previously in EE22 is now in II Drag A1 to H Note that a dialog box warns you about replacing the contents of the destination cells. Click Cancel. Drag E1 to I Your worksheet should look like the one shown in Figure Take Note When you attempt to move a selection to a location that contains data, a caution dialog box opens.

Do you want to replace it? You can click OK or cancel the operation. Copying and Pasting Data The Office Clipboard collects and stores up to 24 copied or cut items that are then available to be used in the active workbook, in other workbooks, and in other Microsoft Office programs. Working with Microsoft Excel 31 You can paste insert selected items from the Clipboard to a new location in the worksheet.

Cut moved data is removed from the worksheet but is still available for you to use in multiple locations. If you copy multiple items and then click Paste, only the last item copied will be pasted.

To access multiple items, you must open the Clipboard pane. In this exercise, you use commands in the Clipboard group and the Clipboard pane to copy and paste cell data.

The Clipboard pane opens on the left side of the worksheet. The most recently copied item is always added at the top of the list in this pane, and it is the item that will be copied when you click Paste or a shortcut command. Select A1:E22 and then press Delete. Select HI22 and in the Clipboard group, click the Copy button. The border around the selected range becomes a moving border.

Select A1 and then click the Paste button. The moving border remains active around HI A copied range does not deactivate until you type new text, issue another command, double-click on another cell, or press Esc.

Select A20 and then click the down arrow on the Paste button. The Paste options menu appears see Figure Figure The Paste options menu 6. Under Paste Values, select the first option. Notice that the values in the range BB31 are no longer formatted. Select HI22 and then press Delete. Click the Close button in the upper-right corner of the Clipboard pane to close it. Take Note If you point to the Paste options in either the shortcut menu or the Paste options in the Clipboard group, you will be able to preview your changes before actually implementing them.

The properties include items that you indirectly change such as file size and last edit date. The workbook properties also include items you directly change such as keywords. Assigning keywords also called tags to the document properties makes it easier to organize and find documents. You can also add more notes to your file for classification and document management. Assigning Keywords If you work for Fabrikam, Inc. You can then search for and locate all files containing information about sales.

You can assign more than one keyword to a document. Click File. The Backstage view displays current properties on the right side of the window. At the bottom of the right pane, click the Show All Properties link to display additional properties.

Click the Categories field and type Revenue. Click the Company field and type Fabrikam, Inc.. Above the Size field, click the Properties drop-down arrow, and then click Advanced Properties. The Properties dialog box opens see Figure Click the Summary tab in the dialog box to see the properties you entered. Click the Statistics tab to see the date you modified the file. Click OK to close the Properties dialog box. Press Esc to return to the worksheet.

Working with Microsoft Excel 33 After a file is saved, the Statistics tab records when the file was accessed and when it was modified. It also identifies the person who last saved the file. After a workbook is saved, the Properties dialog box title bar displays the workbook name. Knowledge Assessment Multiple Choice Select the best response for the following statements. Which of the following consists of details that describe or identify a file, including the author? Paste b. Document properties c.

Copy d. Range 2. Which command is used to insert a cut or copied selection to a cell or range of cells? Range 3. If you want to use a workbook in another kind of document, you have the option to save using which of the following?

File format b. Worksheet c. File sheet d. File range 4. Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series? Cell pointer b.

Column marker c. Fill handle d. Formula bar 5. Which of the following can you drag or double-click to change the width of a column? Using the Delete key removes both text and formats from a cell. You can assign keywords so that others can search for your documents online. The formula bar is found at the bottom of the Excel window. Use the fill handle to create a natural series, such as the months of the year. Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel.

Click cell A1, type Fabrikam, Inc. Beginning in A4, type the following labels and values. If necessary, adjust the column widths to display all of the text in the columns. LEAVE the workbook open for the next project. Project Setting Document Properties and Assigning Keywords In this project, you will use Document Properties to assign properties to an existing workbook. Click Properties and then click Advanced Properties. Click the Summary tab.

In the Subject field, type Sales and then press Tab. In the Author field, type [your name] and then press Tab four times. In the Keywords field, type , options, priorities.

CLOSE the file. Each tab provides related options and settings to help you manage your Excel workbook files. This is your access to Backstage view. When you click the File tab to access Backstage view, you see the navigation pane on the left side of the window, with commands related to managing files refer to Figure If you want to return to your workbook from Backstage view, click the Return to document button in the upper left corner or press Esc.

You can use the Print settings to manipulate workbook elements such as margins, orientation, paper size, and so on. Many of these commands are also available from the Page Layout tab on the ribbon. Setting the Print Area You can use the Print options in Backstage view to print only a selected portion, or print area, of an Excel workbook. In this exercise, you learn to select an area of a workbook for printing.

You print just the list of items in the worksheet. On the worksheet, click cell A3, hold the mouse button, and then drag to cell A Your selected cell range should be highlighted in gray see Figure Figure Selecting a print area 2. Click the File tab and then click Print in the navigation pane. Under Settings, click the first button, labeled Print Active Sheets the name on the button changes if you make a different selection.

A drop-down menu of options displays for setting the print area. From the menu that appears, click Print Selection. You have now set the print area. Notice in the Print Preview pane on the right that you can see only the list of items to bring and not the text in rows 1 and 2 see Figure Click the Return to document button.

You will not print at this time. Take Note Specifying a print area from the Backstage view does not save the setting with the workbook. If you want to save the print area for later use, select the range for the print area, and then on the Page Layout tab, click Print Area, and then Set Print Area.

Printing Selected Worksheets In this exercise, you learn to access the options for printing individual worksheets in a workbook. You can use these options to print the current worksheet only or to print multiple worksheets. This is a modified version of the potluck workbook you used previously. In this case, there are three different worksheets for three different departments.

Click each of the three worksheet tabs: HR, Operations, and Finance. Notice that the title in C1 shows the department name and there are a different number of items to bring to each potluck depending on the size of the department. Click the HR tab.

In the Print Preview pane, the first worksheet displays. Excel prints only the active sheets by default. Notice that the page number shows 1 out of 1, indicating that only one of the worksheets will print, and it will all fit on one page. Press Esc or click the Return to document button. While the HR worksheet is active, hold down Ctrl and click on the Finance tab. Now both the HR and Finance worksheets are selected.

Click the File tab and then click Print. Now in the Print Preview area, the bottom of the screen shows 1 of 2 with the HR worksheet preview. Click the right arrow to go to the second page and notice that the Finance worksheet previews see Figure Page 1 is the HR worksheet 7. In the drop-down menu that appears, notice that you can select several printing options for your workbook or worksheet.

Click the Return to document button to return to the workbook without printing. CLOSE the workbook without saving. Printing an Entire Workbook In most scenarios in business, workbooks are composed of multiple worksheets.

In this exercise, you use commands in Backstage view to print an entire workbook. With Excel open from the previous exercise, perform the following steps. Click the File tab and then click Open if it is not selected. Because you just used the 03 Contoso Potluck Depts workbook, it should be at the top of the Recent list in the right pane. Click 03 Contoso Potluck Depts to open it. Notice that the complete workbook does not display in the Print Preview area.

This is because you did not save the workbook after you selected multiple sheets in the previous exercise. Now in the Print Preview area, the bottom of the screen shows 1 of 3. This exercise prepares you to customize such options as page setup, scale, paper selection, and gridlines, all using the commands in Backstage view.

Click the File tab and select Print see Figure Notice that the worksheet is small and it might be nice to have lines for people to write in on a printed page.

In the Settings area of the Print window, click the Margins drop-down arrow and then click Wide. The new margins will allow the worksheet to be hole-punched and put in a binder. Click the Scaling drop-down and see the choices below. The scaling options ensure that all columns, rows, or the entire worksheet fit on one page. In this case, you want to make the text larger without changing the font. Click Custom Scaling Options. The Page Setup dialog box opens.

Make sure that the Page tab is selected and select Landscape so the page prints horizontally. Click the Sheet tab and in the Print section, select the Gridlines check box.

Click OK to return to Backstage view. Notice that the bottom of the screen still says, 1 of 1, meaning that only one page will print and notice that Print Preview shows larger text with boxes around each cell.

Without printing the document, click the Return to document button and then click the HR-P2 worksheet. Change the Settings to print Landscape, the Scaling to Fit Sheet on One Page, and add gridlines based on the previous steps in this section.

Print Preview should look like Figure Default settings are pre-set options that determine how Excel will behave when performing an action.

For example, a default printer is the one your documents always print to unless you change the setting. By default, there is one worksheet in a workbook and the font is Calibri, 11 points—but you can change those settings too. Take Note After you customize the Quick Access Toolbar and the ribbon in the following exercises, you will follow steps to return Excel to the default settings. In this exercise, you customize the Quick Access Toolbar by adding commands for functions you use most frequently in Excel, and by organizing the command but- tons on the toolbar to best suit your working needs and style.

OPEN a blank workbook in Excel. Click the File tab to access Backstage view. In the navigation pane, click the Options tab. In the right pane, the list on the left includes the commands that you can add to the toolbar. The list on the right shows the commands that are currently shown on the toolbar. In the list on the left, scroll down and click Format Painter see Figure , and then click the Add button in the center of the two lists to add the Format Painter to the Quick Access Toolbar.

Using the same process, move five more commands you use often to the Quick Access Toolbar. Notice that your Quick Access Toolbar now includes additional command buttons. Similarly, you can remove any command that you added to the toolbar. In the For Calendar box, select Jamie Reding. Slide the button next to the calendar until the calendar is on January, Select the dates January 28 and In the first Name field under the Exceptions tab, type Vacation Days.

Press Enter. Microsoft Project will not schedule Jamie Reding to work on these two days. Keep in mind that when you make changes to the project calendar, the changes are reflected in all resource calendars which are based on the project calendar.

However, changes you make to the working times of an individual resource are not reflected in the project calendar. Establishing Specific Work Schedules In addition to specifying exception times for resources, you can also set up a specific work schedule for any given resource.

Establishing Resources 51 2. In the For Calendar box, select Scott Seely. Click the Work Weeks tab, and then click the Details button. In the Select day s box, click and drag to select Monday through Thursday. Select the radio button next to Set day s to these specific working times. Press Enter to set your changes. Figure Details dialog box showing modified working times for Scott Seely 9.

In the Select day s box, click Friday. Select the radio button next to Select Set days to nonworking time. Click OK to close the Details dialog box. Click any Friday in the Change Working Time dialog box. Note that these days are set to nonworking time. Click any one day of the week, Monday — Thursday. Note the working times for these days.

Modified working hours for Monday through Friday Fridays are grayed out indicating nonworking time If you need to edit several resource calendars in the same way to handle a flex-time schedule or night shift, for example , you might find it easier to assign a different base calendar to this group of resources. A base calendar can be used as a task calendar, a project calendar, or resource calendar and specifies default working and nonworking times.

In the For Calendar box, select the desired resource and then in the Base Calendar box, select the desired base calendar. For a group of resources that will be using the same calendar, you can change the calendar directly in the Base Calendar column of the Entry table in the Resource Sheet view.

You can customize these or use them as a basis for your own base calendar. You can add this additional information about a resource by attaching a note. Attaching a Note to a Resource In this exercise, you learn how to attach a scheduling note to a resource in Project In the Resource Name column, select the name of the resource 1, Jamie Reding.

On the ribbon, click the Resource tab, then click the Resource Notes button in the Properties command group on the ribbon. The Resource Information dialog box is displayed with the Notes tab visible. In the Notes box, type Jamie on vacation Jan 28 and 29; available for consult at home if necessary and click OK. A note icon appears in the indicator column. Point to the note icon in the Resource sheet.

The note appears in a ScreenTip double-click the icon to display the full text of longer notes. Figure Resource note displayed as a ScreenTip.

Which of the following is NOT an example of a work resource? Yan Li b. DVD Disc d. It is helpful to assign a base calendar to a group of resources when they all a.

A resource calendar does not apply to a. You can view information for the individual people who will perform the tasks on the project in the a. Calendar view. Gantt Chart view. Task Usage view. Resource Sheet view. You can provide additional information about how a resource is scheduled by a. For which resource is the standard rate listed per tracking unit of consumption?

If you have four electricians who can each work part-time 4 hours rather than 8 , what value should you assign to Max. If you assign a resource to more tasks than it can accomplish at its maximum units, the resource is a. To add vacation days to the calendar for an individual work resource, which dialog box would you use?

Resource Information b. Resource Notes c. Change Working Time d. It is often difficult to get cost information for people resources because a.

Competency Assessment Project Hiring a New Employee In the previous lesson, you entered the tasks of a project schedule for hiring a new employee. Now you need to add some of the people resources that will be responsible for performing those tasks. Enter the following resource names into the Simple Resource Sheet. Project Office Remodel You are in charge of the remodeling project for the kitchen and lunchroom for your office.

Your facilities manager has just provided you with the resource pay rates for this project. You need to enter the pay rates in the project schedule. Select the Resource Sheet view. For the drywall resource, click the Type field drop-down arrow and select Material, then press Tab. For the nails resource, click the Type field drop-down arrow and select Material, then press Tab.

Rate field for resource 1, Toby Nixon. Enter the following standard pay rates for the remaining resources. Now you need to add a note to one of the resources on the project.

Select the name of resource 3, Amy Rusko. On the Resource ribbon, click the Resource Notes button in the Properties command group. Not available for any interviews. Close the Resource Information box.

Select the name of resource 4, Jeff Smith. Click the Resource Notes button. Available for interviews on November Now you need to add several equipment resources to make sure that your schedule flows smoothly. Change the view to Resource Sheet.

Add the following equipment resources to the project schedule. Resource Name Max. Mastery Assessment Project Change Work Times for a Resource on Office Remodel You have just been told that one of your resources on your office remodel project is planning to take a week of vacation. You need to add this information to your project schedule. Open the Change Working Time dialog box. Project Don Funk Music Video Problems A student who is interning with your company made some updates to the music video project schedule.

Unfortunately, he is still learning about Microsoft Project and has entered some information incorrectly. You need to correct the problems with the project schedule before distributing it to your team. Review the Resource Sheet for this project schedule.

Based on what you have learned in this lesson about Resource Types, Maximum Units, and Standard Rates, find the resource errors in this project schedule and make corrections to them. Hint: There are three resource errors in the project schedule. Study the last three resources on the sheet.

If dry ice is a work resource and bottled water is a cost resource, make corrections to the information given for these resources estimate the rate if necessary. You first mapped out the initial tasks in the project, then identified the resources needed to complete the tasks in the project. You activate the Assign Resources dialog box via the Assign Resources button located in the Assignments group on the Resource ribbon.

Your Assign Resources dialog box should look similar to Figure or , depending upon whether the Resource List options are collapsed or expanded. You can collapse the expanded list by clicking the button, now marked with a minus sign, once again. In this lesson you will use the Assign Resources dialog box and other methods to assign resources. You can assign individual resources to a task or multiple resources to a task at one time.

Once assigned, you can track the resource working on the task. Microsoft Project also enables you to see whether or not resource assignments affect task duration. Making Individual Resource Assignments An assignment is the matching of a specific resource to a particular task, to either perform work or as a material or cost.

Depending on your perspective, you might call it a resource assignment or you might call it a task assignment. In the previous lessons, you mapped out tasks and resources for your project schedule. In this exercise, you learn how to assign work resources to the tasks they will perform. Click the Resource tab and then click the Assign Resources button in the Assignments group.

The Assign Resources dialog box appears. If the Assign Resources dialog box is covering the task name column, drag the dialog box into the middle of the screen. To access this dialog box, double click on the task you want to assign resources. In the Task Name column, click the name of task 5, Develop production layouts. Assigning Multiple Resources Simultaneously You have just assigned one resource to a task. In this exercise, you will practice assigning multiple resources simultaneously to a task.

Once the resource has been assigned, it is moved to the top of the list. In the Task Name column, click the name of task 4, Develop scene blocking and schedule. In the Assign Resources dialog box, scroll down and click the name cell for Scott Seely.

Scroll up or down in the list until the name Judy Lew is visible. Hold down Ctrl, then click the name cell for Judy Lew. Release the Ctrl key and then click the Assign button. Check marks appear next to the names of Scott Seely and Judy Lew, indicating you have assigned them both to task 4. Move the center divider to the right to allow the Resource Names column to be visible. Click once on the Resource Name cell for task 6, Identify and reserve locations.

Then click the sub-menu arrow at the right of the cell. In the drop-down list, select the checkboxes for Jeff Pike and Yan Li. Figure Assigning resources using the drop-down list in the Resource Names column Checkmarks indicate the resources assigned to this task 9. Cross Ref Recall that in Lesson 2 you learned that Max. Units referred to the maximum capacity of a resource to accomplish tasks. You may have noticed that the duration of task number 4 changed from 1 week to 1.

Bear in mind that Microsoft Project is using the resource calendars to schedule the tasks. The duration is extended by. The last 8 hours of his portion of the work will not be completed until the following week. The capacity of a resource to work when you assign that resource to a task is measured in units. Units are recorded in the Max. Units field on the Resource Sheet view. As you are assigning resources, you need to be careful that you do not over-allocate a resource, by assigning it more work than can be done within the normal work capacity of the resource.

This may happen if you assign a resource to a task with more units than the resource has available. Another possibility is that you assign the resource to multiple tasks with schedules that overlap and with combined units that exceed those of the resource.

This means that as you assign resources to a task, the duration remains constant and the work value is calculated. The most obvious effect of this scheduling method is that, as you add or remove resources, the work value changes and therefore the costs change.

Adding Work Resources to a Task You have started to define resource assignments for several tasks in your project schedule. Now you will assign additional resources to those tasks. To view work information in each task, you will use a split view.

Pay close attention to the results in relation to task duration and work in the split view. Click the View tab. In the Split View group on the ribbon, select the Details checkbox. The Task Form view appears in the bottom part of your screen.

Click the name of task 3, Review screenplay. In the Task Form pane at the bottom of your screen, note the Work value of this task — hours. Click the sub-menu arrow at the right of this cell, then select Jeff Pike.

At the top of the Task Form portion of the screen, click the OK button. Microsoft Project assigns Jeff Pike to task 3. Wowk is the total amount of effort expended to complete a task. Microsoft Project calculates work using a work formula: Work 5 Duration 3 Units.

While you have the option of entering and displaying work in different units, by default, work is expressed in hours. Notice that when you added Jeff to task 3, Microsoft Project calculated his work using the formula above. The total work of the task doubled with the addition of this one resource. Notice also that Project automatically highlighted the duration, which changed as a result of adding Jeff, based on his work schedule. Click the name of task 5, Develop production layouts.

Jeff Pike is the only resource currently assigned to this task, work is calculated at hours and the duration is 1 month. In the Task Form screen click the check box for Effort driven. On the Ribbon bar, click File, then select Options. On the Project Option dialog box, select Schedule. Navigate down to Scheduling options for this project and clear or select the New tasks are Effort driven check box.

To change effort-driven scheduling for a single task or group of tasks, select the desired task s. Click the Task ribbon and then in the Properties group, select the Information button. Select the Advanced tab of the Multiple Task Information dialog box. Clear or select the Effort driven check box. Click once in the blank cell below Jeff Pike. From the drop-down menu, select Brenda Diaz. Then click the OK button at the upper portion of the Task Form screen.

Notice that the duration has been changed to. In this instance you applied effort-driven scheduling, which tells Microsoft Project to hold the work value constant and change the duration when resources are added or removed. Similar to the work formula but in the context of duration, the duration formula is used in effort-driven scheduling.

In an effort-driven task, the work value is held steady and the variable is units. In the example you used in the previous exercise, hours was the work value with one resource assigned. So, Duration 5 80 hours or. An Actions tag is an indicator that signals the user of a change, additional information, formatting options, etc. In Project , the Actions tag appears mainly when changes to units, duration, or work occurs. The Actions tag will appear only when certain methods are used to apply changes, such as adding resources with the Assign Resources dialog box.

The Actions tag only remains available until you perform your next action. In the Gantt Chart portion of the view, click on the name of task 5, Develop production layouts.

Hold down Ctrl then locate and click Brad Sutton. Release the Ctrl key. Click the Assign button. These two resources are added to the task. In addition, an Actions tag appears to the left of the task name column. Click the Actions tag button. A list of options regarding how you want to handle this additional resource is displayed.

For example, if you assigned resources in the Task Form on an effort-driven task, the Actions tag would not appear in the Gantt Chart portion of the view.

Select Increase the amount of work but keep the same duration. Click the name of task 6, Identify and reserve locations. Take note of the work data in the Task Form pane hours total.

Hold down Ctrl, click Ryan Ihrig. Release the Ctrl key then click the Assign button. Microsoft Project assigns Annete and Ryan to the task. Because this task is using the default settings, Microsoft Project increases the total work value and keeps the task duration constant. You have determined that this task does not require a full-time effort because these two additional resources will take over some of the administrative functions.

Select: Reduce the hours resources work per day units , but keep the same duration and work. Figure Split view showing details of task information after a resource addition Units and Work information recalculated after selecting the Actions option to reduce hours per day 68 Lesson 3 Click the Close button in the Assign Resources dialog box.

Using effort-driven scheduling, Microsoft Project will maintain that work amount as the total effort required to perform that task until you tell it otherwise. In this mode, Microsoft Project performs the work calculation at the FIRST work resource assignment, regardless of the number of work resources assigned i.

This course is available in three price tiers. The course price is not listed on the website. Contact a CBT nuggets representative to get the most accurate pricing information. Webucator offers a set of Microsoft Project tutorials for different versions and levels of mastery of the software.

Instructor-led live classes can be scheduled; students also have an option for customized, in-person private classes. The site offers several types of courses, including one-day rapid formats for beginner, intermediate, or advanced levels of MS Project.

This is a great option for those with no experience with MS Project who need to quickly gain advanced knowledge of this software. Microsoft Project Introduction introduces participants to planning projects, tracking and managing project resources, creating powerful visual reports, and tracking and monitoring project deliverables.

Microsoft Project Advanced provides more in-depth exploration of the software, guiding users through the following core skill areas:. Microsoft Project is a well-known project management tool in the industry. These online tutorials serve those who just want an introduction, all the way up to expert level skills and familiarity with the software. Naturally, the higher the level of training, the more time and financial investment the course will require.

Are you planning to introduce a project management software solution to your employee? Type Travel and then press Tab. In the Type field, click the arrow and select Cost. The travel resource has now been established as a cost resource. Just as with a material resource, some fields are not available with a cost resource. In the Type field, select Cost and press Enter. Also, unlike work resources, cost resources cannot have a calendar applied to them and therefore do not affect the scheduling of the task.

When you enter the cost information for resources, tracking the finances of a project becomes a more manageable task. Entering Resource Cost Information Knowing resource cost information will help you take full advantage of the cost management features of Microsoft Project.

In this exercise, you practice entering cost information for both work and material resources. In the Resource Sheet, click the Std. Standard Rate field for resource 1, Jamie Reding. Establishing Resources 47 2. In the Std. Rate column for resource 2, Scott Seely, type Rate column.

Widen the Std. Rate column by moving the mouse pointer to the vertical divider line between the Std. Rate column and Ovt. Double-click the divider line. Figure Resource Sheet with the standard rate for first two resources entered. For a material resource, the standard rate is per unit of consumption.

For this exercise, that is a 2-hour DVD. Also note that you did not assign a cost to the cost resources; this is done when the cost resources are assigned to a task covered in Lesson 3. In the real world, it is often difficult to get cost information for people resources because this information is usually considered confidential. As a project manager, it is important that you are aware of the limitations of your project schedule because of the information available to you, and that you communicate these limitations to your project team Establishing Resources 49 and management.

As a project manager, tracking and managing cost information may be a significant part of your project responsibilities. You should define these times prior to assigning them to tasks.

Resource working times apply only to people and equipment work resources — not to material resources. Now that you have entered resources and their associated pay rates in your project schedule, you can specify the working and nonworking times for some of these resources.

The resource calendar provides default working times for an entire project. Typically, you will need to make changes to the individual resource calendars to reflect vacation, flex-time work schedules, or conference attendance. In this exercise, you establish nonworking times for your individual work resources. Click the Project tab, then click Change Working Time. The Change Working Time dialog box appears.

In the For Calendar box, select Jamie Reding. Slide the button next to the calendar until the calendar is on January, Select the dates January 28 and In the first Name field under the Exceptions tab, type Vacation Days. Press Enter. Microsoft Project will not schedule Jamie Reding to work on these two days. Keep in mind that when you make changes to the project calendar, the changes are reflected in all resource calendars which are based on the project calendar.

However, changes you make to the working times of an individual resource are not reflected in the project calendar. Establishing Specific Work Schedules In addition to specifying exception times for resources, you can also set up a specific work schedule for any given resource. Establishing Resources 51 2. In the For Calendar box, select Scott Seely.

Click the Work Weeks tab, and then click the Details button. In the Select day s box, click and drag to select Monday through Thursday. Select the radio button next to Set day s to these specific working times. Press Enter to set your changes. Figure Details dialog box showing modified working times for Scott Seely 9. In the Select day s box, click Friday. Select the radio button next to Select Set days to nonworking time. Click OK to close the Details dialog box.

Click any Friday in the Change Working Time dialog box. Note that these days are set to nonworking time. Click any one day of the week, Monday — Thursday. Note the working times for these days.

Modified working hours for Monday through Friday Fridays are grayed out indicating nonworking time If you need to edit several resource calendars in the same way to handle a flex-time schedule or night shift, for example , you might find it easier to assign a different base calendar to this group of resources. A base calendar can be used as a task calendar, a project calendar, or resource calendar and specifies default working and nonworking times.

In the For Calendar box, select the desired resource and then in the Base Calendar box, select the desired base calendar. For a group of resources that will be using the same calendar, you can change the calendar directly in the Base Calendar column of the Entry table in the Resource Sheet view.

You can customize these or use them as a basis for your own base calendar. You can add this additional information about a resource by attaching a note. Attaching a Note to a Resource In this exercise, you learn how to attach a scheduling note to a resource in Project In the Resource Name column, select the name of the resource 1, Jamie Reding.

On the ribbon, click the Resource tab, then click the Resource Notes button in the Properties command group on the ribbon. The Resource Information dialog box is displayed with the Notes tab visible. In the Notes box, type Jamie on vacation Jan 28 and 29; available for consult at home if necessary and click OK. A note icon appears in the indicator column. Point to the note icon in the Resource sheet.

The note appears in a ScreenTip double-click the icon to display the full text of longer notes. Figure Resource note displayed as a ScreenTip. Which of the following is NOT an example of a work resource? Yan Li b. DVD Disc d. It is helpful to assign a base calendar to a group of resources when they all a.

A resource calendar does not apply to a. You can view information for the individual people who will perform the tasks on the project in the a. Calendar view. Gantt Chart view. Task Usage view.

Resource Sheet view. You can provide additional information about how a resource is scheduled by a. For which resource is the standard rate listed per tracking unit of consumption?

If you have four electricians who can each work part-time 4 hours rather than 8 , what value should you assign to Max. If you assign a resource to more tasks than it can accomplish at its maximum units, the resource is a. To add vacation days to the calendar for an individual work resource, which dialog box would you use?

Resource Information b. Resource Notes c. Change Working Time d. It is often difficult to get cost information for people resources because a. Competency Assessment Project Hiring a New Employee In the previous lesson, you entered the tasks of a project schedule for hiring a new employee. Now you need to add some of the people resources that will be responsible for performing those tasks.

Enter the following resource names into the Simple Resource Sheet. Project Office Remodel You are in charge of the remodeling project for the kitchen and lunchroom for your office. Your facilities manager has just provided you with the resource pay rates for this project. You need to enter the pay rates in the project schedule. Select the Resource Sheet view.

For the drywall resource, click the Type field drop-down arrow and select Material, then press Tab. For the nails resource, click the Type field drop-down arrow and select Material, then press Tab. Rate field for resource 1, Toby Nixon. Enter the following standard pay rates for the remaining resources.

Now you need to add a note to one of the resources on the project. Select the name of resource 3, Amy Rusko. On the Resource ribbon, click the Resource Notes button in the Properties command group. Not available for any interviews.

Close the Resource Information box. Select the name of resource 4, Jeff Smith. Click the Resource Notes button. Available for interviews on November Now you need to add several equipment resources to make sure that your schedule flows smoothly.

Change the view to Resource Sheet. Add the following equipment resources to the project schedule. Resource Name Max. Mastery Assessment Project Change Work Times for a Resource on Office Remodel You have just been told that one of your resources on your office remodel project is planning to take a week of vacation. You need to add this information to your project schedule.

Open the Change Working Time dialog box. Project Don Funk Music Video Problems A student who is interning with your company made some updates to the music video project schedule. Unfortunately, he is still learning about Microsoft Project and has entered some information incorrectly.

You need to correct the problems with the project schedule before distributing it to your team. Review the Resource Sheet for this project schedule. Based on what you have learned in this lesson about Resource Types, Maximum Units, and Standard Rates, find the resource errors in this project schedule and make corrections to them. Hint: There are three resource errors in the project schedule.

Study the last three resources on the sheet. If dry ice is a work resource and bottled water is a cost resource, make corrections to the information given for these resources estimate the rate if necessary. You first mapped out the initial tasks in the project, then identified the resources needed to complete the tasks in the project. You activate the Assign Resources dialog box via the Assign Resources button located in the Assignments group on the Resource ribbon.

Your Assign Resources dialog box should look similar to Figure or , depending upon whether the Resource List options are collapsed or expanded.

You can collapse the expanded list by clicking the button, now marked with a minus sign, once again. In this lesson you will use the Assign Resources dialog box and other methods to assign resources. You can assign individual resources to a task or multiple resources to a task at one time.

Once assigned, you can track the resource working on the task. Microsoft Project also enables you to see whether or not resource assignments affect task duration. Making Individual Resource Assignments An assignment is the matching of a specific resource to a particular task, to either perform work or as a material or cost. Depending on your perspective, you might call it a resource assignment or you might call it a task assignment.

In the previous lessons, you mapped out tasks and resources for your project schedule. In this exercise, you learn how to assign work resources to the tasks they will perform. Click the Resource tab and then click the Assign Resources button in the Assignments group. The Assign Resources dialog box appears. If the Assign Resources dialog box is covering the task name column, drag the dialog box into the middle of the screen.

To access this dialog box, double click on the task you want to assign resources. In the Task Name column, click the name of task 5, Develop production layouts. Assigning Multiple Resources Simultaneously You have just assigned one resource to a task. In this exercise, you will practice assigning multiple resources simultaneously to a task.

Once the resource has been assigned, it is moved to the top of the list. In the Task Name column, click the name of task 4, Develop scene blocking and schedule. In the Assign Resources dialog box, scroll down and click the name cell for Scott Seely.

Scroll up or down in the list until the name Judy Lew is visible. Hold down Ctrl, then click the name cell for Judy Lew. Release the Ctrl key and then click the Assign button. Check marks appear next to the names of Scott Seely and Judy Lew, indicating you have assigned them both to task 4. Move the center divider to the right to allow the Resource Names column to be visible. Click once on the Resource Name cell for task 6, Identify and reserve locations. Then click the sub-menu arrow at the right of the cell.

In the drop-down list, select the checkboxes for Jeff Pike and Yan Li. Figure Assigning resources using the drop-down list in the Resource Names column Checkmarks indicate the resources assigned to this task 9. Cross Ref Recall that in Lesson 2 you learned that Max. Units referred to the maximum capacity of a resource to accomplish tasks. You may have noticed that the duration of task number 4 changed from 1 week to 1. Bear in mind that Microsoft Project is using the resource calendars to schedule the tasks.

The duration is extended by. The last 8 hours of his portion of the work will not be completed until the following week. The capacity of a resource to work when you assign that resource to a task is measured in units. Units are recorded in the Max. Units field on the Resource Sheet view. As you are assigning resources, you need to be careful that you do not over-allocate a resource, by assigning it more work than can be done within the normal work capacity of the resource.

This may happen if you assign a resource to a task with more units than the resource has available. Another possibility is that you assign the resource to multiple tasks with schedules that overlap and with combined units that exceed those of the resource. This means that as you assign resources to a task, the duration remains constant and the work value is calculated.

The most obvious effect of this scheduling method is that, as you add or remove resources, the work value changes and therefore the costs change. Adding Work Resources to a Task You have started to define resource assignments for several tasks in your project schedule. Now you will assign additional resources to those tasks. To view work information in each task, you will use a split view. Pay close attention to the results in relation to task duration and work in the split view.

Click the View tab. In the Split View group on the ribbon, select the Details checkbox. The Task Form view appears in the bottom part of your screen. Click the name of task 3, Review screenplay. In the Task Form pane at the bottom of your screen, note the Work value of this task — hours. Click the sub-menu arrow at the right of this cell, then select Jeff Pike.

At the top of the Task Form portion of the screen, click the OK button. Microsoft Project assigns Jeff Pike to task 3. Wowk is the total amount of effort expended to complete a task. Microsoft Project calculates work using a work formula: Work 5 Duration 3 Units. While you have the option of entering and displaying work in different units, by default, work is expressed in hours. Notice that when you added Jeff to task 3, Microsoft Project calculated his work using the formula above. The total work of the task doubled with the addition of this one resource.

Notice also that Project automatically highlighted the duration, which changed as a result of adding Jeff, based on his work schedule. Click the name of task 5, Develop production layouts. Jeff Pike is the only resource currently assigned to this task, work is calculated at hours and the duration is 1 month.

In the Task Form screen click the check box for Effort driven. On the Ribbon bar, click File, then select Options. On the Project Option dialog box, select Schedule. Navigate down to Scheduling options for this project and clear or select the New tasks are Effort driven check box.

To change effort-driven scheduling for a single task or group of tasks, select the desired task s. Click the Task ribbon and then in the Properties group, select the Information button. Select the Advanced tab of the Multiple Task Information dialog box.

Clear or select the Effort driven check box. Click once in the blank cell below Jeff Pike. The remaining last names fill down the column. These processes are discussed as the exercises in this section continue. You can also copy specific contents or attri- butes from the cells.

For example, you can copy the format only without copying the cell value, or copy the resulting value of a formula without copying the formula itself. You can also copy the value from the original cell but retain the formatting of the destination cell.

Just select the cell or range of cells you want to copy and hold down Ctrl while you point to the border of the selection. When the pointer becomes a copy pointer arrow with a plus , you can drag the cell or range of cells to the new location. As you drag, a scrolling ScreenTip identifies where the selection will be copied if you release the mouse button. In this exercise, you practice copying data with the mouse.

Open the 02 Customer Houses file. Select the range AA Press Ctrl and point to the right border of the selected range. The copy pointer is displayed. Troubleshooting Be sure to hold down the Ctrl key the entire time you are dragging a data series for copying with the mouse, or you will move the series instead of copying it. With the copy pointer displayed, press and hold down the left mouse button and drag the selection to the right, until HH22 appears in the scrolling ScreenTip next to the selection.

Release the mouse button and then release Ctrl. The data in AA22 also appears in HH Moving a Data Series with the Mouse Data can be moved from one location to another within a workbook in much the same way as copying. To move a data series, select the cell or range of cells and point to the border of the se- lection.

When data is moved, it replaces any existing data in the destination cells. In this exercise, you practice moving a data series from one range of cells to another. USE the 02 Customer Houses workbook from the previous exercise. Select EE Point to the right border of the selected range. The move pointer a white arrow with four smaller black arrows attached is displayed. With the move pointer displayed, hold down the left mouse button and then drag the selection to the right, until II22 appears in the scrolling ScreenTip beside the selected range.

Release the mouse button. In your worksheet, the destination cells are empty; therefore, you are not concerned with replacing existing data. The data previously in EE22 is now in II Drag A1 to H Note that a dialog box warns you about replacing the contents of the destination cells.

Click Cancel. Drag E1 to I Your worksheet should look like the one shown in Figure Take Note When you attempt to move a selection to a location that contains data, a caution dialog box opens.

Do you want to replace it? You can click OK or cancel the operation. Copying and Pasting Data The Office Clipboard collects and stores up to 24 copied or cut items that are then available to be used in the active workbook, in other workbooks, and in other Microsoft Office programs. Working with Microsoft Excel 31 You can paste insert selected items from the Clipboard to a new location in the worksheet.

Cut moved data is removed from the worksheet but is still available for you to use in multiple locations. If you copy multiple items and then click Paste, only the last item copied will be pasted.

To access multiple items, you must open the Clipboard pane. In this exercise, you use commands in the Clipboard group and the Clipboard pane to copy and paste cell data. The Clipboard pane opens on the left side of the worksheet.

The most recently copied item is always added at the top of the list in this pane, and it is the item that will be copied when you click Paste or a shortcut command. Select A1:E22 and then press Delete. Select HI22 and in the Clipboard group, click the Copy button. The border around the selected range becomes a moving border. Select A1 and then click the Paste button. The moving border remains active around HI A copied range does not deactivate until you type new text, issue another command, double-click on another cell, or press Esc.

Select A20 and then click the down arrow on the Paste button. The Paste options menu appears see Figure Figure The Paste options menu 6.

Under Paste Values, select the first option. Notice that the values in the range BB31 are no longer formatted. Select HI22 and then press Delete. Click the Close button in the upper-right corner of the Clipboard pane to close it. Take Note If you point to the Paste options in either the shortcut menu or the Paste options in the Clipboard group, you will be able to preview your changes before actually implementing them.

The properties include items that you indirectly change such as file size and last edit date. The workbook properties also include items you directly change such as keywords.

Assigning keywords also called tags to the document properties makes it easier to organize and find documents. You can also add more notes to your file for classification and document management. Assigning Keywords If you work for Fabrikam, Inc. You can then search for and locate all files containing information about sales. You can assign more than one keyword to a document. Click File. The Backstage view displays current properties on the right side of the window.

At the bottom of the right pane, click the Show All Properties link to display additional properties. Click the Categories field and type Revenue. Click the Company field and type Fabrikam, Inc.. Above the Size field, click the Properties drop-down arrow, and then click Advanced Properties.

The Properties dialog box opens see Figure Click the Summary tab in the dialog box to see the properties you entered.

Click the Statistics tab to see the date you modified the file. Click OK to close the Properties dialog box. Press Esc to return to the worksheet. Working with Microsoft Excel 33 After a file is saved, the Statistics tab records when the file was accessed and when it was modified. It also identifies the person who last saved the file. After a workbook is saved, the Properties dialog box title bar displays the workbook name. Knowledge Assessment Multiple Choice Select the best response for the following statements.

Which of the following consists of details that describe or identify a file, including the author? Paste b. Document properties c. Copy d. Range 2. Which command is used to insert a cut or copied selection to a cell or range of cells?

Range 3. If you want to use a workbook in another kind of document, you have the option to save using which of the following? File format b. Worksheet c. File sheet d. File range 4. Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?

Cell pointer b. Column marker c. Fill handle d. Formula bar 5. Which of the following can you drag or double-click to change the width of a column? Using the Delete key removes both text and formats from a cell. You can assign keywords so that others can search for your documents online. The formula bar is found at the bottom of the Excel window.

Use the fill handle to create a natural series, such as the months of the year. Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel. Click cell A1, type Fabrikam, Inc.

Beginning in A4, type the following labels and values. If necessary, adjust the column widths to display all of the text in the columns. LEAVE the workbook open for the next project.

Project Setting Document Properties and Assigning Keywords In this project, you will use Document Properties to assign properties to an existing workbook. Click Properties and then click Advanced Properties. Click the Summary tab.

In the Subject field, type Sales and then press Tab. In the Author field, type [your name] and then press Tab four times. In the Keywords field, type , options, priorities. CLOSE the file. Each tab provides related options and settings to help you manage your Excel workbook files. This is your access to Backstage view. When you click the File tab to access Backstage view, you see the navigation pane on the left side of the window, with commands related to managing files refer to Figure If you want to return to your workbook from Backstage view, click the Return to document button in the upper left corner or press Esc.

You can use the Print settings to manipulate workbook elements such as margins, orientation, paper size, and so on. Many of these commands are also available from the Page Layout tab on the ribbon. Setting the Print Area You can use the Print options in Backstage view to print only a selected portion, or print area, of an Excel workbook. In this exercise, you learn to select an area of a workbook for printing.

You print just the list of items in the worksheet. On the worksheet, click cell A3, hold the mouse button, and then drag to cell A Your selected cell range should be highlighted in gray see Figure Figure Selecting a print area 2. Click the File tab and then click Print in the navigation pane. Under Settings, click the first button, labeled Print Active Sheets the name on the button changes if you make a different selection.

A drop-down menu of options displays for setting the print area. From the menu that appears, click Print Selection. You have now set the print area. Notice in the Print Preview pane on the right that you can see only the list of items to bring and not the text in rows 1 and 2 see Figure Click the Return to document button.

You will not print at this time. Take Note Specifying a print area from the Backstage view does not save the setting with the workbook. If you want to save the print area for later use, select the range for the print area, and then on the Page Layout tab, click Print Area, and then Set Print Area. Printing Selected Worksheets In this exercise, you learn to access the options for printing individual worksheets in a workbook. You can use these options to print the current worksheet only or to print multiple worksheets.

This is a modified version of the potluck workbook you used previously. In this case, there are three different worksheets for three different departments. Click each of the three worksheet tabs: HR, Operations, and Finance. Notice that the title in C1 shows the department name and there are a different number of items to bring to each potluck depending on the size of the department.

Click the HR tab. In the Print Preview pane, the first worksheet displays. Excel prints only the active sheets by default. Notice that the page number shows 1 out of 1, indicating that only one of the worksheets will print, and it will all fit on one page.

Press Esc or click the Return to document button. While the HR worksheet is active, hold down Ctrl and click on the Finance tab. Now both the HR and Finance worksheets are selected. Click the File tab and then click Print. Now in the Print Preview area, the bottom of the screen shows 1 of 2 with the HR worksheet preview. Click the right arrow to go to the second page and notice that the Finance worksheet previews see Figure Page 1 is the HR worksheet 7. In the drop-down menu that appears, notice that you can select several printing options for your workbook or worksheet.

Click the Return to document button to return to the workbook without printing. CLOSE the workbook without saving. Printing an Entire Workbook In most scenarios in business, workbooks are composed of multiple worksheets. In this exercise, you use commands in Backstage view to print an entire workbook. With Excel open from the previous exercise, perform the following steps. Click the File tab and then click Open if it is not selected. Because you just used the 03 Contoso Potluck Depts workbook, it should be at the top of the Recent list in the right pane.

Click 03 Contoso Potluck Depts to open it. Notice that the complete workbook does not display in the Print Preview area. This is because you did not save the workbook after you selected multiple sheets in the previous exercise. Now in the Print Preview area, the bottom of the screen shows 1 of 3. This exercise prepares you to customize such options as page setup, scale, paper selection, and gridlines, all using the commands in Backstage view.

Click the File tab and select Print see Figure Notice that the worksheet is small and it might be nice to have lines for people to write in on a printed page. In the Settings area of the Print window, click the Margins drop-down arrow and then click Wide.

The new margins will allow the worksheet to be hole-punched and put in a binder. Click the Scaling drop-down and see the choices below. The scaling options ensure that all columns, rows, or the entire worksheet fit on one page. In this case, you want to make the text larger without changing the font. Click Custom Scaling Options. The Page Setup dialog box opens.

Make sure that the Page tab is selected and select Landscape so the page prints horizontally. Click the Sheet tab and in the Print section, select the Gridlines check box.

Click OK to return to Backstage view. Notice that the bottom of the screen still says, 1 of 1, meaning that only one page will print and notice that Print Preview shows larger text with boxes around each cell. Without printing the document, click the Return to document button and then click the HR-P2 worksheet.

Change the Settings to print Landscape, the Scaling to Fit Sheet on One Page, and add gridlines based on the previous steps in this section. Print Preview should look like Figure Default settings are pre-set options that determine how Excel will behave when performing an action.

For example, a default printer is the one your documents always print to unless you change the setting. By default, there is one worksheet in a workbook and the font is Calibri, 11 points—but you can change those settings too.

Take Note After you customize the Quick Access Toolbar and the ribbon in the following exercises, you will follow steps to return Excel to the default settings. In this exercise, you customize the Quick Access Toolbar by adding commands for functions you use most frequently in Excel, and by organizing the command but- tons on the toolbar to best suit your working needs and style.

OPEN a blank workbook in Excel. Click the File tab to access Backstage view. In the navigation pane, click the Options tab.

In the right pane, the list on the left includes the commands that you can add to the toolbar. The list on the right shows the commands that are currently shown on the toolbar. In the list on the left, scroll down and click Format Painter see Figure , and then click the Add button in the center of the two lists to add the Format Painter to the Quick Access Toolbar.

Using the same process, move five more commands you use often to the Quick Access Toolbar. Notice that your Quick Access Toolbar now includes additional command buttons.

Similarly, you can remove any command that you added to the toolbar. At any time, you can reset the toolbar to its default settings.

Click Yes to confirm and then click OK. Customizing the Ribbon As mentioned in Lesson 1, the ribbon is a visual interface that allows you to manipulate items on your worksheet.