Excellence in Excel! Create a dynamic Gantt Chart in Excel!
3.8 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
88 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excellence in Excel! Create a dynamic Gantt Chart in Excel! to your Wishlist.

Add to Wishlist

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 you profession or business.
3.8 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
88 students enrolled
Created by Nicky Wong
Last updated 10/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 18 Lectures Collapse All 18 Lectures 01:28:34
+
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
4 Lectures 03:37

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:14

Special request sheet

Design on request
00:01
About the Instructor
Nicky Wong
4.1 Average rating
316 Reviews
26,373 Students
22 Courses
Data Analyst, Market Researcher, Data Visualizer!

Nicky Wong is an expert in translating data into market opportunities. Data is his passion, Excel, Databases and Big Data are truly wonderful topics. As an absolute data lover and he is always looking for ways to analyze it. It started with stock market facts and now quickly turned to everything that is unique and different.

However, all the information have one primairy goal and that is "How to use this information to gain a competitive advantage". As a Market Researcher with it roots in Marketing Nicky understands that knowledge is power. Whatever you do make sure you use data at your advantage.

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

My vision of Data and the future

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

Why Data visualization matters!

I truly belief that Big Data is giving us all a new obstacle to overcome! Information overload is a serious challenge and with Big Data it only multiplies the issue. If you are a data miner you will know that much data has no meaning if you cannot connect any meaningful dots.

Large chunks of data, reports and tables are not effective. It is impressive to get a huge database but it is demotivating for others to read data. The biggest data trend is increasing this issue! Big Data = Information Overload x 10.

From (Digital) Information Age to the (Digital) Understanding Age

A data analyst can analyze data but the most important skill is Data Visualization! These so called "data visualizers" will develop a new skill gathering meaningful information and present it in a very understandable and effective way.

The issue is not anymore the data but the way to give meaning and communicating meaning to others. The person who can do that will have a huge advantage in the so ever growing Big Data world.

Big Data is here! Data Visualizer is on it`s way! In all of my courses I use techniques to create understandable data and present it in an impactful manner.