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.

 

Excel Pivot Table: Grouping, Calcs, Slicer, Sparklines


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 schero   |  

Information
Members of Guests cannot leave comments.


SermonBox - Seasonal Collection

SermonBox - The Series Pack Collection

Top Rated News

  • Christmas Material
  • Laser Cut & Print Design Elements Bundle - ETSY
  • Daz3D - All Materials - SKU 37000-37999
  • Cgaxis - All Product - 2019 - All Retail! - UPDATED!!!
  • DigitalXModels Full Collections
  • Rampant Design Tools Full Collections Total: $4400
  • FilmLooks.Com Full Collection
  • All PixelSquid Product
  • The Pixel Lab Collection
  • Envato Elements Full Sources- 3200+ Files
  • Ui8.NET Full Sources
  • The History of The 20th Century
  • The Dover Collections
  • Snake Interiors Collections
  • Inspirational Collections
  • Veer Fancy Collections
  • All Ojo Images
  • All ZZVE Collections
  • All Sozaijiten Collections
  • All Image Broker Collections
  • Shuterstock Bundle Collections
  • Tattoo Collections
  • Blend Images Collections
  • Authors Tuorism Collections
  • Motion Mile - Big Bundle
  • PhotoBacks - All Product - 2018
  • Dekes Techniques - Photoshop & Illustrator Course - 1 to 673
Telegram GFXTRA Group
Udemy - Turkce Gorsel Ogrenme Setleri - Part 2
Videohive Wow Pack Series


rss