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

Essential settings

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.