Microsoft Project
Microsoft Project 2013 screenshot, showing a blank project
Developer(s)Microsoft
Initial release1984; 35 years ago
Stable release(s)
Office 3651906 (16.0.11727.20230) / June 27, 2019; 7 days ago[1]
One-time purchase2019 (16.0) / September 24, 2018; 9 months ago[2]
PlatformMicrosoft Windows
TypeProject management software
Websiteoffice.microsoft.com/project/
Microsoft Project is a project management software product, developed and sold by Microsoft. It is designed to assist a project manager in developing a schedule, assigning resources to tasks, tracking progress, managing the budget, and analyzing workloads.
Microsoft Project was the company's third Microsoft Windows-based application. Within a few years after its launch, it became the dominant PC-based project management software.[3]
It is part of the Microsoft Office family but has never been included in any of the Office suites. It is available currently in two editions, Standard and Professional. Microsoft Project's proprietary file format is .mpp.
Microsoft Project and Microsoft Project Server are the cornerstones of the Microsoft Officeenterprise project management (EPM) product.
  • 2Features

History[edit]

Microsoft Project 2000
'Project' was an MS-DOS software application originally written in Microsoft 'C' (and some assembly) language for the IBM PC. The idea originated from the vision of Ron Bredehoeft, a former IBM S/E and PC-enthusiast in the early 1980s, to express the recipe and all preparation for a breakfast of eggs Benedict in project management terms. Mr. Bredehoeft formed Microsoft Application Services (MAS) during the birth of the application and the company later entered an OEM agreement with Microsoft Corporation. Alan M. Boyd, Microsoft's Manager of Product Development, introduced the application as an internal tool to help manage the huge number of software projects that were in development at any time inside the company. Boyd wrote the specification and engaged a local Seattle company to develop the prototype.
The first commercial version of Project was released for DOS in 1984. Microsoft bought all rights to the software in 1985 and released version 2. Version 3 for DOS was released in 1986. Version 4 for DOS was the final DOS version, released in 1986. The first Windows version was released in 1990, and was labelled version 1 for Windows.
In 1991 a Macintosh version was released. Development continued until Microsoft Project 4.0 for Mac in 1993. Microsoft Project 4 for the Mac included both 68k and PowerMac versions, Visual Basic for Applications and integration with Microsoft office 4.2 for the Mac. In 1994, Microsoft stopped development of most of its Mac applications and did not offer a new version of Office until 1998, after the creation of the new Microsoft Macintosh Business Unit the year prior. The Mac Business Unit never released an updated version of Project, and the last version does not run natively on Mac OS X.
Microsoft Project 1.0 was the only version to support Windows 2.x. It came bundled with Windows 2.x runtime but was fully compatible with Windows 3.0, especially Standard and Enhanced modes. The setup program runs in DOS, like the most Windows-based applications at the time.
Microsoft Project 3.0 introduced macro support, toolbars and Planning Wizards and was the last to support Windows 3.0. The setup program now runs in Windows, and it is based on Microsoft's own setup program, which was also used by e.g. Microsoft Visual Basic 2.0/3.0, Works 2.0, Access 1.x
Microsoft Project 4.0 was the first to use common Office menus, right-click context menus, Acme setup program and the last to support Windows 3.1x, Windows NT 3.1 and 3.5. It was the last 16-bit version. Additionally it was the first version to use VBA macro language and introduced screen tooltips, Cue Cards, GanttChartWizard, Calendar view, Assign Resources dialog, recurring tasks, workgroup abilities, Drawing toolbar, Microsoft Project Exchange file format support and ability to create reports. This version allowed user to consolidate up to 80 projects.
Microsoft Project 95 (4.1) was the first 32-bit version and it was designed for Windows 95, hence the name. It introduced ODBC support, AutoCorrect, Answer Wizard, like all Office 95 applications. Updated version, called Microsoft Project 4.1a improved Windows NT support. Additionally it was the first version to be available on CD-ROM. Additionally it was the last version to open Project 3.0 files.
Microsoft Project 98 was the first to use Tahoma font in the menu bars, to contain Office Assistant, like all Office 97 applications, introduced view bar, AutoFilter, task splitting, Assignment Information dialog, resource availability dates, project status date, user-entered actual costs, new task types, multiple critical paths, in-sheet controls, ability to rename custom fields, Web publishing features, new database format, Task Usage, Tracking Gantt and Resource Usage views, Web features, PERT analysis features, resource contouring, cost rate tables, effort-driven scheduling, cross-project linking, indicators, ability to save project files in HTML format, ability to analyze time-scaled data in Excel, improved limits for the number of tasks, resources, outline levels etc., IntelliMouse and Microsoft Office Binder support, selective data import and export, ability to save as Microsoft Excelpivot tables and allowed user to consolidate 1,000 projects. It was the last version to run on Windows NT 3.51, the last to open Project 4.0/95 files and save in .mpx (Microsoft Project Exchange) file format, the last to use Acme setup program and the last to be available on floppy disks. Project 98 SR-1 was a major service release addressing several issues in Project 98.[4]
Microsoft Project 2000 was the first to use personalized menus, Microsoft Agent-based Office Assistant and to use Windows Installer-based setup interface, like all Office 2000 applications, and introduced Microsoft Project Central (later renamed Microsoft Project Server). PERT Chart was renamed Network Diagram and was greatly improved in this version. Notable new features include ability to create personal Gantt charts, ability to apply filters in Network Diagram view, AutoSave, task calendars, ability to create projects based on templates and to specify default save path and format, graphical indicators, material resources, deadline dates, OLE DB, grouping, outline codes, estimated durations, month duration, value lists and formulas custom fields, contoured resource availability, ability to clear baseline, variable row height, in-cell editing, fill handle, ability to set fiscal year in timescale, single document interface, accessibility features, COM add-ins, pluggable language user interface, roaming user and Terminal Services support, ability to set task and project priority up to 1,000 (previously 10) and HTML help. Project 2000 was also the last version to run on Windows 95. Project 2000 SR-1 fixed several bugs.
Microsoft Project 2002 was the first to contain task panes, safe mode, smart tags, 'Type a question for help' in the top right corner, mandatory product activation, like Office XP and Windows XP and ability to open and save Microsoft Project Data Interchange (.mspdi) files. It was also the last version to run on Windows NT 4.0, 98 (SE) and ME. It was available in two editions for the first time, Standard and Professional. Office Assistant is installed but not enabled by default.
Microsoft Project 2003 was the first to contain Windows XP-style icons, like all Office 2003 applications, and the last to contain Office Assistant and to run on Windows 2000.
Microsoft Project 2007 was the last to contain the menu bar and toolbars. Office Assistant was removed entirely.
Microsoft Project 2010 was the first to contain ribbon and Backstage view, like all Office 2010 applications, and the last to open Microsoft Project 98 and .mpx files and to run on Windows XP and Vista. Additionally it was the first 64-bit version.
Microsoft Project 2013 was the first to contain Modern UI-based look, and introduced Microsoft account and OneDrive integration
Microsoft Project 2016 is the last to support Windows 7 and Windows 8(.1)
Microsoft Project 2019 runs only on Windows 10, and it contains features carried over from Office 365.
Versions for Windows were released in 1990 (v1.0), 1992 (v3.0), 1993 (v4.0), 1995 (Project 95, v4.1a), Project 98 (v8.0), Project 98 SR-1 (1999), Project 2000 (v9.0), Project 2000 SR-1 (2001), Project 2002 (v10.0), Project 2003 (v11.0), Project 2007 (v12.0), Project 2010 (v14.0), Project 2013 (v15.0) and Project 2016 (v16.0).[5] There was no Version 2 on the Windows platform; the original design spec was augmented with the addition of macro capabilities and the extra work required to support a macro language pushed the development schedule out to early 1992 (Version 3).

Features[edit]

Microsoft Project 2007 showing a simple Gantt chart
Project creates budgets based on assignment work and resource rates. As resources are assigned to tasks and assignment work estimated, the program calculates the cost, equal to the work times the rate, which rolls up to the task level and then to any summary tasks and finally to the project level. Resource definitions (people, equipment and materials) can be shared between projects using a shared resource pool. Each resource can have its own calendar, which defines what days and shifts a resource is available. Resource rates are used to calculate resource assignment costs which are rolled up and summarized at the resource level. Each resource can be assigned to multiple tasks in multiple plans and each task can be assigned multiple resources, and the application schedules task work based on the resource availability as defined in the resource calendars. All resources can be defined in label without limit. Therefore, it cannot determine how many finished products can be produced with a given amount of raw materials. This makes Microsoft Project unsuitable for solving problems of available materials constrained production. Additional software is necessary to manage a complex facility that produces physical goods.
The application creates critical path schedules, and critical chain and event chain methodology third-party add-ons also are available. Schedules can be resource leveled, and chains are visualized in a Gantt chart. Additionally, Microsoft Project can recognize different classes of users. These different classes of users can have differing access levels to projects, views, and other data. Custom objects such as calendars, views, tables, filters, and fields are stored in an enterprise global which is shared by all users.

Editions[edit]

Project is available in two editions, Standard and Professional; both editions are available either as 32 or 64bit options. The Professional edition includes all the features of the Standard version, plus more features like team collaboration tools and ability to connect to Microsoft Project Server.[6][7]

Project 2010[edit]

Microsoft Project 2010 includes the Fluent user interface known as the Ribbon.[8]
Interoperability
Microsoft Project's capabilities were extended with the introduction of Microsoft Office Project Server and Microsoft Project Web Access. Project Server stores Project data in a central SQL-based database, allowing multiple, independent projects to access a shared resource pool. Web Access allows authorized users to access a Project Server database across the Internet, and includes timesheets, graphical analysis of resource workloads, and administrative tools.
User controlled scheduling
User-controlled scheduling offers flexible choices for developing and managing projects.[9]
Timeline
The timeline view allows the user to build a basic Visio-style graphical overview of the project schedule. The view can be copied and pasted into PowerPoint, Word, or any other application.
SharePoint 2010 list synchronization
SharePoint Foundation and Project Professional project task status updates may be synchronized for team members.
Inactive tasks
helps experiment with project plans and perform what-if analysis
The Team Planner view
The new Team Planner shows resources and work over time, and helps spot problems and resolve issues.

Project 2013[edit]

What's new in Project 2013 includes new Reports section, better integration with other Microsoft products, and appearance of user interface items:[10]
Reports
A Reports section is added to the ribbon for pre-installed reports. Project 2013 includes graphical reports so that you can create graphical reports and add clipart without having to export data to another program. For example, the Burndown reports show planned work, completed work, and remaining work as lines on a graph. Project 2013 adds pre-installed ability to compare projects, do dashboards, and to export to Visual Reports.
Trace task paths
This feature allows you to highlight the link chain (or 'task path') for any task. When you click on a specific task, all of its predecessor tasks show up in one color and all of its successor tasks show up in another color.
Sharing
Project 2013 improves the sharing and communication features of its predecessors in multiple ways without leaving Project. With Lync installed, hovering over a name allows you to start an IM session, a video chat, an email, or a phone call. You can copy and paste content to any of the Microsoft Office suite. You can sync content to Sharepoint or a SkyDrive to share without going through Project and Project Online provides an online project management web app that has all of the functionality of Project 2013 and can be accessed from any web enabled device.

Project 2016[edit]

Project 2016 adds a new Reports section, backwards-compatibility with Project Server 2013, better integration with other Microsoft products, and improved appearance of user interface items:
Timeline
Allows user to customize views to have multiple timeline bars and custom date ranges in a single view.[11]
Resource Agreements
Gives features for resource planning coordination between Project Manager and Resource Manager.[12]
Office 2016 style theme and help
Uses the new Office query 'tell me what you want to do'.[13]
Backwards compatibility with Microsoft Project Server 2013
The transition of enterprises from one version to the next may be eased by this product being able to interact with the earlier version of server.[14]

See also[edit]

References[edit]

  1. ^'Release notes for Monthly Channel releases in 2019'. Microsoft Docs. Retrieved July 1, 2019.
  2. ^Tom Warren (September 24, 2018). 'Microsoft launches Office 2019 for Windows and Mac'. The Verge. Retrieved July 1, 2019.
  3. ^'Project Planning Tools - Popularity Ranking'. Project Management Zone. Retrieved August 6, 2015.
  4. ^'PRJ98: List of Fixes in Microsoft Project 98 SR-1'. News Center. Microsoft. September 18, 2011. Retrieved January 20, 2013.
  5. ^'Previous Versions of Microsoft Project'. Archived from the original on January 12, 2009. Retrieved May 6, 2006.CS1 maint: BOT: original-url status unknown (link)
  6. ^'Version Comparison (Microsoft Project Professional 2010, Microsoft Project Standard 2010)'(PDF).
  7. ^'Choose Your Microsoft Project, Learn about & compare Project versions'.
  8. ^'Steve Ballmer: Microsoft Office Project Conference 2007'. News Center. Microsoft. October 30, 2007. Retrieved January 20, 2013.
  9. ^'Microsoft Project 2010 Ribbon Guide'(Silverlight animation). Microsoft Project Training. Microsoft. Retrieved January 20, 2013.
  10. ^'What's new in Project 2013'. Microsoft. Retrieved October 10, 2013.
  11. ^'What's new for business users in Microsoft's Office '16'?'. ZDnet. September 18, 2013. Retrieved June 10, 2015.
  12. ^'Was ist neu in Microsoft Project Server 2016 und Project Online - Ressourcenvereinbarungen'. Holertcom. May 20, 2015. Retrieved June 10, 2015.
  13. ^'Microsoft Project 2016 Preview – What is New?'. ManagementYogi. May 23, 2015. Retrieved June 10, 2015.
  14. ^'My Top 5 new Microsoft Project 2016 Client Features from the Microsoft Ignite Conference'. BrightWork. May 12, 2015. Retrieved June 10, 2015.

External links[edit]

  • Official website
  • Project Programmability blog on MSDN Blogs
Retrieved from 'https://en.wikipedia.org/w/index.php?title=Microsoft_Project&oldid=904814371'

Microsoft Excel Starter 2010 is a spreadsheet program designed for everyday tasks such as setting up a budget, maintaining an address list, or keeping track of a list of to-do items. Excel Starter is part of Microsoft Office Starter 2010, and comes pre-loaded on your computer.

Excel Starter 2010 is very similar to Microsoft Excel 2010 in appearance. If you are new to the Ribbon interface or the Backstage view, Excel Starter gives you an opportunity to get accustomed to the new interface before upgrading to Excel 2010.

Excel Starter differs from the complete version of Excel in that it includes display advertising, and it does not support the advanced features of the complete version of Excel. If you find that you want more features, you can upgrade to Excel 2010 right from Excel Starter 2010. Just click Purchase on the Home tab on the ribbon.

Excel

What do you want to do?

Open Excel Starter and take a look around

Open Excel Starter with the Windows Start button.

  1. Click the Start button . If Excel Starter is not included among the list of programs you see, click All Programs, and then click Microsoft Office Starter.
  2. Click Microsoft Excel Starter 2010.
    The Excel Starter startup screen appears, and a blank spreadsheet is displayed. In Excel Starter, a spreadsheet is called a worksheet, and worksheets are stored in a file called a workbook. Workbooks can have one or more worksheets in them.

1. Columns (labeled with letters) and rows (labeled with numbers) make up the cells of your worksheet.

2. Clicking the File tab opens the Backstage view of your workbook, where you can open and save files, get information about the current workbook, and perform other tasks that do not have to do with the content of the workbook, such as printing it or sending a copy of it in e-mail.

3. Each tab in the ribbon displays commands that are grouped by task. You'll probably spend most of your time using the Home tab, when you're entering and formatting data. Use the Insert tab to add tables, charts, pictures, or other graphics to your worksheet. Use the Page Layout tab to adjust margins and layout, especially for printing. Use the Formulas tab to make calculations on the data in your worksheet.

Pengenalan Microsoft Excel 2010 Free

4. The pane along the side of the Excel Starter window includes links to Help and shortcuts to templates and clip art, to give you a head-start on creating workbooks for specific tasks, such as managing a membership list or tracking expenses. The pane also displays advertising and a link to purchase a full-feature edition of Office.

Pengenalan Microsoft Excel 2010 Free Download

Create a new workbook

When you create a workbook in Microsoft Excel Starter 2010, you can start from scratch or you can start from a template, where some of the work is already done for you.

  1. Click File, and then click New.
  2. If you want to start with the equivalent of a blank grid, click Blank workbook.
    If you want a head-start on a particular kind of workbook, choose one of the templates available on Office.com. Choose from budgets, event planners, membership lists, and more.
  3. Excel Starter opens the blank workbook or template, ready for you to add your data.

Save a workbook

When you interrupt your work or quit, you must save your worksheet, or you will lose your work. When you save your worksheet, Excel Starter creates a file called a workbook, which is stored on your computer.

  1. Click the Save button on the Quick Access Toolbar.
    (Keyboard shortcut: Press CTRL+S.)
    If this workbook was already saved as a file, any changes you made are immediately saved in the workbook, and you can continue working.
  2. If this is a new workbook that you have not yet saved, type a name for it.
  3. Click Save.

Enter data

To work with data on a worksheet, you first have to enter that data in the cells on the worksheet.

  1. Click a cell, and then type data in that cell.
  2. Press ENTER or TAB to move to the next cell.
    Tip To enter data on a new line in a cell, enter a line break by pressing ALT+ENTER.
  3. To enter a series of data, such as days, months, or progressive numbers, type the starting value in a cell, and then in the next cell type a value to establish a pattern.
    For example, if you want the series 1, 2, 3, 4, 5.., type 1 and 2 in the first two cells.
    Select the cells that contain the starting values, and then drag the fill handle across the range that you want to fill.
    Tip To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.

Make it look right

You can format text and cells to make your worksheet look the way you want.

For more help with entering and formatting data, see Quick start: Format numbers in a worksheet.

Copy, move, or delete data

You can use the Cut, Copy, and Paste commands to move or copy rows, columns, and cells. To copy, press CTRL+C to use the Copy command. To move, press CTRL+X to use the Cut command.

  1. Select the rows, columns, or cells you want to copy, move, or delete.
    To select a row or column, click the row or column heading.
    1. Row heading
    2. Column heading
    To select a cell, click the cell. To select a range of cells, click click and drag, or click and use the arrow keys while holding down the SHIFT key.
  2. Press CTRL+C to copy or CTRL+X to cut.
    If you want to delete a row or column, pressing DELETE while the row or columns is selected clears the contents, leaving an empty row or cell. To delete a row or column, right-click the row or column heading, and then click Delete Row or Delete Column.
    Note Excel displays an animated moving border around cells that have been cut or copied. To cancel a moving border, press ESC.
  3. Position the cursor where you want to copy or move the cells.
    To copy or move a row or column, click the row or column header that follows where you want to insert the row or column you copied or cut.
    To copy or move a cell, click the cell where you want to paste the cell you copied or cut.
    To copy or move a range of cells, click the upper-left cell of the paste area.
  4. Paste the data in the new location.
    For rows or columns, right-click the row or column heading at the new location, and then click the Insert command.
    For a cell or range of cells, press CTRL+V. The cells you copied or cut replace the cells at the new location.

For more information about copying and pasting cells, see Move or copy cells and cell contents

Change the order

When you sort information in a worksheet, you can see data the way you want and find values quickly.

Select the data that you want to sort

Use the mouse or keyboard commands to select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include titles that you created to identify columns or rows.

How to download hacking tools free from the deep web free. To sort with just two mouse clicks, click Sort & Filter, and then click either of the Sort buttons.

  1. Select a single cell in the column on which you want to sort.
  2. Click the top button to perform an ascending sort (A to Z or smallest number to largest).
  3. Click the bottom button to perform a descending sort (Z to A or largest number to smallest).

Filter out extra information

By filtering information in a worksheet, you can find values quickly. You can filter on one or more columns of data. You control not only what you want to see, but also what you want to exclude.

  1. Select the data that you want to filter
  2. On the Home tab, in the Edit group, click Sort & Filter, and then click Filter.
  3. Click the arrow in the column header to display a list in which you can make filter choices.
    Note Depending on the type of data in the column, Excel Starter displays either Number Filters or Text Filters in the list.

For more help with filtering, see Quick start: Filter data by using an AutoFilter.

Calculate data with formulas

Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more. A formula always starts with an equal sign (=).

Formula
Description
=5+2*3
Adds 5 to the product of 2 times 3.
=SQRT(A1)
Uses the SQRT function to return the square root of the value in A1.
=TODAY()
Returns the current date.
=IF(A1>0)
Tests the cell A1 to determine if it contains a value greater than 0.

Select a cell and start typing

In a cell, type an equal sign (=) to start the formula.

Fill in the rest of the formula

Complete the formula

To complete a formula that uses a combination of numbers, cell references, and operators, press ENTER.

To complete a formula that uses a function, fill in the required information for the function and then press ENTER. For example, the ABS function requires one numeric value — this can be a number that you type, or a cell that you select that contains a number.

Chart your data

A chart is a visual representation of your data. By using elements such as columns (in a column chart) or lines (in a line chart), a chart displays series of numeric data in a graphical format.

The graphical format of a chart makes it easier to understand large quantities of data and the relationship between different series of data. A chart can also show the big picture so that you can analyze your data and look for important trends.

  1. Select the data that you want to chart.
    Tip The data should be arranged in rows or columns, with row labels to the left and column labels above the data — Excel automatically determines the best way to plot the data in the chart.
  2. On the Insert tab, in the Charts group, click the chart type that you want to use, and then click a chart subtype.
    Tip To see all available chart types, click to launch the Insert Chart dialog box, and then click the arrows to scroll through the chart types.
  3. When you rest the mouse pointer over any chart type, a ScreenTip displays its name.

For more information about any of the chart types, see Available chart types.

Print

Before you print a worksheet, it's a good idea to preview it to make sure that it looks the way you want. When you preview a worksheet in Excel, it opens in the Microsoft Office Backstage view. In this view, you can change the page setup and layout before you print.

  1. To print a portion of a worksheet, click the worksheet, and then select the range of data that you want to print. To print the entire worksheet, click the worksheet to activate it.
  2. Click File, and then click Print.
    Keyboard shortcut You can also press CTRL+P.
    Note The preview window displays black and white, regardless of whether your document includes color, unless you are using a printer that can print color.
  3. Click Print.

Share, using e-mail or the Web

Sometimes you will want to share your workbook with others. If you are sharing the workbook with someone who also has Excel, you can send your workbook as an attachment to an e-mail message. The recipient can open the workbook in Excel to work with it.

Note Using commands for sending e-mail attachments requires that you have an e-mail program, such as Windows Mail, installed on your computer.

If your goal is for the recipient to see the workbook, rather than edit it, you can send a snapshot of the workbook, as a PDF or XPS file.

  1. Click the File tab, and then click Save & Send.
  2. Click Send Using E-mail
  3. Do one of the following:
  4. Your e-mail program starts an e-mail message for you, with the specified type of file attached. Write your e-mail, and then send it.

An alternative to sending the workbook is to store it in Windows Live OneDrive. This way, you have a single copy of the workbook that is accessible to others. You can send people a link to the workbook, where they can view it, and even edit it in their Web browser (if you give them permission).

  1. Click the File tab, and then click Save & Send.
  2. Click Save to Web.
  3. Click Sign In, enter your Windows Live ID and password, and click OK.
    If you use Hotmail, Messenger, or Xbox Live, you already have a Windows Live ID. If you don't have one, click Sign up for a new account to create a new Windows Live ID.
  4. Select a folder in OneDrive and click Save As. Type a name for your file and click Save.
    The document is now saved on OneDrive. In OneDrive, you can give people permission to view and edit the contents of your folders. When you want to share a workbook, you send a link to it in e-mail.

For more information about storing your documents in OneDrive, see Save a document to OneDrive from Office 2010.

Get more help

Office.com is continuously updated with new content, including how-to articles, videos, and training courses. If the bottom of the Help Viewer says Offline and you are connected to the Internet, click Offline, and then click Show content from Office.com.