Download Now

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.

Excel Pivot Table Grouping, Calcs, Slicer, Sparklines



Direct Download

Tags: Grouping, Slicer, Sparklines

Add Comments:
Enter Code: *