• Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course
  • This course will make you master in Pivots and Charts. From making new pivots to working in existing pivots and modifying them .
  •  Not only pivots but you will also see pivots combinations with arrays and collection loops.
  • Collection loops in PIvots - how to access pivots . How to loop pivot field items and fully control it.
  • This is extremely advance package and designed for all types of students. Everything is discussed from scratch. Have a great learning.
  • 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.
Basic knowledge

Knowledge of Variables and Collection loops would be an added advantage.

Knowledge of Pivots and Charts is must in Excel Front end.

What you will learn

You will be able to work with charts and pivots in excel using VBA. From making them to modifying them you will learn all.

Number of Lectures: 10
Total Duration: 08:18:01
VBA Pivots
  • Chapter1  

    You will be able to work with charts and pivots in excel using VBA. From making them to modifying them you will learn all.

  • Chapter2  

    From making basic pivots to advance pivots - running loops for pivot we have got everything discussed here.

  • Chapter3  
  • Chapter4  

    Discussing now some questions received by students so that you can get live practical feel also. Since we have studied everything about pivots so now we can go and work on them without fear and hesitation. 

  • Chapter5  
  • Chapter6  
    1. After learning everything about pivots. fields. items and collection loops , doing projects it a turn for pivot slicers.
    2. how to define slicer caches and slicer items - what they meant in VBA
    3. Collection loops in slicers - how to check how many slicers are created in excel sheet
    4. how to check each of the items in a slicer

  • Chapter7  
  • Chapter 1  

    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.

  • Chapter 2  

    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.

  • chapter 3  
Reviews (0)