Excel VBA Awesome Pivots Series10
5.0 (3 ratings)
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.
37 students enrolled

Excel VBA Awesome Pivots Series10

Indepth discussion on every aspect of Pivots
5.0 (3 ratings)
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.
37 students enrolled
Created by ajay parmar
Last updated 1/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will be able to work with pivots in excel using VBA. From making them to modifying them you will learn all.
Course content
Expand 8 lectures 06:14:36
+ Introduction to Pivots
8 lectures 06:14:36

We are starting with Pivots in this chapter. How we can create pivots in excel using VBA but you must know them in excel before taking on vba part .

Introduction to Pivots
01:01:51

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

Introduction to Pivots
01:34:44
Introduction to Pivots
01:00:28

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. 

Pivots Project1
27:53
Pivots Project2
01:07:20
  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

Work with Slicers
28:50
Requirements
  • Knowledge of Variables and Collection loops would be an added advantage
Description
  • This course will make you master in Pivots. 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.
Who this course is for:
  • If you want to automate your charts and Pivots using VBA then you should go for this course definetly