Easily create Gantt chart and amazing Timelines using Excel. With the help of this course you can Project Management with Microsoft Excel.
This course was created by Amey Vidvans. It was rated 4.1 out of 5 by approx 11296 ratings. There are approx 50069 users enrolled with this course, so don’t wait to download yours now. This course also includes 1 hour on-demand video, 13 Supplemental Resources, Full lifetime access, Access on mobile and TV & Certificate of Completion.
What Will You Learn?
Amazing time line based reports and presentations
Learn to create Gantt charts and Dynamic Timelines using Simple Microsoft excel Charts.
In any project success of the project depends on how you handle the information.You have to handle a lot of data and information.To be a successful project manager you need to prioritize and channelize organization’s efforts and resources in most efficient manner.
Mastering Presentation and communication by Presenting the data in Compelling format:-
Every single presentation slide acts as a powerful tool to communicate important information.Quality of presentation speeds up decision making process and improves overall efficiency.
Since dates and numbers are very hard to associate,You may find it hard to visualize the sequence of activities.In any project, every activity acquires a distinct place in project life cycle.But when dates are presented in tabular format it may be difficult to segregate the information in a first go.
Project time line gives a clear picture of things to come. As activities are segregated in chronological order, it’s very easy to prioritize and plan them. It helps you to channelize your efforts and resources to achieve intended project objectives.
Content and Overview :-
In Three sections and Nine lectures this course uncovers techniques to prepare project Timelines.Right from simple bar charts ,it covers creating dynamic time line with variance report.All this is done only using excel charts without any macros.
Basic concept behind this is,any person even with a little knowledge of excel should be able to prepare beautiful and quality presentations,in short time.I am sure it will help and serve you a lot, in your professional life.
All the lectures are adequately supported by resources in the form of PDFs and Excel sheets for easy understanding and practice purpose.
What will you learn ?
- Gantt chart using simple bar chart.
- Creation of milestones using combination of charts.
- Creation of milestones using scatter chart.
- Creation of activities with duration using scatter chart.
- Creation of dynamic timeline with scheduled % completion bar
- Creation of timeline with Actual Vs Planned completion
Who is the target Audience?
- Project Managers.
- Every Person who is handling a project but doesn’t have softwares like Primavera or Microsoft Project.
- Coordinators who want to communicate critical information quickly to different stake holders.