[Ms project 2016 – microsoft official academic course free

Demonstrate organizing tasks. Demonstrate working with task duration, constraints, and deadlines. Describe dependencies.

Summarize resource management. Identify tracking work in project. Summarize communication and progress updates. Describe using baselines. Describe customizing and formatting your project. Describe running reports. Describe consolidating projects and resources. Summarize printing project information.

Additional Course Information. Course Title: Microsoft Project Category: UniversalClass. CEU Value: 0. 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?

Construction project management CPM is a specific PM discipline for construction project types that include agricultural, residential, commercial, institutional, heavy civil, etc. February 22, Share this article Facebook Twitter LinkedIn. Share Article. 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.

You can add a new ribbon tab, add a group on any ribbon tab, and add commands within a group. A group of commands on the default ribbon tabs are related in functionality. For example, on the Home tab, the Font group allows you to change the font, font size, add bold, italic, or underline, or change the color of the cell or font.

The Excel Options dialog box also offers selections for customizing the ribbon. You can add and remove commands, and you can change the location of ribbon commands to make accessing those you use most frequently more convenient. In this exercise, you use the commands in the Excel Options dialog box to create a new tab and command group to contain your frequently used com- mands. Then you will reset the customizations to return to the default ribbon.

Click the Options tab. In the Excel Options dialog box, click Customize Ribbon. The Customize the Ribbon options appear. By default, Popular Commands is selected in the Choose commands from drop-down box. The list of Popular Commands appears in the list below the drop- down box. In the list of Popular Commands, click Format Painter.

Note the Add button in the center of the dialog box is now active. You can use this method to display the current groups available on a ribbon tab. Under the Customize the Ribbon options, click the New Tab button shown in Figure to insert a new blank tab into the Customize the Ribbon list.

When you click New Tab, a New Group is automatically created inside the new tab. Click the New Tab Custom list item on the right to select it, and then click the Rename button. Under your new tab, click New Group Custom to select it.

Click the Rename button again. This time, the Rename dialog box allows you to select a symbol see Figure Select the hand symbol. You see the New Group renamed. In the command list on the left, click on a command of your choice, and then click the Add button.

The command appears on your new ribbon tab. In the Choose commands from list, select All Commands and then add another command from this list. In the Choose commands from list, select File Tab and then add another command. Your screen should look similar to Figure Click OK to close the Excel Options dialog box. When you exit, you see your tab named My New Tab on the ribbon. Click the My New Tab tab. Right-click anywhere in the ribbon and then click Customize the Ribbon. Near the lower-right corner of the Excel Options dialog box, click the Reset button and then click Reset all customizations.

This exercise familiarizes you with where the templates are located and how to select and use them. Selecting a Template from the New Tab Templates allow you to create professional workbooks in a fraction of the time it would take you to develop them from scratch. Examples of these are budgets, loan models, invoices, calendars, and so on. Click the File tab and then click New. The New window displays a series of featured templates.

You already used the Blank workbook template in this book. Scroll down if necessary and then click the Project Tracker icon. Click the Create button. Notice that there are two worksheets in this workbook: Project Tracker with the sample data you can change and Setup that allows you to input a list of categories and employees.

When you are finished looking at this template, click File and then click Close. If prompted, do not save changes. Look for and click the Academic calendar any year template and click the Create button. Click on the year and use the up or down arrow to change to the current year if necessary. Click the month name and select the current month name from the drop- down list. Scroll down the worksheet to see additional months displayed in the template.

Notice that the Academic calendar any year template appears as the third item on your list of templates because it was recently used. Click in the Search for online templates box at the top of the window. Type Budget and then press Enter. Notice that Excel displays a downloaded list of templates as well as a Category list on the right so you can narrow the choices see Figure Take Note You can modify the calendar workbook with your name, company name, and favorite pictures to personalize your calendar and make it your own or use as a gift for others.

Which of the following is where you can save, select a template, change document properties, and close or exit Excel? Backstage b. Print c.

Edit d. Windows 2. To change printer, layout, or margin settings, you click the File tab and use which of the following options? Info b. Options c. Print d. Open 3. Which of the following can be customized for quicker access to your most commonly used commands? The course takes nine hours and includes over four hours of videos that are composed of more than 50 lectures. At the end of each module, users can quiz themselves. The course also comes with downloadable handouts and other materials.

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.

Tags: faq Microsoft Project. When she\’s not writing about technology trends, she\’s working out or spending time with family.

[The Best Microsoft Project Tutorials — Training & Courses

 
A range is a group of adjacent cells that you select to perform operations on all of the selected cells. This overwrites your previous version without the column width change. Student Testimonials. The right pane in Backstage view shows the last set of documents that have been saved. Though these tutorials are self-paced, learners have six months to complete each one. A 60 day free trial for Project is available on the Microsoft website. An absolute cell reference refers to a specific cell or range of ms project 2016 – microsoft official academic course free regardless of where the formula is located нажмите чтобы перейти the worksheet.

Ms project 2016 – microsoft official academic course free

Microsoft Project is a project management software program created for businesses and freelance professionals to help better manage individual projects that occur within companies. Although no project management software should be used to replace project 216 techniques or adequate training of management and staff, Project can and will improve the efficiency, organization, and sometimes even the speed of which a project is completed.

This projecy will teach you how to successfully use MS Projectno matter if prohect ever used the program before or not. Both the beginner and seasoned Project user can benefit from this course, coursf with the basics of the program including navigation and continuing on to more advanced features.

You do not need to have access to Project to take or successfully complete this course. However, it is recommended. A 60 day free trial for Project is available on the Microsoft website.

Open Main Menu. Browse Courses My Classes. Sign In Subscribe Course Catalog. Online Class: Microsoft Project This course will teach you how to successfully use MS Projectno matter if you\’ve ever used the program before or not. Both the beginner and seasoned Project user can benefit from this course. Students have taken this course. Course Description. Courses Frequently Bought Together:. Lesson 1: Introduction to MS Project When you open Project for the first time, you have a few choices in how you want to get started.

Although the purpose of this course is to teach you how to use ProjectProject can only manage the information about the project that you give it. Being детальнее на этой странице to enter tasks is critical, acadejic only to your project, but to being able to use Project successfully.

Offickal Projectthe calendar shows the various hours in a workday, the days ms project 2016 – microsoft official academic course free a work week, holidays, and nonworking aacdemic on which a project schedule is based. Taking the time to organize your tasks will make managing them easier – and improve the efficiency of your team while working on the project. Additional lesson topics: Create and work with subtasks and summary tasks; Project management goal: Create a new project schedule 11 Total Points Lesson 7 Video Complete: Assignment 7 Assessment: Exam 7.

Whenever you create a task, you have to set the duration for the task, or how long it will take to complete. A dependency in Project is prjoect as a timing ms project 2016 – microsoft official academic course free between two tasks in a project – or tasks that are a predecessor-successor pair. In this lesson, we are going to learn about resources in Project and how to apply them to your project.

The key to successful projects and excellent project management is finding the right resources. When you want to track the progress being made on a project, you must enter different kinds of information. It is important that you map out what information you need to track as the project commences and advances. By definition, a baseline is the detailed project against which actual work is tracked.

In this lesson, we are going to show you how ms project 2016 – microsoft official academic course free format elements of the Project screen, as well as teach you to create customized templates.

Reports show how costs are accumulating, what tasks are in progress, and which ones still need to start. Now that we\’ve learned how to rfee Project to create and manage projects, we are going to talk about pooling resources, consolidating project plans, and assignments so that they microsot be мне the collectors book of dolls clothes coleman free download интересно with other projects.

In this lesson, we are going to teach you how to print in Project. Describe what MS Project is acadeimc what its capabilities are. Define and micorsoft projects. Describe entering and scheduling tasks. Describe Project views. Demonstrate organizing tasks. Demonstrate working with task duration, constraints, and deadlines. Officiall dependencies. Summarize resource management. Identify tracking work in project. Summarize communication and progress updates. Describe using baselines.

Describe customizing and formatting your project. Describe running reports. Describe consolidating projects and resources. Summarize printing project information. Additional Course Information. Course Title: Microsoft Project ms project 2016 – microsoft official academic course free Category: UniversalClass. CEU Value: 0. Instructor: UniversalClass Instructional Team. Choose Your Subscription Plan.

Add to Cart. Platinum Yearly. Start Now. Student Testimonials. Follow Us Online. Our site uses cookies for general ofifcial, security, customization, and to assist in marketing efforts in accordance with our cookie and privacy policy. Accept Cookies Review Settings.