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

Indepth discussion on Making and modifying of Charts using Vba

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)

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

  • VBA Charts ( also, Quizes on Loops-if-Functions-Array-files) -Series 11 –> 8 lectures • 3hr 29min.

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

Requirements

  • You should be familiar with VBA Basics like loops, collection loops and Classes/Objects before starting Chart Series..
  • 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)