Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Excellence in Excel! Create a dynamic Gantt Chart in Excel!

Name: Excellence in Excel! Create a dynamic Gantt Chart in Excel!
Rating: 4.2 (95 reviews)

Excel tools, create a Gantt Chart that is 100% dynamic and helps you earn more in your profession or business.

Created byNicky Wong

Last updated 12/2021

English

What you'll learn

Create you own Basic Gantt Chart
Create you own Progress Gantt Chart
Create you own Dynamic Gantt Chart
Understand how to use Nested IF statements
Create professional Gantt Charts

Course content

6 sections • 18 lectures • 1h 24m total length

What will you learn in this course!1:52
Excel Course

Welcome to this course! Im excited to have you here!

Excel is a wonderful tool to create powerful programs. Sadly, many people cannot grasp the true power of Excel. In this course you will learn the formula`s and functions to create practical Excel sheets and tools that you can use for your job to get a higher paid salary.

The real power of Excel is Create by Doing! I do not want to you learn a basic Excel function and let you go. I want you to understand the practical use of Excel by using just a few tools to create something that has a value of a lifetime.

Project Management with Gantt Chart

A project manager needs to manage all the tasks and track the progress. This skill will help you to become a better skillful planner.
Download the Excel file with the Raw Data2:00
Excel Course Raw Data
In this part you can download the raw data. You will not receive the full data. Why? Because I truly want you to learn it by doing.

This course is titled: Create by Doing! It is a challenge and the big question is, can you do it?

Download the Excel sheet so you have the Raw Data at hand that you need for the upcoming lectures.

Creating the Basic Gantt Chart, from start to finish11:13
Excel Basic Gantt Chart

In this lecture you learn how to create a basic Gantt chart. You will need to use the Raw Data that will be the starting point of this course. This Gantt Chart is a basic. Practice this to create a stepping stone for the advanced Gantt chart in the next section.
Exercise Test 1, the Basic Gantt Chart1:39
Excel Exercise

Before we go to the next level it is time to take real action. You will have to complete an exercise to test what you just learned. Take this action because this is the way how you really start to learn what you practice. Good Luck with the exercise.
Exercise Test 1 Answers7:21
Excel Exercise

How did the action exercise went? Was it easy or do you have any questions? If you have any questions, just make a screenshot from your excel sheet and post your question in the discussion board. I can quickly check your results and help out.

Follow and double check if everything you did was correct.

Creating the Progress Gantt Chart, placing the core data and layout5:12
Excel Progress Gantt Chart

In this lecture you learn how to create a Progress Gantt chart. You will need to use the Raw Data that will be the starting point of this course. Practice this to create a stepping stone for the advanced Gantt chart in the next section.

The progress chart will display how many task are done and what still needs to be done. You can see that because of the color difference. This makes it very useful to instantly analyze progress of any project. Project managers will love this wonderful chart.
Create the Progress Gantt Chart, placing the formula`s and chart5:46
Excel Progress Gantt Chart

In this lecture you learn how to create the formula`s and the chart. You will see that the chart will have green and red bars. The green bars will indicate that the task is done and red indicates what still needs to be done. he most important part is the done and incomplete column. These columns are essential for creating a proper display.
Exercise Test 2, the Progress Gantt Chart1:07
Excel Exercise

You already had a solid foundation of a basic Gantt Chart. Now we complete Basic with a progress bar. Create this Progress Gantt Chart as displayed on the video. The most important reminder is to use the "Done" and "Incomplete" columns. Good luck with the exercise.
Exercise Test 2 Answers6:30
Excel Exercise Answer

How did it went? Did you use the two columns "DONE" and "INCOMPLETE"? Was it hard or do you need more guidance? Are you still having some trouble? I`m here to help out. In this part you will see all the answers and understand exactly how to take it step by step. If it still does not work, please make a screenshot and post it on the discussion forum. I will help out as quickly as possible.

This part showed you the usage of the Progress Gantt Chart. You are now ready to create a Dynamic Gantt Chart.

Create the Dynamic Gantt Chart, placing the core data and layout.7:49
Excel Dynamic Gantt Chart

In this lecture you will learn how to create a Dynamic Gantt Chart. Before we start creating the chart we need to give the tab a body. First we place the data and give the tab a layout.
Create the Dynamic Gantt Chart, placing the formula`s and functions10:56
Excel Dynamic Gantt Chart

Did you give the tab a look and feel? That is great. Now it is time for the next level. We will create the formula and statements. The most important part will be the Nested IF statement.
Please pay much attention to this special IF statement.
Create the Dynamic Gantt Chart, place the Dynamic Gantt Chart graph6:18
Excel Dynamic Gantt Chart

Now you completed all the core data and you can start creating the chart. We will make the Dynamic Gantt Chart now. You will notice the chart will automatically change the progress once you change the current date. This is a wonderful chart and very useful for any project you do.
Exercise Test 3, the Dynamic Gantt Chart1:49
Excel Exercise

You have learned now every part of the Gantt Chart. Now it is time to test your knowledge by creating your own Dynamic Gantt Chart. For this exercise you will be organizing parts of a wedding. Create a Gantt Chart that automatically changes based on what date it is "Today".
Exercise Test 3 Answers10:56
Excel Exercise Answer

How did it went? Did you created the nested IF statements properly? Are you still having some trouble? I`m here to help out. In this part you will see all the answers and understand exactly how to take it step by step. If it still does not work, please make a screenshot and post it on the discussion forum. I will help out as quickly as possible.

I truly hope you completed the entire course with all the exercises. You probably understand a lot more and how you can use the Gantt Chart skillfully.

Final Points3:22
Excel Conclusions

Congratulations of completing this course. Remember that you always should continue learning and improve it. That is why I would like to hear from you! Do you want to create something new? Did you like this learning method? Just let me know!

You have learned a lot of quality information and know now how you can make your own Gantt Chart. This is what you can do from now on:

Go and rate my course!

Go ahead and tell me what you want to learn more about Excel in the discussion board!

How can you use this knowledge in your daily life?
Excel Reference Sheet by Udemology4:00
Excel Reference sheet

You learned a lot and I truly believe you want to make sure you remember all the information as well. So here you have a reference sheet. I placed the best functions on this sheet with a very brief explainaton. Are you on a mobile phone? Do not worry! I have also a mobile format ready for you!
Bonus: Further Learning0:42

Requirements

Have an openmind and willingness to truly take action (This is an action course!)
Have Microsoft Excel installed on their computer.

Description

Join my community of over 2,500 students and growing! Many people want to discover Excel! In this course you will learn how you can make Excel work for you! You will learn all how to create time saving tools and techniques that I personally use in my life!

The real secret of Excel: Only use Excel to make it WORK FOR YOU!

=======================================================================

Immediately increase your efficiency and productivity by using this wonderful program. In this program you will learn how to create wonderful Gantt Chart and let it automatically adjust based on the date. This means that it will track your progress without any manual labor.

I truly belief Excel is one of the best programs ever and I will show you why and how. You will love it and learn how to become an expert in Excel and truly save many hours each day by using these tricks.

=======================================================================

Course Details

This course is designed for every beginner or anyone who wants to learn the true working system of Excel. The course is spoon-feeding you, this means that you will learn step-by-step everything you need to know. It starts slow and gradually goes quicker when you become more proficient with Excel.

The best thing of this course is, you start to create something from scratch. You will not only learn how to use basic functions! You will also create and connect these functions with each other. When you follow the entire course you have created a useful Excel tool that you can use forever!

=======================================================================

Are you still in doubt?

Well, just look at the free previews so you can immediately judge that you can expect. Besides, I have also many other Excel courses here on Udemy! Just look at my profile to have learn more about your instructor!

=======================================================================

Join now and Experience the benefits!

I will show you step by step and you will truly understand it! If ever you think this course is not right for you, you can get your money back, for a limited period of time! This basically means that you can get your money back in a blink of an eye.

In life you have the waiters and the walkers. I truly belief you are an active person because you show your interest in learning to grow! When you learn you earn! So, why not start earning by learning the right skills that you need in your business life!

Click the “TAKE THIS COURSE" button, top right, NOW!!...every hour you delay you're missing out on huge opportunities!!

Who this course is for:

Project Managers that need to use Excel for tracking progress.
Businessman that want to create professional looking Gantt Chart with Excel.
Professionals that want to improve their Excel Skills
Business Owners that want to use Excel for planning events, projects or track and measure progress.

Excellence in Excel! Create a dynamic Gantt Chart in Excel!

What you'll learn

Explore related topics

Course content

Welcome2 lectures • 4min

Create a Basic Gantt Chart3 lectures • 20min

Create a Progress Gantt Chart4 lectures • 19min

Create a Dynamic Gantt Chart5 lectures • 38min

Thank you3 lectures • 8min

Bonus Lecture Question from student1 lecture • 1min

Requirements

Description

Who this course is for: