Master Dynamic Gantt charts and amazing Time lines In Excel

Course details

How to prepare dynamic Gantt charts and amazing Timelines in minutes , Using simple excel charts and few formatting techniques. No codes no macros. Quickly Convert simple task list into visually appealing formats.Prepare Gantt charts ,Timelines ,progress bars , Planned Vs Actual completion at any give day.Supported with Many editable Free templates.

What is the problem with regular task list ?

With a simple Task list created in tabular format one may find it hard to visualize the necessary sequence of activities and sense of urgency every task needs.

What is a Gantt Chart :-

In any project,every activity or task acquires a distinct place on the project time line. A Gantt chart also contains a task list, but Gantt chart chart represents activities against time on a timeline thereby giving a clear picture of things to come. Apart from what is to be done it tells you when it is to be done.

Advantages of Gantt chart over Task List : -

Gantt chart instantly improves communication and visualization.It naturally helps you with decision making as one can see entire flow of work in the most logical sense .You can easily focus important activities and prioritize them at any point of time. You can channelize your efforts and resources in an organized manner.

At every point it tells whether you are on schedule or lagging to take necessary corrective action thereby giving a far better control over project.

What will you learn ?

• Basics of Gantt chart.

• Create Gantt chart from a simple project in Microsoft excel.

• Create milestones

• Create timelines

• Show Planned vs Actual %completion

• Create Gantt chart Dashboard with pivot table using Slicers and Timelines

What are primary requirements if you wish to undertake this course ?

All You need is basic knowledge of excel. All the formats are created using simple excel charts without any macros or codes.

Basic idea behind the course is the application of project management tool in day to day life.

I am sure it will help and serve you a lot, in your personal and professional life.

All the lectures are adequately supported by resources in the form of PDFs and Editable Excel templates for easy understanding and practice purpose.

Please take some time to review and Give feedback towards further improvement.