Information of news
 (Votes #: 0)

Excel Pivot Table Grouping, Calcs, Slicer, Sparklines

Category: Tutorial

Download Now

Excel Pivot Table Grouping, Calcs, Slicer, Sparklines

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.
Buy Premium To Support Me & Get Resumable Support & Max Speed

Links are Interchangeable - No Password - Single Extraction
Direct Download

Tags: Grouping, Slicer, Sparklines

Excel Pivot Table Grouping, Calcs, Slicer, Sparklines Fast Download via Rapidshare Hotfile Fileserve Filesonic Megaupload, Excel Pivot Table Grouping, Calcs, Slicer, Sparklines Torrents and Emule Download or anything related.
Dear visitor, you went to website as unregistered user.
We encourage you to Register or Login to website under your name.

Add comments

Enter Code: *