Excellence in Excel! Create a dynamic Gantt Chart in Excel!
- 1.5 hours on-demand video
- 2 articles
- 4 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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
- Have an openmind and willingness to truly take action (This is an action course!)
- Have Microsoft Excel installed on their computer.
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.
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!!
- 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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".
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.
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
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!