Excel VBA Charts ( also 3 Surprise Tests for you ) Series 11
5.0 (1 rating)
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.
5 students enrolled

Excel VBA Charts ( also 3 Surprise Tests for you ) Series 11

Indepth discussion on Making and modifying of Charts using Vba
5.0 (1 rating)
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.
5 students enrolled
Created by ajay parmar
Last updated 3/2019
English
English [Auto-generated]
Current price: $11.99 Original price: $19.99 Discount: 40% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 1 article
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Perfect mastery in creating Charts and at then same time manipulating the existing charts as well - the way you want. Whatever you wan to do with charts you will be able to do it.
Course content
Expand 8 lectures 03:29:17
+ VBA Charts ( also, Quizes on Loops-if-Functions-Array-files) -Series 11
8 lectures 03:29:47

Answering the question received by one of students that how to import the images if we have in excel cells. This video talks about that. We are learning how to use a shapes collection loop here and how we can use charts for images.

Preview 20:09
Introduction to VBA Charts
01:32:14

Here we are going to discuss from scratch about Charts . This tutorial will make you awesome in the making of charts . Please keep in mind that before seeing this chapter you should be well versed with charts in excel. How we create charts in excel without programming.

Introduction to VBA Charts
17:19

This project will give more exposure about charts . How they can be used differently . You should watch this video if you have watched previous one.

Introduction to VBA Charts
21:51
Surprise Test 1 - Arrays Loops IFs File Handling (Mix)
24:05

These videos are a token of love from my side to you. These will sense to you only if you know VBA loops ,if functions and Arrays, Functions. These are my surprise tests which i had given to my students to see how much they understood so far about the topics covered in training. So, go and do these tests without looking at the solution first. 

Surprise Test 2 - Arrays Loops IFs File Handling
08:52

These videos are a token of love from my side to you. These will sense to you only if you know VBA loops ,if functions and Arrays, Functions. These are my surprise tests which i had given to my students to see how much they understood so far about the topics covered in training. So, go and do these tests without looking at the solution first. 

Surprise Test 3- Arrays Loops IFs File Handling - All in One
23:51
Requirements
  • You should be familiar with VBA Basics like loops, collection loops and Classes/Objects before starting Chart Series.
Description
  • How to create new charts in excel.
  • How to work with existing charts in excel. How to go to each of them one by one and do modifications. Any type of modification like changing chart design or editing labels or chart titles etc
  • Loops importance in charts
  • Collection loops of charts - to work with multiple charts in one go
  • Use of other Collection loops with chart collection loops.Loops in Loops.
  • Projects for you to know more about Charts using input-box and range commands- Great case studies.
  • 3 Bonus videos for you- Surprise tests conducted in my online classes (Advance Level) - Arrays, Functions, File folder handling , if functions and Loops) Its  a mixture of all important VBA topics.These tests are going to benefit you if you already have a good knowledge of these topics)
Who this course is for:
  • Charts are the most used thing in excel so it is necessary for us to learn how we can automate them using VBA. This way you can automate your dashboards which uses Charts so it is must know thing for wannabe programmers