Skip to Content

Tag Archives: microsoft excel

Best Practices for Integration of Microsoft Project and Excel

Introduction This article discusses Project and Excel integration points, specifically in the following areas: How to import data from Excel to Project Importing an initial last list How to export data from Project to Excel Exporting a to-do list for resources Exporting time-phased data for reporting   Why Bother with Excel? First things first! My…

Data Analysis Using Project with Excel

  Download a copy of the presentation   Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDUs in the Technical category of the Talent Triangle. Event Description: As a project manager with the State of Maryland Department of Social Services, I was tasked with clearing up case backlogs…

Microsoft® Excel Keyboard Shortcuts

MPUG has done the work for you! We spent some time compiling some of the most useful Microsoft® Excel keyboard shortcuts. Keeping this page bookmarked for reference will help make your life a little bit easier. Be sure to also check out our Microsoft® Project Keyboard Shortcuts and Microsoft® SharePoint Keyboard Shortcuts. Print or Download the Microsoft® Excel…

Project and Excel Integration – the application dream team!

Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Technical category of the Talent Triangle. Event Description: Microsoft Project is a fabulous tool for Project Managers, and it can be used to produce some great reports.  However, sometimes it’s necessary to export data out to Excel for…

4 Handy Microsoft Project Scheduling Tips

1. When you schedule electronically, you should not enter start or finish dates for tasks. If you use Microsoft Project to simply capture dates and only dates, you may as well use Microsoft Excel instead. With MS Project, you enter durations and dependencies instead of dates to create a forecast model. The software then calculates start…

Timeline View

The first video presentation for Microsoft Project 2010 is presented by Collin Quiring from Project Management Professionals (PMP)® Specialists. He starts by explaining the timeline view in Microsoft Project 2010 as well as the general idea behind it. The timeline is a way to present tasks for non-project users – that is, users who are…

Ask the Expert: Importing Data from Excel into Project

Richard J. writes, I’m using Microsoft Project 2000 to import data from Microsoft Excel but some of the data isn’t appearing in Project, seemingly at random. This may be because there are 305 rows of data to import. Is there a limit to the amount of data you can import into Project from Excel or…

Please enter your email to continue viewing