Excellence in Excel! Create Interactive Charts in Excel!

Create Interactive Charts in Excel! Learn how to make your dashboard interactive and professional looking!
3.0 (1 rating) 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.
11 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 10
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course Description

Join my community of over 3.000 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 make interactive chart in Excel. This means that it will show other chart and information based on what you select in the dropdown menu. This makes your dashboard more interactive and very easy to read!

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 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 minute you delay you're missing out on huge opportunities!!

What are the requirements?

  • Have the willingness to take MASSIVE action!
  • Have an open mind.
  • Have a working Microsoft Excel 2007, 2010 or 2013.
  • Wants to achieve Excellence in Excel!

What am I going to get from this course?

  • Create interactive charts in Excel.
  • Understand how to use Linked Picture in Excel.
  • Can create connections with the Combo Box function in Excel.
  • Know how to activate the Excel developer tab.

What is the target audience?

  • Businessman that needs Excel to improve their data visualization skills.
  • Businessman that uses Excel to present data more clearly.
  • Businessman that needs dashboard data clearly presented.
  • Business Owners that uses Excel to track their results and translate data into clear visual graphs.
  • Professionals that need to improve their Excel skills.
  • Students that want to become professional with Excel.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome
01:16

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.

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.

2 pages

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.

Section 2: Create the Input Data tab of the interactive chart dashboard.
05:49

Interactive Charts Excel

In this lecture you will create the first tab. You will first place the data and create the layout of the tab. This will be the structure for the tab.

07:46

Interactive Charts Excel

In this lecture you will make the three charts. These charts need to be placed properly because this will influence the second tab.

Section 3: Create the interactive Chart Dashboard tab.
Create the combo box and advance connection with the Excel Developer tab
05:31
05:37

Interactive Charts Excel

In this lecture you will connect the combo list so it displays the charts dynamically. You will learn:

  • How to get paste a Linked Picture
  • How to make the Linked Picture connected with the combo box selection
Section 4: Excel Interactive Chart Exam
01:09

Excel Interactive Chart Exam

In this part you have a mini exam. Practice by creating this mini exercise. Now there is a challenge for you. How well did you understood the lessons? This is your challenge, create an equal box as on shown in this video.

Please take action on this exercise. You are here to maximize your learning. Research has shown that if you repeat something within the first 20 minutes of learning, it will stick longer in your mind. Besides, this is a challenge as well. Are you ready for the challenge.

09:46

Excel Interactive Chart Exam

How well did everything went? In this part you can double check your results. Double check and look what part was hard and what was easy. If you still have troublewith your Interactive Charts in Excel just make a screenshot and post it on the disucssion board. I will help you out.

Section 5: Thank You!
02:10

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?
4 pages

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!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Nicky Wong, 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.

Ready to start learning?
Take This Course