Excel Pivot Table: Grouping, Calcs, Slicer, Sparklines
MP4 | Video: AVC 1280×720 | 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.
Download uploaded
http://uploaded.net/file/toofisqh/Excel%20Pivot%20Table%20-%20Grouping%2C%20Calcs%2C%20Slicer%2C%20Sparklines.part1.rar
http://uploaded.net/file/rb7gmekz/Excel%20Pivot%20Table%20-%20Grouping%2C%20Calcs%2C%20Slicer%2C%20Sparklines.part2.rar
http://uploaded.net/file/9hhrrwgt/Excel%20Pivot%20Table%20-%20Grouping%2C%20Calcs%2C%20Slicer%2C%20Sparklines.part3.rar
http://uploaded.net/file/ykh0bb0n/Excel%20Pivot%20Table%20-%20Grouping%2C%20Calcs%2C%20Slicer%2C%20Sparklines.part4.rar
http://uploaded.net/file/gad3tobb/Excel%20Pivot%20Table%20-%20Grouping%2C%20Calcs%2C%20Slicer%2C%20Sparklines.part5.rar
Download nitroflare
http://nitroflare.com/view/97AB26DAA36A4AF/Excel_Pivot_Table_-_Grouping%2C_Calcs%2C_Slicer%2C_Sparklines.part1.rar
http://nitroflare.com/view/616BD69C1936476/Excel_Pivot_Table_-_Grouping%2C_Calcs%2C_Slicer%2C_Sparklines.part2.rar
http://nitroflare.com/view/6BD42BB78AA1923/Excel_Pivot_Table_-_Grouping%2C_Calcs%2C_Slicer%2C_Sparklines.part3.rar
http://nitroflare.com/view/99C3A90BA7B20CF/Excel_Pivot_Table_-_Grouping%2C_Calcs%2C_Slicer%2C_Sparklines.part4.rar
http://nitroflare.com/view/AA4D444D60963DB/Excel_Pivot_Table_-_Grouping%2C_Calcs%2C_Slicer%2C_Sparklines.part5.rar
Download 百度云
你是VIP 1个月(1 month)赞助会员，
转载请注明：0daytown » Excel Pivot Table: Grouping, Calcs, Slicer, Sparklines