Whether or not Excel is the best way to collaborate and communicate is not the issue. As PMs the request often comes from someone higher up the food chain than we are, and sometimes the business situation simply dictates what we have to do. What is needed by the PM is (1) an understanding of what the problems are, (2) an understanding of the potential realm of solutions, and (3) a tool which provides a a workaround: a much quicker and easier way to reformat Excel files into something that looks like a normal Gantt chart in the event that none of the other options are viable. The ZIP archive addresses these issues. This practical whitepaper by Masamitsu looks at the problems and issues that surround this gap in what Microsoft Project can do, and summarizes the options currently available as of June 2018. It also provides a step-by-step guide and the included Excel file tool, which provides a workaround "fix" to the problem which should significantly reduce the time required in creating an acceptable Gantt chart in MS Excel. The full whitepaper is 64 pages in length with screen shots, in a compact Adobe Acrobat PDF file, and is accompanied by a sample MS Project 2013 .MPP file and the Excel Spreadsheet tool. This is unsupported freeware.
Shop your favorite products and we’ll find the best deal with a single click. Designed to make shopping easier.