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 From My Links To Get Resumable Support,Max Speed & Support MeCode:Download ( NitroFlare ) http://nitroflare.com/view/DECDF41291BABD9/19tyc.part1.rar http://nitroflare.com/view/476A76B0F05D145/19tyc.part2.rar Download ( Uploaded ) http://uploaded.net/file/3ow6xsku/19tyc.part1.rar http://uploaded.net/file/k5pzgncm/19tyc.part2.rar Download ( Rapidgator ) http://rapidgator.net/file/c42d0c26454a7bdd8d1f1c95c2b6b948/19tyc.part1.rar.html http://rapidgator.net/file/b545ad2c31b28b5232f48d762f8da9a4/19tyc.part2.rar.html Download (BigFile) https://www.bigfile.to/file/6RCxr5tchrF2/19tyc.part1.rar https://www.bigfile.to/file/e6w39pbtkm56/19tyc.part2.rar Download (Oboom) https://www.oboom.com/WLUNCLFP/19tyc.part1.rar https://www.oboom.com/Z1020ZJ8/19tyc.part2.rar
Please visit our sponsors
Results 1 to 1 of 1
-
02-06-2016, 10:15 PM #1
- Join Date
- Mar 2014
- Posts
- 25,742
- Feedback Score
- 0
- Thanks
- 0
- Thanked 0 Times in 0 Posts
Excel Pivot Table Grouping, Calcs, Slicer, Sparklines
-
Sponsored Links
-
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
24 Hour Gold
Advertising
- Over 20.000 UNIQUE Daily!
- Get Maximum Exposure For Your Site!
- Get QUALITY Converting Traffic!
- Advertise Here Today!
Out Of Billions Of Website's Online.
Members Are Online From.
- Get Maximum Exposure For Your Site!
- Get QUALITY Converting Traffic!
- Advertise Here Today!
Out Of Billions Of Website's Online.
Members Are Online From.