Microsoft official academic course microsoft project 2016 pdf free

Looking for:

The Best Microsoft Project Tutorials — Training & Courses – Account Options

Click here to Download


Account Options Anmelden. Meine Mediathek Hilfe Erweiterte Buchsuche. Weiter zu Google Play ». Microsoft Project Microsoft Official Academic Course. The Microsoft Official Academic Course MOAC textbook for Project is designed to help develop and reinforce common workforce skills within today\’s competitive job mictosoft. With this textbook students learn to establish and navigate through project resources like establishing and adjusting resource pay rates and working microsoft official academic course microsoft project 2016 pdf free.

Task ссылка include assigning work resources and assignments to tasks; allowing certain actions to tag and change Project\’s scheduling behaviors.

Scheduling refinements and formatting allows students to understand the different task types and the effects of the work formulas. Students will be able to understand how to utilize the task information dialog box to change a на этой странице type.

This edition also covers project reporting, integrating Microsoft Project with other programs, and managing multiple projects at Skills mastery of Project can mivrosoft students with casework and differentiate job hunters in today\’s competitive job market.

Was andere dazu sagen – Rezension microsfot. Bibliografische Informationen.


Microsoft official academic course microsoft project 2016 pdf free. Microsoft Project 2016

You print just the list of items in the worksheet. Click once in the blank cell below Jeff Pike. Be the first to ask a question about Microsoft Project The width of the больше информации changes to the widest entry in column A. However, when you type in the next cell, продолжение здесь overflow text does not display. For example, if one resource could complete a task in 20 hours, could 20 resources complete the task in one hour? Another possibility is that you assign the resource to multiple tasks with schedules that overlap mmicrosoft with combined units that exceed those of the resource.


Microsoft official academic course microsoft project 2016 pdf free. The Best Microsoft Project Tutorials — Training & Courses


For details visit www. DreamSpark Premium is designed to provide the easiest and most inexpensive way for schools to make the latest Microsoft developer tools, products, and technologies available in labs, classrooms, and on student PCs. The membership provides a complete solution to keep academic labs, faculty, and students on the leading edge of technology.

Software available through the DreamSpark Premium program is provided at no charge to adopting departments through the Wiley and Microsoft publishing partnership. Note: Microsoft Project Professional can be downloaded from DreamSpark Premium for use by students in this course. Contact your Wiley rep for details. Wiley Desktop Editions provide students with numerous additional benefits that are not available with other e-text solutions. Students also have access to fully integrated resources within their Wiley Desktop Edition.

From highlighting their e-text to taking and sharing notes, students can easily personalize their Wiley Desktop Edition as they are reading or following along in class. Wiley E-Text: Powered by Vitalsource When you choose a Wiley E-Text you not only save money; you benefit from being able to access course materials and content anytime, anywhere through a user experience that makes learning rewarding.

Students can access it online and download to their computer for off line access and access read and study on their device of preference— computer, tablet, or smartphone. By using the practice files, you will not waste time creating the samples used in the lessons, and you can concentrate on learning how to use Microsoft Project With the files and the step-by-step instructions in the lessons, you will learn by doing, which is an easy and effective way to acquire and remember new skills.

Copying the Practice Files Your instructor might already have copied the practice files before you arrive in class. 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. In Internet Explorer, go to the student companion site: www. Search for your book title in the upper-right corner. Select Student Companion Site from the pop-up box. Now select Student Data Files from the center of the screen.

Remember the drive name that you saved your files to. Richie Gregg D. Richie, PMP, MCTS is the founding member and managing partner of P8, LLC, which is a consulting firm that provides consulting and training in project management techniques, including advanced usage and application of Microsoft Project. With more than 30 years of experience in the field of project management, working on projects on almost every continent, he travels all over the world as an international project management consultant and speaker.

It was here that his love for both teaching and project management was discovered and developed. He began instructing in , has taught thousands people in classroom environments, and publicly spoken to thousands at a time.

Video production managers must identify the production tasks, plan and manage the schedule, and communicate project information to all the members of the production team. Microsoft Project is the perfect tool for managing a project such as this.

In this lesson, you will learn how to navigate in Microsoft Project , how the software handles data, how to create a new project schedule, enter tasks, durations, and milestones into the schedule, and organize the tasks in the schedule.

Your screen may be different if default settings have been changed or if other preferences have been set. Later, you will set the option directing the software to go directly to the Gantt Chart view. Figure Microsoft Project Start screen Before you begin using Microsoft Project , you will need to become familiar with the user interface, also known as the Ribbon.

This is similar to other Office applications in that the commands are in tabs, such as File, Task, Resource, Report, Project, and View. Selecting a tab activates the ribbon. Within each ribbon, commands are organized into groups; each command has its own button, which you activate by clicking with the mouse.

Project\’s user interface makes it easy to find the commands you need more quickly. This view displays various task data as well as a graphical display of how the project is currently scheduled.

Project Basics 3 The Gantt Chart view is the primary way of viewing the data in a project schedule. It became the standard for visualizing project schedules in the early twentieth century when American engineer and management consultant Henry L.

Gantt developed a bar chart with two main principles; 1 to measure activities by the amount of time needed to complete them; and 2 to represent the amount of the activity that should have been done in a given time. In Microsoft Project, the Gantt Chart view is the default view. A view is a window through which you can see various elements of your project schedule.

You will learn more about the Gantt Chart view in Lesson 8. A project schedule is a model of a real project — what you want to happen or what you think will happen throughout the project. The schedule contains all of the tasks, resources, time frames, and costs that might be associated with such a project. You can modify this schedule or any other project template to fit your specific project needs. Later in this lesson you will learn how to create a project schedule from a blank template.

A template is a predefined file that can be blank with the default characteristics set, or it could already contain project task and resource information. Knowing how to navigate in Microsoft Project and how Microsoft Project handles data will increase your efficiency in locating needed information. In this exercise, you learn how to start Microsoft Project and open a template.

Before you begin these steps, be sure to turn on or log on to your computer. On the Windows taskbar, click the Start button. The Start screen appears. Microsoft Project opens. This is the start screen.

From this screen you can choose to open a blank project, import information from Microsoft Excel or a SharePoint task list, open an existing project file, or open a template. Additionally there are some slight visual variations between the two operating systems. You are encouraged to use this manual with either operating system and understand that the differences are cosmetic only and in no way affect the functionality of Microsoft Project Microsoft Project should be open.

On the Start screen Figure , click the Search for online templates box located at the top of the screen. Type annual report preparation, then press Enter. The template is displayed and a preview of it is on the left of the screen as in Figure Figure Preview of the Annual Report Preparation template 2. Double-click the Annual Report Preparation template graphic. The template is downloaded to your system, then opens a new project based on the template in the Gantt Chart view and closes the New Project screen.

However, it is recommended that they are stored in the default Microsoft templates folder. Project Basics 5 You have just opened a project schedule from a template in Microsoft Project. A project schedule is a model of a real project — what you want to happen or what you think will happen. The schedule contains tasks, resources, time frames, and costs that might be associated with such a project.

Later in this lesson, you will learn how to create a project schedule from a blank template. This is located in the upper right corner of the screen, just to the left of the close application button. See Figure Using the resizing feature, change the width of the reduced window and watch how the ribbon changes with the changing width. Figure shows an example of the ribbon at a reduced level of resolution.

Figure Command Groups show less buttons The Ribbon at a reduced level of resolution Commands are accessed when button is selected 3. This will set the window back to full screen. Note the automatic change in the ribbon as shown in Figure In this exercise, you changed the resolution of the Project window and the software automatically changed the resolution of the ribbon command groups.

This is where the user will change options, save, print, import and export, set file properties, and much more. USE the project schedule you created in the previous exercise. Click the File tab. On the left navigation bar click New. This screen is similar to the Start screen that appeared when you first started the software.

From this screen you can open an existing schedule, start a new project from a blank template, or import from Excel or SharePoint. Click Print in the left navigation bar. This section provides a print preview, allows the user to change printers and the print settings, as well as setting the page options such as headers, footers, and margins.

Click Share in the left navigation bar. Here the user can send the project file as an email attachment or sync it with SharePoint. Click Export in the left navigation bar. In this exercise, you reviewed some sections of the Backstage Area.

Throughout this text, you will return to this area to check and change options. More correctly, it is three databases in one, as shown in Figure The first is a task database. This is where all task-related information such as the task name, start, finish, cost, duration, and work is kept.

The second is the resource database. All resource-related information is stored in the resource database, such as resource name, type of resource, standard rate pay rate , resource group they belong to, the base calendar they are assigned, and the maximum number of units for the resource.

The third database is called the assignment database. When a resource is assigned to a task, all of the assignment-related information for each specific resource on each specific task is stored here. Your screen should be on the Gantt Chart view. Place your mouse cursor on the Task Name column heading, but do not click it. You will notice that a ScreenTip appears, displaying the title of the column Task Name and its actual name Name.

Place the mouse cursor on the Resource Name column heading and observe the ScreenTip that appears as in Figure You will notice that this field has the same name as the one in Figure You have just witnessed two of the databases. On the ribbon, click the Task Usage button, located in the Task Views command group. This is one of two views that displays information from the assignment database. Note the Task Usage button is a two-part button, with a submenu on the bottom half.

Select the name cell of task 1, Perform Initial Planning. This is the Scroll to Task feature which will be discussed later. Figure Task Usage View Task Resource Planned work hours by resource Table shows the default view and the databases from which they collect information. Knowing which database has the information will help later in knowing not only which view to activate but will also assist in developing custom reports.

In this exercise, you viewed some of basic views in the software and the database that held the information. In the next exercise, you will become familiar with more views. When you want to look at data from any one of the databases, you must activate a view. In this exercise, you will learn about some of the common, default views and how to activate them. On the View tab, select the Calendar view from the Task View command group.

Figure Calendar View 10 Lesson 1 2. The Calendar view provides task data in a calendar format. It is helpful when you need to get project information to those project team members who may not have, or know how to operate, Microsoft Project.

On the View tab, select the Network Diagram view. Figure Network Diagram view 4. The network diagram view displays the logical sequencing of the tasks and the relationship these tasks have with other tasks in the project. It is helpful during planning and execution and can show the complexity of a project. On the View tab, select the Resource Usage view. Click the Resource Name column once to highlight the entire column. On the ribbon, in the Data command group, click the Outline button then select Hide Subtasks.

Auto fit the Resource Name column. You do this by placing your cursor on the right side of the column name and double-clicking. Click the Expand button at the left of resource 1, Audit Committee. Your screen should look like Figure In other words, it is helpful to see the assignments each resource has been assigned.

This is opposite from the Task Usage view you selected earlier, which categorized assignments by task. CLOSE the file. When asked to save the file, click No.

In this exercise, you viewed three additional, commonly used views in the software. Now that you are familiar with how to navigate in the program, you will now create your own project schedule. You should perform all the planning processes associated with the project management methodology of your organization before entering any information into Microsoft Project When you create a new project schedule, the first task is to set a start date for your project.

Opening a New Blank Project Schedule Rather than use a project schedule template, you can create a new, blank project schedule that you can fine-tune to your specific project.

In this exercise, you open a new project schedule. On the Start screen, click New. On the screen, double-click the Blank Project option.

A new blank project schedule appears and you are briefly notified that new tasks will be created in the new Manually Scheduled Mode, which is discussed in lesson 2.

Your screen will look like Figure LEAVE the project schedule open to use in the next exercise. In this exercise, you created a new, blank project schedule. Now you will begin to add details to the project schedule, such as start date, tasks, durations, and calendars. This information should be entered in the sequence presented. When using Microsoft Project the user must perform data entry steps in a specific order. Entering information out of sequence could result in inaccurate information or re-entry of the data.

For example, if you enter duration information before setting the calendar options, the durations entered will be altered when calendar options are set. In this exercise, you create a start date for the new project you have created.

USE the project schedule you opened in the previous exercise. In the Properties group click the Project Information button. The Project Information dialog box appears. Single-click the drop-down arrow next to the Start Date text box once. For this exercise, you will change the project start date to January 4, Project Basics 13 3.

In the January calendar, click January 4th. Click OK at the bottom of the dialog box. In this exercise, you specified a start date for your project. You can schedule a project from either the start date or the end date, but not both.

Most projects should be scheduled from a start date. Scheduling from a start date causes all tasks to start as soon as possible, and it gives you the greatest scheduling flexibility.

Scheduling from a finish date can be helpful in determining when a project must start if the finish date is fixed. Saving the Newly Created Project Schedule Once you have created a new project schedule and specified the start date, you need to save the file.

On the ribbon, click the File tab and then click the Save option. Because you have not previously saved the project schedule, the Save-As section is activated. In the Save As section, click Computer then select Browse. Locate and select the solutions folder for this lesson as directed by your instructor.

Click Save. Leave the project schedule open to use in the next exercise. In this exercise, you named and saved your project file. It is important to get into the habit of saving your file frequently so that minimal information is lost should you experience a software or hardware malfunction.

Under the File tab, click Options in the navigation bar, then select Save. In the Save Options dialog box, under Save Projects, select the Auto Save Every check box and then specify the time interval at which you want Microsoft Project to automatically save your file.

You can set your project calendar to reflect the working days and hours of your project, as well as nonworking times such as evenings, weekends, and holidays.

Defining Project Calendars In this exercise, you define the calendar for your project and set up two exception days holidays. On the ribbon, in the Properties command group, select the Change Working Time button.

The Change Working Time dialog box is displayed. Click the For Calendar drop-down arrow. In the dropdown menu, select Standard, if it is not already selected. Using the scroll control at the right of the calendar, navigate until the calendar displays January, Click the date box for January Day and press Enter. Single-click the name of the exception you just entered. Then click the Details button. The Details dialog box appears. Under Recurrence Pattern, click Yearly. Click the The: button, and use the arrows next to each selection box to select Third, Monday, and January.

In the Range of Recurrence section, select the option for End after: then type 3, then press Enter. Scroll until calendar in the Change Working Time dialog box displays May, Click once on May 30, In the next blank exception name cell, type Memorial Day and press Enter.

The Details dialog box reappears. Click the The: button, and use the arrows next to each selection box to select Last, Monday, and May. In the Range of Recurrence section, select the option for End after: then type 3. SAVE the project schedule. Exceptions can also be used to indicate additional time away from the project, such as company-wide training days or morale events.

A calendar is a scheduling tool that determines the standard working time and nonworking time such as evening or holidays for the project, resources, and tasks. Calendars are used to determine how tasks and resources assigned to these tasks are scheduled. It can serve as a project calendar or a task calendar. It defines the normal working and nonworking times. A task calendar defines working and nonworking times for a task, regardless of the settings in the project calendar.

Base calendars can be created and assigned to a project, a resource, or a task. Project, resource, and task calendars are used in scheduling tasks. If resources are assigned to tasks, the task is scheduled based upon the resource calendar. Cross Ref You will learn more about base calendars, project calendars, and resource calendars in Lesson 2. In Microsoft Project, the tasks you define contain the details about each activity or event that must occur in order for your project to be completed.

These details include the order and duration of tasks, critical tasks, and resource requirements. Tasks are the most basic building blocks of any project schedule. In this exercise, you will enter a single task in each row of the Entry table. Click the first blank cell directly below the Task Name column heading. Type Review screenplay and press Enter. Enter the following task names below the Review screenplay task name.

Press Enter after each task name. Develop scene blocking and schedule Develop production layouts Identify and reserve locations Book musicians Book dancers Reserve audio recording equipment Reserve video recording equipment 4.

As you enter new tasks, you will note that each cell automatically wraps the text. The Task ID sometimes simply referred to as ID is a unique number that is assigned to each task in the project. However, you can define the duration of days, weeks, and months for your project.

Click the File tab, select Options, then click the Schedule option, and look under Calendar options for this project: See Figure Because different tasks usually take different amounts of time to complete, each task is assigned a separate duration. Do not confuse duration with elapsed time or work effort. By contrast, a task can have four work resources assigned and equate to 24 hours of effort in a single, eight hour work day. This applies to start dates and finish dates as well.

Click the first cell in the Duration column next to the task 1, Review screenplay. The Duration field for task 1 is selected. Type 3w and then press Enter. The value 3 wks appears in the Duration field. Enter the following durations for the remaining tasks.

Figure Gantt Chart showing task durations entered. You may notice that for those tasks where you entered approximate durations, the software did not draw a corresponding Gantt Chart bar. This is the result of Manual Scheduling. Later in this lesson you will change the scheduling mode to Automatic Scheduling.

Recall that when you set up your project calendar in the previous exercise, the working times for your project were Monday through Friday from A. No work is scheduled on evenings or weekends because these have been defined as nonworking times. Although the task durations are supplied for you for the exercises in this book, you and the project team will have to estimate task durations for most real-world projects.

Risk is an uncertain event or condition that, if it occurs, will have an impact on your project, either positively or negatively. Inaccurate task duration estimates negative risk decreases the likelihood of completing the project on time, within budget and to specification.

Developing good estimates is worth the time and effort. In the Manual mode which is the default , Project allows the user some flexibility in entering information. However, this mode does not allow the software to schedule tasks in a dynamic manner, meaning it requires more attention to maintain the schedule. Automatic scheduling mode reduces the f lexibility of entering approximate durations and dates.

This mode does allow the user to create a dynamic schedule which requires less maintenance. Switching from Manual to Automatic Scheduling When you entered durations earlier, you noticed how the software dealt with approximate duration information — it did not draw a Gantt bar. In this exercise you will learn how to change the scheduling mode. You can do this for an entire project or you can do it on a task-by-task basis, depending on your needs.

By default, all new tasks are set to manual scheduling. Select the Task Name for task 1, Review screenplay. Click the Task tab. CLOSE the workbook. The Home tab, shown in Figure , contains the com- mands that people use the most when creating Excel documents. Having commands visible on the work surface enables you to see at a glance most tasks you want to perform.

Each tab contains groups of commands related to specific tasks or functions. This indicates that in addition to the default task, other options are available for the task. Similarly, some of the groups have Dialog Box Launchers associated with them.

Clicking these displays additional commands not shown on the ribbon. In Figure , the Clipboard, Font, Alignment, and Number groups have associated dialog boxes or task panes, whereas Styles, Cells, and Editing do not. You can open a new, blank work- book when you launch Excel or by using the File tab to access Backstage view. You can open an existing Excel workbook, enter new or additional data, and save the file with a new name, thus creating a new workbook.

You can also use a template to create a new workbook. A template is a model that has already been set up to display certain kinds of data, such as sales reports, invoices, and so on. Creating a Workbook from Scratch To create a new workbook, launch Excel and select a blank workbook or another type of template.

If you are working in Excel and want to begin a new workbook, click the File tab, click New, and then click Blank workbook. Worksheets often include text that describes the content of the work- sheet. In this exercise, you create two Excel workbooks: one with a company address and one with a quick phone message.

Excel gives you options for starting a blank workbook, taking a tour, or using templates see Figure Figure Available options after Excel is launched 1. If you have just launched Excel, Book1 — Excel appears in the title bar at the top of the window. A blank workbook opens with A1 as the active cell. In cell A1, type Fabrikam Inc. This entry is the primary title for the worksheet.

Note that as you type, the text appears in the cell and in the formula bar see Figure Formula bar Active cell 3. Press Enter. The text is entered into cell A1, but appears as if it flows into cell B1.

In cell A2, type Fourth Street and then press Enter. Sometimes you need a quick work area to complete another task while you are in the middle of a workbook. You can open another workbook as a scratch area. Click the File tab, and in the left pane, click New. The different templates available appear refer to Figure In the Backstage view, click Blank workbook. A second Excel workbook opens and Book2 appears in the title bar.

In cell A1, type Phone Calls and then press Enter. Click the File tab to open Backstage view. In the left pane, click Close to close the Phone Calls workbook. You must first identify where the doc- ument is to be saved. The remainder of the Save process is the same, regardless of the location or storage device. Naming and Saving a Workbook When you save a file for the first time, you are asked two important questions: Where do you want to save the file? What name will you give to the file?

In this lesson, you practice answering these questions for two different files. By default in all Office applications, documents are saved to the Documents folder or to your OneDrive, depending on settings specified during the program installation. USE the workbook from the previous exercise.

In the left pane, click Save As to display the save options. Figure Save As dialog box 3. In the navigation pane on the left, in the Save As dialog box, click Desktop.

The Desktop becomes the new destination of your saved file. In the Save As dialog box, click New folder. A folder icon appears with the words New folder selected. Type Excel Lesson 2 and then press Enter. Click the Open button. In the File name box, type 02 Fabrikam Address Solution. Click the Save button. LEAVE the workbook open to use in the next exercise. Take Note Save your workbook often and especially before opening another workbook, printing, or after you enter information.

Saving to Your OneDrive OneDrive is a cloud-based application that allows you to store and sync your files so you can re- trieve them anywhere and share them with other people if desired. OneDrive is also a great place to store backup files of important documents.

OneDrive comes with recent versions of Windows and Microsoft Office. A free desktop app is also available for mobile devices. This exercise assumes you already have access to OneDrive. Click the File tab and then click Save As.

In the Backstage view, under Save As, click your OneDrive account, and then click a folder location in the right pane. Click the New folder button in the Save As dialog box. In the New folder text box, type Excel Lesson 2 to save a folder for this lesson on your OneDrive and then press Enter. Double-click the Excel Lesson 2 icon to move to that folder. Keep the file with the same name or type 02 Fabrikam Address Solution in the File name box , and then click the Save button.

Saving a Workbook Under a Different Name You can rename an existing workbook to create a new workbook. For example, when you have multiple offices, you can save a file with a new name and use it to enter data for another office.

You can also use an existing workbook as a template to create new workbooks. In this exercise, you learn how to use the Save As dialog box to implement either of these options.

Click the File tab, and in the left pane, click Save As. The Backstage view shows that the Current Folder in the right pane is Excel Lesson 2 on your OneDrive, because it was the folder that was last used to save a workbook. Working with Microsoft Excel 17 4. Click This PC to return to the drive you used before. In the right pane, click Excel Lesson 2. Click Save. You created a new workbook by saving an existing workbook with a new name.

Click the File tab, click Save As in the left pane, and then click Browse. In the Save as type box, click the drop-down arrow and then choose Excel Template. Take Note Templates are automatically saved in another location so they can be opened with the File, New option. Creating a template to use for each new workbook based on the example file eliminates the possi- bility that you might lose data because you might overwrite a file after you enter new data.

When you exit, you are prompted to save the file with a new name. However, if some of your users do not have the latest version or use other applications, they might not be able to open your file. You can save a copy of an Excel workbook with the. The program symbol displayed with the filenames is different, but it is a good idea to give the earlier edition file a different name.

At the bottom of the left pane, click Open Other Workbooks. In the list of recent files in the right pane, click 02 Fabrikam Broad Address Solution. First check for compatibility issues. Read the information in the Compatibility Checker dialog box and then click OK.

The Backstage view shows the different file types see Figure Figure Change File Type options in Backstage view 6. Click Excel Workbook and then click Save As. In the File name box, click before Solution, type , and then click Save. Click the File tab and then click Open. The right pane in Backstage view shows the last set of documents that have been saved. Click 02 Fabrikam Broad Address Solution.

The file formats that are listed as options in the Save As dialog box or on the Export tab depend on what type of file format the application supports.

When you save a file in another file format, some of the formatting, data, and features might be lost. USE the 02 Fabrikam Broad Address Solution workbook from the previous exercise or type your name and address in a new workbook. Click the File tab, and then click the Export button. Click the Change File Type button. Excel explains the different file types refer to Figure Figure shows the reasons for using this format.

In the left navigation pane, click Desktop. Double-click Excel Lesson 2 to move to that folder. Click Publish. Take Note Adobe PDF Portable Documents Format ensures that your printed or viewed file retains the formatting that you intended, but the file cannot be easily changed.

All of these options are available from the Save as type drop-down list or the Export tab. You can also copy and paste information from another worksheet or from other programs. Copy takes the information from one location and duplicates it. You use Paste to put this information into another location.

To enter data in a cell in a worksheet, you must make the desired cell active and then type the data. To move to the next column after text is entered, press Tab. Continue to press Tab to go to the next column. Entering Basic Data in a Worksheet When you finish typing the entries in a row, press Enter to move to the beginning of the next row. You can also use the arrow keys to move to an adjacent cell or click on any cell to make that cell active.

Press Enter to accept the entry and move down one row. In the following exercise, you create a list of people working in the office. Click cell A1, type Fabrikam Inc.

Notice that the active cell moves to the next row, to cell A2. In cell A2, type Employee List and then press Enter. Click cell A4, type Name, and then press Tab. Notice that the active cell moves to the next column, to cell B4. Troubleshooting If you type the wrong data, you can click the cell and retype the entry. In the following sec- tions, you see how to edit text. Type Extension and then press Enter. Notice that the active cell moves to the first cell in the next row.

Type Richard Carey and then press Tab. Type and then press Enter. Click cell A5 and notice that the complete entry for Richard Carey appears in the formula bar. Click cell A6, type David Ortiz, and then press Enter. Type Kim Akers and then press Enter. Type Nicole Caron and then press Enter.

Your file should look like Figure LEAVE the workbook open for the next lesson. Take Note Text is stored in only one cell, even when it appears to extend into adjacent cells. If an entry is longer than the cell width and the next cell contains data, the entry appears in truncated form. To edit the data, you need to go to the cell where the text starts and not to the adjacent cells.

Changing the Column Width In Excel, column width is established based on the existing data. Use the 02 Fabrikam Employees Solution file from the previous exercise. Move the mouse pointer between columns A and B, to the column markers at the top of the worksheet see Figure The mouse pointer changes to a double-headed arrow.

Double-click the column marker between A and B. The width of the column changes to the widest entry in column A. Take Note To change the column width manually, point to the column marker between columns A and B and drag the pointer left or right instead of double-clicking. Drag the double-headed arrow mouse pointer between columns B and C until the ScreenTip shows Width: 20 pixels or something close to this amount see Figure , and then release the mouse button.

Figure When you drag the dou- ble-headed arrow pointer, the ScreenTip shows the column width. This overwrites your previous version without the column width change. However, when you type in the next cell, the overflow text does not display. The text is still there.

It is often easier to proof your work if you have the column widths match the longest text entries. You can double-click on the column markers to automatically adjust to the widest entry or drag the column marker to adjust the column width to your desired width. To edit information in a worksheet, you can make changes directly in the cell or edit the contents of a cell in the formula bar, located between the ribbon and the worksheet.

When you enter data in a cell, the text or numbers appear in the cell and in the formula bar. You can also enter data directly in the formula bar.

Selecting text means that you highlight the text that is to be changed. You can also double-click in a cell to position the insertion point for editing. OPEN a blank workbook. Click cell A1, type Fabrikam, and then press Enter. The insertion point moves to cell A2 and nothing appears in the formula bar.

Click cell A1. Notice that the formula bar displays Fabrikam see Figure Figure Active cell and formu- la bar displaying the Formula bar same information Active cell 3. Click after Fabrikam in the formula bar, type a space, type Incorporated, and then press Tab. The insertion point moves to cell B1 and nothing appears in the formula bar see Figure Figure Although it looks like text is in B1, it is actually extended text from A1.

Nothing shows in the formula bar. Click cell A1 and in the formula bar, double-click on Incorporated to select it. Type Inc. Type Sales and then press Enter. Click cell A2 and then click after Sales in the formula bar. Press Home. The insertion point moves to the beginning of the formula bar. Working with Microsoft Excel 23 Take Note While you are editing in the formula bar, you can press Home to move to the beginning, End to move to the end, or the left or right arrow keys to move one character at a time.

Press Delete to delete characters after the insertion point. Press Backspace to delete characters before the insertion point. Type Monthly and then press the spacebar. In cell A3, type January and then press Enter. Click cell A3, type February, and then press Enter. Click cell A3 and then press Delete.

The entry in A3 is removed. Above row 1 and to the left of column A, click the Select All button. All cells on the worksheet are selected. Press Delete. All entries are removed. The previous entry will be restored. You can edit a cell by double-clicking the cell and then typing the replacement text in the cell. Or, you can click the cell and then click in the formula bar. Use the Home key on your keyboard to move the insertion point to the beginning of the cell, and use the End key to move the insertion point to the end of the cell.

You can add new characters at the location of the insertion point. To select multiple characters while in Edit mode, press Shift while you press the arrow keys. You also can use the mouse to select characters while you are editing a cell. Just click and drag the mouse pointer over the characters that you want to select.

This deletes what is in the cell rather than the cell itself. To erase the contents of more than one cell, select all the cells that you want to erase and on your keyboard, press Delete. In cell A1, type 1 and then press Enter. Type 2 and then press Enter. Type 3 and then press Enter.

Type 4 and then press Enter. Highlight cells A1 through A4 containing the numbers 1 through 4. All the cells are erased. On the Quick Access Toolbar, click the Undo button to restore the cell entries. The value and format are placed into the cell. Click cell B5 and then press Delete.

Type without the dollar sign and comma and then press Enter. Although the original entry is gone, the cell retains the previous format when you press Delete. Click cell B5 and on the Home tab, in the Editing group, click Clear. Click Clear Formats. Cell B5 displays without the dollar sign and comma. Take Note Clear displays a number of options. To remove both the entry and the format, choose Clear All.

You have already en- tered basic text and numeric data in this lesson. In the following exercises, you enter dates, use Auto Fill to complete data in a series, and use the Flash Fill feature to speed data entry down a column. The strength of Ex- cel is its capability to calculate and analyze numbers based on the numeric values you enter. Of course, if you enter the wrong numbers, you get the wrong calculations.

For that reason, accurate data entry is crucial. Entering Dates Dates are often used in worksheets to track data over a specified period of time. Like text, dates can be used as row and column headings. However, dates are considered serial numbers, which means that they are sequential and can be added, subtracted, and used in calculations. Dates can also be used in formulas and in developing graphs and charts.

The way a date is initially displayed in a worksheet cell depends on the format in which you type the characters. In Excel , the de- fault date format uses four digits for the year.

Also by default, dates are right-justified in the cells. Working with Microsoft Excel 25 4. If the year displayed in the formula bar is not , click cell B7 and then press F2.

Change the year to and then press Enter. In cell B9, type January 21, and then press Enter. If you enter a date in a different format than specified or had already entered something in the cell and deleted it, your worksheet might not reflect the results described.

The date formats in column B are not consistent see Figure You apply a consistent date format in the next section. Notice that the value changes but the formatting remains the same. Click the Undo button to return to the workbook shown in Figure Excel interprets two-digit years from 00 to 29 as the years to ; two-digit years from 30 to 99 are interpreted as to If you type January 28, , the date will display as Jan In the next section, you learn to apply a consistent format to a series of dates.

Take Note When you enter a date into a cell in a particular format, the cell is automatically formatted even if you delete the entry. Subsequent numbers entered in that cell will be converted to the date format of the original entry. To populate a new cell with data that exists in an adjacent cell, use the Auto Fill feature either through the command or the fill handle. The fill handle is a small green square in the lower-right corner of a selected cell or range of cells.

A range is a group of adjacent cells that you select to perform operations on all of the selected cells. When you refer to a range of cells, the first cell and last cell are separated by a colon for example, C4:H4. Click and drag the fill handle from cells that contain data to the cells you want to fill with that data, or have Excel automatically continue a series of numbers, numbers and text combinations, dates, or time periods, based on an established pattern.

In this exercise, you use the Auto Fill command and fill handle to populate cells with data. USE the workbook from the previous exercise or type the text in Figure Select the range C4:H4.

January is in the first cell. On the Home tab, in the Editing group, click the Fill button. The Fill menu appears see Figure Figure Fill drop-down menu Fill button Fill options 3. From the menu, click Right. Zack Blog. Table of Contents.

Share this: Twitter Facebook. Increasing The Relevance of Academic Education. Academic Medicine Vs Private Practice. What Is An Academic Appointment. Ucf Academic Calendar. CustomGuide Interactive Learning offers a Project Training Course that includes interactive tutorials, training manuals, quick references, and skills assessments. It is geared towards all levels of experience and covers fundamentals, as well as different project views, tasks, resources, and reports.

CustomGuide offers two price tiers. For individuals, once purchased, they have one year of access to the course and its materials. It involves various interactive assignments and quizzes to check your knowledge as you learn.

The course is composed of course hours that take six months to complete. The GoSkills Microsoft Project Fundamentals tutorial is an online, self-paced course for beginners or those who want a refresher on the fundamentals of MS Project.

Participants will learn how to use the different views and tables, create schedules and tasks, manage budget and resources, analyze and track progress, and more.

After completing the 44 lessons, which take approximately 19 hours, students receive a certificate to show their solid foundational knowledge of Microsoft Project.

The training is self-paced, so the price depends on the length of time the user wants access to the course. The course is free with a seven-day trial. Group pricing is available as well. LinkedIn Learning provides a range of online courses where users can choose from 14 courses, three authors, three skill levels, and four versions of MS Project. Tutorials can be as short as under two hours, or more than five hours for advanced courses. The tutorials can be general training on the essentials, or as specific as using Microsoft Project for agile project management or managing subcontractor projects.

Unless your workplace uses a legacy version, a good course to start with is Microsoft Project and Project Online Desktop Essential Training.

The course takes nine hours and includes over four hours of videos that are composed of more than 50 lectures.


Microsoft official academic course microsoft project 2016 pdf free. Microsoft Official Academic Course MICROSOFT EXCEL 2016

Welcome! This Step by Step book has been designed so you can read it from the beginning to learn about Microsoft Project and then build your skills as. Microsoft Official Academic Course textbooks are “Official” in still one more way—they are the dance of projects, exercises, cases, and assessments. Educators and students are the center of the Microsoft IT Academy Program. Microsoft Official Academic Course (MOAC) textbooks (fees apply).

Leave a Comment

Your email address will not be published.