It is a 15 hours program focusing on how to work with huge data sets, extend your Pivot table summarization capabilities, advanced calculations, import data from various sources and, publish the workbooks as interactive web applications.
Before Power Pivot, this kind of analysis was limited to enterprise BI tools such as SAS and Business Objects.
Talk to the Trainer
Know your current Excel skills through a quick pre-assessment, discuss your requirements (if any) with the Trainer and, feel your comfort level before regestering for the program.
"Informative workshop! It has substantially enriched my knowledge and added value to my Career Profile. I really appreciate the way Sami go out of the way to help us understand the topics.
I come from a non-programming background yet, the topics were taught in the most laymen language making it a child’s play. I feel so happy to write the coding all by self and automating my various day-to-day tasks.
The program was the right balance of relevant theoretical inputs and hands-on practical exercises. Well structured! My special thanks to Sami."
Michael Joshua
Operations Analyst,
Shell, TX
Reviews
Sami is truly a passionate trainer, who is more interested in learning of his students. The examples taken are in line with the profile of the group.
Coding was made really simple and fun to work with. Assignments post the session did its...
The course is structured and delivered really well. The majority of our group was from the non-programming domain and hence, relating to new concepts was challenging..
But, Sami made coding look so homespun. Case studies were good, exposing us to the...
Every good course structure requires an expertise trainer to suffice the beauty of the subject and Sami, is just apt for this VBA course.
His equal knowledge on Macros and the industry exposure at different levels made his teaching a child's play...
Good course. Case studies and assignments were quite interesting.
Tutor was really patient and highly knowledgeable about every aspect of VBA. It was good learning experience...
It was an excellent experience to learn a vast amount of information in a relative short time period.
It made me much more confident to assume an analyst position with the company. It was a very good and complete course for the topics...