Excellence in Excel! Create a dynamic Gantt Chart in Excel!
4.0 (64 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
291 students enrolled

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

Excel tools, create a Gantt Chart that is 100% dynamic and helps you earn more in your profession or business.
4.0 (64 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
291 students enrolled
Created by Nicky Wong
Last updated 10/2015
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 2 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
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.
Course content
Expand all 18 lectures 01:28:21
+ Welcome
2 lectures 01: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.

Preview 01:52
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.

Download the Excel file with the Raw Data
2 pages
+ Create a Basic Gantt Chart
3 lectures 20: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.


Preview 11:13

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, the Basic Gantt Chart
01:39

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.

Exercise Test 1 Answers
07:21
+ Create a Progress Gantt Chart
4 lectures 18:35

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.

Creating the Progress Gantt Chart, placing the core data and layout
05:12

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.

Create the Progress Gantt Chart, placing the formula`s and chart
05:46

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, the Progress Gantt Chart
01:07

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.

Exercise Test 2 Answers
06:30
+ Create a Dynamic Gantt Chart
5 lectures 37:48

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 core data and layout.
07:49

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, placing the formula`s and functions
10:56

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.

Create the Dynamic Gantt Chart, place the Dynamic Gantt Chart graph
06:18

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, the Dynamic Gantt Chart
01:49

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.

Exercise Test 3 Answers
10:56
+ Thank you
3 lectures 04:04

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:

  1. Go and rate my course!
  2. Go ahead and tell me what you want to learn more about Excel in the discussion board!
  3. How can you use this knowledge in your daily life?
Final Points
03:22

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!

Excel Reference Sheet by Udemology
4 pages
Bonus: Further Learning
00:42
+ Bonus Lecture Question from student
1 lecture 00:01

Special request sheet

Design on request
00:01