Excel Pivot Table: Grouping, Calcs, Slicer, Sparklines
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1.5 Hours | 556 MB
Genre: eLearning | Language: English
Learn Beginner to Advanced Tricks - Field Logics, Grouping, Calculations, Slicer, Sparklines, Charts, Hidden settings
Before you read what I have to say, see what my students are saying about my courses on Excel:
"I would like to tell you that I am very impressed with your courses so far - I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one's attention span). The other gem in your training are the shortcuts, I found no other course with the same insights." by Peter Klugsberger, Australia, ex-McKinsey & Co., served various senior roles (CEO, COO) in various companies
“Course helped me improve my speed and shine among my peers” by Kanish Tuplondhe, Sr Finance Professional, Greater Bank, India
Pivot table is easy to use technique of Excel. Professionals can benefit from the hidden tricks and Ninja hacks -
Do's and Donts'
Understanding logics of the four field areas
Perform mathematical calculations - Sum, Average, Count
Perform percentage calculations - % of Row, Column, Grand total
Grouping Dates into months and years
Grouping Numbers into standard ranges such as 0-10, 11-20 etc.
Grouping Text into clusters such as SBUs, Zonal regions
Understanding new data visualisation features - Sparklines, Slicer, Charts
Create 100s of customised reports in under 1 minute - using special hack
3 Project case studies - Sales data analysis, Closing Stock analysis, Salary & Performance analysis
Introduction to PowerQuery & it's practical application
We have 21 videos of duration 1+ hrs. Through practical examples, they start from the foundation and take you to the Ninja level application.