As you know, with Project for the Web you can export Project data, for single Project
Today I will show you how can you export data from multiple Projects to Excel, using Microsoft Project Accelerator.
First of all I will create two simple Projects using Microsoft Project for the Web
Now I will skip to Project Accelerator:
and I will see Excel file in my Downloads folder:
When I open this file I will get:
As you can see, Project name, Start and Finish Date, Earliest Start, Total Effort, Completed Effort, % Complete and Project Status field are exported.
But wait? Where are the Tasks?
Well, that will be Topic for my next Blog Post
About Nenad Trajkovski
Location: Zagreb, Croatia
Occupation: Project Manager
Interests: Project Management and MS PROJECT
He was born in Zagreb, Croatia at 1963. After completing his college he started working on projects in different business areas (banking, manufacturing, automotive industry, distribution, oil companies, etc.) developing and implementing ERP systems into different companies. He has got a lot of experience working with people in different business processes and also possesses great knowledge in information technologies and financial services. Today he works as a business consultant, adn Project Manager in PERPETUUM MOBILE d.o.o. Zagreb. He is a regular lecturer for Project Management in MS Innovation Center in Varaždin, Logosoft Sarajevo in Bosnia and Herzegovina and SEAVUS GROUP in Skopje Macedonia. He was named the best lecturer of WINDAYS 2008 while his lecture was also voted as the best. In addition, he was in TOP 10 lecturers at the MS SINERGY 2009 and MS VISIA 2009, 2010. Shares first place as the best lecturer of KulenDays 2009 and 2010 and PMI Conference 2009 in Zagreb. He is also a regular lecturer in the MS Community. He is a Certified Accountant and a PMP (Project Manager Professional) and a PMI-RMP (Risk Manager Professional), MCP, MCT, and Microsoft Certified Technical Specialist - Microsoft Project 2010. From 01.01.2012 awarded with MVP (Microsoft Most Valuable Proffesional - Microsoft Project)!