Project-VBA-Project-Guru.ppt - Project VBA How an…….ppt

? Copyright ACE Project Systems Ltd 2009 Project VBA: How and Why it can Make You a Project Guru! A Project Guru is not just a power user Project Gurus are great at managing and reporting on, project information Data management and reporting is what makes VBA so useful and productive Rod Gill Microsoft MVP for Project since 1997(Most Valuable Professional) Has over 25 years experience as a Project Manager in Construction, Software Engineering and many other industries in between Trains Project Management and advanced Microsoft Project courses Author of the book: VBA Programming for Microsoft Office Project Versions 98 through 2007 A Project Guru is not just a power user Project Gurus are great at managing and reporting on, project information Data management and reporting is what makes VBA so useful and productive This Session is aboutHow VBA helps you: Manipulate data Import/Export data Create custom Reports in Excel Add functionality to Project Make you stand out as an expert Make you more money! Up skill you to more job security You’ll Learn How Project VBA will help elevate you to Guru status Lessons from some real life examples Some code to get you going A road map to success with Project VBA How Project VBA will help elevate you to Guru status Helps you understand and use your application better Makes you and your team more productive Adds value to your information Eliminates boring and repetitive work Makes following processes easier and more reliable Makes you more useful and valuable at work Makes you stand out as a Power User/Guru VBA – More Benefits If you know Project VBA, Excel VBA is easy to pick up Lets you integrate the power of Project and Excel almost seamlessly Good schedulers likely to have the right aptitude to program in VBA Can be used for any active project Works with or without Project Server VBA written for Project 98 still works in Project 2010 – so great compatibility Real Life Lessons from Two Project